Question

Delete List of unuse attribute and time format

  • 12 January 2024
  • 1 reply
  • 26 views

Hey guys,

 

Any suggestion on how can I delete a list of attribute for all users in our account?
also, can we store time under timestamp or datetime format when syncing from Bigquery to CIO?
If possible, any suggestion on how we do that?

 

Thanks,
 


1 reply

Userlevel 2

Hi Katenn,

 

Quick options for removing an attribute for all profiles is to import a CSV with an identifier for each profile and a column for the attributes you want to remove. The column (besides the header with the attribute name) should be blank, which will remove the value on upload and result in the attribute being dropped from the profile.

https://customer.io/docs/journeys/uploading-people/

 

Another option could be to come up with a segment that matches all people you want to remove the attribute from and use that segment to trigger a campaign to utilize the add/update people action. If you’re removing the attribute from all profiles, a good segment to use is “cio_id exists” since we populate for each profile by default. The add/update people action includes a “remove attribute” option. When the campaign is triggered, select the option to have current people in the segment trigger the campaign and everyone will flow through the create/update action to have the attribute removed. 

https://customer.io/docs/journeys/create-update-person/

 

 

We typically recommend storing dates as Unix timestamps in seconds. 

https://customer.io/docs/journeys/faq-timestamps/

 

I hope this answers your questions.

Reply