Business Intelligence Data Sources
Contents
The following tables define the fields found in each of the Business Intelligence data sources.
Client Config
| Field Name | Description |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Is Active | Slice data by user engagement level. |
| Name | Slice data by the account name that appears in the UI |
| Rollup | The name of your account |
| Timezone | The time zone that is set in your account |
Email and List Stats
email_stats_by_day_list_template
| Field Name | Description |
| campaign_name | Select which message data to view by campaign name |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Email Type | Select the type of email data you wish to view: campaign, triggered, or both |
| Event Date | Select date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Template Name | Slice data by the template name that appears in the UI |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Delivered Count | The count of emails sent minus bounces (which include softbounces and hardbounces). |
| Hardbounce Count | The number of hard bounced users. |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The number of opted out users |
| Pageview Count | The number of pageviews. |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
list_stats
| Field Name | Description |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Event Date | Select date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Active Count | The count of active users on the list |
| Disengaged Count | The count of disengaged users on the list |
| Dormant Count | The count of dormant users on the list |
| Email Count | The total # of users on a given day |
| Engaged Count | The count of engaged users on the list |
| Hardbounce Count | Total number of hard bounced users on the list. |
| Lists Remove Count | The number of users removed from the list |
| Lists Signup Count | The number of users who signed up to the list |
| New Count | The number of new users |
| Optout Count | The number of opted out users |
| Optout Loss Count | The total number of users lost to optouts in the (relative) last 24 hours |
| Passive Count | The number of passive users on the list |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Valid Count | Total number of users on the list who have any engagement status other than Hardbounce or Optout. |
Campaign Stats by Domain and Engagement
campaign_stats_by_domain
| Field Name | Description |
| Blast ID | Select which message data to view by Blast ID |
| campaign_name | Select which message data to view by campaign name |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Domain | Select the data to view by domain |
| Event Date | Select date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Hardbounce Count | Total number of hard bounced users on the list. |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The number of opted out users |
| Pageview Count | The number of pageviews |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
campaign_stats_by_engagement
| Field Name | Description |
| Blast ID | Select which message data to view by Blast ID |
| campaign_name | Select which message data to view by campaign name |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Engagement | Select the data you wish to view based on the user engagement level. |
| Event Date | Select date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Hardbounce Count | Total number of hard bounced users on the list. |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The number of opted out users |
| Pageview Count | The number of pageviews. |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A soft bounced message may eventually be delivered and the system makes redelivery attempts of soft bounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
Campaign Stats by Signup Month
campaign_stats_by_signup_month
| Field Name | Description |
| campaign_name | Select which message data to view by campaign name |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Event Date | Select date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Signup Month | Select the signup months you wish to view |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Hardbounce Count | Count of hard bounced users |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The number of opted out users |
| Pageview Count | The number of pageviews |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
Campaign Stats by Device
campaign_stats_by_device
| Field Name | Description |
| Blast ID | Select which message data to view by Blast ID |
| campaign_name | Select which message data to view by campaign name |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Device | Slice data by device type |
| Event Date | Select date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Refresh Time | Displays a timestamp of the last time the data was updated/refreshed. |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Hardbounce Count | Total number of hard bounced users. |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The number of opted out users |
| Pageview Count | The number of pageviews. |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
Campaign Stats
campaign_stats_blast_list
| Field Name | Description |
| Abtest ID | Slice data by the AB Test ID |
| Blast ID | Select which message data to view by Blast ID |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Event Date | Slice data by specific dates or date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Name | Slice data by the campaign name that appears in the UI |
| Subject | Slice data by the message subject |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Delivered Count | The count of emails sent minus bounces (which include softbounces and hardbounces). |
| Hardbounce Count | Total number of hard bounced users on the list. |
| List Active Count | The total # of users on a given list that are considered "Active" on a given day |
| List Disengaged Count | The total # of users on a given list that are considered "Disengaged" on a given day |
| List Dormant Count | The total # of users on a given list that are considered "Dormant" on a given day |
| List Email Count | The total # of users on a given list on a given day |
| List Engaged Count | The total # of users on a given list that are considered "Engaged" on a given day |
| List Hardbounce Count | The total # of users on a given list that are considered "Hardbounced" on a given day |
| List New Count | The total # of users on a given list that are considered "New" on a given day |
| List Optout Count | The total # of users on a given list that are considered "Optout" on a given day |
| List Passive Count | The total # of users on a given list that are considered "Passive" on a given day |
| List Spam Count | The number of users who reported your email as spam and were automatically opted out on a list on a given day |
| List Valid Count | Total number of users on the list who have any engagement status other than Hardbounce or Optout on a list |
| Lists Remove Count | The total # of users that were removed from a list in the (relative) last 24 hours |
| Lists Signup Count | The total # of users that were signed up to a list in the (relative) last 24 hours |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The count of opted out users |
| Pageview Count | The number of pageviews |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
Campaign Stats by URL
campaign_stats_by_url
| Field Name | Description |
| Blast ID | Select which message data to view by Blast ID |
| campaign_name | Select which message data to view by campaign name |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Event Date | Select date ranges |
| List Name | Slice data by the list name that appears in the UI |
| Refresh Time | Displays a timestamp of the last time the data was updated/refreshed. |
| URL | Filter campaign performance by url/links included in campaigns |
| Click Count | The number of clicks per link included in campaigns |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Total Click Count | Total number of email clicks (campaign, triggered) |
Campaign Label Stats
campaign_stats_blast_label
| Field Name | Description |
| Abtest ID | Select which message data to view by AB Test ID |
| Blast ID | Select which message data to view by Blast ID |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Event Date | Select date ranges |
| Label ID | The label ID |
| Label Name | Used to segment campaign data by user-generated labels |
| List Name | Slice data by the list name that appears in the UI |
| campaign_name | Select which message data to view by campaign name |
| Subject | Slice data by message subject |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Hardbounce Count | Total number of hard bounced users. |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The number of opted out users |
| Pageview Count | The number of pageviews. |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
campaign_stats_by_device_label
Field Name | Description |
Blast ID | Select which message data to view by Blast ID |
campaign_name | Select which message data to view by campaign name |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Device | Slice data by device type |
Event Date | Select date ranges |
Label Name | Used to segment campaign data by user-generated labels |
List Name | Slice data by the list name that appears in the UI |
Refresh Time | Displays a timestamp of the last time the data was updated/refreshed. |
Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
Hardbounce Count | Total number of hard bounced users. |
Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
Optout Count | The number of opted out users |
Pageview Count | The number of pageviews. |
Purchase Count | The number of purchases |
Revenue | Monetary value of all purchases |
Send Count | The number of users to whom a message was sent |
Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
Spam Count | The number of users who reported your email as spam and were automatically opted out |
Total Click Count | Total number of email clicks (campaign, triggered) |
Total Open Count | Total number of open emails (campaign, triggered) |
campaign_stats_by_domain_label
| Field Name | Description |
| Blast ID | Select which message data to view by Blast ID |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Domain | Slice data by domain |
| Event Date | Select date ranges |
| Label Name | Used to segment campaign data by user-generated labels |
| List Name | Slice data by the list name that appears in the UI |
| Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
| Hardbounce Count | Total number of hard bounced users. |
| Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
| Optout Count | The number of opted out users |
| Pageview Count | The number of pageviews |
| Purchase Count | The number of purchases |
| Revenue | Monetary value of all purchases |
| Send Count | The number of users to whom a message was sent |
| Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
| Spam Count | The number of users who reported your email as spam and were automatically opted out |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
Purchase
first _purchase
| Field Name | Description |
| Campaign ID | Use in reports to slice campaign data by Campaign ID |
| Campaign Name | Select which message data to view by campaign name |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Message ID | The unique identifier for purchases that tell you if a purchase was driven from an email. If not, message ID will be (empty value). If it is, it'll give you the unique message ID that drove that purchase. (Note that this is different than Blast ID) |
| Product ID | Unique identifier for specific products |
| Product Name | Unique name for specific products |
| Purchase Date | Slice data by purchase date |
| Purchase ID | Unique identifier for specific purchases |
purchase_stats_by_hour
| Field Name | Description |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Event Hour | Select time ranges |
| Purchase Count | The number of purchases |
| Total Items | The total number of items purchased |
| Total Price | The gross revenue generated (or - total unadjusted price) of all items in a users' cart |
purchases_per_product_day
| Field Name | Description |
| Campaign ID | Use in reports to slice campaign data by Campaign ID |
| Product Name | Unique name for specific products |
| Purchase Date | Slice data by purchase date |
| average_price | The average price of items purchased |
| items_sold | The number of items sold |
| Purchase Count | The number of purchases |
| total_revenue | Total monetary value of all purchases |
Profile Stats
| Field Name | Description |
| Client ID | Select one or more of your Client IDs to view the most relevant data |
| Domain | Two separate uses: 1) to filter any campaign facts/metrics by domain, allowing you to segment campaign metrics by specific email domains that were sent to. 2) to filter all customer-specific reports by user domains |
| Is Buyer | Segments Customer ID (or all user data) by whether or not users have made at least one purchase |
| Is Hardbounce | Used to segment Customer IDs by hardbounce status |
| Is Optout | A Yes/No value - is the profile opted out? |
| Is Subscriber | Use to slice by whether or not a user is a subscriber |
| Is Valid | Use to slice by whether or not users/audiences/segments are currently valid or invalid (Invalid = Optout OR Hardbounced) |
| Last Open Period | A user's last open was between X and Y days ago |
| last_click_period | A user's last click was between X and Y days ago |
| last_open_period_finegrained | A user's last open was between X and Y days ago |
| Signup Day | Metric returning a user's signup date |
| Time to Conversion Period | Average time to users' converting |
| Time to Optout Period | Average time to users' opting out |
| Click Count | The count of email clicks |
| Num Profiles | The total number of profiles |
| Num Profiles Gte 1 Purchases | Total number of profiles that have made at least one purchase |
| Num Profiles Gtw 2 Purchases | Total number of profiles that have made at least two purchases |
| Num Profiles Gte 3 Purchases | Total number of profiles that have made at least three purchases |
| Num Profiles Gte 4 Profiles | Total number of profiles that have made at least four purchases |
| Open Count | The number of opened messages |
| Total Click Count | Total number of email clicks (campaign, triggered) |
| Total Open Count | Total number of open emails (campaign, triggered) |
| Total Pageview Count | Total number of pageviews. |
| Total Purchase Count | Total number of purchases |
| Total Purchase Revenue | Total monetary value of all purchases |
| Total Send Count | The total number of users to whom a message was sent |
Email Stats
email_stats_by_day_list_template
Field Name | Description |
Campaign Name | Select which message data to view by campaign name |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Email Type | Select the type of email data you wish to view: campaign, triggered, or both |
Event Date | Select date ranges |
List Name | Slice data by the list name that appears in the UI |
Template Name | Slice data by the template name that appears in the UI |
Beacon Click Count | The total # of clicks that occurred with a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
Beacon Noclick Count | The total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email. |
Delivered Count | The count of emails sent minus bounces (which include softbounces and hardbounces). |
Hardbounce Count | The number of hard bounced users. |
Nobeacon Click Count | The total # of clicks that occurred without a campaign's beacon image firing. This is part of the larger definition for "total number of people that opened my email" |
Optout Count | The number of opted out users |
Pageview Count | The number of pageviews. |
Purchase Count | The number of purchases |
Revenue | Monetary value of all purchases |
Send Count | The number of users to whom a message was sent |
Softbounce Count | The count of messages with a report of a delivery problem or failed delivery. Messages may soft bounce at the server level, because of a resource exhaustion such as a full disc, or because of spam filters. A softbounced message may eventually be delivered and the system makes redelivery attempts of softbounced messages. |
Spam Count | The number of users who reported your email as spam and were automatically opted out |
Total Click Count | Total number of email clicks (campaign, triggered) |
Total Open Count | Total number of open emails (campaign, triggered) |
Average Emails by Signup Month
average_emails_by_signup_month
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Signup Month | Select the signup months you wish to view |
Time Since Signup | Time from signup |
Average Emails Received | Emails received since signup |
Full Profile Stats
Profile Stats
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
country,state,city | Segment profile data by user location |
Device | Slice data by device type |
Domain | Two separate uses: 1) to filter any campaign facts/metrics by domain, allowing you to segment campaign metrics by specific email domains that were sent to. 2) to filter all customer-specific reports by user domains |
First Purchase Time | Used to identify the date a user made their first purchase |
Is Buyer | Segments Customer ID (or all user data) by whether or not users have made at least one purchase |
Is Hardbounce | Used to segment Customer IDs by hardbounce status |
Is Optout | A Yes/No value - is the profile opted out? |
Is Subscriber | Use to slice by whether or not a user is a subscriber |
Is Valid | Use to slice by whether or not users/audiences/segments are currently valid or invalid (Invalid = Optout OR Hardbounced) |
Last Click Time | A user's last click date |
Last Open Time | A user's last open date |
Last Pageview Time | A user's last pageview date |
Last Purchase Time | A user's last purchase date |
Optout Reason | Metric returning a user's reason for opting out |
Optout Time | Metric returning a user's opt out time |
Profile Id | A user's Profile Id |
Signup Time | Metric returning a user's signup time |
Click Count | The count of email clicks |
Num Profiles | The total number of profiles |
Open Count | The number of opened messages |
Total Click Count | Total number of email clicks (campaign, triggered) |
Total Open Count | Total number of open emails (campaign, triggered) |
Total Pageview Count | Total number of pageviews. |
Total Purchase Count | Total number of purchases |
Total Send Count | The total number of users to whom a message was sent |
profile_top_location
Field Name | Description |
City | Segment profile data by user's city |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Country | Segment profile data by user's country |
Location | Segment profile data by city, state, country |
Profile Id | A user's Profile Id |
State | Segment profile data by user's state |
List Stats
list_stats
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Event Date | Select date ranges |
List Name | Slice data by the list name that appears in the UI |
Active Count | The count of active users on the list |
Disengaged Count | The count of disengaged users on the list |
Dormant Count | The count of dormant users on the list |
Email Count | The total # of users on a given day |
Engaged Count | The count of engaged users on the list |
Hardbounce Count | Total number of hard bounced users on the list. |
Lists Remove Count | The number of users removed from the list |
Lists Signup Count | The number of users who signed up to the list |
New Count | The number of new users |
Optout Count | The number of opted out users |
Optout Loss Count | The total number of users lost to optouts in the (relative) last 24 hours |
Passive Count | The number of passive users on the list |
Spam Count | The number of users who reported your email as spam and were automatically opted out |
Valid Count | Total number of users on the list who have any engagement status other than Hardbounce or Optout. |
Profile stats broken out by time from signup
profile_stats_with_time_from_signup
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Profile Id | A user's Profile Id |
Signup Time | Metric returning a user's signup time |
Open 121 150 | A user's last open was between 121 and 150 days ago |
Open 151 180 | A user's last open was between 151 and 180 days ago |
Open 181 365 | A user's last open was between 181 and 365 days ago |
Open 30 | A user's last open was less than 30 days ago |
Open 31 60 | A user's last open was between 31 and 60 days ago |
Open 61 90 | A user's last open was between 61 and 90 days ago |
Open 91 120 | A user's last open was between 91 and 120 days ago |
Open_0 | A user's last open was less than a day ago |
Open_1 | A user's last open was 1 day ago |
Open_2 | A user's last open was 2 days ago |
Open_3 | A user's last open was 3 days ago |
Open_4 | A user's last open was 4 days ago |
Open_5 | A user's last open was 5 days ago |
Open_6 | A user's last open was 6 days ago |
Open_7 | A user's last open was 7 days ago |
Send 121 150 | A user's last send was between 121 and 150 days ago |
Send 151 180 | A user's last open was between 151 and 180 days ago |
Send 181 365 | A user's last send was between 181 and 365 days ago |
Send 30 | A user's last send was less than 30 days ago |
Send 31 60 | A user's last send was between 31 and 60 days ago |
Send 61 90 | A user's last send was between 61 and 90 days ago |
Send 91 120 | A user's last send was between 91 and 120 days ago |
Send_0 | A user's last send was less than a day ago |
Send_1 | A user's last send was 1 day ago |
Send_2 | A user's last send was 2 days ago |
Send_3 | A user's last send was 3 days ago |
Send_4 | A user's last send was 4 days ago |
Send_5 | A user's last send was 5 days ago |
Send_6 | A user's last send was 6 days ago |
Send_7 | A user's last send was 7 days ago |
profile_var_mapping
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Var Name | Displays custom user vars by var name |
Var Number | Displays custom user vars by var number |
Var Title | Displays custom user vars by var title |
profile_vars
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Profile Id | A user's Profile Id |
Profile Var 1-100 | Displays custom user vars by var number |
Signup Time (Profile Vars) | Metric returning a user's signup time |
Profile with Vars
profile
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
A user's email address | |
First Purchase Time | Used to identify the date a user made their first purchase |
Latest Click Time | A user's last click date |
Latest Open Time | A user's last open date |
Latest Pageview Time | A user's last pageview date |
Optout Reason | Metric returning a user's reason for opting out |
Optout Time | Metric returning a user's opt out time |
Profile Id | A user's Profile Id |
Signup Time | Metric returning a user's signup time |
Status | Metric returning if a user's email has Hard bounced or Soft bounced |
Click Count | The count of email clicks |
Num Profiles | The total number of profiles |
Open Count | The number of opened messages |
Total Click Count | Total number of email clicks (campaign, triggered) |
Total Open Count | Total number of open emails (campaign, triggered) |
Total Pageview Count | Total number of pageviews. |
Total Purchase Count | Total number of purchases |
Total Send Count | The total number of users to whom a message was sent |
profile_var_mapping
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Var Name | Displays custom user vars by name |
Var Number | Displays custom user vars by var number |
Var Title | Displays custom user vars by title |
profile_vars
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Profile Id | A user's Profile Id |
Profile Var 1-100 | Displays custom user vars by var number |
Signup Time (Profile Vars) | Metric returning a user's signup time |
Profile with Vars and other Stats
profile
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
A users email | |
First Purchase Time | Used to identify the date a user made their first purchase |
Latest Click Time | A user's last click date |
Latest Open Time | A user's last open date |
Latest Pageview Time | A user's last pageview date |
Latest Purchase Time | A user's last purchase date |
Optout Reason | Metric returning a user's reason for opting out |
Optout Time | Metric returning a user's opt out time |
Profile Id | A user's Profile Id |
Signup Time | Metric returning a user's signup time |
Status | Metric returning if a user's email has Hard bounced or Soft bounced |
Click Count | The count of email clicks |
Num Profiles | The total number of profiles |
Open Count | The number of opened messages |
Total Click Count | Total number of email clicks (campaign, triggered) |
Total Open Count | Total number of open emails (campaign, triggered) |
Total Pageview Count | Total number of pageviews. |
Total Purchase Count | Total number of purchases |
Total Send Count | The total number of users to whom a message was sent |
profile_click
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Event Date | Select date ranges |
Profile Id | A user's Profile Id |
Signup Time | Metric returning a user's signup time |
Click Count | The count of profile clicks |
profile_open
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Event Date | Select date ranges |
Profile Id | A user's Profile Id |
Signup Time | Metric returning a user's signup time |
Open Count | The count of profile opens |
profile_pageview
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Event Date | Select date ranges |
Profile Id | A user's Profile Id |
Signup Time | Metric returning a user's signup time |
Pageview Count | The count of profile pageviews |
profile_var_mapping
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Var Name | Displays the name of the custom user var |
Var Number | Displays custom user vars by var number |
Var Title | Displays the title of the custom user var |
profile_vars
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Profile Id | A user's Profile Id |
Profile Var 1-100 | Displays custom user vars by var number |
Signup Time (Profile Vars) | Metric returning a user's signup time |
SBR Stats with Vars
average_emails_by_vars_signup_month
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Signup Month | Select the signup months you wish to view |
Time Since Signup | Time from signup between X and Y |
Profile Var 1-100 | Custom user vars |
Average Emails Received | Average emails received over a certain time period |
pageviews_by_vars_signup_month
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Signup Month | Select the signup months you wish to view |
Time Since Signup | Time from signup |
Profile Var 1-100 | Custom user vars |
Pv 1 | Number of pageviews is equal to 1 |
Pv 10 19 | Number of pageviews between 10 and 19 |
Pv 2 | Number of pageviews equal to 2 |
Pv 3 9 | Number of pageviews between 3 and 9 |
Pv Gte 20 | Number of pageviews over 20 |
profile_stats_by_vars_signup_day
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
Domain | Two separate uses: 1) to filter any campaign facts/metrics by domain, allowing you to segment campaign metrics by specific email domains that were sent to. 2) to filter all customer-specific reports by user domains |
Is Buyer | Segments Customer ID (or all user data) by whether or not users have made at least one purchase |
Is Hardbounce | Used to segment Customer IDs by hardbounce status |
Is Optout | A Yes/No value - is the profile opted out? |
Is Subscriber | Use to slice by whether or not a user is a subscriber |
Is Valid | Use to slice by whether or not users/audiences/segments are currently valid or invalid (Invalid = Optout OR Hardbounced) |
Last Open Period | A user's last open was between X and Y days ago |
last_click_period | A user's last click was between X and Y days ago |
last_open_period_finegrained | A user's last open was between X and Y days ago |
Signup Day | Metric returning a user's signup date |
Time to Conversion Period | Average time to users' converting |
Time to Optout Period | Average time to users' opting out |
Profile Var 1-100 | Custom user vars |
Click Count | The count of email clicks |
Num Profiles | The total number of profiles |
Num Profiles Gte 1 Purchases | Total number of profiles that have made at least one purchase |
Num Profiles Gtw 2 Purchases | Total number of profiles that have made at least two purchases |
Num Profiles Gte 3 Purchases | Total number of profiles that have made at least three purchases |
Num Profiles Gte 4 Profiles | Total number of profiles that have made at least four purchases |
Open Count | The number of opened messages |
Total Click Count | Total number of email clicks (campaign, triggered) |
Total Open Count | Total number of open emails (campaign, triggered) |
Total Pageview Count | Total number of pageviews. |
Total Purchase Count | Total number of purchases |
Total Purchase Revenue | Total monetary value of all purchases |
Total Send Count | The total number of users to whom a message was sent |
repeat_purchasers
Field Name | Description |
Client ID | Select one or more of your Client IDs to view the most relevant data |
First Purchase Time | Used to identify the date a user made their first purchase |
Profile Id | A user's Profile Id |
Profile Var 1-100 | Custom user vars |
time_to_repeat_purchase_181_360 | Count of users where a repeat purchase occurs between 181 and 360 days after their first purchase |
time_to_repeat_purchase_30 | Count of users where a repeat purchase occurs within 30 days after their first purchase |
time_to_repeat_purchase_31 60 | Count of users where a repeat purchase occurs between 31 and 60 days after their first purchase |
time_to_repeat_purchase_360_plus | Count of users where a repeat purchase occurs 360+ days after their first purchase |
time_to_repeat_purchase_61_90 | Count of users where a repeat purchase occurs between 61 and 90 days after their first purchase |
time_to_repeat_purchase_91_180 | Count of users where a repeat purchase occurs between 91 and 180 days after their first purchase |