This page contains information about your Analytics-related data views. For more information on Open Data - Data views, see Data views overview.
Revenue Attribution
If a purchase could not be attributed, the treatment fields remain empty (null).
If there was no contact information (external_id) sent for the order, or the contact could not be found in the Emarsys database, contact_id will be null.
This data view contains the purchases from your selected data source and identifies the ones that Emarsys was able to attribute to your marketing activities, based on your Revenue Attribution settings. By running a query, you can get information about which marketing activity led to purchases, when, by which customers and what products those purchases contained.
View name: revenue_attribution_[customer_ID]
This view contains data from August 7th, 2023 onwards.
| Data field | Description | Type | ||
|---|---|---|---|---|
| customer_id |
The unique ID of the account. | integer | ||
| contact_id |
Emarsys internal unique contact ID. | integer | ||
| event_time |
The time of the purchase. | timestamp | ||
| loaded_at |
The time when the event was loaded. | timestamp | ||
| order_id |
The ID of the purchase. | integer | ||
| Items | Purchased items. | record | ||
| items.item_id |
The ID of the purchased item. | string | ||
| items.price |
The total sales price of the item (unit price multiplied by quantity). | float | ||
| items.quantity |
Quantity of the purchased items. | float | ||
| treatments | The treatments the purchase was attributed to. | record | ||
| hardware_id | The unique ID of the SDK instance on which the message was displayed. | string | ||
| campaign_id |
The campaign ID of the treatment. | integer | ||
| channel | The channel of the treatment (e.g. email, in-app, etc.). | string | ||
| id | The ID of the treatment (e.g. email message ID, etc.). | string | ||
| rti | Interactions related information. | record | ||
| id | The ID of the Interactions program (if applicable). | string | ||
| run_id | The run ID of the Interactions program (if applicable). | string | ||
| ac | Automation Center related information. | record | ||
| id | The ID of the Automation Center program (if applicable). | integer | ||
| run_id | The run ID of the Automation Center program (if applicable). | string | ||
| Email specific metadata. | record | |||
| launch_id | The launch ID of the treatment. | integer | ||
| event_time | The time of the treatment. | timestamp | ||
| attributed_amount | The amount of revenue attributed to the treatment. | float | ||
| reason | The reason why the purchase was attributed to the treatment. | record | ||
| type | The type of the event that is the reason for the attribution (e.g. send, click, etc.). | string | ||
| event_time | The time of the event that is the reason for the attribution (e.g. click time, etc.). | timestamp | ||
Smart Insight
To have Smart Insight data added to your Open Data, please reach out to your Client Success Manager. As part of our cloud transformation journey there are currently some additional steps required to make the data available to you.
Smart Insight - Lifecycle calculations
View name: si_contacts_[customer_ID] (where customer_ID is your Emarsys account ID)
This data view contains all your contact data which was loaded into or calculated by Smart Insight.
It contains data from November 9, 2023 onwards.
| Data field | Description | Type |
|---|---|---|
| si_contact_id | The unique ID of the contact used inside the Smart Insight system. | integer |
| contact_id | The unique ID of the contact from Suite. | integer |
| contact_external_id | Contacts unique identifier from the customer used for user identification. | string |
| load_date | The load date of the contact in Emarsys data. | timestamp |
| registered_on | Date of contact’s registration. | date |
| contact_source | The source of the contact. (e.g. Manual entry, or the name of the form the contact used for registration.) | string |
| number_of_purchases | Number of the purchases the contact made. | integer |
| turnover | Total lifetime spend of the contact. (Taking refunded purchases into account.) | numeric |
| time_ranged_turnover | Total spend of the contacts within the monetary interval time range. (Taking refunded purchases into account.) | numeric |
| average_order_value | The average value of orders made by the contact. | numeric |
| customer_lifecycle_status | Contact’s customer lifecycle status. Possible values are: Lead, Fist time buyer, Active, Defecting, Inactive | string |
| buyer_status | Contact’s buyer status. Possible values are set on the eRFM settings page. | string |
| lead_lifecycle_status | Contact’s lead lifecycle status, filled only if the lifecycle status is Lead. Possible values are: New Lead, Cold Lead, Inactive Lead | string |
| last_order_date | Last date when the contact made an order. | date |
| last_engagement_date | Last date when contact was visiting the website, clicking a link in an email or making a purchase. | date |
| last_response_date | Last date when contact interacted with the customer. | date |
| average_future_spend | A calculated value of how much the contact are likely to spend in the future, based on their historical spend level, the average value of contacts in their lifecycle stage, the conversion rate of that stage, and how much people like them have spent when converting in the past. | numeric |
| is_generated | True if the contact is unidentified. | boolean |
Smart Insight - Sales data
View name: si_purchases_[customer_ID] (where customer_ID is your Emarsys account ID)
This data view contains all your sales data which was loaded into or calculated by Smart Insight.
It contains data from December 4, 2023 onwards.
| Data field | Description | Type |
|---|---|---|
| order_id | The unique ID of the order. | string |
| load_date | The load date of the purchase in Emarsys. | timestamp |
| si_contact_id | The unique ID of the contact used in Smart Insight. | integer |
| si_product_id | The unique ID of the product in Smart Insight. | integer |
| product_external_id | The product ID sent by the client. | string |
| product_name | The name of the product. | string |
| purchase_date | Date of the purchase. | date |
| channel | The sales channel of the order. Its value is either online or offline. |
string |
| quantity | The quantity (number) of the purchased items. | numeric |
| sales_amount | The total price of the items. | numeric |