Profile export
Profile history export allows you to download information about all profiles in the database or segment. The data will be downloaded as a csv file. You can choose the data you want to receive.
To start exporting, select a database or segment and click 
in the toolbar:
Export fields
Check the profile fields to be downloaded. The buttons at the top of the page can help here — check all fields, uncheck all of them, or check only opt-in fields. Opt-in data includes registration information: email, date, links and IP address at the time of registration.
The following profile fields are available for export:
- default fields;
- behavioral fields;
- system fields;
- custom fields.
The table below describes behavioral and system fields:
Behavioral fields
| Export field | Column in file | Description |
|---|---|---|
| Send date Send SMS date Send push date | SendDate SendSMSDate SendPushDate | Date and time of the first message sent (Email, SMS, Push) |
| Open date Open push date | OpenDate OpenPushDate | Date and time when the message was last opened (Email, Push) |
| Click date Click SMS date Click push date | ClickDate ClickSMSDate ClickPushDate | Date and time of the message was last clicked (Email, SMS, Push) |
| Deliv date Deliv SMS date Deliv push date | DelivDate DelivSMSDate DelivPushDate | Date and time when the message was last delivered (Email, SMS, Push) |
| Read date | ReadDate | Date and time when the message was last read (Email) |
| Reply date | ReplyDate | Date and time when the message was last read (Email) |
| Confirm date | ConfirmDate | Date and time when the confirmation link was clicked |
| Pixel date | PixelDate | Date and time when the pixel was last activated |
| Sent SMS sent Push sent | SendExists SendSMSExists SendPushExists | Whether a message was sent for the entire period of interaction with the profile or not (Email, SMS, Push) |
| Opened Push opened | OpenExists OpenPushExists | Whether a message was opened for the entire period of interaction with the profile or not (Email, Push) |
| Clicked SMS clicked Push clicked | ClickExists ClickSMSExists ClickPushExists | Whether a message was clicked for the entire period of interaction with the profile or not (Email, SMS, Push) |
| Delivered SMS delivered Push delivered | DelivExists DelivSMSExists DelivPushExists | Whether a message was delivered for the entire period of interaction with the profile or not (Email, SMS, Push) |
| Read | ReadExists | Whether a message was read for the entire period of interaction with the profile or not (Email) |
| Reply exists | ReplyExists | Whether a message was replied for the entire period of interaction with the profile or not (Email) |
| Confirmed | ConfirmExists | Whether there was a click on the confirmation link in the message for the entire period of interaction with the profile or not |
| Pixel | PixelOpenExists | Whether any pixel was activated for the entire period of interaction with the profile or not |
System fields
| Export field | Column in file | Description |
|---|---|---|
| Created | CreateTime | Date and time the profile was created |
| Updated | UpdateTime | Date and time the profile was updated |
| Subscriptions (linear) | The following subscription data is exported:
| |
| Subscriptions (base64) | Subscription data is exported as a base64 encoded string | |
| utm_campaign utm_source utm_medium utm_content utm_term | UtmCampaign UtmSource UtmMedium UtmContent UtmTerm | UTM tags |
| Static segment IDs | StaticSegments | ID of the static segment that the profile belongs to |
| ID | Id | profile_id |
Export settings
In this block, you set additional export settings. You can export the data of profiles that have a certain global status, as well as limit the number of downloaded profiles:
To download information about profiles with a subscription to a specific resource, activate the "Filter by specific subscriptions" option. Select a resource and optionally a subscription status.
In some cases, a resource subscription is added to a profile, but deleted after some time. If you want the file to contain profile data with a deleted subscription to the selected resource, check the box "Include deleted subscriptions".
Once you have selected the fields to export and set up the export details, click on the "Export" button. The platform will start the process. Go to the "Tasks" section to download the generated file containing profile data.