Business Intelligence Data Sources

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 NameDescription
campaign_nameSelect which message data to view by campaign name
Client IDSelect one or more of your Client IDs to view the most relevant data
Email TypeSelect the type of email data you wish to view: campaign, triggered, or both
Event DateSelect date ranges
List NameSlice data by the list name that appears in the UI
Template NameSlice data by the template name that appears in the UI
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Delivered CountThe count of emails sent minus bounces (which include softbounces and hardbounces).
Hardbounce CountThe number of hard bounced users.
Nobeacon Click CountThe 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 CountThe number of opted out users
Pageview CountThe number of pageviews. 
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

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 NameDescription
Blast IDSelect which message data to view by Blast ID
campaign_nameSelect which message data to view by campaign name
Client IDSelect one or more of your Client IDs to view the most relevant data
DomainSelect the data to view by domain
Event DateSelect date ranges
List NameSlice data by the list name that appears in the UI
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Hardbounce CountTotal number of hard bounced users on the list.
Nobeacon Click CountThe 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 CountThe number of opted out users
Pageview CountThe number of pageviews
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

campaign_stats_by_engagement

Field NameDescription
Blast IDSelect which message data to view by Blast ID
campaign_nameSelect which message data to view by campaign name
Client IDSelect one or more of your Client IDs to view the most relevant data
EngagementSelect the data you wish to view based on the user engagement level. 
Event DateSelect date ranges
List NameSlice data by the list name that appears in the UI
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Hardbounce CountTotal number of hard bounced users on the list.
Nobeacon Click CountThe 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 CountThe number of opted out users
Pageview CountThe number of pageviews.
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

Campaign Stats by Signup Month

campaign_stats_by_signup_month

Field NameDescription
campaign_nameSelect which message data to view by campaign name
Client IDSelect one or more of your Client IDs to view the most relevant data
Event DateSelect date ranges
List NameSlice data by the list name that appears in the UI
Signup MonthSelect the signup months you wish to view
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Hardbounce CountCount of hard bounced users
Nobeacon Click CountThe 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 CountThe number of opted out users
Pageview CountThe number of pageviews
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

Campaign Stats by Device

campaign_stats_by_device

Field NameDescription
Blast IDSelect which message data to view by Blast ID
campaign_nameSelect which message data to view by campaign name
Client IDSelect one or more of your Client IDs to view the most relevant data
DeviceSlice data by device type
Event DateSelect date ranges
List NameSlice data by the list name that appears in the UI
Refresh TimeDisplays a timestamp of the last time the data was updated/refreshed.
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Hardbounce CountTotal number of hard bounced users.
Nobeacon Click CountThe 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 CountThe number of opted out users
Pageview CountThe number of pageviews.
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

Campaign Stats

campaign_stats_blast_list

Field NameDescription
Abtest IDSlice data by the AB Test ID
Blast IDSelect which message data to view by Blast ID
Client IDSelect one or more of your Client IDs to view the most relevant data
Event DateSlice data by specific dates or date ranges
List NameSlice data by the list name that appears in the UI
NameSlice data by the campaign name that appears in the UI
SubjectSlice data by the message subject 
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Delivered CountThe count of emails sent minus bounces (which include softbounces and hardbounces).
Hardbounce CountTotal number of hard bounced users on the list.
List Active CountThe total # of users on a given list that are considered "Active" on a given day
List Disengaged CountThe total # of users on a given list that are considered "Disengaged" on a given day
List Dormant CountThe total # of users on a given list that are considered "Dormant" on a given day
List Email CountThe total # of users on a given list on a given day
List Engaged CountThe total # of users on a given list that are considered "Engaged" on a given day
List Hardbounce CountThe total # of users on a given list that are considered "Hardbounced" on a given day
List New CountThe total # of users on a given list that are considered "New" on a given day
List Optout CountThe total # of users on a given list that are considered "Optout" on a given day
List Passive CountThe total # of users on a given list that are considered "Passive" on a given day
List Spam CountThe number of users who reported your email as spam and were automatically opted out on a list on a given day
List Valid CountTotal number of users on the list who have any engagement status other than Hardbounce or Optout on a list
Lists Remove CountThe total # of users that were removed from a list in the (relative) last 24 hours
Lists Signup CountThe total # of users that were signed up to a list in the (relative) last 24 hours
Nobeacon Click CountThe 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 CountThe count of opted out users
Pageview CountThe number of pageviews
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

Campaign Stats by URL

campaign_stats_by_url

Field NameDescription
Blast IDSelect which message data to view by Blast ID
campaign_nameSelect which message data to view by campaign name
Client IDSelect one or more of your Client IDs to view the most relevant data
Event DateSelect date ranges
List NameSlice data by the list name that appears in the UI
Refresh TimeDisplays a timestamp of the last time the data was updated/refreshed.
URLFilter campaign performance by url/links included in campaigns 
Click CountThe number of clicks per link included in campaigns
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Total Click CountTotal number of email clicks (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

Campaign Label Stats

campaign_stats_blast_label

Field NameDescription
Abtest IDSelect which message data to view by AB Test ID
Blast IDSelect which message data to view by Blast ID
Client IDSelect one or more of your Client IDs to view the most relevant data
Event DateSelect date ranges
Label IDThe label ID
Label NameUsed to segment campaign data by user-generated labels
List NameSlice data by the list name that appears in the UI
campaign_nameSelect which message data to view by campaign name
SubjectSlice data by message subject
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Hardbounce CountTotal number of hard bounced users.
Nobeacon Click CountThe 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 CountThe number of opted out users
Pageview CountThe number of pageviews.
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

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)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.


campaign_stats_by_domain_label

Field NameDescription
Blast IDSelect which message data to view by Blast ID
Client IDSelect one or more of your Client IDs to view the most relevant data
DomainSlice data by domain
Event DateSelect date ranges
Label NameUsed to segment campaign data by user-generated labels
List NameSlice data by the list name that appears in the UI
Beacon Click CountThe 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 CountThe total # of beacons that fired without any clicks. This is part of the calculation for Opens in an email.
Hardbounce CountTotal number of hard bounced users.
Nobeacon Click CountThe 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 CountThe number of opted out users
Pageview CountThe number of pageviews
Purchase CountThe number of purchases
RevenueMonetary value of all purchases
Send CountThe number of users to whom a message was sent
Softbounce CountThe 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 CountThe number of users who reported your email as spam and were automatically opted out
Total Click CountTotal number of email clicks (campaign, triggered)
Total Open CountTotal number of open emails (campaign, triggered)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.

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)

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.


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

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.



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

Email

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

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.


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

Email

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

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.


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 

real_click_count

Count of Unique Real Clicks - The number of Real unique user clicks from all links in a message.

bot_click_count

Count of Unique NHI Clicks - The number of NHI unique bot clicks from all links in a message.

real_total_click_count

Count of Total Real Clicks - The total number of Real clicks in a message, includes multiple clicks by a recipient within the same message.

bot_total_click_count

Count of Total NHI Clicks - The total number of NHI clicks in a message, includes multiple clicks by a bot within the same message.


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

Contact us

Top