Snowflake Data Warehouse Schema Version 3

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.

NOTE

Rows with a value for _DELETED_DATE will be retained for 15 days, then removed from Snowflake.

Entity Relationship Diagrams

Click an image for its full-size version

CRM Data	Touchpoint Creation Data

Touchpoint Attributes	Spend Data

BIZ_ACCOUNTS

All CRM Accounts that are imported, along with custom Marketo Measure fields.

Column	Data Type	Description	Sample Data	Primary Key
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

BIZ_ACCOUNT_TO_EMAILS

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
EMAIL	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

BIZ_ACTIVITIES

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

BIZ_ADS

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	Facebook
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

BIZ_ADVERTISERS

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

BIZ_AD_ACCOUNTS

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

BIZ_AD_CAMPAIGNS

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

BIZ_AD_FORMS

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	LinkedIn
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

BIZ_AD_GROUPS

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

BIZ_AD_PROVIDERS

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

BIZ_ATTRIBUTION_TOUCHPOINTS

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.”	linkedin
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.	Google
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

BIZ_CAMPAIGN_MEMBERS

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

BIZ_CHANNELS

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

BIZ_CONVERSION_RATES

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

BIZ_CONTACTS

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
EMAIL	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

BIZ_COSTS

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	Google
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

BIZ_CREATIVES

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

BIZ_CRM_EVENTS

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	Email
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

BIZ_CRM_TASKS

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

BIZ_CURRENCIES

Table of all ISO currencies.

Column	Data Type	Description	Sample Data	Primary Key
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

BIZ_CUSTOMER_AB_TESTS

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	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

BIZ_CUSTOMER_EVENTS

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	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

BIZ_CUSTOM_LANDING_PAGES

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

BIZ_EMAIL_TO_VISITOR_IDS

Email addresses mapped to the Visitor_Id.

Column	Data Type	Description	Sample Data	Primary Key
EMAIL	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

BIZ_FACTS

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	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, Cost = 2, TPLead = 3, TPUser = 4, PageView = 5, Session = 6, FormSubmit = 7, Impression = 8	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
EMAIL	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

BIZ_FORM_SUBMITS

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 Nwdml3YTZBZDdPdXh4Q0RmcnBJWXhwZTF1Z0RrbXlDVmxJNzIwNkhWOExxNFZLRmphc 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
EMAIL	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

BIZ_IMPRESSIONS

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

BIZ_KEYWORDS

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

BIZ_LANDING_PAGES

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

BIZ_LEADS

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
EMAIL	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

BIZ_LEAD_STAGE_TRANSITIONS

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
EMAIL	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

BIZ_OPPORTUNITIES

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

BIZ_OPP_STAGE_TRANSITIONS

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

BIZ_PAGE_VIEWS

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
EMAIL	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

BIZ_PLACEMENTS

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

BIZ_SEGMENTS

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 BIZ_FACTS.CATEGORY_02_KEY BIZ_FACTS.CATEGORY_03_KEY BIZ_FACTS.CATEGORY_04_KEY BIZ_FACTS.CATEGORY_05_KEY BIZ_FACTS.CATEGORY_06_KEY BIZ_FACTS.CATEGORY_07_KEY BIZ_FACTS.CATEGORY_08_KEY BIZ_FACTS.CATEGORY_09_KEY BIZ_FACTS.CATEGORY_10_KEY BIZ_FACTS.CATEGORY_11_KEY BIZ_FACTS.CATEGORY_12_KEY BIZ_FACTS.CATEGORY_13_KEY BIZ_FACTS.CATEGORY_14_KEY BIZ_FACTS.CATEGORY_15_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

BIZ_SESSIONS

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	Google
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.	Google
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	linkedin
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

BIZ_SITES

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

BIZ_SITE_LINKS

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

BIZ_STAGE_DEFINITIONS

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
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

BIZ_TOUCHPOINTS

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
EMAIL	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.”	LinkedIn
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.	LinkedIn
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

BIZ_URLS

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
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

BIZ_USER_TOUCHPOINTS

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
EMAIL	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.	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/
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.	http://info.adobe.com/adwords-for-lead-generation
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.”	linkedin
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.	Google
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.	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.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).	http://info.adobe.com/demo
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/demo
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

Sample Queries

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