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: subscription_resource_id subscription_channel subscription_status subscription_priority subscription_hash_id subscription_is_delete (whether the subscription to the resource was deleted or not) subscription_email subscription_phone subscription_subscription_id (push subscription ID) subscription_provider (push provide) subscription_date subscription_ip subscription_url
Subscriptions (base64)		Subscription data is exported as a base64 encoded string
utm_campaign utm_source utm_medium utm_content utm_term	UtmMailing 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.