Data Warehouse allows you to track as much as you want, report on your attribution data wherever you want, and plug it in to other data sets.
Rows with a value for _DELETED_DATE will be retained for 15 days, then removed from Snowflake.
Click an image for its full-size version
CRM Data | Touchpoint Creation Data |
Touchpoint Attributes | Spend Data |
All CRM Accounts that are imported, along with custom Marketo Measure fields.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
CRM AccountId |
0013100001kpAZxAAM |
X | |
CREATED_DATE |
timestamp_ntz |
The created date of the Account from the CRM |
2016-08-28 00:32:55.000 |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Account from the CRM |
2018-08-01 17:38:30.000 |
||
NAME |
varchar |
The Account Name, as recorded in the CRM |
Marketo Measure |
||
WEB_SITE |
varchar |
Website that is entered for the Account, used for Lead2Account mapping |
www.adobe.com |
||
ENGAGEMENT_RATING |
varchar |
A letter grade (A, B, C, D, N/A) that is generated from Marketo Measure’s Machine Learning model. This will be null if ABM is disabled. |
B |
||
ENGAGEMENT_SCORE |
number(38,19) |
A numerical score calculated by Marketo Measure’s Machine Learning to generate the Predictive Engagement Score (Engagement_Rating). This will be null if ABM is disabled. |
0.1417350147058800000 |
||
DOMAIN |
varchar |
The parsed down version of the website, only storing the domain. |
Marketo Measure |
||
IS_DELETED |
boolean |
Whether or not the record is deleted in the CRM. |
FALSE |
||
CUSTOM_PROPERTIES | varchar | Custom CRM properties that Marketo Measure has imported from the CRM in JSON format |
{"Account_Type__c": "Security", "Foo":"Bar"} |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Lead and Contact email addresses that are mapped and known under CRM Accounts. This table will be empty if ABM is disabled.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ACCOUNT_ID |
varchar |
CRM AccountId |
0013100001phrBAAAY |
X | BIZ_ACCOUNTS.ID |
varchar |
Any email address that has been mapped to the Account, whether through Contact relationships or from Lead2Account mapping |
email@adobe.com |
X | ||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Account from the CRM |
2018-08-31 23:53:39.000 |
||
CREATED_DATE |
timestamp_ntz |
The created date of the Account from the CRM |
2018-08-18 22:01:32.000 |
||
IS_DELETED |
boolean |
Whether or not the record is considered deleted |
FALSE |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
Id of the activity in the CRM |
number or GUID depending on the source system |
X | BIZ_USER_TOUCHPOINTS.CRM_ACTIVITY_ID |
LEAD_ID |
varchar |
Id of person associated with this activity |
|||
CONTACT_ID |
timestamp_ntz |
Id of person associated with this activity |
|||
ACTIVITY_TYPE_ID |
boolean |
Type Id as defined by the source system |
|||
ACTIVITY_TYPE_NAME |
varchar |
Name as defined by the source system |
|||
START_DATE |
timestamp_ntz |
Start of the activity |
|||
END_DATE |
timestamp_ntz |
End of the activity |
|||
CAMPAIGN_ID |
varchar |
Id of the campaign the activity is part or |
|||
SOURCE_SYSTEM |
varchar |
Type of CRM |
Dynamics, Marketo |
||
AD_FORM_ID |
varchar |
ID of the Ad Form the activity is a part of |
li.507063119.3757704 |
||
CREATED_DATE | timestamp_ntz | The created date of the activity from the CRM |
|
||
MODIFIED_DATE | timestamp_ntz | The last modified date of the activity from the CRM |
|
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all ads downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the ad |
fb.106851586409075.6052044288804.6052044290004.6053457066804 |
X | |
DISPLAY_ID |
varchar |
The ad id? |
6053457066804 |
||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the ad |
fb.106851586409075 |
BIZ_AD_ACCOUNTS.ID | |
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the ad |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser for the ad, specifically for Doubleclick. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser for the ad, specifically for Doubleclick. |
Marketo Measure Marketing Analytics |
||
AD_GROUP_UNIQUE_ID |
varchar |
The ID of the ad group for the ad |
fb.106851586409075.6052044288804.6052044290004 |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
The name of the ad group for the ad |
US - 18+ |
||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign for the ad |
fb.106851586409075.6052044288804 |
BIZ_AD_CAMPAIGNS.ID | |
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign for the ad |
Lead generation Campaign |
||
IS_ACTIVE |
boolean |
Whether or not the ad is still active in the ads account |
FALSE |
||
IS_DELETED |
boolean |
Whether or not the ad has been deleted in the ads account |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:35:59.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date that the ad was first downloaded by Marketo Measure |
2018-08-02 06:35:59.000 |
||
NAME |
varchar |
The name of the ad |
Ad 2 |
||
NEEDS_UPDATE |
boolean |
Whether or not the ad needs to get updated to get Marketo Measure tagging |
FALSE |
||
GROUPING_KEY |
varchar |
fb.106851586409075.6052044288804.6052044290004 |
|||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Ad” |
Ad |
||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the ad |
|||
URL_CURRENT |
varchar |
||||
URL_OLD |
varchar |
||||
URL_REQUESTED |
varchar |
||||
URL_ALTENATIVES |
varchar |
||||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
6008900572523230000 |
BIZ_FACTS.AD_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all advertisers downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the advertiser |
X | ||
DISPLAY_ID |
varchar |
||||
AD_ACCOUNT_UNIQUE_ID |
varchar |
BIZ_AD_ACCOUNTS.ID | |||
AD_ACCOUNT_NAME |
varchar |
||||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser, specifically for Doubleclick. |
300181641 |
||
ADVERTISER_NAME |
varchar |
The name of the advertiser, specifically for Doubleclick. |
Marketo Measure Marketing Analytics |
||
AD_GROUP_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Group above the Advertiser in any ads hierarchy |
NULL |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
Expected to be NULL since there is no Ad Group above the Advertiser in any ads hierarchy |
NULL |
||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Campaign above the Advertiser in any ads hierarchy |
NULL |
BIZ_AD_CAMPAIGNS.ID | |
AD_CAMPAIGN_NAME |
varchar |
Expected to be NULL since there is no Campaign above the Ad Advertiser in any ads hierarchy |
NULL |
||
IS_ACTIVE |
boolean |
Whether or not the advertiser is still active in the ads platform |
TRUE |
||
IS_DELETED |
boolean |
Whether or not the advertiser has been deleted in the ads platform |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:35:59.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date and time that this row was first added to the table |
2018-08-02 06:35:59.000 |
||
NAME |
varchar |
The name of the advertiser |
Marketo Measure Marketing Analytics |
||
NEEDS_UPDATE |
boolean |
Whether or not this row needs to have Marketo Measure update its tags |
FALSE |
||
GROUPING_KEY |
varchar |
||||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Advertisers” |
Advertisers |
||
PROVIDER_TYPE |
varchar |
The ad provider for the advertiser |
Doubleclick |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
6008900572523230000 |
BIZ_FACTS.ADVERTISER_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all ads accounts downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the ad account |
aw.6601259029 |
X | |
DISPLAY_ID |
varchar |
6601259029 |
|||
AD_ACCOUNT_UNIQUE_ID |
varchar |
NULL |
|||
AD_ACCOUNT_NAME |
varchar |
NULL |
|||
ADVERTISER_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Advertiser above the Ad Accounts in any ads hierarchy |
NULL |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
Expected to be NULL since there is no Advertiser above the Ad Accounts in any ads hierarchy |
NULL |
||
AD_GROUP_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Group above the Ad Accounts in any ads hierarchy |
NULL |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
Expected to be NULL since there is no Ad Group above the Ad Accounts in any ads hierarchy |
NULL |
||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Campaign above the Ad Accounts in any ads hierarchy |
NULL |
BIZ_AD_CAMPAIGNS.ID | |
AD_CAMPAIGN_NAME |
varchar |
Expected to be NULL since there is no Ad Campaign above the Ad Accounts in any ads hierarchy |
NULL |
||
IS_ACTIVE |
boolean |
Whether or not the advertiser is still active in the ads platform |
TRUE |
||
IS_DELETED |
boolean |
Whether or not the advertiser has been deleted in the ads platform |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-09-06 12:54:37.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date and time that this row was first added to the table |
2018-08-02 06:35:58.000 |
||
NAME |
varchar |
The name of the ad account |
Marketo Measure |
||
NEEDS_UPDATE |
boolean |
Whether or not the tagging needs to get updatedfor this ads account. |
FALSE |
||
GROUPING_KEY |
varchar |
NULL |
|||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Account” |
Account |
||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the ad account |
AdWords |
||
ACCOUNT_CURRENCY_UNIT |
varchar |
The currency code that is used for the ads account. |
USD |
||
COMPANY_ID |
varchar |
NULL |
|||
SOURCE |
varchar |
NULL |
|||
MEDIUM |
varchar |
NULL |
|||
LAST_30_DAYS_COST |
number(38,19) |
The amount of spend imported for the last 30 days. |
17260.000000000000000000 |
||
LAST_30_DAYS_IMPRESSIONS |
number(38,0) |
The number of impressions from the last 30 days |
730060 |
||
LAST_30_DAYS_CLICKS |
number(38,0) |
The number of clicks from the last 30 days |
3400 |
||
LAST_30_DAYS_CONVERSIONS |
number(38,0) |
The number of conversions reported from the last 30 days |
180 |
||
TRACKING_URL_TEMPLATE |
varchar |
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType} |
|||
TRACKING_URL_TEMPLATE_OLD |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_REQUESTED |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_APPLIED |
varchar |
The tracking template added on the Ad Account level for AdWords or Bing for tagging landing pages. |
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType} |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-4609512587744160000 |
BIZ_FACTS.AD_ACCOUNT_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all campaigns downloaded from any connected ads accounts or UTM campaigns.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the campaign |
aw.6601259029.285114995 |
X | |
DISPLAY_ID |
varchar |
285114995 |
|||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the campaign |
aw.6601259029 |
BIZ_AD_ACCOUNTS.ID | |
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the campaign |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser for the campaign, specifically for Doubleclick. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser for the campaign, specifically for Doubleclick. |
Marketo Measure Marketing Analytics |
||
AD_GROUP_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Group above the Campaign in any ads hierarchy |
NULL |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
Expected to be NULL since there is no Ad Group above the Campaign in any ads hierarchy |
NULL |
||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign |
NULL |
||
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign |
NULL |
||
IS_ACTIVE |
boolean |
Whether or not the campaign is still active in the ads account |
TRUE |
||
IS_DELETED |
boolean |
Whether or not the campaign has been deleted in the ads account |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:35:58.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date that the campaign was first downloaded by Marketo Measure |
2018-08-02 06:35:58.000 |
||
NAME |
varchar |
The name of the campaign |
Partner Retargeting |
||
NEEDS_UPDATE |
boolean |
Whether or not the campaign needs to get updated to get Marketo Measure tagging |
FALSE |
||
GROUPING_KEY |
varchar |
aw.6601259029 |
|||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Campaign” |
Campaign |
||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the campaign |
AdWords |
||
DAILY_BUDGET |
number(38,19) |
The daily budget that’s set in the ad platform for the campaign. |
0.0000000000000000000 |
||
TRACKING_URL_TEMPLATE |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_OLD |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_REQUESTED |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_APPLIED |
varchar |
The tracking template added on the Ad Campaign level for AdWords or Bing for tagging landing pages. |
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType} |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-6008900572523230000 |
BIZ_FACTS.CAMPAIGN_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all Ad forms downloaded from any connected ads accounts.
Column | Data Type | Description | Sample Data | Primary Key | Foreign Keys/Joins | Is Private |
---|---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the Ad forms |
li.507063119.3757704 |
X | ||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the ad form | li.507063119 |
AD_ACCOUNTS.ID | ||
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the ad form |
Marketo Measure |
|||
IS_ACTIVE |
boolean |
The Ad from is set to active if the status is {"APPROVED", "SUBMITTED"} |
TRUE |
|||
IS_DELETED |
boolean |
The Ad from is set to deleted if the status is {"DRAFT", "ARCHIVED", "CANCELED"} |
FALSE |
|||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:35:58.000 |
|||
FIRST_IMPORTED |
timestamp_ntz |
The date that the campaign was first downloaded by Marketo Measure |
2018-08-02 06:35:58.000 |
|||
NAME |
varchar |
The name of the Ad form |
NSPA Ebook LGF (May 2020) |
|||
GROUPING_KEY |
varchar |
aw.6601259029 |
||||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “AdForm” |
AdForm |
|||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the Ad form |
||||
DESCRIPTION |
varchar |
Description of the Ad Form. |
Learn how intelligent automation can increase process efficiency in mortgage refinance loan applications. |
|||
HEADLINE |
varchar |
Headline of the Ad Form. |
It’s Time to Automate the Refinancing Application Process |
|||
LANDING_URL |
varchar |
Landing URL of the Ad Form. | https://hyperscience.com/blog/refinancing-application-process/ |
|||
QUESTIONS |
varchar |
List of Questions of the Ad Form. |
First name:Last name:Email address:Country/Region:Job title:Company name |
|||
STATUS |
varchar |
Status of the Ad Form. |
SUBMITTED |
|||
SOURCE_ID |
varchar |
Id of the source for this record |
aw.3284209 |
SOURCES.ID | X | |
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
|||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
|||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all ad groups downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the ad group |
aw.6601259029.317737955.23105326115 |
X | |
DISPLAY_ID |
varchar |
23105326115 |
|||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the ad group |
aw.6601259029 |
BIZ_AD_ACCOUNTS.ID | |
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the ad group |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Group in the Doubleclick ads hierarchy. |
NULL |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
Expected to be NULL since there is no Ad Group in the Doubleclick ads hierarchy. |
NULL |
||
AD_GROUP_UNIQUE_ID |
varchar |
The ID of the ad group for the ad group |
NULL |
||
AD_GROUP_NAME |
varchar |
The name of the ad group for the ad group |
NULL |
||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign for the ad group |
aw.6601259029.317737955 |
BIZ_AD_CAMPAIGNS.ID | |
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign for the ad group |
Revenue Attribution |
||
IS_ACTIVE |
boolean |
Whether or not the ad group is still active in the ads account |
TRUE |
||
IS_DELETED |
boolean |
Whether or not the ad group has been deleted in the ads account |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:36:14.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date that the ad group was first downloaded by Marketo Measure |
2018-08-02 06:36:14.000 |
||
NAME |
varchar |
The name of the ad group |
Revenue Attribution - Account Based |
||
NEEDS_UPDATE |
boolean |
Whether or not the ad group needs to get updated to get Marketo Measure tagging |
FALSE |
||
GROUPING_KEY |
varchar |
aw.6601259029.317737955 |
|||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “AdGroup” |
AdGroup |
||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the ad group |
AdWords |
||
AD_NETWORK_TYPE |
varchar |
The medium(s) that the Ad Group is running on |
Search, Display, YouTube_Search, YouTube_Watch |
||
TRACKING_URL_TEMPLATE |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_OLD |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_REQUESTED |
varchar |
NULL |
|||
TRACKING_URL_TEMPLATE_APPLIED |
varchar |
The tracking template added on the Ad Account level for AdWords or Bing for tagging landing pages. |
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType} |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-5594512713562690000 |
BIZ_FACTS.AD_GROUP_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all ad providers recognized from any connected ads accounts. This includes an entry for “SelfReported” costs so that it can link to the costs table.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the ad provider |
Bing |
X | |
NAME |
varchar |
The name of the ad provider |
Bing |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
4783788151269206864 |
BIZ_FACTS.AD_PROVIDER_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All touchpoints that are associated with an Opportunity. This table will be empty if Opportunity Touchpoints is disabled.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the touchpoint |
BAT2_0060Z00000lFHtOQAW_ 0030Z00003K5bpKQAR_2017-06-20:01-05-20-6193330.0b5c5678807c |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-09-01 04:53:53.000 |
||
USER_TOUCHPOINT_ID |
varchar |
A lookup to the Biz_User_Touchpoints table to select columns such as email, campaignmember_id, session_id |
email@adobe.com |
BIZ_USER_TOUCHPOINTS.ID |
|
OPPORTUNITY_ID |
varchar |
A lookup to the Biz_Opportunities table to select columns such as Amount or Close Date |
0060Z00000lFHtOQAW |
BIZ_OPPORTUNITIES.ID |
|
CONTACT_ID |
varchar |
A lookup to the Biz_Contacts table to select columns such as Created Date |
0030Z00003K5bpKQAR |
BIZ_CONTACTS.ID |
|
ACCOUNT_ID |
varchar |
A lookup to the Biz_Accounts table to select columns such as Website or Engagement Rating |
0013100001otbIAAAY |
BIZ_ACCOUNTS.ID |
|
TOUCHPOINT_DATE |
timestamp_ntz |
The date of the recorded touchpoint, which is the date that the session occurred |
2017-06-20 01:05:20.000 |
||
MARKETING_TOUCH_TYPE |
varchar |
Referred to in the CRM as “Touchpoint Type.” This records the type of activity, whether it was a Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity |
Web Form |
||
CHANNEL |
varchar |
Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. |
Social.LinkedIn |
||
CATEGORY1 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 1st Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
ABC, or NULL |
||
CATEGORY2 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 2nd Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
Yes, or NULL |
||
CATEGORY3 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 3rd Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
SMB, or NULL |
||
CATEGORY4 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 4th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
New Business, or NULL |
||
CATEGORY5 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 5th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY6 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 6th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY7 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 7th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY8 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 8th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY9 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 9th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY10 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 10th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY11 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 11th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY12 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 12th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY13 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 13th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY14 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 14th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY15 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 15th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
BROWSER_NAME |
varchar |
From the javascript and IP address, the detected browser that the user was on during the session. For example, Chrome or Internet Explorer. |
Chrome |
||
BROWSER_VERSION |
varchar |
From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer. |
58 |
||
PLATFORM_NAME |
varchar |
From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows. |
Mac |
||
PLATFORM_VERSION |
varchar |
From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows. |
10_12 |
||
LANDING_PAGE |
varchar |
Referred to in the CRM as “Landing Page” This is the first landing page of the session that resulted in a touchpoint. |
http://www.adobe.com/blog/uncover- truth-behind-cost-per-lead |
||
LANDING_PAGE_RAW |
varchar |
Referred to in the CRM as “Landing Page - Raw.” This is the first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. |
http://www.adobe.com/blog/uncover-truth -behind-cost-per-lead?utm_content=27322869&utm_ medium=social&utm_source=linkedin |
||
REFERRER_PAGE |
varchar |
Referred to in the CRM as “Referrer Page” This is the usually the external landing page immediately before the user comes onto the website. |
https://www.linkedin.com/ |
||
REFERRER_PAGE_RAW |
varchar |
Referred to in the CRM as “Referrer Page - Raw.” This is the usually the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. |
https://www.linkedin.com/ |
||
FORM_PAGE |
varchar |
Referred to in the CRM as “Form URL.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table. |
http://info.adobe.com/intro-guide-b2b-marketing-attribution |
||
FORM_PAGE_RAW |
varchar |
Referred to in the CRM as “Form URL - Raw.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table. A raw form page may contain query parameters in the URL. |
http://info.adobe.com/intro-guide-b2b-marketing-attribution |
||
FORM_DATE |
timestamp_ntz |
The date that the form submission occurred. |
2017-06-20 01:06:41.000 |
||
CITY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver. |
San Francisco |
||
REGION |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia. |
California |
||
COUNTRY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada. |
United States |
||
MEDIUM |
varchar |
Used to define the medium that resulted in the touchpoint. This can either be parsed out from the URL from utm_medium or if Marketo Measure is able to resolve an ad, it may be values such as “cpc” or “display.” |
social |
||
WEB_SOURCE |
varchar |
Referred to in the CRM as “Touchpoint Source.” Used to define the source that resulted in the touchpoint. This can be parsed out from the URL from utm_source or generically set as “CRM Campaign” if it was synced from the CRM or if Marketo Measure is able to resolve an ad, it may be values such as “Google AdWords” or “Facebook.” |
|||
SEARCH_PHRASE |
varchar |
The value that the user entered in the browser to search for and end up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform. |
google marketo measure |
||
AD_PROVIDER |
varchar |
The ad platform that Marketo Measure was able to resolve from, typically one of our integration partners. |
|||
ACCOUNT_UNIQUE_ID |
varchar |
The Id of the ads account in which the ad was resolved from. |
aw.6601259029 |
BIZ_AD_ACCOUNTS.ID | |
ACCOUNT_NAME |
varchar |
The name of the ads account in which the ad was resolved from, such as Marketo-Measure-US. |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser from the ads accounts in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser from the ads account in which the ad was resolved from, such as Marketo Measure Inc. This only applies to Doubleclick Campaign Manager. |
Marketo Measure Marketing Analytics |
||
SITE_UNIQUE_ID |
varchar |
The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
1695651 |
BIZ_SITES.ID | |
SITE_NAME |
varchar |
The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager. |
Quora.com |
||
PLACEMENT_UNIQUE_ID |
varchar |
The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
120839827 |
BIZ_PLACEMENTS.ID | |
PLACEMENT_NAME |
varchar |
The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager. |
roadblock |
||
CAMPAIGN_UNIQUE_ID |
varchar |
The Id of the campaign from the ads account in which the ad was resolved from. |
aw.6601259029.317738075 |
BIZ_AD_CAMPAIGNS.ID | |
CAMPAIGN_NAME |
varchar |
The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar. |
Marketing Attribution |
||
AD_GROUP_UNIQUE_ID |
varchar |
The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords. |
aw.6601259029.317738075.23105327435 |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords. |
Marketing Attribution - General |
||
AD_UNIQUE_ID |
varchar |
The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display). |
NULL |
BIZ_ADS.ID | |
AD_NAME |
varchar |
The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display). |
NULL |
||
CREATIVE_UNIQUE_ID |
varchar |
The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
aw.6601259029.317738075.23105327435.182716179597 |
BIZ_CREATIVES.ID | |
CREATIVE_NAME |
varchar |
The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Google AdWords and Bing Ads (search). |
B2B Marketing Attribution |
||
CREATIVE_DESCRIPTION_1 |
varchar |
The first line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Download The CMOs Guide |
||
CREATIVE_DESCRIPTION_2 |
varchar |
The second line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Learn how attribution measures ROI by connecting marketing activities to revenue |
||
CREATIVE_DESTINATION_URL |
varchar |
The landing page that clicks through from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution |
||
CREATIVE_DISPLAY_URL |
varchar |
The friendly URL name that’s shown on the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
http://info.adobe.com/CMOs-Guide |
||
KEYWORD_UNIQUE_ID |
varchar |
The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads |
aw.6601259029.317738075.23105327435.4838421670 |
BIZ_KEYWORDS.ID | |
KEYWORD_NAME |
varchar |
The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search) |
"marketing attribution" |
||
KEYWORD_MATCH_TYPE |
varchar |
The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact” |
Phrase |
||
IS_FIRST_TOUCH |
boolean |
Whether or not this touchpoint is treated as the first touch of the opportunity journey |
FALSE |
||
IS_LEAD_CREATION_TOUCH |
boolean |
Whether or not this touchpoint is treated as the lead creation touch of the opportunity journey |
FALSE |
||
IS_OPP_CREATION_TOUCH |
boolean |
Whether or not this touchpoint is treated as the opportunity creation touch of the opportunity journey |
FALSE |
||
IS_CLOSED_TOUCH |
boolean |
Whether or not this touchpoint is treated as the closed touch of the opportunity journey |
FALSE |
||
STAGES_TOUCHED |
varchar |
The stages that the touchpoint has gone through |
Qualified Discovery, Demo Scheduled |
||
IS_FORM_SUBMISSION_TOUCH |
boolean |
Whether or not this touchpoint had a form fill during the session |
TRUE |
||
IS_IMPRESSION_TOUCH |
boolean |
Whether or not this touchpoint is treated as the first impression touch of the opportunity journey |
FALSE |
||
FIRST_CLICK_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s a first touch (See Is_First_Touch) |
0.0000000000000000000 |
||
LAST_ANON_CLICK_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s a lead creation touch (See Is_Last_Anon_Click_Percentage) |
0.0000000000000000000 |
||
U_SHAPE_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a u-shaped touch (See Is_First_Touch and Is_Lead_Creation_Touch) |
0.0000000000000000000 |
||
W_SHAPE_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a w-shaped touch (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch) |
0.0153374234214425 |
||
FULL_PATH_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch) |
0.0143061513081193 |
||
CUSTOM_MODEL_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch, Stages_Touched) |
0.0143061513081193 |
||
IS_DELETED |
boolean |
Whether this touchpoint is deleted or not. Used for diagnostics to see if a record was deleted in CRM. |
FALSE |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-2712935512233520000 |
BIZ_FACTS.ATP_KEY |
|
OPPORTUNITY_ROW_KEY |
number(38,0) |
-2712935512233520000 |
|||
LANDING_PAGE_KEY | number(38,0) | ||||
REFERRER_PAGE_KEY | number(38,0) | ||||
FORM_PAGE_KEY | number(38,0) | ||||
ACCOUNT_ROW_KEY | number(38,0) | ||||
ADVERTISER_ROW_KEY | number(38,0) | ||||
SITE_ROW_KEY | number(38,0) | ||||
PLACEMENT_ROW_KEY |
number(38,0) | ||||
CAMPAIGN_ROW_KEY | number(38,0) | ||||
AD_ROW_KEY | number(38,0) | ||||
AD_GROUP_ROW_KEY | number(38,0) | ||||
CREATIVE_ROW_KEY | number(38,0) | ||||
KEYWORD_ROW_KEY | number(38,0) | ||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All CRM Campaign Members that are imported, along with custom Marketo Measure fields. This table will be empty if Campaign Sync is disabled.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
CRM CampaignMember Id |
00v0Z00001VVzdLQAT |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Campaign Member from the CRM |
2018-08-31 20:49:54.000 |
||
CREATED_DATE |
timestamp_ntz |
The created date of the Campaign Member from the CRM |
2018-08-31 20:49:54.000 |
||
BIZIBLE_TOUCH_POINT_DATE |
timestamp_ntz |
(optional) The date and time that the customer sets to override the campaign date and use this value for the Touchpoint Date instead |
2018-08-30 18:00:00.000 |
||
LEAD_ID |
varchar |
The Id for the related Lead that this Campaign Member is tied to |
00Q0Z000013dw4GUAQ |
BIZ_LEADS.ID |
|
LEAD_EMAIL |
varchar |
The email for the related Lead that this Campaign Member is tied to |
email@adobe.com |
||
CONTACT_ID |
varchar |
The Id for the related Contact that this Campaign Member is tied to |
00331000032hMxRAAU |
BIZ_CONTACTS.ID |
|
CONTACT_EMAIL |
varchar |
The email for the related Contact that this Campaign Member is tied to |
email@adobe.com |
||
STATUS |
varchar |
The Campaign Member’s status, usually set to Sent or Responded or another custom value. This status is tied to the Campaign_Sync_Type to determine which Campaign Members to create touchpoints for |
FALSE |
||
HAS_RESPONDED |
boolean |
A true/false value that tells if the Campaign Member was marked as “Responded” from the Status picker |
TRUE |
||
FIRST_RESPONDED_DATE |
timestamp_ntz |
A date field that is automatically populated if Has_Responded is marked as true |
2018-08-30 07:00:00.000 |
||
CAMPAIGN_NAME |
varchar |
The name for the related Campaign that this Campaign Member is apart of |
Fast CMO Interviews |
||
CAMPAIGN_ID |
varchar |
The Id for the related Campaign that this Campaign Member is apart of |
7010Z000001TcKlQAK |
BIZ_AD_CAMPAIGNS.ID | |
CAMPAIGN_TYPE |
varchar |
The Type that’s selected on the related Campaign that this Campaign Member is apart of. The Type is used to map the Marketing Channel. |
Offline |
||
CAMPAIGN_SYNC_TYPE |
varchar |
Used to determine which Campaign Members to create touchpoints for. The possible values are: Include All Campaign Members, Include “Responded” Campaign Members, Exclude All Campaign Members |
Include_All |
||
LEAD_SYNC_STATUS |
varchar |
Used as an audit field to tell whether or not a touchpoint was generated for this Lead as a Buyer Touchpoint and if not, the reason why it didn’t qualify |
No Touchpoint: Date outside model |
||
CONTACT_SYNC_STATUS |
varchar |
Used as an audit field to tell whether or not a touchpoint was generated for this Contact as a Buyer Touchpoint and if not, the reason why it didn’t qualify |
Touchpoint Created |
||
OPP_SYNC_STATUS |
varchar |
Used as an audit field to tell whether or not a touchpoint was generated for this Contact as a Buyer Attribution Touchpoint and if not, the reason why it didn’t qualify |
Touchpoint Created |
||
IS_DELETED |
boolean |
Finds whether or not the Campaign Member that was in the system is deleted. Used for diagnostics to see if a record was deleted in CRM. |
FALSE |
||
CUSTOM_PROPERTIES | varchar | Custom CRM properties that Marketo Measure has imported from the CRM in JSON format | {"Campaign_Type__c":"Dinners","Foo":"Bar"} | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all marketing channels, as created by the customer.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for each marketing channel |
Paid Search |
X | |
NAME |
varchar |
The name of each marketing channel, as created by the customer |
Paid Search |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
2018-08-30 07:00:00.000 |
BIZ_FACTS.CHANNEL_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Currency conversion rate data from the CRM.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID | number(38,0) | A unique value for each currency and start_date combination | X | ||
CURRENCY_ID | number(38,0) | The unique id value for the currency | 7493833133899044458 | BIZ_CURRENCIES.ID | |
SOURCE_ISO_CODE | varchar | The currency ISO code from the CRM source | USD | ||
START_DATE | timestamp_ntz | The start date of the conversion rate | 2018-11-01 00:00:00.000 |
||
END_DATE | timestamp_ntz | The next start date for the conversion rate (i.e. the end date for the conversion rate is end_date minus 1 day) | 2018-09-01 00:00:00.000 |
||
CONVERSION_RATE | number(38,0) | The rate used to convert the currency to the corporate currency | 0.76728300 | ||
CREATED_DATE | timestamp_ntz | 2019-03-30 00:54:50.000 |
|||
MODIFIED_DATE | timestamp_ntz | 2019-03-30 00:54:50.000 |
|||
IS_DELETED | boolean | Used to determine if the row/value was deleted from the CRM | FALSE | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All CRM Contacts that are imported, along with custom Marketo Measure fields.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
CRM Contact Id |
0030Z00003OzioeQAB |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Contact from the CRM |
2018-09-05 05:17:53.000 |
||
CREATED_DATE |
timestamp_ntz |
The created date of the Contact from the CRM |
2018-09-05 05:17:51.000 |
||
varchar |
The email address of the Contact from the CRM |
email@adobe.com |
|||
ACCOUNTID |
varchar |
The Id of the related Account that this Contact is tied to |
0013100001b44aGAAQ |
BIZ_ACCOUNTS.ID |
|
LEAD_SOURCE |
varchar |
The source in which the contact was created |
NULL |
||
BIZIBLE_STAGE |
varchar |
The current stage that the Contact is sitting in, recognized as a custom stage that can be created in Marketo Measure’s application. |
Demo Scheduled |
||
BIZIBLE_STAGE_PREVIOUS |
varchar |
A string of all stages that the Contact had previously gone through, recognized as custom stages that can be created in Marketo Measure’s application. |
Open - Contact |
||
ODDS_OF_CONVERSION |
number(38,19) |
Marketo Measure's algorithm of estimating whether a contact will help an opportunity close based on the age and stage |
NULL |
||
BIZIBLE_COOKIE_ID |
varchar |
Marketo Measure's CookieId value that is used to populate from an integration partner to map an offline Event to a web session. Requirement: Enable Call Tracking: True |
08c1063cb0a64349ad0d2d862f5cc700 |
||
IS_DELETED |
boolean |
Finds whether or not the Contact that was in the system is deleted |
FALSE |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
3263982503087870000 |
||
CUSTOM_PROPERTIES | varchar | Custom CRM properties that Marketo Measure has imported from the CRM in JSON format | {"Contact_Type__c":"CMO", "Foo":"Bar"} | ||
IS_DUPLICATE | boolean | Default is 'FALSE'. This column exists to mark any persons (leads, contacts) that exist in both Marketo and CRM as duplicate true. If there are duplicates, the Marketo Source lead will be marked IS_DUPLICATE = true (see BIZ_LEADS) | FALSE / TRUE | ||
SOURCE_SYSTEM | varchar | Default is 'Crm'. This column exists to capture the 'source' (Marketo or Crm) from where a contact was imported into our system. | CRM / Marketo |
||
OTHER_SYSTEM_ID |
varchar | Default is 'NULL'. This column exists to map a person from Marketo with a Contact from Crm. The value would be the corresponding ID (from Marketo or CRM) |
1234 / 00Q0Z00001OohgTUAR |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All cost data, either from third party integrations or self reported marketing spend, segmented by various dimensions like Account, Channel, Campaign, Creative, Keyword, AdGroup, Site, Placement.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the cost record |
aw.6601259029.285114995.21703163075.[AdWords Display]_2018-09-06 |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-09-06 12:22:45.000 |
||
COST_DATE |
timestamp_ntz |
The date that the cost was reported on |
2018-09-06 00:00:00.000 |
||
SOURCE |
varchar |
The source of the reported cost |
[AdWords Display] |
||
COST_IN_MICRO |
number(38,0) |
The reported cost of the day in millions. User will need to divide the value by 1000000 before using this column. |
1410000 |
||
CLICKS |
number(38,0) |
The number of clicks reported for the group for the day |
4 |
||
IMPRESSIONS |
number(38,0) |
The number of impressions reported for the group for the day |
4187 |
||
ESTIMATED_TOTAL_POSSIBLE_IMPRESSIONS |
number(38,0) |
The total number of impressions that are estimated from DCM for the group for the day |
5024 |
||
AD_PROVIDER |
varchar |
The known provider (Google, Bing, Facebook, LinkedIn, SelfReported) in which the cost was pulled from, which could include costs uploaded through Marketing Spend |
|||
CHANNEL_UNIQUE_ID |
varchar |
The Id for the marketing channel, created by Marketo Measure |
Display.Google |
BIZ_CHANNELS.ID | |
CHANNEL_NAME |
varchar |
The name for the marketing channel, created by the customer in the Marketo Measure application |
Display.Google |
||
CHANNEL_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the channel, filter this column by “TRUE” |
FALSE |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser pulled from the ads connection, specifically for Doubleclick connections |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser pulled from the ads connection, specifically for Doubleclick connections |
Marketo Measure Marketing Analytics |
||
ADVERTISER_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the advertiser, filter this column by “TRUE” |
FALSE |
||
ACCOUNT_UNIQUE_ID |
varchar |
The Id of the ads account pulled from the ads connection |
aw.6601259029 |
BIZ_AD_ACCOUNTS.ID | |
ACCOUNT_NAME |
varchar |
The name of the ads account pulled from the ads connection |
Marketo Measure |
||
ACCOUNT_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the ads account, filter this column by “TRUE” |
FALSE |
||
CAMPAIGN_UNIQUE_ID |
varchar |
The Id of the campaign pulled from the ads connection |
aw.6601259029.285114995 |
BIZ_AD_CAMPAIGNS.ID | |
CAMPAIGN_NAME |
varchar |
The name of the campaign pulled from the ads connection |
Partner Retargeting |
||
CAMPAIGN_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the campaign, filter this column by “TRUE” |
FALSE |
||
AD_GROUP_UNIQUE_ID |
varchar |
The Id of the ad group pulled from the ads connection |
aw.6601259029.285114995.21703163075 |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
The name of the ad group pulled from the ads connection |
ClosedOpp |
||
AD_GROUP_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the ad group, filter this column by “TRUE” |
TRUE |
||
AD_UNIQUE_ID |
varchar |
The Id of the ad pulled from the ads connection |
BIZ_ADS.ID | ||
AD_NAME |
varchar |
The name of the ad pulled from the ads connection |
|||
AD_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the ad, filter this column by “TRUE” |
FALSE |
||
CREATIVE_UNIQUE_ID |
varchar |
The Id of the creative pulled from the ads connection |
aw.6601259029.285114995.51749608028.266050115160 |
BIZ_CREATIVES.ID | |
CREATIVE_NAME |
varchar |
The name of the creative pulled from the ads connection |
Ad name: Ad3-320x50.gif; 320 x 50 |
||
CREATIVE_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the creative, filter this column by “TRUE” |
FALSE |
||
KEYWORD_UNIQUE_ID |
varchar |
The Id of the keyword pulled from the ads connection |
aw.6601259029.669328935.39419128772.99608705795 |
BIZ_KEYWORDS.ID | |
KEYWORD_NAME |
varchar |
The name of the keyword pulled from the ads connection |
sfdc marketing attribution |
||
KEYWORD_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the keyword, filter this column by “TRUE” |
FALSE |
||
PLACEMENT_UNIQUE_ID |
varchar |
The Id of the placement pulled from the ads connection |
120839827 |
BIZ_PLACEMENTS.ID | |
PLACEMENT_NAME |
varchar |
The name of the placement pulled from the ads connection |
roadblock |
||
PLACEMENT_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the placement, filter this column by “TRUE” |
FALSE |
||
SITE_UNIQUE_ID |
varchar |
The Id of the site pulled from the ads connection |
1695651 |
BIZ_SITES.ID | |
SITE_NAME |
varchar |
The name of the site pulled from the ads connection |
quora.com | ||
SITE_IS_AGGREGATABLE_COST |
boolean |
If rolling up costs and summarizing by the site, filter this column by “TRUE” |
FALSE |
||
IS_DELETED |
boolean |
Whether or not the record was deleted, used as an audit trail. |
FALSE |
||
ROW_KEY | number(38,0) | BIZ_FACTS.COST_KEY | |||
ACCOUNT_ROW_KEY |
number(38,0) | ||||
ADVERTISER_ROW_KEY | number(38,0) | ||||
SITE_ROW_KEY | number(38,0) | ||||
PLACEMENT_ROW_KEY | number(38,0) | ||||
CAMPAIGN_ROW_KEY | number(38,0) | ||||
AD_ROW_KEY | number(38,0) | ||||
AD_GROUP_ROW_KEY | number(38,0) | ||||
CREATIVE_ROW_KEY | number(38,0) | ||||
KEYWORD_ROW_KEY | number(38,0) | ||||
ISO_CURRENCY_CODE | varchar | The ISO currency code as imported from costs data source. | USD | ||
CURRENCY_ID | number(38,0) | BIZ_CURRENCIES.ID | |||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all creatives downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the creative |
ba.3284209.132855866.4556709270.10426699711 |
X | |
DISPLAY_ID |
varchar |
10426699711 |
|||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the creative |
ba.3284209 |
BIZ_AD_ACCOUNTS.ID | |
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the creative |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser for the creative, specifically for Doubleclick. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser for the creative, specifically for Doubleclick. |
Marketo Measure Marketing Analytics |
||
AD_GROUP_UNIQUE_ID |
varchar |
The ID of the ad group for the creative |
ba.3284209.132855866.4556709270 |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
The name of the ad group for the creative |
PipelineMarketing.com - General |
||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign for the creative |
ba.3284209.132855866 |
BIZ_AD_CAMPAIGNS.ID | |
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign for the creative |
PipelineMarketing.com |
||
IS_ACTIVE |
boolean |
Whether or not the creative is still active in the ads account |
TRUE |
||
IS_DELETED |
boolean |
Whether or not the creative has been deleted in the ads account |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:36:25.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date that the creative was first downloaded by Marketo Measure |
2018-08-02 06:36:25.000 |
||
NAME |
varchar |
The name of the creative |
PipelineMarketing.com |
||
NEEDS_UPDATE |
boolean |
Whether or not the creative needs to get updated to get Marketo Measure tagging |
FALSE |
||
GROUPING_KEY |
varchar |
ba.3284209.132855866.4556709270 |
|||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Creative” |
Creative |
||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the creative |
BingAds |
||
URL_CURRENT |
varchar |
The current version of the URL including all tags |
cdn.adobe.com/redir?lp=http%3a%2f%2fwww.pipelinemarketing.com%2f&_bt={creative}&_bk={keyword}&_bm={matchType}&utm_content={adid}&utm_term={keyword}&utm_campaign=PipelineMarketing.com&utm_source=bing&utm_medium=cpc |
||
URL_DISPLAY |
varchar |
The shortened and friendly URL that’s displayed on the creative |
PipelineMarketing.com |
||
URL_OLD |
varchar |
||||
URL_REQUESTED |
varchar |
||||
URL_SHORTENED |
varchar |
||||
AD_TYPE |
varchar |
The type of creative, which could be Text or Display |
Text |
||
IS_UPGRADED_URL |
boolean |
Whether or not the creative is using Upgraded URLs |
FALSE |
||
HEADLINE |
varchar |
The top line (headline) of the creative |
PipelineMarketing.com |
||
DESCRIPTION_LINE_1 |
varchar |
The copy from the first line of the creative |
Connect & Learn From Revenue-Driven B2B Marketers. Join the Community. |
||
DESCRIPTION_LINE_2 |
varchar |
The copy from the second line of the creative |
Have You Used Analytics? Leave a Review Today! |
||
TRACKING_URL_TEMPLATE |
varchar |
||||
TRACKING_URL_TEMPLATE_OLD |
varchar |
||||
TRACKING_URL_TEMPLATE_REQUESTED |
varchar |
||||
TRACKING_URL_TEMPLATE_APPLIED |
varchar |
The URL tracking template that Marketo Measure added to the creative |
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType} |
||
SHARE_URN |
varchar |
The share Id, used for LinkedIn ads only. |
urn:li:share:6376987561897848832 |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
4609512587744160000 |
BIZ_FACTS.CREATIVE_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All CRM Events that are imported, along with custom Marketo Measure fields.
Requirements: Enable Activities Sync: True
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
CRM Event Id |
00U3100000VLUnEEAX |
X | |
CREATED_DATE |
timestamp_ntz |
The created date of the Event from the CRM |
2016-12-12 19:32:53.000 |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Event from the CRM |
2018-09-03 08:39:51.000 |
||
LEAD_ID |
varchar |
The Id of the related Lead that this Event is tied to |
00Q0Z000013eVrxUAE |
BIZ_LEADS.ID |
|
LEAD_EMAIL |
varchar |
The email of the related Lead that this Event is tied to |
email@adobe.com |
||
CONTACT_ID |
varchar |
The Id of the related Contact that this Event is tied to |
0030Z00003OyjbOQAR |
BIZ_CONTACTS.ID |
|
CONTACT_EMAIL |
varchar |
The email of the related Contact that this Event is tied to |
email@adobe.com |
||
BIZIBLE_COOKIE_ID |
varchar |
Marketo Measure’s CookieId value that is used to populate from an integration partner to map an offline Event to a web session. Requirement: Enable Call Tracking: True |
08c1063cb0a64349ad0d2d862f5cc700 |
||
ACTIVITY_TYPE |
varchar |
The Type value that’s pulled from the CRM for the Event |
|||
EVENT_START_DATE |
timestamp_ntz |
The start date of the Event record, one of the options used to determine the Buyer Touchpoint Date |
2016-12-16 19:30:00.000 |
||
EVENT_END_DATE |
timestamp_ntz |
The end date of the Event record, one of the options used to determine the Buyer Touchpoint Date |
2016-12-16 21:30:00.000 |
||
IS_DELETED |
boolean |
Finds whether or not the Event that was in the system is deleted |
FALSE |
||
CUSTOM_PROPERTIES | varchar | Custom CRM properties that Marketo Measure has imported from the CRM in JSON format | {"Contact_Type__c":"CMO","Foo":"Bar"} | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All CRM Tasks that are imported, along with custom Marketo Measure fields.
Requirements: Enable Activities Sync: True OR Enable Call Tracking: True
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
CRM Task Id |
00T0Z00004Rf62rUAB |
X | |
CREATED_DATE |
timestamp_ntz |
The created date of the Task from the CRM |
2018-08-27 18:30:25.000 |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Task from the CRM |
2018-08-27 18:31:53.000 |
||
LEAD_ID |
varchar |
The Id of the related Lead that this Task is tied to |
00Q0Z000013eVrxUAE |
BIZ_LEADS.ID |
|
LEAD_EMAIL |
varchar |
The email of the related Lead that this Task is tied to |
email@adobe.com |
||
CONTACT_ID |
varchar |
The Id of the related Contact that this Task is tied to |
00331000038uGfhAAE |
BIZ_CONTACTS.ID |
|
CONTACT_EMAIL |
varchar |
The email of the related Contact that this Task is tied to |
email@adobe.com |
||
BIZIBLE_COOKIE_ID |
varchar |
Marketo Measure’s CookieId value that is used to populate from an integration partner to map an offline Task to a web session. Requirement: Enable Call Tracking: True |
08c1063cb0a64349ad0d2d862f5cc700 |
||
ACTIVITY_TYPE |
varchar |
Used to describe the type of Task, usually along the lines of Call or Email or any other custom value. For Activities, this value is used to populate the Touchpoint Type and Medium. |
Call |
||
ACTIVITY_DATE |
timestamp_ntz |
The date that the Task occurred, one of the options used to determine the Buyer Touchpoint Date |
2018-08-27 07:00:00.000 |
||
IS_DELETED |
boolean |
Finds whether or not the Task that was in the system is deleted |
FALSE |
||
CUSTOM_PROPERTIES | varchar | Custom CRM properties that Marketo Measure has imported from the CRM in JSON format | {"Contact_Type__c":"CMO", "Foo":"Bar"} | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table of all ISO currencies.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
number(38,0) | A unique Id for the currency record | 139474809945095870 | X | |
ISO_CODE | varchar | The ISO code for the currency | USD | ||
IS_CORPORATE | boolean | Designates if the currency is the corporate currency | FALSE |
||
IS_ENABLED | boolean | Designates if the currency is enabled in the CRM or not | FALSE | ||
MODIFIED_DATE | timestamp_ntz | The last modified date from Marketo Measure | 2018-08-27 18:30:25.000 | ||
MODIFIED_DATE_CRM | timestamp_ntz | The last modified date of the currency from the CRM | 2018-08-27 18:30:25.000 | ||
CREATED_DATE | timestamp_ntz | The created date from Marketo Measure | 2018-08-27 18:30:25.000 | ||
CREATED_DATE_CRM | timestamp_ntz | The created date of the currency from the CRM | 2018-08-27 18:30:25.000 | ||
ISO_NUMERIC | number(38,0) | The ISO standard numeric code | 048 | ||
EXPONENT | number(38,0) | 2 | |||
NAME | varchar | The name of the currency | Argentine Peso | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
AB Tests that have been recorded which contain a VisitorId and is related to a Biz_Session. This will contain the experiment and variation that the user was shown.
Requirement: Enable AB Tests: Yes
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
VISITOR_ID |
varchar |
The first cookie of the related visitor Id |
BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID | ||
COOKIE_ID |
varchar |
The recorded cookie Id at the time the chat was logged. |
|||
EVENT_DATE |
timestamp_ntz |
The date and time that the chat was logged. |
|||
MODIFIED_DATE | timestamp_ntz | ||||
IP_ADDRESS | varchar |
The recorded IP address at the time the experiment was logged. |
|||
EXPERIMENT_ID |
varchar |
The Id of the experiment that’s pulled from the AB test platform. |
|||
EXPERIMENT_NAME |
varchar |
The name of the experiment that’s pulled from the AB test platform. |
|||
VARIATION_ID |
varchar |
The Id of the experiment’s variation that’s pulled from the AB test platform. |
|||
VARIATION_NAME |
varchar |
The name of the experiment’s variation that’s pulled from the AB test platform. |
|||
ABTEST_USER_ID |
varchar |
The Id of the user that was served the experiment that’s pulled from the AB test platform. |
|||
IS_DELETED |
boolean |
Whether or not the record was deleted, used for diagnostics and auditing. |
|||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Web events that have been recorded using custom events in the Javascript which contain a VisitorId and is related to a Biz_Session.
Requirement: Enable Marketo Measure Events: True
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
VISITOR_ID |
varchar |
The first cookie of the related visitor Id |
BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID | ||
COOKIE_ID |
varchar |
The recorded cookie Id at the time the event was triggered from the javascript. |
|||
EVENT_DATE |
timestamp_ntz |
The date and time that the event was triggered from the custom javascript. |
|||
MODIFIED_DATE | timestamp_ntz | ||||
IP_ADDRESS |
varchar |
The recorded IP address at the time the event was triggered from the custom javascript. |
|||
KEY |
varchar |
The name given to the event that was triggered from the custom javascript. For example, “Video View” |
|||
VALUE |
varchar |
A value that’s given from the event that was triggered from the custom javascript. For example, “75% viewed” |
|||
IS_DELETED |
boolean |
Whether or not the record was deleted, used for diagnostics and auditing. |
|||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all landing pages downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the row |
X | ||
DISPLAY_ID |
varchar |
||||
AD_ACCOUNT_UNIQUE_ID |
varchar |
BIZ_AD_ACCOUNTS.ID | |||
AD_ACCOUNT_NAME |
varchar |
||||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser for the landing page, specifically for Doubleclick. |
300181641 | BIZ_ADVERTISERS.ID |
|
ADVERTISER_NAME |
varchar |
The name of the advertiser for the landing page, specifically for Doubleclick. |
Marketo Measure Marketing Analytics |
||
AD_GROUP_UNIQUE_ID |
varchar |
BIZ_AD_GROUPS.ID | |||
AD_GROUP_NAME |
varchar |
||||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
BIZ_AD_CAMPAIGNS.ID | |||
AD_CAMPAIGN_NAME |
varchar |
||||
IS_ACTIVE |
boolean |
||||
IS_DELETED |
boolean |
||||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
|||
FIRST_IMPORTED |
timestamp_ntz |
||||
NAME |
varchar |
||||
NEEDS_UPDATE |
boolean |
||||
GROUPING_KEY |
varchar |
||||
ENTITY_TYPE |
varchar |
||||
PROVIDER_TYPE |
varchar |
||||
AD_DISPLAY_ID |
varchar |
||||
CREATIVE_DISPLAY_ID |
varchar |
||||
URL_CURRENT |
varchar |
||||
URL_OLD |
varchar |
||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Email addresses mapped to the Visitor_Id.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
varchar |
A known email address that’s tied to a given visitor Id from a session |
email@adobe.com |
X | ||
VISITOR_ID |
varchar |
The first cookie of the related visitor Id |
v_36ec805b4db344d6e92c972c86aee34a |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-14 23:55:03.000 |
||
CREATED_DATE |
timestamp_ntz |
The created date of the row |
2018-08-14 23:55:03.000 |
||
IS_DELETED |
boolean |
Whether or not the record was deleted, used for diagnostics and auditing. |
FALSE |
||
IS_IGNORED | boolean | ||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
The biz_facts table unions together Impressions, Page Views, Visits, Form Submits, User Touchpoints, Touchpoints (BT), Attribution Touchpoints (BAT), and Cost data. It is used internally to support Marketo Measure reporting in Discover.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
COST_KEY | number(38,0) | The key that relates this table to the BIZ_COSTS table to join the dimensions | 2672629811884560039 | BIZ_COSTS.ROW_KEY | |
ATP_KEY |
number(38,0) |
The key that relates this table to the BIZ_ATTRIBUTION_TOUCHPOINTS table to join the dimensions |
2672629811884560039 |
BIZ_ATTRIBUTION_TOUCHPOINTS.ROW_KEY |
|
TP_KEY |
number(38,0) |
The key that relates this table to the BIZ_TOUCHPOINTS table to join the dimensions |
5028390208679093800 |
BIZ_TOUCHPOINTS.ROW_KEY |
|
PAGE_VIEW_KEY |
number(38,0) |
The key that relates this table to the BIZ_PAGE_VIEWS table to join the dimensions |
-8044063242541720607 |
BIZ_PAGE_VIEWS.ROW_KEY |
|
SESSION_KEY |
number(38,0) |
The key that relates this table to the BIZ_SESSIONS table to join the dimensions |
8817975702393619368 |
BIZ_SESSIONS_ROW_KEY |
|
VISITOR_ID |
varchar |
The Id that relates this table to the BIZ_EMAIL_TO_VISITOR_IDS table to join the dimensions |
v_530d8334c455460df0d48f48270a4b23 |
BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID |
|
COOKIE_ID | varchar | ||||
FORM_SUBMIT_KEY |
number(38,0) |
The key that relates this table to the BIZ_FORM_SUBMITS table to join the dimensions |
-8659572802702769670 |
BIZ_FORM_SUBMITS.ROW_KEY |
|
IMPRESSION_KEY |
number(38,0) |
The key that relates this table to the BIZ_IMPRESSIONS table to join the dimensions |
8817975702393619368 |
BIZ_IMPRESSIONS.ROW_KEY |
|
CURRENT_PAGE_KEY |
number(38,0) |
4079876040770132443 |
BIZ_URLS.ROW_KEY | ||
REFERRER_PAGE_KEY |
number(38,0) |
8817975702393619368 |
BIZ_URLS.ROW_KEY | ||
FORM_PAGE_KEY |
number(38,0) |
8817975702393619368 |
|||
AD_PROVIDER_KEY |
number(38,0) |
The key that relates this table to the BIZ_AD_PROVIDERS table to join the dimensions |
8817975702393619368 |
BIZ_AD_PROVIDERS.ROW_KEY |
|
CHANNEL_KEY |
number(38,0) |
The key that relates this table to the BIZ_CHANNELS table to join the dimensions |
-1921844114032355934 |
BIZ_CHANNELS.ROW_KEY |
|
CAMPAIGN_KEY |
number(38,0) |
The key that relates this table to the BIZ_AD_CAMPAIGNS table to join the dimensions |
252687814634577606 |
BIZ_AD_CAMPAIGNS.ROW_KEY |
|
KEYWORD_KEY |
number(38,0) |
The key that relates this table to the BIZ_KEYWORDS table to join the dimensions |
8817975702393619368 |
BIZ_KEYWORDS.ROW_KEY |
|
AD_KEY |
number(38,0) |
The key that relates this table to the BIZ_ADS table to join the dimensions |
8817975702393619368 |
BIZ_ADS.ROW_KEY |
|
AD_GROUP_KEY |
number(38,0) |
The key that relates this table to the BIZ_AD_GROUPS table to join the dimensions |
8817975702393619368 |
BIZ_AD_GROUPS.ROW_KEY |
|
CREATIVE_KEY |
number(38,0) |
The key that relates this table to the BIZ_CREATIVES table to join the dimensions |
-2333871387956621113 |
BIZ_CREATIVES.ROW_KEY |
|
SITE_KEY |
number(38,0) |
The key that relates this table to the BIZ_SITES table to join the dimensions |
8817975702393619368 |
BIZ_SITES.ROW_KEY |
|
ADVERTISER_KEY |
number(38,0) |
The key that relates this table to the BIZ_ADVERTISERS table to join the dimensions |
8817975702393619368 |
BIZ_ADVERTISERS.ROW_KEY |
|
AD_ACCOUNT_KEY |
number(38,0) |
The key that relates this table to the BIZ_AD_ACCOUNTS table to join the dimensions |
1825012532740770032 |
BIZ_AD_ACCOUNTS.ROW_KEY |
|
PLACEMENT_KEY |
number(38,0) |
The key that relates this table to the BIZ_PLACEMENTS table to join the dimensions |
8817975702393619368 |
BIZ_PLACEMENTS.ROW_KEY |
|
CATEGORY_01_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_02_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_03_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_04_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_05_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_06_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_07_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_08_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_09_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_10_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_11_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_12_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_13_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_14_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
CATEGORY_15_KEY | number(38,0) | BIZ_SEGMENTS.ROW_KEY | |||
TYPE |
number(38,0) |
Maps the row to the category it belongs to: TPOpp = 1, |
3 |
||
DATE |
date |
2018-08-28 |
|||
TIMESTAMP |
timestamp_ntz |
2018-08-28 19:39:15.000 |
|||
MODIFIED_DATE |
timestamp_ntz |
The date and time the row was last modified |
2018-08-29 00:46:47.000 |
||
COST_IN_MICRO |
number(38,0) |
The reported cost of the day in millions. User will need to divide the value by 1000000 before using this column. |
27370000 |
||
IMPRESSIONS |
number(38,0) |
The number of impressions reported for the day |
340 |
||
CLICKS |
number(38,0) |
The number of clicks reported for the day |
4 |
||
FIRST_CLICK_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s a first touch (See Is_First_Touch) |
100.0000000000000000000 |
||
LAST_ANON_CLICK_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s a lead creation touch (See Is_Last_Anon_Click_Percentage) |
100.0000000000000000000 |
||
U_SHAPE_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a u-shaped touch (See Is_First_Touch and Is_Lead_Creation_Touch) |
100.0000000000000000000 |
||
W_SHAPE_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a w-shaped touch (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch) |
0.0000000000000000000 |
||
FULL_PATH_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch) |
0.0000000000000000000 |
||
CUSTOM_MODEL_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch, Stages_Touched) |
0.0000000000000000000 |
||
AMOUNT |
number(38,8) |
The deal amount that is expected or closed from the Opportunity |
42000.00000000 |
||
IS_WON |
boolean |
Whether or not the Opportunity has been moved to a stage that is considered Won |
FALSE |
||
IS_OPP_CLOSED |
boolean |
Whether or not the Opportunity has been moved to a stage that is considered closed, which can either be Won or Lost |
FALSE |
||
OPPORTUNITY_ID |
varchar |
The Id that relates this table to the BIZ_OPPORTUNITIES table to join the dimension |
0060Z00000nFEfEQAW |
BIZ_OPPORTUNITIES.ID |
|
OPP_CREATED_DATE |
timestamp_ntz |
The created date of the Opportunity from the CRM |
2018-08-31 15:45:47.000 |
||
OPP_CLOSE_DATE |
timestamp_ntz |
The anticipated or actual Close Date set on the Opportunity |
2018-12-31 07:00:00.000 |
||
CONTACT_CREATED_DATE |
timestamp_ntz |
The created date of the Contact from the CRM |
2018-08-07 20:49:07.000 |
||
CONTACT_ID |
varchar |
The Id that relates this table to the BIZ_CONTACTS table to join the dimensions |
0030Z00003ORVJmQAP |
BIZ_CONTACTS.ID |
|
varchar | |||||
LEAD_CREATED_DATE |
timestamp_ntz |
The created date of the Lead from the CRM |
2017-04-28 00:21:52.000 |
||
LEAD_ID |
varchar |
The Id that relates this table to the BIZ_LEADS table to join the dimensions |
00Q3100001GMPIsEAP |
BIZ_LEADS.ID |
|
IS_AGGREGATABLE_COST_AD |
boolean |
If rolling up costs and summarizing by the ad, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_ADVERTISER |
boolean |
If rolling up costs and summarizing by the advertiser, filter this column by “TRUE” |
TRUE |
||
IS_AGGREGATABLE_COST_AD_ACCOUNT |
boolean |
If rolling up costs and summarizing by the ad account, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_AD_GROUP |
boolean |
If rolling up costs and summarizing by the ad group, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_CAMPAIGN |
boolean |
If rolling up costs and summarizing by the campaign, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_CHANNEL |
boolean |
If rolling up costs and summarizing by the channel, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_CREATIVE |
boolean |
If rolling up costs and summarizing by the creative, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_KEYWORD |
boolean |
If rolling up costs and summarizing by the keyword, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_PLACEMENT |
boolean |
If rolling up costs and summarizing by the placement, filter this column by “TRUE” |
FALSE |
||
IS_AGGREGATABLE_COST_SITE |
boolean |
If rolling up costs and summarizing by the site, filter this column by “TRUE” |
FALSE |
||
IS_DELETED |
boolean |
Whether or not the record was deleted, used as an audit trail. |
FALSE |
||
ISO_CODE | varchar | ||||
CURRENCY_ID | number(38,0) | BIZ_CURRENCIES.ID | |||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All form submissions that occurred which contain a VisitorId and is related to a Biz_Session.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the form submission |
2018-08-06:01-35-21-927280.9bc63c34482f4 |
X | |
COOKIE_ID |
varchar |
The recorded cookie Id at the time the form was submitted |
9bc63c34482f4de8c2e3b9d8d9f0df56 |
||
VISITOR_ID |
varchar |
The first cookie of the related visitor Id |
v_9bc63c34482f4de8c2e3b9d8d9f0df56 |
BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID |
|
SESSION_ID |
varchar |
The recorded session Id at the time the form was submitted |
2018-08-06:01-35-24-1231230.9bc63c34482f |
BIZ_SESSIONS.ID |
|
EVENT_DATE |
timestamp_ntz |
The date and time that form was submitted |
2018-08-06 01:35:21.000 |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-07 23:09:52.000 |
||
CURRENT_PAGE |
varchar |
The URL where the form was submitted without query parameters. |
https://info.adobe.com/webinar-marketo-bizible-impact |
||
CURRENT_PAGE_RAW |
varchar |
The URL where the form was submitted. The current page may contain query parameters in the URL. |
https://info.adobe.com/webinar-marketo-bizible-impact?utm_source=partner&mkt_tok=eyJpIjoiTnpBeE1EVml PV0UyWlRObSIsInQiOiI3MEFIek04ZVJiWm9renc1Z29RXC9kXC92YkxycFRYclE0MVhOaH ThVXC9xc3FvR2pET2lXT1ZOMjlKZXEyd3lSMVU3YmljeWdZVWUyZU5iWiJ9 |
||
IP_ADDRESS |
varchar |
The recorded IP address at the time the form was submitted |
174.127.184.158 |
||
TYPE |
varchar |
FormSubmit |
|||
USER_AGENT_STRING |
varchar |
The device and browser that the person is using at the time of the form submit. |
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1.2 Safari/605.1.15 |
||
CLIENT_SEQUENCE |
varchar |
4 |
|||
CLIENT_RANDOM |
varchar |
20042b6b7af44512b43f6244d86faf4c |
|||
IS_DUPLICATED |
boolean |
FALSE |
|||
IS_PROCESSED |
boolean |
TRUE |
|||
varchar |
The email address provided that’s pulled directly from the form, as captured from the javascript. |
email@adobe.com |
|||
FORM_TYPE |
varchar |
Form |
|||
FORM_SOURCE |
varchar |
The method in which the form was recognized, such as onSubmit or AjaxIntercept |
onSubmit |
||
FORM_IDENTIFIER |
varchar |
-956012665 |
|||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-6255315750913680000 |
BIZ_FACTS.FORM_SUBMIT_KEY |
|
CURRENT_PAGE_KEY | number(38,0) | ||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All impressions that have been fired and recorded which contain a VisitorId and is related to the Biz_Touchpoints. This will contain the resolved ads information of the served impression.
Requirements: Enable View Through: True, Doubleclick by Google: True
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the impression |
X | ||
COOKIE_ID |
varchar |
The recorded cookie Id at the time of the impression |
|||
VISITOR_ID |
varchar |
The first cookie of the related visitor Id |
BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID |
||
SESSION_ID |
varchar |
The recorded session Id at the time of the impression. |
BIZ_SESSIONS.ID |
||
EVENT_DATE |
timestamp_ntz |
The date and time that the impression was served |
|||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
|||
CURRENT_PAGE |
varchar |
The URL where the impression was served without query parameters. |
|||
CURRENT_PAGE_RAW |
varchar |
The URL where the form was submitted. The current page may contain query parameters in the URL. |
|||
IP_ADDRESS |
varchar |
The recorded IP address at the time of the impression |
|||
TYPE |
varchar |
||||
USER_AGENT_STRING |
varchar |
The device and browser that the person is using at the time of the form submit. |
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1.2 Safari/605.1.15 |
||
CLIENT_SEQUENCE |
varchar |
4 |
|||
CLIENT_RANDOM |
varchar |
20042b6b7af44512b43f6244d86faf4c |
|||
IS_DUPLICATED |
boolean |
FALSE |
|||
IS_PROCESSED |
boolean |
TRUE |
|||
REFERRER_PAGE |
varchar |
Referred to in the CRM as “Referrer Page” This is the usually the external landing page immediately before the user comes onto the website. |
|||
REFERRER_PAGE-RAW |
varchar |
Referred to in the CRM as “Referrer Page - Raw.” This is the usually the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. |
|||
CITY |
varchar |
The resolved city from the IP address. For example, Seattle or Vancouver. |
Seattle |
||
REGION |
varchar |
The resolved region from the IP address. For example, Washington or British Columbia. |
Washington |
||
COUNTRY |
varchar |
The resolved country from the IP address. For example, United States or Canada. |
United States |
||
ISP_NAME |
varchar |
The name of the internet service provider, used by customers with advanced Geo IP tracking. |
AT&T U-verse |
||
AD_PROVIDER |
varchar |
The ad platform that Marketo Measure was able to resolve from, typically one of our integration partners. |
|||
ACCOUNT_UNIQUE_ID |
varchar |
The Id of the ads account in which the ad was resolved from. |
BIZ_AD_ACCOUNTS.ID | ||
ACCOUNT_NAME |
varchar |
The name of the ads account in which the ad was resolved from, such as Marketo-Measure-US. |
|||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically for Doubleclick connections. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser from the ads account in which the ad was resolved from, specifically for Doubleclick connections. |
Marketo Measure Marketing Analytics |
||
SITE_UNIQUE_ID |
varchar |
The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
1695651 |
BIZ_SITES.ID | |
SITE_NAME |
varchar |
The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager. |
Quora.com |
||
PLACEMENT_UNIQUE_ID |
varchar |
The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
120839827 |
BIZ_PLACEMENTS.ID | |
PLACEMENT_NAME |
varchar |
The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager. |
roadblock |
||
CAMPAIGN_UNIQUE_ID |
varchar |
The Id of the campaign from the ads account in which the ad was resolved from. |
BIZ_AD_CAMPAIGNS.ID | ||
CAMPAIGN_NAME |
varchar |
The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar. |
|||
AD_GROUP_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Group in the Doubleclick hierarchy for impressions |
NULL |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
Expected to be NULL since there is no Ad Group in the Doubleclick hierarchy for impressions |
NULL |
||
AD_UNIQUE_ID |
varchar |
The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display). |
68035923 |
BIZ_ADS.ID | |
AD_NAME |
varchar |
The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display). |
centurylink_banner_98121 |
||
CREATIVE_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
BIZ_CREATIVES.ID | |
CREATIVE_NAME |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
||
CREATIVE_DESCRIPTION_1 |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
||
CREATIVE_DESCRIPTION_2 |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
||
CREATIVE_DESTINATION_URL |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
||
CREATIVE_DISPLAY_URL |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
||
KEYWORD_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
BIZ_KEYWORDS.ID | |
KEYWORD_NAME |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
||
KEYWORD_MATCH_TYPE |
varchar |
Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions |
NULL |
||
BROWSER_NAME |
varchar |
From the javascript and IP address, the detected browser that the user was on during the session. For example, Chrome or Internet Explorer. |
Chrome |
||
BROWSER_VERSION |
varchar |
From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer. |
58 |
||
PLATFORM_NAME |
varchar |
From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows. |
Mac |
||
PLATFORM_VERSION |
varchar |
From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows. |
10_12 |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-2712935512233520000 |
BIZ_FACTS.IMPRESSION_KEY |
|
CURRENT_PAGE_KEY |
number(38,0) | ||||
REFERRER_PAGE_KEY | number(38,0) | ||||
ACCOUNT_ROW_KEY | number(38,0) | ||||
ADVERTISER_ROW_KEY | number(38,0) | ||||
SITE_ROW_KEY | number(38,0) | ||||
PLACEMENT_ROW_KEY | number(38,0) | ||||
CAMPAIGN_ROW_KEY | number(38,0) | ||||
AD_ROW_KEY | number(38,0) | ||||
AD_GROUP_ROW_KEY | number(38,0) | ||||
CREATIVE_ROW_KEY | number(38,0) | ||||
KEYWORD_ROW_KEY | number(38,0) | ||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all keywords downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the keyword |
ba.3284209.132630532.3646889365.39464932147 |
X | |
DISPLAY_ID |
varchar |
39464932147 |
|||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the keyword |
ba.3284209 |
BIZ_AD_ACCOUNTS.ID | |
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the keyword |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Keyword in the Doubleclick ads hierarchy. |
NULL |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
Expected to be NULL since there is no Keyword in the Doubleclick ads hierarchy. |
NULL |
||
AD_GROUP_UNIQUE_ID |
varchar |
The ID of the ad group for the keyword |
ba.3284209.132630532.3646889365 |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
The name of the ad group for the keyword |
Revenue Attribution - B2B |
||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign for the keyword |
ba.3284209.132630532 |
BIZ_AD_CAMPAIGNS.ID | |
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign for the keyword |
Revenue Attribution |
||
IS_ACTIVE |
boolean |
Whether or not the keyword is still active in the ads account |
TRUE |
||
IS_DELETED |
boolean |
Whether or not the keyword has been deleted in the ads account |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:37:29.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date that the keyword was first downloaded by Marketo Measure |
2018-08-02 06:37:29.000 |
||
NAME |
varchar |
The name of the keyword |
[revenue attribution b2b] |
||
NEEDS_UPDATE |
boolean |
Whether or not the keyword needs to get updated to get Marketo Measure tagging |
FALSE |
||
GROUPING_KEY |
varchar |
ba.3284209.132630532.3646889365 |
|||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Keyword” |
Keyword |
||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the keyword |
BingAds |
||
URL_CURRENT |
varchar |
||||
URL_OLD |
varchar |
||||
IS_UPGRADED_URL |
boolean |
TRUE |
|||
WORD |
varchar |
revenue attribution b2b |
|||
MATCH_TYPE |
varchar |
The type of match that was found between the search phrase and th |
Exact |
||
TRACKING_URL_TEMPLATE |
varchar |
||||
TRACKING_URL_TEMPLATE_OLD |
varchar |
||||
TRACKING_URL_TEMPLATE_REQUESTED |
varchar |
||||
TRACKING_URL_TEMPLATE_APPLIED |
varchar |
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType} |
|||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
BIZ_FACTS.KEYWORD_KEY |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all landing pages downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the touchpoint |
X | ||
DISPLAY_ID |
varchar |
||||
AD_ACCOUNT_UNIQUE_ID |
varchar |
BIZ_AD_ACCOUNTS.ID | |||
AD_ACCOUNT_NAME |
varchar |
||||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser for the landing page, specifically for Doubleclick. |
300181641 | BIZ_ADVERTISERS.ID |
|
ADVERTISER_NAME |
varchar |
The name of the advertiser for the landing page, specifically for Doubleclick. |
Marketo Measure Marketing Analytics | ||
AD_GROUP_UNIQUE_ID |
varchar |
BIZ_AD_GROUPS.ID | |||
AD_GROUP_NAME |
varchar |
||||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
BIZ_AD_CAMPAIGNS.ID | |||
AD_CAMPAIGN_NAME |
varchar |
||||
IS_ACTIVE |
boolean |
||||
IS_DELETED |
boolean |
||||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
|||
FIRST_IMPORTED |
timestamp_ntz |
||||
NAME |
varchar |
||||
NEEDS_UPDATE |
boolean |
||||
GROUPING_KEY |
varchar |
||||
ENTITY_TYPE |
varchar |
||||
PROVIDER_TYPE |
varchar |
||||
URL_CURRENT |
varchar |
||||
URL_OLD |
varchar |
||||
URL_REQUESTED |
varchar |
||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All CRM Leads that are imported, along with custom Marketo Measure fields.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
CRM Lead Id |
00Q0Z00001MZcj8UAD |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Lead from the CRM |
2018-08-27 21:52:10.000 |
||
CREATED_DATE |
timestamp_ntz |
The created date of the Lead from the CRM |
2018-08-27 21:47:05.000 |
||
varchar |
The email address of the Lead from the CRM |
email@adobe.com |
|||
WEB_SITE |
varchar |
Website that is entered for the Lead, used for Lead2Account mapping |
adobe.com |
||
COMPANY |
varchar |
The company name that is entered for the Lead, used for Lead2Account mapping |
Marketo Measure |
||
LEAD_SOURCE |
varchar |
The value of the Lead Source, as entered in the CRM |
NULL |
||
IS_CONVERTED |
boolean |
Whether or not the Lead has been converted to a Contact |
TRUE |
||
CONVERTED_OPPORTUNITY_ID |
varchar |
The Id of the related Opportunity once the Lead has been converted, if applicable |
NULL |
BIZ_OPPORTUNITIES.ID | |
CONVERTED_DATE |
timestamp_ntz |
The date that the Lead was converted to a Contact, if applicable |
2018-08-27 07:00:00.000 |
||
CONVERTED_CONTACT_ID |
varchar |
The Id of the related Contact once the Lead has been converted, if applicable |
0030Z00003Oyp25QAB |
BIZ_CONTACTS.ID | |
ACCOUNTID |
varchar |
The Id of the mapped Account based off of domain and company name matching. Requirements: Enable ABM |
0010Z0000236F9GQAU |
BIZ_ACCOUNTS.ID |
|
BIZIBLE_STAGE |
varchar |
The current stage that the Lead is sitting in, recognized as a custom stage that can be created in Marketo Measure’s application. |
Demo Scheduled |
||
BIZIBLE_STAGE_PREVIOUS |
varchar |
A string of all stages that the Lead had previously gone through, recognized as custom stages that can be created in Marketo Measure’s application. |
MQL |
||
ODDS_OF_CONVERSION |
number(38,19) |
Marketo Measure's algorithm of estimating if a Lead will convert based on the age and stage |
NULL |
||
LEAD_SCORE_MODEL |
varchar |
(deprecated) |
NULL |
||
LEAD_SCORE_RESULTS |
varchar |
(deprecated) |
NULL |
||
BIZIBLE_COOKIE_ID |
varchar |
Marketo Measure's CookieId value that is used to populate from an integration partner to map an offline Event to a web session. Requirement: Enable Call Tracking: True |
08c1063cb0a64349ad0d2d862f5cc700 |
||
IS_DELETED |
boolean |
Finds whether or not the Lead that was in the system is deleted |
FALSE |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
4609512587744160000 |
||
CUSTOM_PROPERTIES | varchar | Custom CRM properties that Marketo Measure has imported from the CRM in JSON format | {"Lead_Type__c":"Sales Created", "Foo":"Bar"} | ||
IS_DUPLICATE |
boolean | Default is 'FALSE'. This column exists to mark any persons (leads) that exists in both Marketo and CRM as duplicate true. If there are duplicates, the Marketo Source lead will be marked IS_DUPLICATE = true |
FALSE / TRUE |
||
SOURCE_SYSTEM |
varchar | Default is 'Crm'. This column exists to capture the 'source' (Marketo or Crm) from where a contact was imported into our system. |
CRM / Marketo |
||
OTHER_SYSTEM_ID |
varchar | Default is 'NULL'. This column exists to map a person from Marketo with a Contact from Crm. The value would be the corresponding ID (from Marketo or CRM) |
1234 / 00Q0Z00001OohgTUAR |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Stores all stage transitions that occur on the Lead or Contact, tying it to a touchpoint to generate funnels and velocity calculations.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the transition |
ST_0030Z00003FhkRXQAZ__bizible_FT-1_TP2_Person_0030Z00003FhkRXQAZ_2018-08-27:17-05-45-9474800.0d5c18c29d7b |
X | |
varchar |
The provided email address for the related Lead/Contact |
email@adobe.com |
|||
LEAD_ID |
varchar |
A lookup to the Lead Id to get data such as created date. |
00Q3100001Fx6AlEAJ |
BIZ_LEADS.ID |
|
CONTACT_ID |
varchar |
A lookup to the Contact Id to get data such as created date. |
0033100003Aq9grAAB |
BIZ_CONTACTS.ID |
|
TOUCHPOINT_ID |
varchar |
A lookup to the Touchpoint Id to get data such as channel or count. |
TP2_Person_00Q3100001Fx6AlEAJ_2018-08-28:14-41-06-1674260.d00ceb09fbd3 |
BIZ_TOUCHPOINTS.ID |
|
TRANSITION_DATE |
timestamp_ntz |
The date that the record transitioned into the stage. |
2018-08-27 16:05:34.000 |
||
STAGE_ID |
varchar |
An identifier for the stage, which can either be a position value or external Id. It will be a value if it’s a custom stage, otherwise it will be an Id from the CRM if it’s a Lead Status or Opportunity Stage. |
_bizible_FT |
BIZ_STAGE_DEFINITIONS.ID | |
STAGE |
varchar |
An entry for the current stage and current transition that’s being recorded. |
FT |
||
RANK |
number(38,0) |
The numerical rank of the stage, as ordered in Marketo Measure’s Stage Mapping settings. |
1 |
||
INDEX |
varchar(1) |
For the occurrence of the stage (to be used later for Rebound Stages) |
NULL |
||
LAST_INDEX |
varchar(1) |
NULL |
|||
IS_PENDING |
boolean |
Whether or not the touchpoint is considered “pending” and not yet closed lost or closed won. This only appears for customers with Full Path. |
FALSE |
||
IS_NON_TRANSITIONAL |
boolean |
Whether or not the row is tied to a milestone stage transition. For example, if there are 3 stages/entries (FT, LC, MQL) and 4 touchpoints, the 1 touchpoint without a stage on it is considered “non-transitional” so the value would be FALSE. |
FALSE |
||
PREVIOUS_STAGE_DATE |
timestamp_ntz |
The transition date for the previous stage, according to the stage rank. |
2017-11-28 21:26:44.000 |
||
NEXT_STAGE_DATE |
timestamp_ntz |
The transition date for the next stage, according to the stage rank. |
2017-12-11 22:39:17.000 |
||
MODIFIED_DATE |
timestamp_ntz |
The last time the entry or record was modified |
2018-08-28 15:31:10.000 |
||
IS_DELETED |
boolean |
Whether or not the record exists in the source table, primarily used for auditing. |
FALSE |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All CRM Opportunities that are imported, along with custom Marketo Measure fields.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
CRM Opportunity Id |
0060Z00000o89I4QAI |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the Opportunity from the CRM |
2018-09-04 17:00:12.000 |
||
CREATED_DATE |
timestamp_ntz |
The created date of the Opportunity from the CRM |
2018-09-04 16:07:07.000 |
||
ACCOUNT_ID |
varchar |
The Id of the related Account that this Opportunity is tied to |
001i000000qbyeoAAA |
BIZ_ACCOUNTS.ID |
|
NAME |
varchar |
The name of the Opportunity |
NULL |
||
IS_WON |
boolean |
Whether or not the Opportunity has been moved to a stage that is considered Won |
FALSE |
||
IS_CLOSED |
boolean |
Whether or not the Opportunity has been moved to a stage that is considered closed, which can either be Won or Lost |
FALSE |
||
CLOSE_DATE |
timestamp_ntz |
The anticipated or actual Close Date set on the Opportunity |
2019-08-28 07:00:00.000 |
||
BIZIBLE_CUSTOM_MODEL_DATE |
timestamp_ntz |
A custom close date, if Close_Date is not used in the CRM, set within the Marketo Measure App to determine which custom Close Date field is being used |
NULL |
||
AMOUNT |
number(38,8) |
The deal amount that is expected or closed from the Opportunity |
8988.00000000 |
||
CONVERTED_FROM_LEAD_ID |
varchar |
The Id of the related Lead that had converted into this Opportunity |
00Q0Z000013eVrxUAE |
BIZ_LEADS.ID |
|
CONVERTED_FROM_LEAD_EMAIL |
varchar |
The email of the related Lead that had converted into this Opportunity |
email@adobe.com |
||
PRIMARY_CONTACT_ID |
varchar |
If Primary Contact Role is used, the Id of the related Contact that is listed as the primary contact role |
00331000038uGfhAAE |
BIZ_CONTACTS.ID |
|
PRIMARY_CONTACT_EMAIL |
varchar |
If Primary Contact Role is used, the email d of the related Contact that is listed as the primary contact role |
email@adobe.com |
||
ODDS_OF_CONVERSION |
number(38,19) |
Marketo Measure's algorithm of estimating whether an opportunity will close based on the age and stage |
0.8225108385086060000 |
||
BIZIBLE_STAGE |
varchar |
The current stage that the Contact is sitting in, recognized as a custom stage that can be created in Marketo Measure’s application. |
DM Demo |
||
BIZIBLE_STAGE_PREVIOUS |
varchar |
A string of all stages that the Contact had previously gone through, recognized as custom stages that can be created in Marketo Measure’s application. |
Qualified Discovery, Demo Scheduled |
||
IS_DELETED |
boolean |
Finds whether or not the Contact that was in the system is deleted |
FALSE |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
4609512587744160000 |
||
CURRENCY_ISO_CODE | varchar | ||||
CURRENCY_ID | number(38,0) | 4609512587744160000 | BIZ_CURRENCIES.ID | ||
CUSTOM_PROPERTIES | varchar | Custom CRM properties that Marketo Measure has imported from the CRM in JSON format | {"Opportunity_Location__c":"Seattle", "Foo":"Bar"} | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Stores all stage transitions that occur on the Opportunity, tying it to a touchpoint to generate funnels and velocity calculations.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the transition |
ST_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_Demo Scheduled-1_BAT2_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_2018-06-01:19-51-38-1685390.beec556e7757 |
X | |
ACCOUNT_ID |
varchar |
A lookup to the Account Id to get data such as created date or predictive engagement score (ABM) |
0013100001b44nTAAQ |
BIZ_ACCOUNTS.ID |
|
OPPORTUNITY_ID |
varchar |
A lookup to the Opportunity Id to get data such as record type or (opportunity) stage. |
0060Z00000nEgjlQAC |
BIZ_OPPORTUNITIES.ID |
|
CONTACT_ID |
varchar |
A lookup to the Contact Id to get data such as created date. |
0030Z00003IjojKQAR |
BIZ_CONTACTS.ID |
|
TOUCHPOINT_ID |
varchar |
A lookup to the Lead Id to get data such as channel or count. |
BAT2_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_2018-06-01:19-51-38-1685390.beec556e7757 |
BIZ_ATTRIBUTION_TOUCHPOINTS.ID |
|
TRANSITION_DATE |
timestamp_ntz |
The date that the record transitioned into the stage. |
2018-05-26 07:29:43.000 |
||
STAGE |
varchar |
An entry for the current stage and current transition that’s being recorded. |
Demo Scheduled |
||
STAGE_ID |
varchar |
An identifier for the stage, which can either be a position value or external Id. It will be a value if it’s a custom stage, otherwise it will be an Id from the CRM if it’s a Lead Status or Opportunity Stage. |
BIZ_STAGE_DEFINITIONS.ID | ||
RANK |
number(38,0) |
The numerical rank of the stage, as ordered in Marketo Measure’s Stage Mapping settings. |
4 |
||
INDEX |
varchar(1) |
For the occurrence of the stage (to be used later for Rebound Stages) |
1 |
||
LAST_INDEX |
varchar(1) |
1 |
|||
IS_PENDING |
boolean |
Whether or not the touchpoint is considered “pending” and not yet closed lost or closed won. This would appear for customers with Full Path if a record is still open. |
FALSE |
||
IS_NON_TRANSITIONAL |
boolean |
Whether or not the row is tied to a milestone stage transition. For example, if there are 3 stages/entries (FT, LC, MQL) and 4 touchpoints, the 1 touchpoint without a stage on it is considered “non-transitional” so the value would be FALSE. |
FALSE |
||
PREVIOUS_STAGE_DATE |
timestamp_ntz |
The transition date for the previous stage, according to the stage rank. |
2015-07-16 17:41:49.000 |
||
NEXT_STAGE_DATE |
timestamp_ntz |
The transition date for the next stage, according to the stage rank. |
2018-08-27 19:40:52.000 |
||
MODIFIED_DATE |
timestamp_ntz |
The last time the entry or record was modified |
2018-08-28 03:53:33.000 |
||
IS_DELETED |
boolean |
Whether or not the record exists in the source table, primarily used for auditing. |
FALSE |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Page views from web visits with a VisitorId and is related to Biz_Session. Multiple page views can compose of a single session.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the page view |
2018-08-19:16-49-58-24340.277d79d0167849 |
X | |
COOKIE_ID |
varchar |
The recorded cookie Id at the time of the page view |
277d79d01678498fea067c9b631bf6df |
||
VISITOR_ID |
varchar |
The first cookie of the related visitor Id |
v_277d79d01678498fea067c9b631bf6df |
BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID |
|
SESSION_ID |
varchar |
The recorded session Id at the time of the page view |
2018-08-19:16-49-58-24340.277d79d0167849 |
BIZ_SESSIONS.ID |
|
EVENT_DATE |
timestamp_ntz |
The date and time of the page view |
2018-08-19 16:49:58.000 |
||
MODIFIED_DATE |
timestamp_ntz |
The last time the entry or record was modified |
2018-08-19 16:55:37.000 |
||
CURRENT_PAGE |
varchar |
The URL of the current page view without query parameters. |
https://info.adobe.com/demo |
||
CURRENT_PAGE_RAW |
varchar |
The URL of the current page view. The current page may contain query parameters in the URL. |
https://info.adobe.com/demo?hsCtaTracking=207219e9-87b6-4105-8f4b-0a3b62ae1af8%7C48060522-3aeb-4c72-8ce5-fd4b1017f069 |
||
IP_ADDRESS |
varchar |
The recorded IP address at the time the form was submitted |
174.127.184.158 |
||
TYPE |
varchar |
PageView |
|||
USER_AGENT_STRING |
varchar |
The device and browser that the person is using at the time of the form submit. |
Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0 |
||
CLIENT_SEQUENCE |
varchar(1) |
The order in which the page view occurred in the user’s session |
1 |
||
CLIENT_RANDOM |
varchar |
103532 |
|||
IS_DUPLICATED |
boolean |
FALSE |
|||
IS_PROCESSED |
boolean |
TRUE |
|||
REFERRER_PAGE |
varchar |
The URL where page view originated from without query parameters |
http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution |
||
REFERRER_PAGE_RAW |
varchar |
The URL where the page view originated from. The referrer page may contain query parameters in the URL. |
http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution?utm_source=linkedin&utm_medium=Social&utm_campaign=SU%20-%20CMO%20JT&utm_content=CMOs%20Guide&utm_term=lisu05091601 |
||
PAGE_TITLE |
varchar |
The title of the page view |
The CMO's Guide to B2B Marketing Attribution Download |
||
varchar |
|||||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-6255315750913680000 |
BIZ_FACTS.PAGE_VIEW_KEY |
|
CURRENT_PAGE_KEY | number(38,0) | BIZ_URLS.ROW_KEY | |||
REFERRER_PAGE_KEY | number(38,0) | BIZ_URLS.ROW_KEY | |||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all placements downloaded from any connected ads accounts, an object from the Doubleclick integration.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the placement |
X | ||
DISPLAY_ID |
varchar |
||||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the placement |
BIZ_AD_ACCOUNTS.ID | ||
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the placement |
|||
ADVERTISER_UNIQUE_ID |
varchar |
BIZ_ADVERTISERS.ID | |||
ADVERTISER_NAME |
varchar |
||||
AD_GROUP_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Group above the Placement in any ads hierarchy |
BIZ_AD_GROUPS.ID | ||
AD_GROUP_NAME |
varchar |
Expected to be NULL since there is no Ad Group above the Placement in any ads hierarchy |
|||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign for the placement |
BIZ_AD_CAMPAIGNS.ID | ||
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign for the placement |
|||
IS_ACTIVE |
boolean |
Whether or not the placement is still active in the ads account |
|||
IS_DELETED |
boolean |
Whether or not the placement has been deleted in the ads account |
|||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
|||
FIRST_IMPORTED |
timestamp_ntz |
The date that the placement was first downloaded by Marketo Measure |
|||
NAME |
varchar |
The name of the placement |
|||
NEEDS_UPDATE |
boolean |
Whether or not the placement needs to get updated to get Marketo Measure tagging |
|||
GROUPING_KEY |
varchar |
||||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Placement” |
|||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the placement |
|||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
BIZ_FACTS.PLACEMENT_KEY |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all segment values that the customer has created.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the segment name |
New Business |
X | |
NAME |
varchar |
The name of the segment created |
New Business |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
1028715376434030000 |
BIZ_FACTS.CATEGORY_01_KEY |
|
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All recorded sessions associated with a VisitorId. Multiple sessions can be associated to a single visitor.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the session |
2016-08-01:14-24-21-9079480.33163948f0a3 |
X | |
VISITOR_ID |
varchar |
The first cookie of the related visitor Id |
v_33163948f0a34303f2f4759e5d31a620 |
BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID |
|
COOKIE_ID |
varchar |
The recorded cookie Id from the session |
33163948f0a34303f2f4759e5d31a620 |
||
EVENT_DATE |
timestamp_ntz |
The date and time of the session |
2016-08-01 14:24:21.000 |
||
MODIFIED DATE |
timestamp_ntz |
The last modified date of the row |
2018-09-01 03:49:10.000 |
||
CHANNEL |
varchar |
Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. |
Paid Search.AdWords |
||
PAGE_TITLE |
varchar |
The name of the web page |
Salesforce Google Analytics | Marketo Measure |
||
LANDING_PAGE |
varchar |
Referred to in the CRM as “Landing Page” This is the first landing page of the session that resulted in a touchpoint. |
http://www.adobe.com/salesforce-google-analytics |
||
LANDING_PAGE_RAW |
varchar |
Referred to in the CRM as “Landing Page - Raw.” This is the first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. |
http://www.adobe.com/salesforce-google-analytics?_bt=83558988035&_bk=google%20analytics%20salesforce&_bm= p&gclid=CMvd5YTLo84CFUI9gQodd-kLEQ |
||
REFERRER_PAGE |
varchar |
Referred to in the CRM as “Referrer Page” This is the usually the external landing page immediately before the user comes onto the website. |
https://www.google.com/ |
||
REFERRER_PAGE_RAW |
varchar |
Referred to in the CRM as “Referrer Page - Raw.” This is the usually the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. |
https://www.google.com/ |
||
REFERRER_NAME |
varchar |
The name of the referrer web page |
|||
SEARCH_PHRASE |
varchar |
The value that the user entered in the browser to search for and end up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform. |
marketo measure google salesforce |
||
WEB_SOURCE |
varchar |
Referred to in the CRM as “Touchpoint Source.” Used to define the source that resulted in the touchpoint. This can be parsed out from the URL from utm_source or generically set as “CRM Campaign” if it was synced from the CRM or if Marketo Measure is able to resolve an ad, it may be values such as “Google AdWords” or “Facebook.” |
Google AdWords |
||
HAS_FORM |
boolean |
Whether or not the session contained a form fill |
TRUE |
||
HAS_CHAT |
boolean |
Whether or not the session contained a web chat |
FALSE |
||
HAS_EMAIL |
boolean |
Whether or not the session had an email address |
FALSE |
||
HAS_CRM_ACTIVITY |
boolean |
Whether or not the session came from a CRM activity record |
FALSE |
||
DEVICE |
varchar |
The browser and operating system the user is using during the web session |
Chrome (65.0), Windows (6.1) |
||
AD_PROVIDER |
varchar |
The ad platform that Marketo Measure was able to resolve from, typically one of our integration partners. |
|||
ACCOUNT_UNIQUE_ID |
varchar |
The Id of the ads account in which the ad was resolved from. |
aw.6601259029 |
BIZ_AD_ACCOUNTS.ID | |
ACCOUNT_NAME |
varchar |
The name of the ads account in which the ad was resolved from, such as Marketo-Measure-US. |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically from Doubleclick connection. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser from the ads account in which the ad was resolved from, such as Marketo Measure Inc. |
Marketo Measure Marketing Analytics |
||
SITE_UNIQUE_ID |
varchar |
The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
1695651 |
BIZ_SITES.ID | |
SITE_NAME |
varchar |
The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager. |
Quora.com |
||
PLACEMENT_UNIQUE_ID |
varchar |
The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
120839827 |
BIZ_PLACEMENTS.ID | |
PLACEMENT_NAME |
varchar |
The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager. |
roadblock |
||
CAMPAIGN_UNIQUE_ID |
varchar |
The Id of the campaign from the ads account in which the ad was resolved from. |
aw.6601259029.321586235 |
BIZ_AD_CAMPAIGNS.ID | |
CAMPAIGN_NAME |
varchar |
The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar. |
Salesforce |
||
AD_GROUP_UNIQUE_ID |
varchar |
The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords. |
aw.6601259029.321586235.23182235435 |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords. |
Salesforce - Google Analytics |
||
AD_UNIQUE_ID |
varchar |
The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display). |
BIZ_ADS.ID | ||
AD_NAME |
varchar |
The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display). |
|||
CREATIVE_UNIQUE_ID |
varchar |
The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
aw.6601259029.321586235.23182235435.83558988035 |
BIZ_CREATIVES.ID | |
CREATIVE_NAME |
varchar |
The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Google AdWords and Bing Ads (search). |
Integrate GA & Salesforce |
||
CREATIVE_DESCRIPTION_1 |
varchar |
The first line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Integrate Salesforce & Analytics To |
||
CREATIVE_DESCRIPTION_2 |
varchar |
The second line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Optimize for Revenue. Learn How. |
||
CREATIVE_DESTINATION_URL |
varchar |
The landing page that clicks through from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
http://www.adobe.com/salesforce-google-analytics |
||
CREATIVE_DISPLAY_URL |
varchar |
The friendly URL name that’s shown on the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
adobe.com/Salesforce-for-GA |
||
KEYWORD_UNIQUE_ID |
varchar |
The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search |
aw.6601259029.321586235.23182235435.35934468937 |
BIZ_KEYWORDS.ID | |
KEYWORD_NAME |
varchar |
The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search) |
google analytics salesforce |
||
KEYWORD_MATCH_TYPE |
varchar |
The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact” |
Phrase |
||
CAMPAIGN |
varchar |
This is parsed out from the URL from utm_campaign |
SU - ABC Accounts - Paid Media Skills |
||
SOURCE |
varchar |
This is parsed out from the URL from utm_source |
|||
MEDIUM |
varchar |
This is parsed out from the URL from utm_medium |
Social |
||
TERM |
varchar |
This is parsed out from the URL from utm_term |
lisu07261601 |
||
CONTENT |
varchar |
This is parsed out from the URL from utm_content |
2016 AdWords Benchmark Report |
||
CITY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver. |
Seattle |
||
REGION |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia. |
Washington |
||
COUNTRY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada. |
United States |
||
ISP_NAME |
varchar |
The internet service provider of the user |
AT&T U-verse |
||
IP_ADDRESS |
varchar |
The recorded IP address at the time the session |
174.127.184.158 |
||
IS_DELETED |
boolean |
Determines if this session was merged with another and should be deleted. |
FALSE |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-251659132606672000 |
BIZ_FACTS.SESSION_KEY |
|
LANDING_PAGE_KEY | number(38,0) | ||||
REFERRER_PAGE_KEY | number(38,0) | ||||
ACCOUNT_ROW_KEY | number(38,0) | ||||
ADVERTISER_ROW_KEY | number(38,0) | ||||
SITE_ROW_KEY | number(38,0) | ||||
PLACEMENT_ROW_KEY | number(38,0) | ||||
CAMPAIGN_ROW_KEY | number(38,0) | ||||
AD_ROW_KEY | number(38,0) | ||||
AD_GROUP_ROW_KEY | number(38,0) | ||||
CREATIVE_ROW_KEY | number(38,0) | ||||
KEYWORD_ROW_KEY | number(38,0) | ||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all sites downloaded from any connected ads accounts, an object from the Doubleclick integration.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the site |
X | ||
DISPLAY_ID |
varchar |
||||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the site |
BIZ_AD_ACCOUNTS.ID | ||
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the site |
|||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser for the site, specifically for Doubleclick. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser for the site, specifically for Doubleclick. |
Marketo Measure Marketing Analytics |
||
AD_GROUP_UNIQUE_ID |
varchar |
Expected to be NULL since there is no Ad Group above the Site in any ads hierarchy |
BIZ_AD_GROUPS.ID | ||
AD_GROUP_NAME |
varchar |
Expected to be NULL since there is no Ad Group above the Site in any ads hierarchy |
|||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign for the site |
BIZ_AD_CAMPAIGNS.ID | ||
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign for the site |
|||
IS_ACTIVE |
boolean |
Whether or not the site is still active in the ads account |
|||
IS_DELETED |
boolean |
Whether or not the site has been deleted in the ads account |
|||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
|||
FIRST_IMPORTED |
timestamp_ntz |
The date that the site was first downloaded by Marketo Measure |
|||
NAME |
varchar |
The name of the site |
|||
NEEDS_UPDATE |
boolean |
Whether or not the site needs to get updated to get Marketo Measure tagging |
|||
GROUPING_KEY |
varchar |
||||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “Site” |
|||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the site |
|||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
BIZ_FACTS.SITE_KEY | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Table that stores all site links downloaded from any connected ads accounts.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the site link |
aw.6601259029.285077795.1654234342 |
X | |
DISPLAY_ID |
varchar |
1654234342 |
|||
AD_ACCOUNT_UNIQUE_ID |
varchar |
The ID of the connected ads account for the site link |
aw.6601259029 |
BIZ_AD_ACCOUNTS.ID | |
AD_ACCOUNT_NAME |
varchar |
The name of the connected ads account for the site link |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser for the site link, specifically for Doubleclick. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser for the site link, specifically for Doubleclick. |
Marketo Measure Marketing Analytics |
||
AD_GROUP_UNIQUE_ID |
varchar |
The ID of the ad group for the site link |
BIZ_AD_GROUPS.ID | ||
AD_GROUP_NAME |
varchar |
The name of the ad group for the site link |
|||
AD_CAMPAIGN_UNIQUE_ID |
varchar |
The ID of the campaign for the site link |
aw.6601259029.285077795 |
BIZ_AD_CAMPAIGNS.ID | |
AD_CAMPAIGN_NAME |
varchar |
The name of the campaign for the site link |
Brand |
||
IS_ACTIVE |
boolean |
Whether or not the site link is still active in the ads account |
TRUE |
||
IS_DELETED |
boolean |
Whether or not the site link has been deleted in the ads account |
FALSE |
||
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-02 06:36:50.000 |
||
FIRST_IMPORTED |
timestamp_ntz |
The date that the site link was first downloaded by Marketo Measure |
2018-08-02 06:36:50.000 |
||
NAME |
varchar |
The name of the site link |
|||
NEEDS_UPDATE |
boolean |
Whether or not the site link needs to get updated to get Marketo Measure tagging |
FALSE |
||
GROUPING_KEY |
varchar |
aw.6601259029.285077795 |
|||
ENTITY_TYPE |
varchar |
The main object or entity for this table. In this case, “SiteLink” |
SiteLink |
||
PROVIDER_TYPE |
varchar |
The name of the ads provider for the site link |
AdWords |
||
URL_CURRENT |
varchar |
http://adobe.com/b2b-marketing-attribution?_bt = {creative}&_bk={keyword}&_bm={matchType} |
|||
URL_OLD |
varchar |
||||
URL_REQUESTED |
varchar |
||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Lists all Lead Statuses and Opportunity Stages from the CRM, as well as any custom stages defined in Marketo Measure Settings.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique identifier for the stage |
01J3100000QE753EAD |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-22 17:27:27.000 |
||
STAGE_NAME |
varchar |
The name of the stage |
Verbal |
||
IS_INACTIVE |
boolean |
FALSE |
|||
IS_IN_CUSTOM_MODEL |
boolean |
Whether or not the stage has been selected to track in the custom attribution model |
FALSE |
||
IS_BOOMERANG |
boolean |
Whether or not the stage has been selected to track as a boomerang stage |
FALSE |
||
IS_TRANSITION_TRACKING |
boolean |
FALSE |
|||
STAGE_STATUS |
varchar |
The status of the stage, whether it’s an Open, Lost, or Won stage |
Open |
||
IS_FROM_SALESFORCE |
boolean |
Whether or not the stage is pulled from Salesforce |
TRUE |
||
IS_DEFAULT |
boolean |
FALSE |
|||
RANK |
number(38,0) |
The numerical rank of the stage that can be used to sort all stages |
53 |
||
IS_DELETED |
boolean |
Whether or not the stage has been deleted |
FALSE |
||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
All touchpoints that are associated with a Lead and/or Contact. This table will be empty if Lead Touchpoints or Contact Touchpoints are disabled.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the touchpoint record |
TP2_Person_00Q0Z000013e2PYUAY_2018-08-27:20-04-40-5655690.1ee8567c175a |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-08-29 22:29:30.000 |
||
varchar |
The known email address that’s tied to this touchpoint via a Lead or Contact |
email@adobe.com |
|||
CONTACT_ID |
varchar |
A lookup to the Biz_Contacts table to select columns such as Created Date |
0030Z00003Fhe7qQAB |
BIZ_CONTACTS.ID |
|
ACCOUNT_ID |
varchar |
A lookup to the Biz_Accounts table to select columns such as Website or Engagement Rating |
0013100001lSLScAAO |
BIZ_ACCOUNTS.ID |
|
LEAD_ID |
varchar |
A lookup to the Biz_Leads table to select columns such as Created Date |
00Q0Z000013e2PYUAY |
BIZ_LEADS.ID |
|
UNIQUE_ID_PERSON |
varchar |
The parent person record that relates to a Lead or Contact |
Person_00Q0Z000013e2PYUAY |
||
USER_TOUCHPOINT_ID |
varchar |
A lookup to the Biz_User_Touchpoints table to select columns such as session_id |
email@adobe.com_2018-08-29:18-14-53-8102030.10df92cbb414 |
BIZ_USER_TOUCHPOINTS.ID |
|
VISITOR_ID | varchar | BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID | |||
TOUCHPOINT_DATE |
timestamp_ntz |
The date of the recorded touchpoint, which is the date that the session occurred |
2018-08-27 20:04:40.000 |
||
MARKETING_TOUCH_TYPE |
varchar |
Referred to in the CRM as “Touchpoint Type.” This records the type of activity, whether it was a Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity |
Web Form |
||
CHANNEL |
varchar |
Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. |
Social.LinkedIn |
||
CATEGORY1 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 1st Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
ABC, or NULL |
||
CATEGORY2 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 2nd Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
Yes, or NULL |
||
CATEGORY3 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 3rd Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
Other, or NULL |
||
CATEGORY4 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 4th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
Partner, or NULL |
||
CATEGORY5 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 5th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY6 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 6th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY7 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 7th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY8 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 8th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY9 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 9th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY10 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 10th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY11 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 11th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY12 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 12th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY13 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 13th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY14 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 14th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
CATEGORY15 |
varchar |
Referred to in the CRM as “Segments.” This is the segment value for the 15th Category that the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. |
NULL |
||
BROWSER_NAME |
varchar |
From the javascript and IP address, the detected browser that the user was on during the session. For example, Chrome or Internet Explorer. |
Chrome |
||
BROWSER_VERSION |
varchar |
From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer. |
68 |
||
PLATFORM_NAME |
varchar |
From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows. |
Windows |
||
PLATFORM_VERSION |
varchar |
From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows. |
6.1 |
||
LANDING_PAGE |
varchar |
Referred to in the CRM as “Landing Page.” This is the first landing page of the session that resulted in a touchpoint. |
https://info.adobe.com/definitive-guide-to-pipeline-marketing |
||
LANDING_PAGE_RAW |
varchar |
Referred to in the CRM as “Landing Page - Raw.” This is the first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. |
https://info.adobe.com/definitive-guide-to-pipeline-marketing?utm_source=linkedin&utm_medium=Social&utm_campaign=SU_COM_Demand_ Skills&utm_content=DGPM&utm_term=lisu03151846&_bl=66452504 |
||
REFERRER_PAGE |
varchar |
Referred to in the CRM as “Referrer Page.” This is the usually the external landing page immediately before the user comes onto the website. |
https://www.linkedin.com/feed |
||
REFERRER_PAGE_RAW |
varchar |
Referred to in the CRM as “Referrer Page - Raw.” This is the usually the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. |
https://www.linkedin.com/feed |
||
FORM_PAGE |
varchar |
Referred to in the CRM as “Form - URL.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table. |
https://info.adobe.com/demo |
||
FORM_DATE |
timestamp_ntz |
The date that the form submission occurred. |
https://info.adobe.com/demo?hsCtaTracking=98adcc2f-afe2-40c4-9d79-40dcc41663ee%7C3cfaa909-39cb-4f5d-93eb-be05de6b0180 |
||
CITY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver. |
New York |
||
REGION |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia. |
New York |
||
COUNTRY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada. |
United States |
||
MEDIUM |
varchar |
Used to define the medium that resulted in the touchpoint. This can either be parsed out from the URL from utm_medium or if Marketo Measure is able to resolve an ad, it may be values such as “cpc” or “display.” |
Social |
||
WEB_SOURCE |
varchar |
Referred to in the CRM as “Touchpoint Source.” Used to define the source that resulted in the touchpoint. This can be parsed out from the URL from utm_source or generically set as “CRM Campaign” if it was synced from the CRM or if Marketo Measure is able to resolve an ad, it may be values such as “Google AdWords” or “Facebook.” |
|||
SEARCH_PHRASE |
varchar |
The value that the user entered in the browser to search for and end up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform. |
buyer attribution |
||
AD_PROVIDER |
varchar |
The ad platform that Marketo Measure was able to resolve from, typically one of our integration partners. |
|||
ACCOUNT_UNIQUE_ID |
varchar |
The Id of the ads account in which the ad was resolved from. |
li.502664737 |
BIZ_AD_ACCOUNTS.ID | |
ACCOUNT_NAME |
varchar |
The name of the ads account in which the ad was resolved from, such as Marketo-Measure-US. |
Marketo Measure SC 2016_14605342_3/7-3/31/16 |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically for Doubleclick connections. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser from the ads account in which the ad was resolved from, specifically for Doubleclick connections. |
Marketo Measure Marketing Analytics |
||
SITE_UNIQUE_ID |
varchar |
The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
1695651 |
BIZ_SITES.ID | |
SITE_NAME |
varchar |
The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager. |
Quora.com |
||
PLACEMENT_UNIQUE_ID |
varchar |
The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
120839827 |
BIZ_PLACEMENTS.ID | |
PLACEMENT_NAME |
varchar |
The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager. |
roadblock |
||
CAMPAIGN_UNIQUE_ID |
varchar |
The Id of the campaign from the ads account in which the ad was resolved from. |
li.502664737.138949954 |
BIZ_AD_CAMPAIGNS.ID | |
CAMPAIGN_NAME |
varchar |
The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar. |
SU - COM Accounts - Demand Skills |
||
AD_GROUP_UNIQUE_ID |
varchar |
The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords. |
BIZ_AD_GROUPS.ID | ||
AD_GROUP_NAME |
varchar |
The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords. |
|||
AD_UNIQUE_ID |
varchar |
The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display). |
BIZ_ADS.ID | ||
AD_NAME |
varchar |
The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display). |
|||
CREATIVE_UNIQUE_ID |
varchar |
The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
li.502664737.138949954.66452504 |
BIZ_CREATIVES.ID | |
CREATIVE_NAME |
varchar |
The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Google AdWords and Bing Ads (search). |
lisu03151846 |
||
CREATIVE_DESCRIPTION_1 |
varchar |
The first line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Lead gen is dead |
||
CREATIVE_DESCRIPTION_2 |
varchar |
The second line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Download the definitive guide to pipeline marketing: https://lnkd.in/e9xYj5M |
||
CREATIVE_DESTINATION_URL |
varchar |
The landing page that clicks through from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
https://image-store.slidesharecdn.com/d29165c0-1e0b-4ffc-a494-d2c77e7cd4a6-large.jpeg |
||
CREATIVE_DISPLAY_URL |
varchar |
The friendly URL name that’s shown on the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
adobe.com/guide |
||
KEYWORD_UNIQUE_ID |
varchar |
The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search |
__GAId__lisu03151846 |
BIZ_KEYWORDS.ID | |
KEYWORD_NAME |
varchar |
The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search) |
lisu03151846 |
||
KEYWORD_MATCH_TYPE |
varchar |
The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact” |
Broad |
||
IS_FIRST_TOUCH |
boolean |
Whether or not this touchpoint is treated as the first touch of the opportunity journey |
TRUE |
||
IS_LEAD_CREATION_TOUCH |
boolean |
Whether or not this touchpoint is treated as the lead creation touch of the opportunity journey |
TRUE |
||
IS_OPP_CREATION_TOUCH |
boolean |
Whether or not this touchpoint is treated as the opportunity creation touch of the opportunity journey. Because this is the lead model, this is expected to be 0. |
FALSE |
||
IS_CLOSED_TOUCH |
boolean |
Whether or not this touchpoint is treated as the closed touch of the opportunity journey. Because this is the lead model, this is expected to be 0. |
FALSE |
||
STAGES_TOUCHED |
varchar |
The stages that the touchpoint has gone through |
Open, MQL |
||
IS_FORM_SUBMISSION_TOUCH |
boolean |
Whether or not this touchpoint had a form fill during the session |
TRUE |
||
IS_IMPRESSION_TOUCH |
boolean |
Whether or not this touchpoint is treated as the first impression touch of the opportunity journey |
FALSE |
||
FIRST_CLICK_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s a first touch (See Is_First_Touch) |
100 |
||
LAST_ANON_CLICK_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s a lead creation touch (See Is_Last_Anon_Click_Percentage) |
100 |
||
U_SHAPE_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a u-shaped touch (See Is_First_Touch and Is_Lead_Creation_Touch) |
100 |
||
W_SHAPE_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a w-shaped touch (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch). Because this is the lead model, this is expected to be 0. |
0 |
||
FULL_PATH_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch). Because this is the lead model, this is expected to be 0. |
0 |
||
CUSTOM_MODEL_PERCENTAGE |
number(22,19) |
The calculated percentage that gets allocated to this touchpoint because it’s part of a custom model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch, Stages Touch). Because this is the lead model, this is expected to be 0. |
0 |
||
IS_DELETED |
boolean |
Whether or not the record was deleted, used for diagnostics and auditing. |
FALSE |
||
ROW_KEY |
number(38,0) |
The key that relates this table to the BIZ_FACTS table to fetch all the metrics |
-9004910726709710000 |
BIZ_FACTS.TP_KEY |
|
CONTACT_ROW_KEY |
number(38,0) |
8817975702393610000 |
|||
LEAD_ROW_KEY |
number(38,0) |
-2198155202365030000 |
|||
LANDING_PAGE_KEY | number(38,0) | ||||
REFERRER_PAGE_KEY | number(38,0) | ||||
FORM_PAGE_KEY | number(38,0) | ||||
ACCOUNT_ROW_KEY | number(38,0) | ||||
ADVERISER_ROW_KEY | number(38,0) | ||||
SITE_ROW_KEY | number(38,0) | ||||
PLACEMENT_ROW_KEY | number(38,0) | ||||
CAMPAIGN_ROW_KEY | number(38,0) | ||||
AD_ROW_KEY | number(38,0) | ||||
AD_GROUP_KEY | number(38,0) | ||||
CREATIVE_ROW_KEY | number(38,0) | ||||
KEYWORD_ROW_KEY | number(38,0) | ||||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
A table of all recognized URLs from landing pages or referrer pages or page visits, aggregated into a single table.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
The full URL, from landing pages or referrer pages or page visits |
https://www.adobe.com/blog/strategic-marketing-plangoals |
||
SCHEME |
varchar |
The secure communication of the web page over the network, whether it’s HTTP or HTTPS |
https |
||
HOST |
varchar |
The domain of the URL, with any subdomains |
www.adobe.com |
||
PORT |
varchar |
The port from an internet host, optional in a URL |
NULL |
||
PATH |
varchar |
The part of the URL that points to a specific location on the host. |
/blog/strategic-marketing-plangoals |
||
ROW_KEY |
number(38,0) |
5686109553536636820 |
X | ||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
Any touchpoint recorded that can be tied to an email, so it can be a web visit, web form, chat, or offline event.
Column | Data Type |
Description | Sample Data | Primary Key | Foreign Keys/Joins |
---|---|---|---|---|---|
ID |
varchar |
A unique Id for the user touchpoint |
email@adobe.com_2018-01-05:16-47-02-8803320.ddf67c101f58 |
X | |
MODIFIED_DATE |
timestamp_ntz |
The last modified date of the row |
2018-09-05 23:30:53.000 |
||
varchar |
The email address that this Touchpoint is created from |
email@adobe.com |
|||
SESSION_ID |
varchar |
The Id of the related Session that this Touchpoint is created from |
2018-01-05:16-47-02-8803320.ddf67c101f58 |
BIZ_SESSIONS.ID |
|
CAMPAIGN_MEMBER_ID |
varchar |
The Id of the related Campaign Member that this Touchpoint is created from |
00v0Z00001VTgv1QAD |
BIZ_CAMPAIGN_MEMBERS.ID |
|
CRM_EVENT_ID |
varchar |
The Id of the related Event that this Touchpoint is created from |
00U0Z00000pCZmyUAG |
BIZ_CRM_EVENTS.ID |
|
CRM_TASK_ID |
varchar |
The Id of the related Task that this Touchpoint is created from |
00T0Z00004Qbd1jUAB |
BIZ_CRM_TASKS.ID |
|
IMPRESSION_ID |
varchar |
The Id of the related Impression that this Touchpoint is created from |
BIZ_IMPRESSIONS.ID |
||
TOUCHPOINT_DATE |
timestamp_ntz |
The date of the recorded touchpoint, which is the date that the session occurred |
2018-01-05 16:47:02.000 |
||
MARKETING_TOUCH_TYPE |
varchar |
Referred to in the CRM as “Touchpoint Type.” This records the type of activity, whether it was a Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity |
Web Form |
||
CHANNEL |
varchar |
Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. |
Social.LinkedIn |
||
BROWSER_NAME |
varchar |
From the javascript and IP address, the detected browser that the user was on during the session. For example, Chrome or Internet Explorer. |
Firefox |
||
BROWSER_VERSION |
varchar |
From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer. |
33 |
||
PLATFORM_NAME |
varchar |
From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows. |
Mac |
||
PLATFORM_VERSION |
varchar |
From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows. |
10_12 |
||
LANDING_PAGE |
varchar |
Referred to in the CRM as “Landing Page.” This is the first landing page of the session that resulted in a touchpoint. |
https://www.adobe.com/blog/budget-and-planning-maturity-model-b2b-marketing |
||
LANDING_PAGE_RAW |
varchar |
Referred to in the CRM as “Landing Page - Raw.” This is the first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. |
https://www.adobe.com/blog/budget-and-planning-maturity-model-b2b-marketing?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+ adobe+%adobe%27s+Pipeline+Marketing+Blog%29 |
||
REFERRER_PAGE |
varchar |
Referred to in the CRM as “Referrer Page.” This is the usually the external landing page immediately before the user comes onto the website. |
|||
REFERRER_PAGE_RAW |
varchar |
Referred to in the CRM as “Referrer Page - Raw.” This is the usually the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. |
|||
FORM_PAGE |
varchar |
Referred to in the CRM as “Form Page” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table. |
|||
FORM_PAGE_RAW |
varchar |
Referred to in the CRM as “Form Page - Raw.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table. A raw form page may contain query parameters in the URL. |
http://info.adobe.com/adwords-for-lead-generation?utm_source=linkedin&utm_medium=paid&utm_content=sfskill&utm _campaign=Content%20-%20AdWords%20Guide |
||
FORM_DATE |
timestamp_ntz |
The date that the form submission occurred. |
2015-06-03 17:49:10.000 |
||
CITY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver. |
Oakland |
||
REGION |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia. |
California |
||
COUNTRY |
varchar |
From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada. |
United States |
||
MEDIUM |
varchar |
Used to define the medium that resulted in the touchpoint. This can either be parsed out from the URL from utm_medium or if Marketo Measure is able to resolve an ad, it may be values such as “cpc” or “display.” |
paid |
||
WEB_SOURCE |
varchar |
Referred to in the CRM as “Touchpoint Source.” Used to define the source that resulted in the touchpoint. This can be parsed out from the URL from utm_source or generically set as “CRM Campaign” if it was synced from the CRM or if Marketo Measure is able to resolve an ad, it may be values such as “Google AdWords” or “Facebook.” |
|||
SEARCH_PHRASE |
varchar |
The value that the user entered in the browser to search for and end up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform. |
Marketo Measure |
||
AD_PROVIDER |
varchar |
The ad platform that Marketo Measure was able to resolve from, typically one of our integration partners. |
|||
ACCOUNT_UNIQUE_ID |
varchar |
The Id of the ads account in which the ad was resolved from. |
aw.6601259029 |
BIZ_AD_ACCOUNTS.ID | |
ACCOUNT_NAME |
varchar |
The name of the ads account in which the ad was resolved from, such as Marketo-Measure-US. |
Marketo Measure |
||
ADVERTISER_UNIQUE_ID |
varchar |
The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically for Doubleclick connections. |
300181641 |
BIZ_ADVERTISERS.ID | |
ADVERTISER_NAME |
varchar |
The name of the advertiser from the ads account in which the ad was resolved from, specifically for Doubleclick connections. |
Marketo Measure Marketing Analytics |
||
SITE_UNIQUE_ID |
varchar |
The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
1695651 |
BIZ_SITES.ID | |
SITE_NAME |
varchar |
The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager. |
|||
PLACEMENT_UNIQUE_ID |
varchar |
The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager. |
120839827 |
BIZ_PLACEMENTS.ID | |
PLACEMENT_NAME |
varchar |
The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager. |
roadblock |
||
CAMPAIGN_UNIQUE_ID |
varchar |
The Id of the campaign from the ads account in which the ad was resolved from. |
aw.6601259029.208548635 |
BIZ_AD_CAMPAIGNS.ID | |
CAMPAIGN_NAME |
varchar |
The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar. |
Brand |
||
AD_GROUP_UNIQUE_ID |
varchar |
The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords. |
aw.6601259029.208548635.16750166675 |
BIZ_AD_GROUPS.ID | |
AD_GROUP_NAME |
varchar |
The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords. |
Brand - Core |
||
AD_UNIQUE_ID |
varchar |
The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display). |
BIZ_AD.ID | ||
AD_NAME |
varchar |
The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display). |
|||
CREATIVE_UNIQUE_ID |
varchar |
The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
aw.6601259029.208548635.16750166675.195329631298 |
BIZ_CREATIVES.ID | |
CREATIVE_NAME |
varchar |
The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Google AdWords and Bing Ads (search). |
Marketo Measure Official Site |
||
CREATIVE_DESCRIPTION_1 |
varchar |
The first line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Revenue Planning & Attribution |
||
CREATIVE_DESCRIPTION_2 |
varchar |
The second line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
Learn why 250+ companies choose Marketo Measure for marketing attribution. Get a demo! |
||
CREATIVE_DESTINATION_URL |
varchar |
The landing page that clicks through from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
|||
CREATIVE_DISPLAY_URL |
varchar |
The friendly URL name that’s shown on the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search). |
|||
KEYWORD_UNIQUE_ID |
varchar |
The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search |
aw.6601259029.208548635.16750166675.46267805426 |
BIZ_KEYWORDS.ID | |
KEYWORD_NAME |
varchar |
The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search) |
[marketo measure] |
||
KEYWORD_MATCH_TYPE |
varchar |
The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact” |
Exact |
||
IS_FORM_SUBMISSION_TOUCH |
boolean |
Whether or not this touchpoint had a form fill during the session |
TRUE |
||
IS_IMPRESSION_TOUCH |
boolean |
Whether or not this touchpoint is treated as the first impression touch of the opportunity journey |
FALSE |
||
IS_DELETED |
boolean |
Whether or not the record was deleted, used for diagnostics and auditing. |
FALSE |
||
ROW_KEY |
number(38,0) |
-5269090762570690000 |
|||
_CREATED_DATE |
timestamp_ntz |
The first time the row was inserted into Snowflake |
2016-08-28 00:32:55.000 |
||
_MODIFIED_DATE |
timestamp_ntz |
The time the row was last modified in Snowflake |
2016-08-28 00:32:55.000 |
||
_DELETED_DATE |
timestamp_ntz |
The time when the record was marked as deleted in Snowflake |
2016-08-28 00:32:55.000 |
How many Leads had sessions from Paid Search in 1-month?
select sum (tp.first_click_percentage)
from biz_leads leads
join biz_touchpoints tp
on leads.Id = tp.Lead_Id
join biz_user_touchpoints utp
on tp.User_Touchpoint_Id = utp.Id
where utp.touchpoint_date >= '2017-08-01' and utp.touchpoint_date < '2017-09-01' and utp.Channel like
'Paid Search%'
How many sessions are there per Opportunity in Custom Model?
select top 100 opps.Id, count(utp.*)
from biz_opportunities opps
inner join biz_attribution_touchpoints tp
on opps.Id = tp.Opportunity_Id
inner join biz_user_touchpoints utp
on tp.User_Touchpoint_Id = utp.Id
where tp.Custom_Model_Percentage > 0
group by opps.Id
What is the revenue per channel in Custom model per month?
select tp.Channel, extract(year from tp.Touchpoint_date) as year, extract(month from tp.Touchpoint_date) as month, sum(opps.Amount * tp.Custom_Model_percentage) as amountWithAttribution
from biz_opportunities opps
join biz_attribution_touchpoints tp
on opps.Id = tp.Opportunity_Id
group by tp.Channel, extract(year from tp.Touchpoint_date), extract(month from tp.Touchpoint_date) order by 1, 2, 3
How many anonymous sessions by channel?
select channel, count
from biz_sessions
group by channel
What is the top landing page for Leads?
select top 5 landing_page, count
from biz_sessions
group by landing_page