Blueshift supports multiple ways of importing customer data. After you import customer data into your Blueshift account, Blueshift can easily build a 360 degree view of all your customers.
You can send customer data to Blueshift using any of the following methods:
|Amazon S3 bucket||
You can upload a customer data CSV file from an Amazon S3 bucket. Blueshift recommends that you use this method when possible.
Configure the job to run hourly/daily/weekly. When the upload is done, you will get an email with the upload status.
You can get high throughput with the customer attribute upload job. Blueshift can process around 1M users/hr and the background job also takes care of retries.
For more information, see Customer data from S3.
With the integration of Blueshift and Snowflake, you can import customer data into your Blueshift account very easily.
Before you can import data from Snowflake you must set up integration of Blueshift with Snowflake and configure at least one adapter.
For more information, see Customer data from Snowflake.
You can upload a customer data CSV file from the Blueshift UI.
For more information, see Customer data from UI.
You can upload a list of customers from the UI.
If you use Blueshift's SDKs to integrate your apps with Blueshift, you can send customer data to Blueshift.
For more information, see Blueshift's Developer Portal.
Use Blueshift's APIs to send customer data to Blueshift.
For more information, see APIs to import customer data.
You can import historical customer data in CSV format into Blueshift to help build a better profile of your customers. For more information, see Historical Data.
Consider the following points about importing customer attributes into Blueshift:
- When you import customer attributes, you can set the data type for any custom attributes in the import task.
Note: You cannot change the data type for a custom attribute once it is imported. If you have accidentally set the incorrect data type for a custom attribute, create a new attribute and re-upload customer data.
- To update the value of any customer attributes, you must upload the data by using any of the import methods. Customer attributes cannot be updated from the customer profile.
- If the Enable user updates option is set for a custom event, customer attributes are updated with the information contained in the event.
Note: The Enable user updates option is not available for standard events.
Blueshift supports the following data types:
- Boolean data types
- Array (via Snowflake only)
- Object (via Snowflake only)
Note: Attributes with data type as Boolean cannot be set to a NULL or blank value and must be set as either true or false. If you require an attribute to have a blank values, use the a String data type instead of a Boolean data type.
Here are some suggested attributes, but feel free to add additional ones as well.
Cannot have more than 256 characters.
For an email address firstname.lastname@example.org, the following email syntax is acceptable according to RFC standard:
must be one of the following:
|unsubscribed||value can be true or false and must be in lower case.|
You can also format the date in excel/numbers using custom format to convert the date to ISO8601 format yyyy-mm-ddThh:mm:ss+/-00:00. Replace +/-00:00 with the time zone offset for your timezone.
Dates can be converted in excel by using a function to add (=A2+TIME(8,0,0) ) or subtract hours (=A2-TIME(8,0,0)) so the time is represented in the UTC time. Replace A2 with the cell of the date you are converting. Please note that this is good for one time uploads as it does not take into account daylight savings for ongoing file uploads.
For example: yyyy-mm-ddThh:mm:ss-05:00 for Eastern (Est) timezone.
Converting time = A2,5,0,0 will add 5 hours to the time converting EST timezome to UTC.