Data Warehouse Schema

Last update: 2023-12-06

Topics:
Data Warehouse
View more on this topic

Created for:

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.

IMPORTANT

Rows with a value for _DELETED_DATE will be retained for 7 days, then removed from Snowflake.
The time zones used in Snowflake adhere to Coordinated Universal Time (UTC).

NOTE

Click here to see sample queries at the bottom of this article.

Entity Relationship Diagrams

The Data Warehouse Data Model ERD shows how data in the data warehouse is intended to flow and be linked together. This diagram does not include all tables available in the data warehouse because some of them represent mapping tables, views of other tables already present, or deprecated tables we don’t recommend using any more. Please see the detailed descriptions of tables and columns present in the data warehouse below. Many of these tables contain denormalized fields, however, this diagram is the recommended data model, leveraging data from dimensional tables instead.

The additional Ads Dimensional Data Model ERD presents a view of how tables for ads specific dimensions can be best linked back to the tables in the main data model. Though ads dimensions are also denormalized in other tables, this represents the recommended model for joining these dimensions.

Click an image for its full-size version

Data Warehouse Data Model	Ads Dimensional Data Model

Views

BIZ_ACCOUNTS

Accounts imported from the source system.

Column	Data Type	Description	Sample Data
ID	varchar	The Account Id from the source system.	0013100001kpAZxAAM
CREATED_DATE	timestamp_ntz	The created date of the Account, from the source system.	2016-08-28 00:32:55.000
MODIFIED_DATE	timestamp_ntz	The last modified date of the Account, from the source system.	2018-08-01 17:38:30.000
NAME	varchar	The Account Name, from the source system.	Marketo Measure
WEB_SITE	varchar	Website for the Account, as recorded in the source system, used for Lead to Account mapping.	www.adobe.com
ENGAGEMENT_RATING	varchar	A letter grade (A, B, C, D, N/A) that is generated from the Marketo Measure Machine Learning model. This will be null if ABM is disabled.	B
ENGAGEMENT_SCORE	number(38,19)	A numerical score calculated by Marketo Measure 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.	adobe
IS_DELETED	boolean	Whether or not the record is deleted in the source system.	false
CUSTOM_PROPERTIES	varchar	Custom properties that Marketo Measure has imported from the source system, in JSON format.	{"Account_Type__c": "Security", "Foo":"Bar"}
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_ACCOUNT_TO_EMAILS

Mapping table between known Lead/Contact email addresses and Accounts. This table will be empty if ABM is disabled.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the record.	0013800001MMPPiAAP_person@adobe.com\|2022-01-05 17:22:13.000
ACCOUNT_ID	varchar	Source system Account Id.	0013100001phrBAAAY
EMAIL	varchar	Email address that has been mapped to the Account, either through Contact relationships or Lead to Account mapping.	person@adobe.com
MODIFIED_DATE	timestamp_ntz	The last modified date of the Account, from the source system.	2018-08-31 23:53:39.000
CREATED_DATE	timestamp_ntz	The created date of the Account, from the source system.	2018-08-18 22:01:32.000
IS_DELETED	boolean	Whether or not the record is considered deleted.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_ACTIVITIES

Activities imported from a source system or connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	The Activity Id from the source system.	1678625515
LEAD_ID	varchar	Id for the Lead associated with the Activity.	15530482
CONTACT_ID	varchar	Id for the Contact associated with the Activity.	13792552
ACTIVITY_TYPE_ID	varchar	Id for the Activity Type, from the source system.	104
ACTIVITY_TYPE_NAME	varchar	The Activity Name, from the source system.	change status in progression
START_DATE	timestamp_ntz	Start Date of the Activity, from the source system.	2020-01-01 01:01:00.000
END_DATE	timestapm_ntz	End Date of the Activity, from the source system.	2020-01-01 01:01:00.000
CAMPAIGN_ID	varchar	Id for the Campaign the Activity is a part of, from the source system.	li.508038570.147643566
SOURCE_SYSTEM	varchar	Identifies the source system type.	Marketo
CREATED_DATE	timestamp_ntz	Date the row was created in the source system.	2020-01-01 01:01:00.000
MODIFIED_DATE	timestamp_ntz	Date the row was last modified in the source system.	2020-01-01 01:01:00.000
IS_DELETD	boolean	Whether or not the record is considered deleted in the source system.	false
AD_FORM_ID	varchar	Id for the Ad Form the Activity is part of, from the source system.	li.507063119.3757704
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_ADS

Ads imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Ad.	fb.106851586409075.6052044288804.6052044290004.6053457066804
DISPLAY_ID	varchar	The Ad Id from the source system.	6053457066804
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Ad was imported.	fb.106851586409075
AD_ACCOUNT_NAME	varchar	Name of the Ad Account from which the Ad was imported.	Marketo Measure Account
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser for the Ad, specifically for Doubleclick.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser for the Ad, specifically for Doubleclick.	Marketing Analytics
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group for the Ad.	fb.106851586409075.6052044288804.6052044290004
AD_GROUP_NAME	varchar	Name of the Ad Group for the Ad.	Ad Set for Ad B
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the Ad.	fb.106851586409075.6052044288804
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the Ad.	Lead generation Campaign
IS_ACTIVE	boolean	Whether or not the Ad is still active in the source system.	false
IS_DELETED	boolean	Whether or not the Ad has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:35:59.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:35:59.000
NAME	varchar	Name of the Ad, from the source system.	Ad 2
NEEDS_UPDATE	boolean	Whether or not the Ad needs to be updated for Marketo Measure tagging. (Diagnostic field, used by internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, used for internal processing.	fb.106851586409075.6052044288804.6052044290004
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Ad".	Ad
PROVIDER_TYPE	varchar	Name of the Ad Provider for the Ad.	Facebook
URL_CURRENT	varchar	The URL for the landing page. (Diagnostic field, for internal processing.)
URL_OLD	varchar	Previous value for URL_CURRENT. (Diagnostic field, for internal processing.)
URL_REQUESTED	varchar	What the URL will be decorated with Marketo Measure parameters. (Diagnostic field, for internal processing.)
URL_ALTENATIVES	varchar	Imported from the source system. (Diagnostic field, for internal processing.)
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	6008900572523230000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_ADVERTISERS

Advertisers imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Advertiser.	dc.6114.9143143
DISPLAY_ID	varchar	The Advertiser Id from the source system.	9143143
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Ad was imported.	fb.106851586409075
AD_ACCOUNT_NAME	varchar	Name of the Ad Account from which the Ad was imported.	Marketo Measure Account
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser, specifically for Doubleclick.	300181641
ADVERTISER_NAME	varchar	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
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
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 source system.	true
IS_DELETED	boolean	Whether or not the Advertiser has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:35:59.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:35:59.000
NAME	varchar	Name of the Advertiser, from the source system.	Marketo Measure Marketing Analytics
NEEDS_UPDATE	boolean	Whether or not the Advertiser needs to be updated for Marketo Measure tagging. (Diagnostic field, used by internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, used for internal processing.
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Advertiser".	Advertiser
PROVIDER_TYPE	varchar	The Ad Provider for the Advertiser.	Doubleclick
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	6008900572523230000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_AD_ACCOUNTS

Ad Accounts imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique identifier for the Ad Account.	aw.6601259029
DISPLAY_ID	varchar	The Ad Account Id from the source system.	6601259029
AD_ACCOUNT_UNIQUE_ID	varchar	Expected to be null since this is the record for the Ad Accounts in the ads hierarchy.	null
AD_ACCOUNT_NAME	varchar	Expected to be null since this is the record for the Ad Accounts in the ads hierarchy.	null
ADVERTISER_UNIQUE_ID	varchar	Expected to be null since there is no Advertiser above the Ad Accounts in any ads hierarchy.	null
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
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
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 Ad Account is still active in the source system.	true
IS_DELETED	boolean	Whether or not the Ad Account has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-09-06 12:54:37.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:35:58.000
NAME	varchar	Name of the Ad Account, from the source system.	Marketo Measure Ad Account
NEEDS_UPDATE	boolean	Whether or not the Advertiser needs to be updated for Marketo Measure tagging. (Diagnostic field, used by internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, used for internal processing.
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Account".	Account
PROVIDER_TYPE	varchar	The name of the Ad Provider for the Ad Account.	AdWords
ACCOUNT_CURRENCY_UNIT	varchar	The currency code used for the Ad Account, from the source system.	USD
COMPANY_ID	varchar	Used for internal processing.	1933789
SOURCE	varchar	Parsed from the URL from utm_source.	Social
MEDIUM	varchar	Parsed from the URL from utm_medium.	lisu07261601
LAST_30_DAYS_COST	number(38,19)	The amount of spend imported for the last 30 days, only applicable to AdWords.	17260.000000000000000000
LAST_30_DAYS_IMPRESSIONS	number(38,0)	The number of impressions from the last 30 days, only applicable to AdWords.	730060
LAST_30_DAYS_CLICKS	number(38,0)	The number of clicks from the last 30 days, only applicable to AdWords.	3400
LAST_30_DAYS_CONVERSIONS	number(38,0)	The number of conversions reported from the last 30 days, only applicable to AdWords.	180
TRACKING_URL_TEMPLATE	varchar	Used for internal diagnostics.	http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
TRACKING_URL_TEMPLATE_OLD	varchar	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED	varchar	Used for internal diagnostics.
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)	Foreign Key to the Biz_Facts view.	-4609512587744160000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_AD_CAMPAIGNS

Campaigns imported from connected Ad Accounts, source systems, utm, and self reported.

Column	Data Type	Description	Sample Data
ID	varchar	Unique Id for the Campaign.	aw.6601259029.285114995
DISPLAY_ID	varchar	The Campaign Id from the source system.	285114995
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Campaign was imported.	aw.6601259029
AD_ACCOUNT_NAME	varchar	Name for the Ad Account from which the Campaign was imported.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser for the Campaign, specifically for Doubleclick.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser for the Campaign, specifically for Doubleclick.	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
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	Unique Id for the Campaign, use the Id field instead.
AD_CAMPAIGN_NAME	varchar	Name of the Campaign, use the Name field instead.
IS_ACTIVE	boolean	Whether or not the Campaign is still active in the source system.	true
IS_DELETED	boolean	Whether or not the Campaign has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:35:58.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:35:58.000
NAME	varchar	Name of the Campaign.	Partner Retargeting
NEEDS_UPDATE	boolean	Whether or not the Campaign needs to be updated for Marketo Measure tagging. (Diagnostic field, used by internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, used for internal processing.
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Campaign".	Campaign
PROVIDER_TYPE	varchar	Name of the Ad 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	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_OLD	varchar	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED	varchar	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_APPLIED	varchar	The tracking template added on the 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)	Foreign Key to the Biz_Facts view.	-6008900572523230000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_AD_FORMS

Ad Forms imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Ad Form.	li.507063119.3757704
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Ad Form was imported.	li.507063119
AD_ACCOUNT_NAME	varchar	Name of the Ad Account from which the Ad Form was imported.	Marketo Measure
IS_DELETED	boolean	Deleted status from the source system. Set to deleted if the status is Draft, Archived, or Canceled.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:35:58.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:35:58.000
NAME	varchar	Name of the Ad Form.	NSPA Ebook LGF (May 2020)
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "AdForm".	AdForm
PROVIDER_TYPE	varchar	Name of the Ad 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://adobe.com/blog/refinancing-application-process/
QUESTIONS	varchar	List of Questions for the Ad Form.	First name:Last name:Email address:Country/Region:Job title:Company name
STATUS	varchar	Status of the Ad Form.	submitted
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000
SOURCE_ID	varchar	Id for the Source from which the record originated.	aw.3284209

BIZ_AD_GROUPS

Ad Groups imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Ad Group.	aw.6601259029.317737955.23105326115
DISPLAY_ID	varchar	The Ad Group Id from the source system.	23105326115
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Ad Group was imported.	aw.6601259029
AD_ACCOUNT_NAME	varchar	Name for the Ad Account from which the Ad Group was imported.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Expected to be null since there is no Ad Group in the Doubleclick ads hierarchy.	null
ADVERTISER_NAME	varchar	Expected to be null since there is no Ad Group in the Doubleclick ads hierarchy.	null
AD_GROUP_UNIQUE_ID	varchar	Expected to be null since this is the record for the Ad Group in the hierarchy.	null
AD_GROUP_NAME	varchar	Expected to be null since this is the record for the Ad Group in the hierarchy.	null
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the Ad Group.	aw.6601259029.317737955
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the Ad Group.	Revenue Attribution
IS_ACTIVE	boolean	Whether or not the Ad Account is still active in the source system.	true
IS_DELETED	boolean	Whether or not the Ad Account has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:36:14.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:36:14.000
NAME	varchar	Name of the Ad Group.	Revenue Attribution - Account Based
NEEDS_UPDATE	boolean	Whether or not the Advertiser needs to be updated for Marketo Measure tagging. (Diagnostic field, used by internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, used for internal processing.
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "AdGroup".	AdGroup
PROVIDER_TYPE	varchar	Name of the Ad 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	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_OLD	varchar	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED	varchar	Used for internal diagnostics.
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)	Foreign Key to the Biz_Facts view.	-5594512713562690000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_AD_PROVIDERS

Ad Providers from any connected Ad Account, including an entry for self reported if applicable.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Ad Provider.	Bing
NAME	varchar	Name of the Ad Provider.	Bing
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	4783788151269206864
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_ATTRIBUTION_TOUCHPOINTS

Buyer Attribution Touchpoints, all touchpoints associated with an Opportunity.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Buyer Attribution Touchpoint (BAT).	BAT2_0060Z00000lFHtOQAW_ 0030Z00003K5bpKQAR_2017-06-20:01-05-20-6193330.0b5c5678807c
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-09-01 04:53:53.000
OPPORTUNITY_ID	varchar	Id for the Opportunity the BAT is attributed to.	0060Z00000lFHtOQAW
CONTACT_ID	varchar	Id for the Contact associated with the BAT.	0030Z00003K5bpKQAR
EMAIL	varchar	Email address associated with the BAT.	person@adobe.com
ACCOUNT_ID	varchar	Id for the Account the BAT is attributed to.	0013100001otbIAAAY
USER_TOUCHPOINT_ID	varchar	Id for the User Touchpoint which generated the BAT.	person@adobe.com_00v1B00003ZbWzHQAV
TOUCHPOINT_DATE	timestamp_ntz	Date of the touchpoint.	2017-06-20 01:05:20.000
VISITOR_ID	varchar	Id for the visitor associated with the BAT.	v_277d79d01678498fea067c9b631bf6df
MARKETING_TOUCH_TYPE	varchar	The type of activity, Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity. Referred to in the CRM as "Touchpoint Type."	Web Form
CHANNEL	varchar	The channel the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. Referred to in the CRM as "Marketing Channel - Path."	Social.LinkedIn
CATEGORY1	varchar	The segment value for the 1st Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."	ABC
CATEGORY2	varchar	The segment value for the 2nd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."	Yes
CATEGORY3	varchar	The segment value for the 3rd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."	SMB
CATEGORY4	varchar	The segment value for the 4th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."	New Business
CATEGORY5	varchar	The segment value for the 5th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY6	varchar	The segment value for the 6th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY7	varchar	The segment value for the 7th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY8	varchar	The segment value for the 8th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY9	varchar	The segment value for the 9th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY10	varchar	The segment value for the 10th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY11	varchar	The segment value for the 11th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY12	varchar	The segment value for the 12th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY13	varchar	The segment value for the 13th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY14	varchar	The segment value for the 14th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY15	varchar	The segment value for the 15th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
BROWSER_NAME	varchar	From the javascript and IP address, the detected browser that the user was on during the session.	Chrome
BROWSER_VERSION	varchar	From the javascript and IP address, the detected version of the browser that the user was on during the session.	58
PLATFORM_NAME	varchar	From the javascript and IP address, the detected platform that the user was on during the session.	Mac
PLATFORM_VERSION	varchar	From the javascript and IP address, the detected version of the platform that the user was on during the session.	10_12
LANDING_PAGE	varchar	The first landing page of the session which resulted in a touchpoint. Referred to in the CRM as "Landing Page".	http://www.adobe.com/blog/uncover- truth-behind-cost-per-lead
LANDING_PAGE_RAW	varchar	The first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. Referred to in the CRM as "Landing Page - Raw".	http://www.adobe.com/blog/uncover-truth -behind-cost-per-lead?utm_content=27322869&utm_ medium=social&utm_source=linkedin
REFERRER_PAGE	varchar	Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".	https://www.linkedin.com/
REFERRER_PAGE_RAW	varchar	Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".	https://www.linkedin.com/
FORM_PAGE	varchar	The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. Referred to in the CRM as "Form URL".	http://info.adobe.com/intro-guide-b2b-marketing-attribution
FORM_PAGE_RAW	varchar	The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. A raw form page may contain query parameters in the URL. Referred to in the CRM as "Form URL - Raw".	http://info.adobe.com/intro-guide-b2b-marketing-attribution
FORM_DATE	timestamp_ntz	Date the form submission occurred.	2017-06-20 01:06:41.000
CITY	varchar	From the javascript and IP address, the detected city the user was in during the session.	San Francisco
REGION	varchar	From the javascript and IP address, the detected region the user was in during the session.	California
COUNTRY	varchar	From the javascript and IP address, the detected country the user was in during the session.	United States
MEDIUM	varchar	Used to define the medium which 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	Used to define the source which resulted in the touchpoint. This can be parsed out from the URL from utm_source, 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." Referred to in the CRM as "Touchpoint Source".	linkedin
SEARCH_PHRASE	varchar	The value which the user entered in the browser to search for and ended 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	Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.	Google
ACCOUNT_UNIQUE_ID	varchar	Id of the Ad Account in which the ad was resolved from.	aw.6601259029
ACCOUNT_NAME	varchar	Name of the Ad Account in which the ad was resolved from.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Marketo Measure Marketing Analytics
SITE_UNIQUE_ID	varchar	Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	1695651
SITE_NAME	varchar	Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Quora.com
PLACEMENT_UNIQUE_ID	varchar	Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	120839827
PLACEMENT_NAME	varchar	Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	roadblock
CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign from the Ad Account in which the Ad was resolved from.	aw.6601259029.317738075
CAMPAIGN_NAME	varchar	Name of the Campaign from the Ad Account in which the Ad was resolved from.	Marketing Attribution
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords.	aw.6601259029.317738075.23105327435
AD_GROUP_NAME	varchar	Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords.	Marketing Attribution - General
AD_UNIQUE_ID	varchar	Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	dc.6114.8882972.25272734.492579576
AD_NAME	varchar	Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	Budget Webinar - sidebar
CREATIVE_UNIQUE_ID	varchar	Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	aw.6601259029.317738075.23105327435.182716179597
CREATIVE_NAME	varchar	Name of the Creative from the Ad Account in which the Ad was resolved from. 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, pulled from the Ad 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, pulled from the Ad 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, pulled from the Ad 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, pulled from the Ad 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	Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	aw.6601259029.317738075.23105327435.4838421670
KEYWORD_NAME	varchar	Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search)	"marketing attribution"
KEYWORD_MATCH_TYPE	varchar	The type of match found between the search phrase and the purchased keyword.	Exact
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	This field has been deprecated. Use the Stage_Transitions tables for stage information.	null
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 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 allocated to this touchpoint because it's a lead creation touch (See Is_Lead_Creation_Touch).	0.0000000000000000000
U_SHAPE_PERCENTAGE	number(22,19)	The calculated percentage 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 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 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 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).	0.0143061513081193
IS_DELETED	boolean	Whether this touchpoint is deleted.	false
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	-2712935512233520000
OPPORTUNITY_ROW_KEY	number(38,0)
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	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CAMPAIGN_MEMBERS

Campaign Members imported from the source system. This table will be empty if Campaign Sync is disabled.

Column	Data Type	Description	Sample Data
ID	varchar	The Campaign Member Id from the source system.	00v0Z00001VVzdLQAT
MODIFIED_DATE	timestamp_ntz	The last modified date of the Campaign Member, from the source system.	2018-08-31 20:49:54.000
CREATED_DATE	timestamp_ntz	The created date of the Campaign Member, from the source system.	2018-08-31 20:49:54.000
BIZIBLE_TOUCH_POINT_DATE	timestamp_ntz	Date and time 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	Id for the Lead the Campaign Member is tied to.	00Q0Z000013dw4GUAQ
LEAD_EMAIL	varchar	Email for the Lead the Campaign Member is tied to.	persona@adobe.com
CONTACT_ID	varchar	Id for the Contact the Campaign Member is tied to.	00331000032hMxRAAU
CONTACT_EMAIL	varchar	Email for the Contact the Campaign Member is tied to.	persona@adobe.com
STATUS	varchar	Status of the Campaign Member, 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.	Sent
HAS_RESPONDED	boolean	Tells if the Campaign Member was marked as "Responded" from the Status picker.	true
FIRST_RESPONDED_DATE	timestamp_ntz	Date the Campaign Member first responded.	2018-08-30 07:00:00.000
CAMPAIGN_NAME	varchar	Name of the related Campaign the Campaign Member is a part of.	Fast CMO Interviews
CAMPAIGN_ID	varchar	Id of the related Campaign the Campaign Member is a part of.	7010Z000001TcKlQAK
CAMPAIGN_TYPE	varchar	Type selected on the related Campaign the Campaign Member is a part of. The Type is used to map the Marketing Channel.	Offline
CAMPAIGN_SYNC_TYPE	varchar	Determines which Campaign Members to create touchpoints for. The possible values are: Include_All, Include_Responded, Exclude_All.	Include_All
LEAD_SYNC_STATUS	varchar	Audit field, states whether or not a Buyer Touchpoint was generated for the Lead. If no touchpoint was created, the reason why it didn't qualify is given.	No Touchpoint: Date outside model
CONTACT_SYNC_STATUS	varchar	Audit field, states whether or not a Buyer Touchpoint was generated for the Contact. If no touchpoint was created, the reason why it didn't qualify is given.	Touchpoint Created
OPP_SYNC_STATUS	varchar	Audit field, states whether or not a Buyer Attribution Touchpoint was generated for the Opportunity. If no touchpoint was created, the reason why it didn't qualify is given.	Touchpoint Created
IS_DELETED	boolean	Whether or not the record is considered deleted in the source system .	false
CUSTOM_PROPERTIES	varchar	Custom properties that Marketo Measure has imported from the source system, in JSON format.	{"Campaign_Type__c":"Dinners","Foo":"Bar"}
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CHANNELS

Marketing Channels, as created in the Marketo Measure application.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Channel.	Organic Search.Google
NAME	varchar	Name of the Channel.	Organic Search.Google
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	6008900572523230000
_CREATED_DATE	timestamp_ntz	The date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	The date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	The date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CONTACTS

Contacts imported from the source system.

Column	Data Type	Description	Sample Data
ID	varchar	The Contact Id from the source system.	0030Z00003OzioeQAB
MODIFIED_DATE	timestamp_ntz	Date the Contact record was last modified, from the source system.	2018-09-05 05:17:53.000
CREATED_DATE	timestamp_ntz	Date the Contact record was created, from the source system.	2018-09-05 05:17:51.000
EMAIL	varchar	Email address of the Contact, from the source system.	persona@adobe.com
ACCOUNTID	varchar	Id of the Account related to the Contact.	0013100001b44aGAAQ
LEAD_SOURCE	varchar	Source in which the Lead was created.	Advertisement
BIZIBLE_STAGE	varchar	Current stage of the Contact, recognized as a custom stage which can be created in the Marketo Measure application.	Demo Scheduled
BIZIBLE_STAGE_PREVIOUS	varchar	All previous stages for the Contact, recognized as custom stages which can be created in the Marketo Measure application.	Open - Contact
ODDS_OF_CONVERSION	number(38,19)	This feature has been deprecated. Please do not use this column.	N/A
BIZIBLE_COOKIE_ID	varchar	The Marketo Measure Cookie Id 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	Whether or not the record is deleted in the source system.	false
IS_DUPLICATE	boolean	Used to de-duplicate records if both a CRM and Marketo integration are set up. If there are duplicates, the Marketo Contact is marked true.	false
SOURCE_SYSTEM	varchar	Indicates if the record came from a CRM or a Marketo integration.	Crm
OTHER_SYSTEM_ID	varchar	Maps a person from a Marketo integration with a Contact from a CRM integration. If both a CRM and Marketo integration exist, the value is the corresponding Id.	1234 / 00Q0Z00001OohgTUAR
CUSTOM_PROPERTIES	varchar	Custom properties that Marketo Measure has imported from the source system , in JSON format.	{"Contact_Type__c":"CMO", "Foo":"Bar"}
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	3263982503087870000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CONVERSION_RATES

Currency conversion rates imported from the source system.

Column	Data Type	Description	Sample Data
ID	number(38,0)	A unique Id for the record.	-5942345438803054604
CURRENCY_ID	number(38,0)	Id value for the Currency.	7493833133899044458
SOURCE_ISO_CODE	varchar	Currency ISO code, from the source system.	USD
START_DATE	timestamp_ntz	Start date of the Conversion Rate.	2018-11-01 00:00:00.000
END_DATE	timestamp_ntz	Next start date for the Conversion Rate. (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)	Rate used to convert the currency to the corporate currency.	0.76728300
IS_CURRENT	boolean	The semantics of this field have been corrupted. Do not use.	true
CREATED_DATE	timestamp_ntz	Date the record was created in the source system.	2019-03-30 00:54:50.000
MODIFIED_DATE	timestamp_ntz	Date the record was last modified in the source system.	2019-03-30 00:54:50.000
IS_DELETED	boolean	Whether or not the record is considered deleted in the source system.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_COSTS

Cost data imported from connected Ad Accounts or self reported marketing spend.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Cost record.	aw.6601259029.285114995.21703163075.[AdWords Display]_2018-09-06
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-09-06 12:22:45.000
COST_DATE	timestamp_ntz	Date the Cost was incurred (or attributed to).	2018-09-06 00:00:00.000
SOURCE	varchar	Source of the reported Cost.	[AdWords Display]
COST_IN_MICRO	number(38,0)	Cost amount in millions. User will need to divide the value by 1000000.	1410000
CLICKS	number(38,0)	Number of clicks reported for the group for the day.	4
IMPRESSIONS	number(38,0)	Number of impressions reported for the group for the day.	4187
ESTIMATED_TOTAL_POSSIBLE_IMPRESSIONS	number(38,0)	Total number of impressions estimated from DCM for the group for the day.	5024
AD_PROVIDER	varchar	Provider for which the Cost was pulled.	Google
CHANNEL_UNIQUE_ID	varchar	Id for the marketing Channel, created by Marketo Measure.	Display.Google
CHANNEL_NAME	varchar	Name for the marketing Channel, created by the customer in the Marketo Measure app.	Display.Google
CHANNEL_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Channel. (i.e. to get Channel Cost, sum rows where this column equals true.)	false
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser pulled from the Ad connection, specifically for Doubleclick connections.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser pulled from the Ad connection, specifically for Doubleclick connections.	Marketo Measure Marketing Analytics
ADVERTISER_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Advertiser. (i.e. to get Advertiser Cost, sum rows where this column equals true.)	false
ACCOUNT_UNIQUE_ID	varchar	Id of the Ad Account pulled from the Ad connection.	aw.6601259029
ACCOUNT_NAME	varchar	Name of the Ad Account pulled from the Ad connection.	Marketo Measure
ACCOUNT_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Account. (i.e. to get Account Cost, sum rows where this column equals true.)	false
CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign pulled from the Ad connection.	aw.6601259029.285114995
CAMPAIGN_NAME	varchar	Name of the Campaign pulled from the Ad connection.	Partner Retargeting
CAMPAIGN_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Campaign. (i.e. to get Campaign Cost, sum rows where this column equals true.)	true
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group pulled from the Ad connection.	aw.6601259029.285114995.21703163075
AD_GROUP_NAME	varchar	Name of the Ad Group pulled from the Ad connection.	Attribution Management Software \| Phrase
AD_GROUP_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Ad Group. (i.e. to get Ad Group Cost, sum rows where this column equals true.)	false
AD_UNIQUE_ID	varchar	Id of the Ad pulled from the Ad connection.	dc.6114.9131003.24149929.467969200
AD_NAME	varchar	Name of the Ad pulled from the Ad connection.	Ad name: Ad3-320x50.gif; 320 x 50
AD_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Ad. (i.e. to get Ad Cost, sum rows where this column equals true.)	false
CREATIVE_UNIQUE_ID	varchar	Id of the Creative pulled from the Ad connection.	aw.6601259029.285114995.51749608028.266050115160
CREATIVE_NAME	varchar	Name of the Creative pulled from the Ad connection.	Gartner Magic Quadrant 2019
CREATIVE_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Creative. (i.e. to get Creative Cost, sum rows where this column equals true.)	false
KEYWORD_UNIQUE_ID	varchar	Id of the Keyword pulled from the Ad connection.	aw.6601259029.669328935.39419128772.99608705795
KEYWORD_NAME	varchar	Name of the Keyword pulled from the Ad connection.	sfdc marketing attribution
KEYWORD_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Keyword. (i.e. to get Keyword Cost, sum rows where this column equals true.)	false
PLACEMENT_UNIQUE_ID	varchar	Id of the Placement pulled from the Ad connection.	120839827
PLACEMENT_NAME	varchar	Name of the Placement pulled from the Ad connection.	roadblock
PLACEMENT_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Placement. (i.e. to get Placement Cost, sum rows where this column equals true.)	false
SITE_UNIQUE_ID	varchar	Id of the Site pulled from the Ad connection.	1695651
SITE_NAME	varchar	Name of the Site pulled from the Ad connection.	Quora.com
SITE_IS_AGGREGATABLE_COST	boolean	Indicates if the row contains Cost which can be summed up by Site . (i.e. to get Site Cost, sum rows where this column equals true.)	false
IS_DELETED	boolean	Whether or not the record is considered deleted in the source system .	false
ISO_CURRENCY_CODE	varchar	ISO code for the currency, imported from the source system.	USD
SOURCE_ID	varchar	Id for the Source from which the record originated.	aw.3284209
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	6008900572523230000
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)
CURRENCY_ID	number(38,0)	Id value of the Currency for the record.	-3253183181619994799
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CREATIVES

Creatives imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Creative.	ba.3284209.132855866.4556709270.10426699711
DISPLAY_ID	varchar	The Creative Id from the source system.	10426699711
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Creative was imported.	fb.106851586409075
AD_ACCOUNT_NAME	varchar	Name for the Ad Account from which the Creative was imported.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser for the Creative, specifically for Doubleclick.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser for the Creative, specifically for Doubleclick.	Marketo Measure Marketing Analytics
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group for the Creative.	fb.106851586409075.6052044288804.6052044290004
AD_GROUP_NAME	varchar	Name of the Ad Group for the Creative.	Ad Set for Ad B
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the Creative.	ba.3284209.132855866
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the Creative.	PipelineMarketing.com
IS_ACTIVE	boolean	Whether or not the Creative is still active in the source system.	true
IS_DELETED	boolean	Whether or not the Creative has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:36:25.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:36:25.000
NAME	varchar	Name of the Creative, from the source system.	PipelineMarketing.com
NEEDS_UPDATE	boolean	Whether or not the Creative needs to be updated for Marketo Measure tagging. (Diagnostic field, used by internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, for internal processing.
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Creative".	Creative
PROVIDER_TYPE	varchar	Name of the Ad Provider for the Creative.	BingAds
URL_CURRENT	varchar	The current version of the URL including all tags. (Diagnostic field, for internal processing.)	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	Previous value for URL_CURRENT. (Diagnostic field, for internal processing.)
URL_REQUESTED	varchar	What the URL will be decorated with Marketo Measure parameters. (Diagnostic field, for internal processing.)
URL_SHORTENED	varchar	The shortened and friendly URL that's displayed on the Creative. (Used for LinkedIn Ads only.)
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	Diagnostics field, for internal processing.
TRACKING_URL_TEMPLATE_OLD	varchar	Diagnostics field, for internal processing.
TRACKING_URL_TEMPLATE_REQUESTED	varchar	Diagnostics field, for internal processing.
TRACKING_URL_TEMPLATE_APPLIED	varchar	Diagnostics field, for internal processing.	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)	Foreign Key to the Biz_Facts view.	6008900572523230000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CRM_EVENTS

Events imported from the source system. This table will be empty if Activities Sync is disabled.

Column	Data Type	Description	Sample Data
ID	varchar	The Event Id from the source system.	00U3100000VLUnEEAX
CREATED_DATE	timestamp_ntz	Date the Event was created, from the source system.	2016-12-12 19:32:53.000
MODIFIED_DATE	timestamp_ntz	Date the Event was last modified, from the source system.	2018-09-03 08:39:51.000
LEAD_ID	varchar	Id for the Lead associated with the Event.	00Q0Z000013eVrxUAE
LEAD_EMAIL	varchar	Email for the Lead associated with the Event.	person@adobe.com
CONTACT_ID	varchar	Id for the Contact associated with the Event.	0030Z00003OyjbOQAR
CONTACT_EMAIL	varchar	Email for the Contact associated with the Event.	person@adobe.com
BIZIBLE_COOKIE_ID	varchar	The Marketo Measure Cookie Id 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	Activity Type Name, from the source system.	Email
EVENT_START_DATE	timestamp_ntz	Start date for the Event, one of the options used to determine the Touchpoint date.	2016-12-16 19:30:00.000
EVENT_END_DATE	timestamp_ntz	End date for the Event, one of the options used to determine the Touchpoint date.	2016-12-16 21:30:00.000
IS_DELETED	boolean	Whether or not the record is considered deleted in the source system.	False
CUSTOM_PROPERTIES	varchar	Custom properties that Marketo Measure has imported from the source system, in JSON format.	{"Contact_Type__c":"CMO","Foo":"Bar"}
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CRM_TASKS

Tasks imported from the source system. This table will populate if Activities Sync OR Call Tracking are enabled.

Column	Data Type	Description	Sample Data
ID	varchar	The Task Id from the source system.	00T0Z00004Rf62rUAB
CREATED_DATE	timestamp_ntz	Date the Task was created, from the source system.	2018-08-27 18:30:25.000
MODIFIED_DATE	timestamp_ntz	Date the Task was last modified, from the source system.	2018-08-27 18:31:53.000
LEAD_ID	varchar	Id for the Lead associated with the Task.	00Q0Z000013eVrxUAE
LEAD_EMAIL	varchar	Email for the Lead associated with the Task.	person@adobe.com
CONTACT_ID	varchar	Id for the Contact associated with the Task.	00331000038uGfhAAE
CONTACT_EMAIL	varchar	Email for the Contact associated with the Task.	person@adobe.com
BIZIBLE_COOKIE_ID	varchar	The Marketo Measure Cookie Id 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	Activity Type Name, from the source system.	Call
ACTIVITY_DATE	timestamp_ntz	Date the Task occurred, one of the options used to determine the Touchpoint date.	2018-08-27 07:00:00.000
IS_DELETED	boolean	Whether or not the record is considered deleted in the source system.	false
CUSTOM_PROPERTIES	varchar	Custom properties that Marketo Measure has imported from the source system, in JSON format.	{"Contact_Type__c":"CMO", "Foo":"Bar"}
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CURRENCIES

Table of all ISO currencies.

Column	Data Type	Description	Sample Data
ID	number(38,0)	A unique Id for the Currency record.	139474809945095870
ISO_CODE	varchar	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 source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modefied in Marketo Measure.	2018-08-27 18:30:25.000
MODIFIED_DATE_CRM	timestamp_ntz	Date the record was last modified in the source system.	2018-08-27 18:30:25.000
CREATED_DATE	timestamp_ntz	Date the record was created in Marketo Measure	2018-08-27 18:30:25.000
CREATED_DATE_CRM	timestamp_ntz	Date the record was created in the source system.	2018-08-27 18:30:25.000
ISO_NUMERIC	number(38,0)	ISO standard numeric code.	048
EXPONENT	number(38,0)	The number of decimal places between the smallest defined Currency unit and a whole Currency unit.	2
NAME	varchar	Name of the Currency.	Argentine Peso
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CUSTOMER_AB_TESTS

AB Tests recorded. This table will be empty if AB Tests are not enabled.

Column	Data Type	Description	Sample Data
VISITOR_ID	varchar	The first cookie id of the related visitor id.	v_36ec805b4db344d6e92c972c86aee34a
COOKIE_ID	varchar	The recorded cookie id at the time the event was logged.	36ec805b4db344d6e92c972c86aee34a
EVENT_DATE	timestamp_ntz	Date the chat was logged.	2020-01-01 01:01:00.000
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2020-01-01 01:01:00.000
IP_ADDRESS	varchar	The recorded IP address at the time the experiment was logged.	192.0.2.1
EXPERIMENT_ID	varchar	The id of the experiment pulled from the AB test platform.	123
EXPERIMENT_NAME	varchar	The name of the experiment pulled from the AB test platform.	Experiment A
VARIATION_ID	varchar	The variation id of the experiment pulled from the AB test platform.	456
VARIATION_NAME	varchar	The variation name of the experiment pulled from the AB test platform.	Blue Test
ABTEST_USER_ID	varchar	The id of the user who was served the experiment pulled from the AB test platform.	584d64et
IS_DELETED	boolean	Whether or not the record was deleted, used for diagnostics and auditing.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CUSTOMER_EVENTS

Web events that have been recorded using custom events in the Javascript. This table will be empty if Marketo Measure Events are not enabled.

Column	Data Type	Description	Sample Data
VISITOR_ID	varchar	The first cookie id of the related visitor id.	v_36ec805b4db344d6e92c972c86aee34a
COOKIE_ID	varchar	The recorded cookie id at the time the event was triggered from the custom javascript.	36ec805b4db344d6e92c972c86aee34a
EVENT_DATE	timestamp_ntz	The date the event was triggered from the custom javascript.	2020-01-01 01:01:00.000
MODIFIED_DATE	timestamp_ntz	The last date the record was modified.	2020-01-01 01:01:00.000
IP_ADDRESS	varchar	The recorded IP address at the time the event was triggered from the custom javascript.	192.0.2.1
KEY	varchar	The name given to the event which was triggered from the custom javascript.	Video View
VALUE	varchar	The value given to the event which was triggered from the custom javascript.	75% viewed
IS_DELETED	boolean	Whether or not the record was deleted, used for diagnostics and auditing.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_CUSTOM_LANDING_PAGES

Landing Pages downloaded from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the record.
DISPLAY_ID	varchar
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the landing page was imported.
AD_ACCOUNT_NAME	varchar	Name of the Ad Account from which the landing page was imported
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser for the landing page, specifically for Doubleclick.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser for the landing page, specifically for Doubleclick.	Marketing Analytics
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group for the landing page.
AD_GROUP_NAME	varchar	Name of the Ad Group for the landing page.
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the landing page.
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the landing page.
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	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_EMAIL_TO_VISITOR_IDS

Mapping table for email addresses and visitor ids.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the record.	0013800001MMPPiAAP_person@adobe.com\|2022-01-05 17:22:13.000
EMAIL	varchar	A known email address that's tied to a given visitor Id from a session	person@adobe.com
VISITOR_ID	varchar	The first cookie of the related visitor Id	v_36ec805b4db344d6e92c972c86aee34a
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 is considered deleted, used for diagnostics and auditing.	false
IS_IGNORE	boolean	Indicates if the email or visitor id is considered noise or spam, used for internal processing.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_FACTS

Unions together Impressions, Page Views, Visits, Form Submits, User Touchpoints, Touchpoint (BT), Attribution Touchpoints (BAT), and Cost data. Used internally to support Marketo Measure reporting.

Column	Data Type	Description	Sample Data
COST_KEY	number(38,0)	Used to join to the Costs table.	2672629811884560039
ATP_KEY	number(38,0)	Used to join to the Attribution Touchpoints table.	2672629811884560039
TP_KEY	number(38,0)	Used to join to the Touchpoints or User Touchpoints tables.	5028390208679093800
PAGE_VIEW_KEY	number(38,0)	Used to join to the Page Views table.	-8044063242541720607
SESSION_KEY	number(38,0)	Used to join to the Sessions table.	8817975702393619368
VISITOR_ID	varchar	The first cookie id of the related visitor id.	v_530d8334c455460df0d48f48270a4b23
COOKIE_ID	varchar	The recorded cookie id at the time the event was logged.	530d8334c455460df0d48f48270a4b23
FORM_SUBMIT_KEY	number(38,0)	Used to join to the Form Submits table.	-8659572802702769670
IMPRESSION_KEY	number(38,0)	Used to join to the Impressions table.	8817975702393619368
CURRENT_PAGE_KEY	number(38,0)	Used to join to the Urls table.	4079876040770132443
REFERRER_PAGE_KEY	number(38,0)	Used to join to the Urls table.	8817975702393619368
FORM_PAGE_KEY	number(38,0)	Used to join to the Urls table.	8817975702393619368
AD_PROVIDER_KEY	number(38,0)	Used to join to the Ad Providers table.	8817975702393619368
CHANNEL_KEY	number(38,0)	Used to join to the Channels table.	-1921844114032355934
CAMPAIGN_KEY	number(38,0)	Used to join to the Ad Campaigns table.	252687814634577606
KEYWORD_KEY	number(38,0)	Used to join to the Keywords table.	8817975702393619368
AD_KEY	number(38,0)	Used to join to the Ads table.	8817975702393619368
AD_GROUP_KEY	number(38,0)	Used to join to the Ad Groups table.	8817975702393619368
CREATIVE_KEY	number(38,0)	Used to join to the Creatives table.	-2333871387956621113
SITE_KEY	number(38,0)	Used to join to the Sites table.	8817975702393619368
ADVERTISER_KEY	number(38,0)	Used to join to the Advertisers table.	8817975702393619368
AD_ACCOUNT_KEY	number(38,0)	Used to join to the Ad Accounts table.	1825012532740770032
PLACEMENT_KEY	number(38,0)	Used to join to the Placements table.	8817975702393619368
CATEGORY_01_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_02_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_03_KEY	nubmer(38,0)	Used to join to the Segments table.	-2333871387956621113
CATEGORY_04_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_05_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_06_KEY	nubmer(38,0)	Used to join to the Segments table.	-2333871387956621113
CATEGORY_07_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_08_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_09_KEY	nubmer(38,0)	Used to join to the Segments table.	2333871387956621113
CATEGORY_10_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_11_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_12_KEY	nubmer(38,0)	Used to join to the Segments table.	-2333871387956621113
CATEGORY_13_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_14_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
CATEGORY_15_KEY	nubmer(38,0)	Used to join to the Segments table.	8817975702393619368
TYPE	number(38,0)	Indicates the fact type of the row. 1 = Buyer Attribution Touchpoint 2 = Cost 3 = Buyer Touchpoint 4 = User Touchpoint 5 = Page View 6 = Session 7 = Form Submit 8 = Impression	3
DATE	date	Date the event occurred.	2018-08-28
TIMESTAMP	timestamp_ntz	Date and time the event occurred.	2018-08-28 19:39:15.000
MODIFIED_DATE	timestamp_ntz	Date the row was last modified.	2018-08-29 00:46:47.000
COST_IN_MICRO	number(38,0)	Cost amount in millions. User will need to divide the value by 1000000.	27370000
IMPRESSIONS	number(38,0)	Number of impressions reported for the group for the day.	340
CLICKS	number(38,0)	Number of clicks reported for the group for the day.	4
FIRST_CLICK_PERCENTAGE	number(22,19)	The calculated percentage allocated to this touchpoint because it's a first touch.	0.0000000000000000000
LAST_ANON_CLICK_PERCENTAGE	number(22,19)	The calculated percentage allocated to this touchpoint because it's a lead creation touch.	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.	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.	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.	0.0000000000000000000
CUSTOM_MODEL_PERCENTAGE	number(22,19)	The calculated percentage that gets allocated to this touchpoint because it's part of a custom model.	0.0000000000000000000
AMOUNT	number(38,8)	Amount of the Opportuity, from the source system.	42000.00000000
IS_WON	boolean	Indicates if the Opportunity has been moved to a stage which is classified as won.	false
IS_OPP_CLOSED	boolean	Indicates if the Opportunity has moved to a stage which is classifed as closed.	false
OPPORTUNITY_ID	varchar	Opportunity Id from the source system.	0060Z00000nFEfEQAW
OPP_CREATED_DATE	timestamp_ntz	Date the Opportunity was created, from the source system.	2018-08-31 15:45:47.000
OPP_CLOSE_DATE	timestamp_ntz	Close date for the Opportunity, from the source system.	2018-12-31 07:00:00.000
CONTACT_CREATED_DATE	timestamp_ntz	Date the Contact record was created, from the source system.	2017-04-28 00:21:52.000
CONTACT_ID	varchar	Contact Id from the source system.	0030Z00003ORVJmQAP
EMAIL	varchar	Email address for the record.	personb@adobe.com
LEAD_CREATED_DATE	timestamp_ntz	Date the Lead record was created, from the source system.	2017-04-28 00:21:52.000
LEAD_ID	varchar	Lead Id from the source system.	00Q3100001GMPIsEAP
IS_AGGREGATABLE_COST_AD	boolean	Indicates if the row contains Cost which can be summed up by Ad. (i.e. to get Ad Cost, sum rows where this column equals true.)	false
IS_AGGREGATABLE_COST_ADVERTISER	boolean	Indicates if the row contains Cost which can be summed up by Advertiser. (i.e. to get Advertiser Cost, sum rows where this column equals true.)	true
IS_AGGREGATABLE_COST_AD_ACCOUNT	boolean	Indicates if the row contains Cost which can be summed up by Account. (i.e. to get Account Cost, sum rows where this column equals true.)	false
IS_AGGREGATABLE_COST_AD_GROUP	boolean	Indicates if the row contains Cost which can be summed up by Ad Group. (i.e. to get Ad Group Cost, sum rows where this column equals true.)	false
IS_AGGREGATABLE_COST_CAMPAIGN	boolean	Indicates if the row contains Cost which can be summed up by Campaign. (i.e. to get Campaign Cost, sum rows where this column equals true.)	true
IS_AGGREGATABLE_COST_CHANNEL	boolean	Indicates if the row contains Cost which can be summed up by Channel. (i.e. to get Channel Cost, sum rows where this column equals true.)	false
IS_AGGREGATABLE_COST_CREATIVE	boolean	Indicates if the row contains Cost which can be summed up by Creative. (i.e. to get Creative Cost, sum rows where this column equals true.)	false
IS_AGGREGATABLE_COST_KEYWORD	boolean	Indicates if the row contains Cost which can be summed up by Keyword. (i.e. to get Keyword Cost, sum rows where this column equals true.)	false
IS_AGGREGATABLE_COST_PLACEMENT	boolean	Indicates if the row contains Cost which can be summed up by Placement. (i.e. to get Placement Cost, sum rows where this column equals true.)	false
IS_AGGREGATABLE_COST_SITE	boolean	Indicates if the row contains Cost which can be summed up by Site . (i.e. to get Site Cost, sum rows where this column equals true.)	false
IS_DELETED	boolean	Whether or not the record was deleted, used as an audit trail.	false
CURRENCY_ID	number(38,0)	Id value of the Currency for the record.	-3253183181619994799
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_FORM_SUBMITS

Captured Form Submissions.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Form Submit.	2018-08-06:01-35-21-927280.9bc63c34482f4
COOKIE_ID	varchar	The recorded cookie id at the time the Form Submit was logged.	9bc63c34482f4de8c2e3b9d8d9f0df56
VISITOR_ID	varchar	The first cookie id of the related visitor id. If the record is marked as is_duplicated = true, this field will be null.	v_9bc63c34482f4de8c2e3b9d8d9f0df56
SESSION_ID	varchar	The recorded Session Id at the time the Form Submit was logged. If the record is marked as is_duplicated = true, this field will be null.	2018-08-06:01-35-24-1231230.9bc63c34482f
EVENT_DATE	timestamp_ntz	Date the Form was submitted.	2018-08-06 01:35:21.000
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-07 23:09:52.000
CURRENT_PAGE	varchar	URL where the Form was submitted, without query parameters.	https://info.adobe.com/webinar-marketo-measure-impact
CURRENT_PAGE_RAW	varchar	URL where the Form was submitted, including any query parameters.	https://info.adobe.com/webinar-marketo-measure-impact?utm_source=partner&mkt_tok=eyJpIjoiTnpBeE1EVml PV0UyWlRObSIsInQiOiI3MEFIek04ZVJiWm9renc1Z29RXC9kXC92YkxycFRYclE0MVhOaH Nwdml3YTZBZDdPdXh4Q0RmcnBJWXhwZTF1Z0RrbXlDVmxJNzIwNkhW
IP_ADDRESS	varchar	The recorded IP address at the time the Form was submitted.	174.127.184.158
TYPE	varchar	Indicates the type of Event.	FormSubmit
USER_AGENT_STRING	varchar	Device and browser recorded 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	Indicates the order in which the Page View occurred in the Session.	4
CLIENT_RANDOM	varchar	Used for internal auditing and processing.	20042b6b7af44512b43f6244d86faf4c
IS_DUPLICATED	boolean	Indicates if the record is considered a duplicate.	false
IS_PROCESSED	boolean	Used for internal processing.	true
EMAIL	varchar	Email address provided on the Form, as captured from the javascript.	personc@adobe.com
FORM_TYPE	varchar	Indicates the type of Form submitted.	Chat
FORM_SOURCE	varchar	Indicates the method in which the Form was recognized, such as onSubmit or AjaxIntercept	onSubmit
FORM_IDENTIFIER	varchar	Id value for the Form.	-956012665
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	-6255315750913680000
CURRENT_PAGE_KEY	number(38,0)	Foreign Key to the Url table.	6255315750913680000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_IMPRESSIONS

Impressions fired and recorded. This table requires a DoubleClick connection and Enable View Through set to True.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Impression.	6acd7b43290490fe5c53eed31281d09a\|2020-05-18:22:20:59\|0000\|0\|2869369052
COOKIE_ID	varchar	The recorded cookie id at the time of the Impression.	08c1063cb0a64349ad0d2d862f5cc700
VISITOR_ID	varchar	The first cookie id of the related visitor id.	v_08c1063cb0a64349ad0d2d862f5cc700
SESSION_ID	varchar	The recorded Session Id at the time the Impression was logged.	2018-08-06:01-35-24-1231230.9bc63c34482f
EVENT_DATE	timestamp_ntz	Date the Impression was served.	2020-01-01 01:01:00.000
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2020-01-01 01:01:00.000
CURRENT_PAGE	varchar	URL where the Impression was served, without query parameters.	https://info.adobe.com/webinar-marketo-measure-impact
CURRENT_PAGE_RAW	varchar	URL where the Impression was served, including any query parameters.	https://info.adobe.com/webinar-marketo-measure-impact?utm_source=partner&mkt_tok=eyJpIjoiTnpBeE1EVml PV0UyWlRObSIsInQiOiI3MEFIek04ZVJiWm9renc1Z29RXC9kXC92YkxycFRYclE0MVhOaH Nwdml3YTZBZDdPdXh4Q0RmcnBJWXhwZTF1Z0RrbXlDVmxJNzIwNkhW
IP_ADDRESS	varchar	The recorded IP address at the time of the Impression.	174.127.184.158
TYPE	varchar	Indicates the type of Event.	Impression
USER_AGENT_STRING	varchar	Device and browser recorded 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	Indicates the order in which the Page View occurred in the Session.	4
CLIENT_RANDOM	varchar	Used for internal auditing and processing.	20042b6b7af44512b43f6244d86faf4c
IS_DUPLICATED	boolean	Indicates if the record is considered a duplicate.	false
IS_PROCESSED	boolean	Used for internal processing.	true
REFERRER_PAGE	varchar	Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".	https://www.linkedin.com/
REFERRER_PAGE-RAW	varchar	Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".	https://www.linkedin.com/
CITY	varchar	The resolved city from the IP address.	Seattle
REGION	varchar	The resolved region from the IP address.	Washington
COUNTRY	varchar	The resolved country from the IP address.	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	Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.	Google
ACCOUNT_UNIQUE_ID	varchar	Id of the Ad Account in which the ad was resolved from.	aw.6601259029
ACCOUNT_NAME	varchar	Name of the Ad Account in which the ad was resolved from.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Market Measure Marketing Analytics
SITE_UNIQUE_ID	varchar	Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	1695651
SITE_NAME	varchar	Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Quora.com
PLACEMENT_UNIQUE_ID	varchar	Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	120839827
PLACEMENT_NAME	varchar	Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	roadblock
CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign from the Ad Account in which the Ad was resolved from.	aw.6601259029.317738075
CAMPAIGN_NAME	varchar	Name of the Campaign from the Ad Account in which the Ad was resolved from.	Marketing Attribution
AD_GROUP_UNIQUE_ID	varchar	Expected to be null since there is no Ad Group in the Doubleclick hierarchy for impressions	null
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	Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	68035923
AD_NAME	varchar	Name of the Ad from the Ad Account in which the Ad was resolved from. 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
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 Keyword in the Doubleclick hierarchy for Impressions.	null
KEYWORD_NAME	varchar	Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.	null
KEYWORD_MATCH_TYPE	varchar	Expected to be null since there is no Keyword 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.	Chrome
BROWSER_VERSION	varchar	From the javascript and IP address, the detected version of the browser that the user was on during the session.	58
PLATFORM_NAME	varchar	From the javascript and IP address, the detected platform that the user was on during the session.	Mac
PLATFORM_VERSION	varchar	From the javascript and IP address, the detected version of the platform that the user was on during the session.	10_12
ROW_KEY	number(38,0)	Foreign Key to the BIZ_FACTS view.	-2712935512233520000
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	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_KEYWORDS

Keywords imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Keyword.	ba.3284209.132630532.3646889365.39464932147
DISPLAY_ID	varchar	The Keyword Id from the source system.	39464932147
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Keyword was imported.	fb.106851586409075
AD_ACCOUNT_NAME	varchar	Name of the Ad Account from which the Keyword was imported.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.	null
ADVERTISER_NAME	varchar	Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.	null
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group for the Keyword.	ba.3284209.132630532.3646889365
AD_GROUP_NAME	varchar	Name of the Ad Group for the Keyword.	Revenue Attribution - B2B
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the Keyword.	ba.3284209.132630532
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the Keyword.	Revenue Attribution
IS_ACTIVE	boolean	Whether or not the Keyword is still active in the source system.	true
IS_DELETED	boolean	Whether or not the Keyword has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:37:29.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:37:29.000
NAME	varchar	Name of the Keyword, from the source system.	[revenue attribution b2b]
NEEDS_UPDATE	boolean	Whether or not the Keyword needs to be updated for Marketo Measure tagging. (Diagnostic field, used for internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, used for internal processing.	ba.3284209.132630532.3646889365
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Keyword".	Keyword
PROVIDER_TYPE	varchar	Name of the Ad Provider for the Keyword.	BingAds
URL_CURRENT	varchar	The URL for the landing page. (Diagnostic field, for internal processing.)
URL_OLD	varchar	Previous value for URL_CURRENT. (Diagnostic field, for internal processing.)
URL_REQUESTED	varchar	The URL for the landing page with Marketo Measure parameters. (Diagnostic field, for internal processing.)
IS_UPGRADED_URL	boolean	Diagnostic field, for internal processing.	false
WORD	varchar	The search phase the user entered.	revenue attribution b2b
MATCH_TYPE	varchar	The type of match that was found between the search phrase and the Keyword.	Exact
TRACKING_URL_TEMPLATE	varchar	Used for internal diagnostics.	http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
TRACKING_URL_TEMPLATE_OLD	varchar	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED	varchar	Used for internal diagnostics.
TRACKING_URL_TEMPLATE_APPLIED	varchar	The URL tracking template Marketo Measure added to the Keyword.	http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	-2712935512233520000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_LANDING_PAGES

Landing Pages imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Landing Page.
DISPLAY_ID	varchar
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the landing page was imported.
AD_ACCOUNT_NAME	varchar	Name of the Ad Account from which the landing page was imported.
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser for the landing page, specifically for Doubleclick.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser for the landing page, specifically for Doubleclick.	Marketing Analytics
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group for the landing page.
AD_GROUP_NAME	varchar	Name of the Ad Group for the landing page.
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the landing page.
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the landing page.
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	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_LEADS

Leads imported from the source system.

Column	Data Type	Description	Sample Data
ID	varchar	The Lead Id from the source system.	00Q0Z00001MZcj8UAD
MODIFIED_DATE	timestamp_ntz	Date the Lead record was last modified, from the source system.	2018-08-27 21:52:10.000
CREATED_DATE	timestamp_ntz	Date the Lead record was created, from the source system.	2018-08-27 21:52:10.000
EMAIL	varchar	Email address of the Lead, from the source system.	persona@adobe.com
WEB_SITE	varchar	Website entered for the Lead, from the source system, used for Lead2Account mapping.	adobe.com
COMPANY	varchar	Company name entered for the Lead, from the source system, used for Lead2Account mapping.	Marketo Measure
LEAD_SOURCE	varchar	Source in which the Lead was created.	Advertisement
IS_CONVERTED	boolean	Whether or not the Lead has been converted to a Contact.	true
CONVERTED_OPPORTUNITY_ID	varchar	Id of the related Opportunity once the Lead has been converted.	0013100001b44aGAAQ
CONVERTED_DATE	timestamp_ntz	Date the Lead was converted to a Contact.	2018-08-27 07:00:00.000
CONVERTED_CONTACT_ID	varchar	Id of the related Contact once the Lead has been converted.	0030Z00003Oyp25QAB
ACCOUNTID	varchar	Id of the mapped Account. Requirements: Enable ABM	0010Z0000236F9GQAU
BIZIBLE_STAGE	varchar	Current stage of the Lead, recognized as a custom stage which can be created in the Marketo Measure application.	Demo Scheduled
BIZIBLE_STAGE_PREVIOUS	varchar	All previous stages for the Lead, recognized as custom stages which can be created in the Marketo Measure application.	MQL
ODDS_OF_CONVERSION	number(38,19)	This feature has been deprecated. Please do not use this column.	N/A
LEAD_SCORE_MODEL	varchar	(deprecated)	null
LEAD_SCORE_RESULTS	varchar	(deprecated)	null
BIZIBLE_COOKIE_ID	varchar	The Marketo Measure Cookie Id 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	Whether or not the record is deleted in the source system.	false
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	3263982503087870000
CUSTOM_PROPERTIES	varchar	Custom properties that Marketo Measure has imported from the source system , in JSON format.	{"Lead_Type__c":"Sales Created", "Foo":"Bar"}
IS_DUPLICATE	boolean	Used to de-duplicate records if both a CRM and Marketo integration are set up. If there are duplicates, the Marketo Lead is marked true.	true
SOURCE_SYSTEM	varchar	Indicates if the record came from a CRM or a Marketo integration.	Crm
OTHER_SYSTEM_ID	varchar	Maps a person from a Marketo integration with a Lead from a CRM integration. If both a CRM and Marketo integration exist, the value is the corresponding Id.	1234
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_LEAD_STAGE_TRANSITIONS

Stage transitions for Leads or Contacts.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the transition.	ST_0030Z00003FhkRXQAZ__FT-1_TP2_Person_0030Z00003FhkRXQAZ_2018-08-27:17-05-45-9474800.0d5c18c29d7b
EMAIL	varchar	The provided email address for the related Lead/Contact.	persone@adobe.com
LEAD_ID	varchar	Id for the Lead associated to the transition.	00Q3100001Fx6AlEAJ
CONTACT_ID	varchar	Id for the Contact associated to the transition.	0033100003Aq9grAAB
TOUCHPOINT_ID	varchar	Id for the Buyer Touchpoint tied to the transition.	TP2_Person_00Q3100001Fx6AlEAJ_2018-08-28:14-41-06-1674260.d00ceb09fbd3
TRANSITION_DATE	timestamp_ntz	Date the record transitioned into the stage.	2018-08-27 16:05:34.000
STAGE_ID	varchar	Id value of the stage for the transition.	_bizible_FT
STAGE	varchar	Name of the stage for the transition.	FT
RANK	number(38,0)	The numerical rank of the stage, as ordered in the Marketo Measure Stage Mapping settings.	5
INDEX	varchar(1)	Used in internal processing for indexing and ordering boomerang stages.	1
LAST_INDEX	varchar(1)	Used in internal processing for indexing and ordering boomerang stages.	1
IS_PENDING	boolean	Indicates if the touchpoint is considered pending and not yet closed. This only appears for customers with full path attribution model.	false
IS_NON_TRANSITIONAL	boolean	Indicates if the 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 equal true.	false
PREVIOUS_STAGE_DATE	timestamp_ntz	Transition date for the previous stage, according to the stage rank.	2017-11-28 21:26:44.000
NEXT_STAGE_DATE	timestamp_ntz	Transition date for the next stage, according to the stage rank.	2017-12-11 22:39:17.000
MODIFIED_DATE	timestamp_ntz	Last modified date of the record.	2018-08-28 15:31:10.000
IS_DELETED	boolean	Whether or not the transition record is considered deleted.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_OPPORTUNITIES

Opportunities imported from the source system.

Column	Data Type	Description	Sample Data
ID	varchar	The Opportunity Id from the source system.	0060Z00000o89I4QAI
MODIFIED_DATE	timestamp_ntz	The last modified date of the Opportunity, from the source system.	2017-11-28 21:26:44.000
CREATED_DATE	timestamp_ntz	The created date of the Opportunity, from the source system.	2017-11-28 21:26:44.000
ACCOUNT_ID	varchar	Id of the related Account.	001i000000qbyeoAAA
NAME	varchar	The Opportunity Name, from the source system.	Mareketo Measure Renewal
IS_WON	boolean	Indicates if the Opportunity has moved to a stage considered won.	false
IS_CLOSED	boolean	Indicates if the Opportunity has moved to a stage considered closed.	false
CLOSE_DATE	timestamp_ntz	Anticipated or actual close date of the Opportunity, from the source system.	2019-08-28 07:00:00.000
BIZIBLE_CUSTOM_MODEL_DATE	timestamp_ntz	(deprecated)	null
AMOUNT	number(38,8)	Deal amount which is expected or closed from the Opportunity, from the source system.	8988.00000000
CONVERTED_FROM_LEAD_ID	varchar	The Id of the related Lead that had converted into this Opportunity. Note that this field is not set and returns null in Snowflake for all customers.	null
CONVERTED_FROM_LEAD_EMAIL	varchar	The email of the related Lead that had converted into this Opportunity. Note that this field is not set and returns null in Snowflake for all customers.	null
PRIMARY_CONTACT_ID	varchar	If Primary Contact Role is used, the Id of the related Contact listed as the primary contact role.	00331000038uGfhAAE
PRIMARY_CONTACT_EMAIL	varchar	If Primary Contact Role is used, the email of the related Contact listed as the primary contact role.	personb@adobe.com
ODDS_OF_CONVERSION	number(38,19)	This feature has been deprecated. Please do not use this column.	N/A
BIZIBLE_STAGE	varchar	Current stage of the Opportunity, as defined in the Marketo Measure application.	DM Demo
BIZIBLE_STAGE_PREVIOUS	varchar	A string of all stages the Opportunity has previously gone through, as defined in the Marketo Measure application.	Qualified Discovery, Demo Scheduled
IS_DELETED	boolean	Whether or not the record is deleted in the source system.	false
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	4609512587744160000
CURRENCY_ISO_CODE	varchar	ISO code for the currency, imported from the source system.	USD
CURRENCY_ID	number(38,0)	Id value of the Currency for the record.	4609512587744160000
CUSTOM_PROPERTIES	varchar	Custom properties that Marketo Measure has imported from the source system , in JSON format.	{"Opportunity_Location__c":"Seattle", "Foo":"Bar"}
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_OPP_STAGE_TRANSITIONS

Stage transitions for Opportunities.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the transition.	ST_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_Demo Scheduled-1_BAT2_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_2018-06-01:19-51-38-1685390.beec556e7757
ACCOUNT_ID	varchar	Id for the Account associated with the Opportunity.	0013100001b44nTAAQ
OPPORTUNITY_ID	varchar	Id for the Opportunity associatedto the transition.	0060Z00000nEgjlQAC
CONTACT_ID	varchar	Id for the Contact associated to the transition.	0030Z00003IjojKQAR
EMAIL	varchar	The provided email address for the related Contact.	persone@adobe.com
TOUCHPOINT_ID	varchar	Id for the Buyer Attribution Touchpoint tied to the transition.	BAT2_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_2018-06-01:19-51-38-1685390.beec556e7757
TRANSITION_DATE	timestamp_ntz	Date the record transitioned into the stage.	2018-05-26 07:29:43.000
STAGE	varchar	Name of the stage for the transition.	Demo Scheduled
STAGE_ID	varchar	Id value of the stage for the transition.	_bizible_FT
RANK	number(38,0)	The numerical rank of the stage, as ordered in the Marketo Measure Stage Mapping settings.	4
INDEX	varchar(1)	Used in internal processing for indexing and ordering boomerang stages.	1
LAST_INDEX	varchar(1)	Used in internal processing for indexing and ordering boomerang stages.	1
IS_PENDING	boolean	Indicates if the touchpoint is considered pending and not yet closed. This only appears for customers with full path attribution model.	false
IS_NON_TRANSITIONAL	boolean	Indicates if the 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 equal true.	false
PREVIOUS_STAGE_DATE	timestamp_ntz	Transition date for the previous stage, according to the stage rank.	2015-07-16 17:41:49.000
NEXT_STAGE_DATE	timestamp_ntz	Transition date for the next stage, according to the stage rank.	2018-08-27 19:40:52.000
MODIFIED_DATE	timestamp_ntz	Last modified date of the record.	2018-08-28 03:53:33.000
IS_DELETED	boolean	Whether or not the transition record is considered deleted.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_PAGE_VIEWS

Page Views collected from web visits. Multiple page views can compose a single Session.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Page View.	2018-08-19:16-49-58-24340.277d79d0167849
COOKIE_ID	varchar	The recorded cookie id at the time the Page View was logged.	277d79d01678498fea067c9b631bf6df
VISITOR_ID	varchar	The first cookie of the related visitor id.	v_277d79d01678498fea067c9b631bf6df
SESSION_ID	varchar	The Session id correlated with the Page View.	2018-08-19:16-49-58-24340.277d79d0167849
EVENT_DATE	timestamp_ntz	Date the Page View occurred.	2018-08-19 16:49:58.000
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-19 16:55:37.000
CURRENT_PAGE	varchar	URL of the Page View, without query parameters.	https://info.adobe.com/demo
CURRENT_PAGE_RAW	varchar	URL of the Page View, including any query parameters.	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	Indicates the type of Event.	PageView
USER_AGENT_STRING	varchar	Device and browser recorded 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)	Indicates the order in which the Page View occurred in the Session.	1
CLIENT_RANDOM	varchar	Used for internal auditing and processing.	103532
IS_DUPLICATED	boolean	Indicates if the record is considered a duplicate.	false
IS_PROCESSED	boolean	Used for internal processing.	true
REFERRER_PAGE	varchar	URL where the Page View originated from, without query parameters.	http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution
REFERRER_PAGE_RAW	varchar	URL where the Page View originated from, including any query parameters.	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	Title of the Page.	The CMO's Guide to B2B Marketing Attribution Download
EMAIL	varchar	Email address provided on a Form, as captured from the javascript.	personc@adobe.com
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	-6255315750913680000
CURRENT_PAGE_KEY	number(38,0)	Foreign Key to the Url table.	6255315750913680000
REFERRER_PAGE_KEY	number(38,0)	Foreign Key to the Url table.	6255315750913680000
HAS_USER_CONSENT	boolean	Indicates if the user has consented to tracking. False means the Page View has been collected because user consent is not required. True means the Page View has been collected and the user has given consent to be tracked.	true
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.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
ID	varchar	A unique Id for the Placement.	ba.3284209.132855866.4556709270.10426699711
DISPLAY_ID	varchar	The Placement Id from the source system.	10426699711
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Placement was imported.	fb. 106851586409075
AD_ACCOUNT_NAME	varchar	Name for the Ad Account from which the Placement was imported.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser for the Placement, specifically for Doubleclick.	300184624
ADVERTISER_NAME	varchar	Name of the Advertiser for the Placement, specifically for Doubleclick.	Marketo Measure Analytics
AD_GROUP_UNIQUE_ID	varchar	Expected to be null since there is no Ad Group above the Placement in any ads hierarchy.	null
AD_GROUP_NAME	varchar	Expected to be null since there is no Ad Group above the Placement in any ads hierarchy.	null
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the Placement.	ba.3284209.132855866
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the Placement.	Pipeline Marketing
IS_ACTIVE	boolean	Whether or not the Placement is still active in the source system.	true
IS_DELETED	boolean	Whether or not the Placement has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:36:25.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:36:25.000
NAME	varchar	Name of the Placement, from the source system.	Market
NEEDS_UPDATE	boolean	Whether or not the Placement needs to be updated for Marketo Measure tagging. (Diagnostic field, used by internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, for internal processing.
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Placement".	Placement
PROVIDER_TYPE	varchar	Name of the Ad Provider for the Placement.	BingAds
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	6008900572523230000
_CREATED_DATE	timestamp_ntz	Snowflake's created date of the record	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Snowflake's modified date of the record	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Snowflake's deleted date of the record if it has been deleted	2020-01-01 01:01:00.000

BIZ_SEGMENTS

Segment values as defined in the Marketo Measure application.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Segment.	New Business
NAME	varchar	Name of the Segment.	New Business
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	1028715376434030000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_SEGMENT_NAMES

Maps the name of the custom segment to it’s category value. (This maps the column names to the Category1 - 15 column headers found in the touchpoint tables.)

Column	Data Type	Description	Sample Data
CATEGORY	varchar	Indicates the category the segment name is mapped to.	CategoryOne
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2022-02-28 18:12:35.000
SEGMENT_NAME	varchar	Name of the segment mapped to the category.	1028715376434030000
IS_ACTIVE	boolean	Indicates if the category is in use.	true
IS_DELETED	boolean	Indicates if the record is deleted.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_SESSIONS

Sessions as processed from Page Views. Multiple Page Views can make up one Session, and a single visitor id can be associated to multiple Sessions.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Session.	2016-08-01:14-24-21-9079480.33163948f0a3
VISITOR_ID	varchar	The first cookie of the related visitor id.	v_277d79d01678498fea067c9b631bf6df
COOKIE_ID	varchar	The recorded cookie id of the Session.	277d79d01678498fea067c9b631bf6df
EVENT_DATE	timestamp_ntz	Date of the Session.	2016-08-01 14:24:21.000
MODIFIED DATE	timestamp_ntz	Date the record was last modified.	2018-09-01 03:49:10.000
IS_FIRST_SESSION	boolean	Indicates if this is the first Session for the visitor id.	true
CHANNEL	varchar	Channel attirbuted to the Session, as defined by the Channel definitions set in the Marketo Measure application.	Paid Search.AdWords
PAGE_TITLE	varchar	Name of the web page.	Salesforce Google Analytics \| Marketo Measure
LANDING_PAGE	varchar	URL of the first Page View of the Session, without query parameters.	http://www.adobe.com/salesforce-google-analytics
LANDING_PAGE_RAW	varchar	URL of the first Page View of the Session, including any query parameters.	http://www.adobe.com/salesforce-google-analytics?_bt=83558988035&_bk=google%20analytics%20salesforce&_bm= p&gclid=CMvd5YTLo84CFUI9gQodd-kLEQ
REFERRER_PAGE	varchar	URL where the Session originated from, without query parameters.	https://www.google.com/
REFERRER_PAGE_RAW	varchar	URL where the Session originated from, including any query parameters.	https://www.google.com/
REFERRER_NAME	varchar	Name of the referrer page.	Google
SEARCH_PHRASE	varchar	The value that the user entered in the browser to search for and ended up on the website.	Marketo Measure google salesforce
WEB_SOURCE	varchar	Used to define the source that resulted in the Session. This can be parsed out from the URL from utm_source or set to an Ad Provider if Marketo Measure is able to resolve an ad.	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 Sesssion came from a CRM activity record.	false
DEVICE	varchar	The browser and operating system of the user during the Session.	Chrome (65.0), Windows (6.1)
AD_PROVIDER	varchar	The Ad platform Marketo Measure resolvde from, typically one of our integration partners.	Google
ACCOUNT_UNIQUE_ID	varchar	Id of the Ad Account which the ad was resolved from.	aw.6601259029
ACCOUNT_NAME	varchar	Name of the Ad Account which the ad was resolved from.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser the Ad was resolved from, specifically from Doubleclick connection.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser the Ad was resolved from, specifically from Doubleclick connection.	Marketing Analytics
SITE_UNIQUE_ID	varchar	Id of the Site the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	1695651
SITE_NAME	varchar	Name of the Site the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Quora.com
PLACEMENT_UNIQUE_ID	varchar	Id of the Palcement the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	120839827
PLACEMENT_NAME	varchar	Name of the Placement the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	roadblock
CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign the Ad was resolved from.	aw.6601259029.321586235
CAMPAIGN_NAME	varchar	Name of the Campaign the Ad was resolved from.	Planning Your Budget Webinar
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group the Ad was resolved from. This only applies to Google Adwords.	aw.6601259029.321586235.23182235435
AD_GROUP_NAME	varchar	Name of the Ad Group the Ad was resolved from. This only applies to Google Adwords.	Salesforce - Google Analytics
AD_UNIQUE_ID	varchar	Id of the Ad resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	aw.6601259029.321586235.23182235435
AD_NAME	varchar	Name of the Ad resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	Winter Promo - Green
CREATIVE_UNIQUE_ID	varchar	Id of the Creative the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	aw.6601259029.321586235.23182235435.83558988035
CREATIVE_NAME	varchar	Name of the Creative the Ad was resolved from. 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, pulled from the Ad 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, pulled from the Ad 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, pulled from the Ad 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, pulled from the Ad 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	Id of the Keyword the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	aw.6601259029.321586235.23182235435.35934468937
KEYWORD_NAME	varchar	Name of the Keyword the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	google analytics salesforce
KEYWORD_MATCH_TYPE	varchar	The type of match found between the search phrase and the purchased keyword.	Phrase
CAMPAIGN	varchar	Parsed from the URL from utm_campaign.	SU - ABC Accounts - Paid Media Skills
SOURCE	varchar	Parsed from the URL from utm_source.	linkedin
MEDIUM	varchar	Parsed from the URL from utm_medium.	Social
TERM	varchar	Parsed from the URL from utm_term.	lisu07261601
CONTENT	varchar	Parsed from the URL from utm_content.	2016 AdWords Benchmark Report
CITY	varchar	The resolved city from the IP address.	Vancouver
REGION	varchar	The resolved region from the IP address.	British Columbia
COUNTRY	varchar	The resolved country from the IP address.	Canada
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)	Foreign Key to the Biz_Facts view.	-2712935512233520000
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	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_SITES

Sites imported from any connected Ad Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Site.	aw.3284209
DISPLAY_ID	varchar	The Site Id from the source system.	39464932147
AD_ACCOUNT_UNIQUE_ID	varchar	Id for the Ad Account from which the Site was imported.	aw.3284209
AD_ACCOUNT_NAME	varchar	Name of the Ad Account from which the Site was imported.	Marketo Measure
ADVERTISER_UNIQUE_ID	varchar	The Id of the advertiser for the site, specifically for Doubleclick.	300181641
ADVERTISER_NAME	varchar	The name of the advertiser for the site, specifically for Doubleclick.	Marketing Analytics
AD_GROUP_UNIQUE_ID	varchar	Expected to be null since there is no Ad Group above Site in any ads hierarchy.	null
AD_GROUP_NAME	varchar	Expected to be null since there is no Ad Group above Site in any ads hierarchy.	null
AD_CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign for the Site.	ba.3284209.132630532
AD_CAMPAIGN_NAME	varchar	Name of the Campaign for the Site.	Revue Attribution
IS_ACTIVE	boolean	Whether or not the Site is still active in the source system.	true
IS_DELETED	boolean	Whether or not the Site has been deleted in the source system.	false
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-02 06:37:29.000
FIRST_IMPORTED	timestamp_ntz	Date the record was first imported from the source system.	2018-08-02 06:37:29.000
NAME	varchar	Name of the Site, from the source system.	Revenue
NEEDS_UPDATE	boolean	Whether or not the Site needs to be updated for Marketo Measure tagging. (Diagnostic field, used for internal processing.)	false
GROUPING_KEY	varchar	Diagnostic field, used for internal processing.
ENTITY_TYPE	varchar	The main object or entity for this table. In this case, "Site".	Site
PROVIDER_TYPE	varchar	Name of the Ad Provider for the Site.	AdWords
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	-2712935512233520000
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_SITE_LINKS

Sites Links from any connected Ads Account.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the site link	aw.6601259029.285077795.1654234342
DISPLAY_ID	varchar		1654234342
AD_ACCOUNT_UNIQUE_ID	varchar	The ID of the connected ads account for the site link	aw.6601259029
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
ADVERTISER_NAME	varchar	The name of the advertiser for the site link, specifically for Doubleclick.	Marketing Analytics
AD_GROUP_UNIQUE_ID	varchar	The ID of the ad group for the site link	aw.6601259029.208548635.16750166675
AD_GROUP_NAME	varchar	The name of the ad group for the site link	Brand - Core
AD_CAMPAIGN_UNIQUE_ID	varchar	The ID of the campaign for the site link	aw.6601259029.285077795
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	Link A
NEEDS_UPDATE	boolean	Whether or not the site link needs to get updated to get Marekto 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	The URL for the landing page. (Diagnostic field, for internal processing.)	http://adobe.com/b2b-marketing-attribution?_bt = {creative}&_bk={keyword}&_bm={matchType}
URL_OLD	varchar	Previous value for URL_CURRENT. (Diagnostic field, for internal processing.)
URL_REQUESTED	varchar	What the URL will be decorated with Marketo Measure parameters. (Diagnostic field, for internal processing.)
_CREATED_DATE	timestamp_ntz	Snowflake's created date of the record	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Snowflake's modified date of the record	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Snowflake's deleted date of the record if it has been deleted	2020-01-01 01:01:00.000

BIZ_STAGE_DEFINITIONS

List of stages as imported or defined in the Marketo Measure application.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Stage.	01J3100000QE753EAD
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-22 17:27:27.000
STAGE_NAME	varchar	Name of the Stage.	Verbal
IS_INACTIVE	boolean	Indicates if the Stage is considered inactive.	false
IS_IN_CUSTOM_MODEL	boolean	Indicates if the Stage is selected to track in the custom model.	false
IS_BOOMERANG	boolean	Indicates if the Stage is selected to track as a boomerang stage.	false
IS_TRANSITION_TRACKING	boolean	Indicates if the Stage is selected to track for transitions.	false
STAGE_STATUS	varchar	Status of the Stage, as defined in the Marketo Measure application Stage Mapping.	Open
IS_FROM_SALESFORCE	boolean	Indicates if the Stage is imported from an external source system.	true
IS_DEFAULT	boolean	Indicates if the Stage is set as a default.	false
RANK	number(38,0)	The numerical rank of the Stage, used to sort Stages in transitional order.	53
IS_DELETED	boolean	Whether or not the Stage has been deleted.	false
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_TOUCHPOINTS

Buyer Touchpoints, all touchpoints associated with a Lead or Contact. This table will be empty if Lead Touchpoints or Contact Touchpoints are disabled.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the Buyer Touchpoint (BT).	TP2_Person_00Q0Z000013e2PYUAY_2018-08-27:20-04-40-5655690.1ee8567c175a
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-08-29 22:29:30.000
EMAIL	varchar	Email address associated with the BT.	person@adobe.com
CONTACT_ID	varchar	Id for the Contact associated with the BT.	0030Z00003K5bpKQAR
ACCOUNT_ID	varchar	Id for the Account associated with the BT.	0013100001lSLScAAO
LEAD_ID	varchar	Id for the Lead associated with the BT.	00Q0Z000013e2PYUAY
UNIQUE_ID_PERSON	varchar	The parent person record that relates to a Lead or Contact.	Person_00Q0Z000013e2PYUAY
USER_TOUCHPOINT_ID	varchar	Id for the User Touchpoint which generated the BT.	person@adobe.com_2018-08-29:18-14-53-8102030.10df92cbb414
VISITOR_ID	varchar	Id for the visitor associated with the BT.	v_277d79d01678498fea067c9b631bf6df
TOUCHPOINT_DATE	timestamp_ntz	Date of the touchpoint.	2018-08-27 20:04:40.000
MARKETING_TOUCH_TYPE	varchar	The type of activity, Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity. Referred to in the CRM as "Touchpoint Type."	Web Form
CHANNEL	varchar	The channel the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. Referred to in the CRM as "Marketing Channel - Path."	Social.LinkedIn
CATEGORY1	varchar	The segment value for the 1st Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".	ABC
CATEGORY2	varchar	The segment value for the 2nd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".	Yes
CATEGORY3	varchar	The segment value for the 3rd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".	Other
CATEGORY4	varchar	The segment value for the 4th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".	Partner
CATEGORY5	varchar	The segment value for the 5th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY6	varchar	The segment value for the 6th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY7	varchar	The segment value for the 7th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY8	varchar	The segment value for the 8th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY9	varchar	The segment value for the 9th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY10	varchar	The segment value for the 10th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY11	varchar	The segment value for the 11th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY12	varchar	The segment value for the 12th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY13	varchar	The segment value for the 13th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY14	varchar	The segment value for the 14th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
CATEGORY15	varchar	The segment value for the 15th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".
BROWSER_NAME	varchar	From the javascript and IP address, the detected browser that the user was on during the session.	Chrome
BROWSER_VERSION	varchar	From the javascript and IP address, the detected version of the browser that the user was on during the session.	68
PLATFORM_NAME	varchar	From the javascript and IP address, the detected platform that the user was on during the session.	Windows
PLATFORM_VERSION	varchar	From the javascript and IP address, the detected version of the platform that the user was on during the session.	10_12
LANDING_PAGE	varchar	The first landing page of the session which resulted in a touchpoint. Referred to in the CRM as "Landing Page".	https://info.adobe.com/definitive-guide-to-pipeline-marketing
LANDING_PAGE_RAW	varchar	The first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. Referred to in the CRM as "Landing Page - Raw".	https://info.adpbe.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	Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".	https://www.linkedin.com/
REFERRER_PAGE_RAW	varchar	Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".	https://www.linkedin.com/feed
FORM_PAGE	varchar	The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Touchpoints table, but rather in the Form_Submits table. Referred to in the CRM as "Form URL".	https://info.adobe.com/demo
FORM_PAGE_RAW	varchar	The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Touchpoints table, but rather in the Form_Submits table. A raw form page may contain query parameters in the URL. Referred to in the CRM as "Form URL - Raw".	https://info.adobe.com/demo?hsCtaTracking=98adcc2f-afe2-40c4-9d79-40dcc41663ee%7C3cfaa909-39cb-4f5d-93eb-be05de6b0180
FORM_DATE	timestamp_ntz	Date the form submission occurred.	2017-06-20 01:06:41.000
CITY	varchar	From the javascript and IP address, the detected city the user was in during the session.	New York
REGION	varchar	From the javascript and IP address, the detected region the user was in during the session.	New York
COUNTRY	varchar	From the javascript and IP address, the detected country the user was in during the session.	United States
MEDIUM	varchar	Used to define the medium which 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	Used to define the source which resulted in the touchpoint. This can be parsed out from the URL from utm_source, 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." Referred to in the CRM as "Touchpoint Source".	LinkedIn
SEARCH_PHRASE	varchar	The value which the user entered in the browser to search for and ended up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform.	markeot measure attribution
AD_PROVIDER	varchar	Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.	LinkedIn
ACCOUNT_UNIQUE_ID	varchar	Id of the Ad Account in which the ad was resolved from.	li.502664737
ACCOUNT_NAME	varchar	Name of the Ad Account in which the ad was resolved from.	MM SC 2016_14605342_3/7-3/31/16
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Marketo Marketing Analytics
SITE_UNIQUE_ID	varchar	Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	1695651
SITE_NAME	varchar	Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Quora.com
PLACEMENT_UNIQUE_ID	varchar	Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	120839827
PLACEMENT_NAME	varchar	Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	roadblock
CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign from the Ad Account in which the Ad was resolved from.	li.502664737.138949954
CAMPAIGN_NAME	varchar	Name of the Campaign from the Ad Account in which the Ad was resolved from.	SU - COM Accounts - Demand Skills
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords.	aw.6601259029.317738075.23105327435
AD_GROUP_NAME	varchar	Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords.	Marketing Attribution - General
AD_UNIQUE_ID	varchar	Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	dc.6114.8882972.25272734.492579576
AD_NAME	varchar	Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	Budget Webinar - sidebar
CREATIVE_UNIQUE_ID	varchar	Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	li.502664737.138949954.66452504
CREATIVE_NAME	varchar	Name of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	lisu03151846
CREATIVE_DESCRIPTION_1	varchar	The first line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	Lead gen is done
CREATIVE_DESCRIPTION_2	varchar	The second line of the Creative from the search Ad, pulled from the Ad 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, pulled from the Ad 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, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	marektomeasure.com/guide
KEYWORD_UNIQUE_ID	varchar	Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	__GAId__lisu03151846
KEYWORD_NAME	varchar	Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search)	lisu03151846
KEYWORD_MATCH_TYPE	varchar	The type of match found between the search phrase and the purchased keyword.	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.	false
IS_CLOSED_TOUCH	boolean	Whether or not this touchpoint is treated as the closed touch of the opportunity journey.	false
STAGES_TOUCHED	varchar	This field has been deprecated. Use the Stage_Transitions tables for stage information.	null
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 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 allocated to this touchpoint because it's a lead creation touch (See Is_Lead_Creation_Touch).	100
U_SHAPE_PERCENTAGE	number(22,19)	The calculated percentage 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 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). Expected to be 0 since this is a BT.	0
FULL_PATH_PERCENTAGE	number(22,19)	The calculated percentage 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). Expected to be 0 since this is a BT.	0
CUSTOM_MODEL_PERCENTAGE	number(22,19)	The calculated percentage 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). Expected to be 0 since this is a BT.	0
IS_DELETED	boolean	Whether this touchpoint is deleted.	false
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	-9004910726709710000
CONTACT_ROW_KEY	number(38,0)
LEAD_ROW_KEY	number(38,0)
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	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_URLS

Aggregation of URLs from landing pages, referrer pages, and page views.

Column	Data Type	Description	Sample Data
ID	varchar	The full URL,.	https://www.adobe.com/blog/strategic-marketing-plangoals
SCHEME	varchar	The secure communication of the web page over the network.	https
HOST	varchar	The domain of the URL, with any subdomains.	www.adobe.com
PAGE_TITLE	varchar	Title of the page.	The CMO's Guide to B2B Marketing Attribution Download
PATH	varchar	The part of the URL that points to a specific location on the host.	/blog/strategic-marketing-plangoals
PORT	varchar	The port from an internet host, optional in a URL.	584
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	5686109553536636820
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_USER_TOUCHPOINTS

All Touchpoints created from any event tied to an email.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the User Touchpoint.	person@adobe.com_2018-01-05:16-47-02-8803320.ddf67c101f58
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2018-09-05 23:30:53.000
EMAIL	varchar	Email address associated with the User Touchpoint.	person@adobe.com
SESSION_ID	varchar	Id for the Session which created the User Touchpoint.	2018-01-05:16-47-02-8803320.ddf67c101f58
CAMPAIGN_MEMBER_ID	varchar	Id for the Campaign Member which created the User Touchpoint.	00v0Z00001VTgv1QAD
CRM_ACTIVITY_ID	varchar	Id for the Activity which created the User Touchpoint.	1678625515
CRM_EVENT_ID	varchar	Id for the Event which created the User Touchpoint.	00U0Z00000pCZmyUAG
CRM_TASK_ID	varchar	TId for the Task which created the User Touchpoint.	00T0Z00004Qbd1jUAB
IMPRESSION_ID	varchar	Id for the Impression which created the User Touchpoint.	00T0Z00004Qbd1jUAB
IS_FIRST_KNOWN_TOUCH	boolean	Whether or not this touchpoint is treated as the first touch of the opportunity journey.	false
VISITOR_ID	varchar	The first cookie id of the related visitor id.	v_36ec805b4db344d6e92c972c86aee34a
TOUCHPOINT_DATE	timestamp_ntz	Date the User Touchpoint occured.	2018-01-05 16:47:02.000
MARKETING_TOUCH_TYPE	varchar	The type of activity, Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity. Referred to in the CRM as "Touchpoint Type."	Web Form
CHANNEL	varchar	The channel the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. Referred to in the CRM as "Marketing Channel - Path."	Social.LinkedIn
BROWSER_NAME	varchar	From the javascript and IP address, the detected browser that the user was on during the session.	Firefox
BROWSER_VERSION	varchar	From the javascript and IP address, the detected version of the browser that the user was on during the session.	33
PLATFORM_NAME	varchar	From the javascript and IP address, the detected platform that the user was on during the session.	Mac
PLATFORM_VERSION	varchar	From the javascript and IP address, the detected version of the platform that the user was on during the session.	10_12
LANDING_PAGE	varchar	The first landing page of the session which resulted in a touchpoint. Referred to in the CRM as "Landing Page".	https://www.adobe.com/blog/budget-and-planning-maturity-model-b2b-marketing
LANDING_PAGE_RAW	varchar	The first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. Referred to in the CRM as "Landing Page - Raw".	https://www.adobe.com/blog/budget-and-planning-maturity-model-b2b-marketing?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+ marketo+%maeasure%27s+Pipeline+Marketing+Blog%29
REFERRER_PAGE	varchar	Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".	https://www.google.com/
REFERRER_PAGE_RAW	varchar	Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".	https://www.google.com/
FORM_PAGE	varchar	The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. Referred to in the CRM as "Form URL".	http://info.adobe.com/adwords-for-lead-generation
FORM_PAGE_RAW	varchar	The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. A raw form page may contain query parameters in the URL. Referred to in the CRM as "Form URL - Raw".	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	Date the form submission occurred.	2015-06-03 17:49:10.000
CITY	varchar	From the javascript and IP address, the detected city the user was in during the session.	Oakland
REGION	varchar	From the javascript and IP address, the detected region the user was in during the session.	California
COUNTRY	varchar	From the javascript and IP address, the detected country the user was in during the session.	United States
MEDIUM	varchar	Used to define the medium which 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	Used to define the source which resulted in the touchpoint. This can be parsed out from the URL from utm_source, 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." Referred to in the CRM as "Touchpoint Source".	linkedin
SEARCH_PHRASE	varchar	The value which the user entered in the browser to search for and ended 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	Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.	Google
ACCOUNT_UNIQUE_ID	varchar	Id of the Ad Account in which the ad was resolved from.	aw.6601259029
ACCOUNT_NAME	varchar	Name of the Ad Account in which the ad was resolved from.	Marketo Measure Account
ADVERTISER_UNIQUE_ID	varchar	Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	300181641
ADVERTISER_NAME	varchar	Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Marketing Analytics
SITE_UNIQUE_ID	varchar	Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	1695651
SITE_NAME	varchar	Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	Quora.com
PLACEMENT_UNIQUE_ID	varchar	Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	120839827
PLACEMENT_NAME	varchar	Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.	roadblock
CAMPAIGN_UNIQUE_ID	varchar	Id of the Campaign from the Ad Account in which the Ad was resolved from.	aw.6601259029.208548635
CAMPAIGN_NAME	varchar	Name of the Campaign from the Ad Account in which the Ad was resolved from.	Brand
AD_GROUP_UNIQUE_ID	varchar	Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords.	aw.6601259029.208548635.16750166675
AD_GROUP_NAME	varchar	Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords.	Brand - Core
AD_UNIQUE_ID	varchar	Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	dc.6114.8882972.25272734.492579576
AD_NAME	varchar	Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).	Budget Webinar - sidebar
CREATIVE_UNIQUE_ID	varchar	Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	aw.6601259029.208548635.16750166675.195329631298
CREATIVE_NAME	varchar	Name of the Creative from the Ad Account in which the Ad was resolved from. 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, pulled from the Ad 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, pulled from the Ad 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, pulled from the Ad 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, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	adobe.com/demo
KEYWORD_UNIQUE_ID	varchar	Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).	aw.6601259029.208548635.16750166675.46267805426
KEYWORD_NAME	varchar	Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search)	[marketo]
KEYWORD_MATCH_TYPE	varchar	The type of match found between the search phrase and the purchased keyword.	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 touchpoint is deleted.	false
ROW_KEY	number(38,0)	Foreign Key to the Biz_Facts view.	-5269090762570690000
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	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

BIZ_WEB_HOST_MAPPINGS

Mapping table to map Marketo Measure Session Id to Adobe ECID and Munckin Id.

Column	Data Type	Description	Sample Data
ID	varchar	A unique Id for the mapping record.	0d643578c0c74753eff91abe668ed328\|2020-06-17:19:03:36\|0002\|0\|568668
COOKIE_ID	varchar	The Marketo Measure recorded cookie id.	0d643578c0c74753eff91abe668ed328
VISITOR_ID	varchar	The first cookie id of the related visitor id.	v_0d643578c0c74753eff91abe668ed328
SESSION_ID	varchar	The Marketo Measure Session id.	2018-08-06:01-35-24-1231230.9bc63c34482f
EVENT_DATE	timestamp_ntz	Date the mapping was recorded.	2020-06-17 19:03:36.000
MODIFIED_DATE	timestamp_ntz	Date the record was last modified.	2020-06-17 19:03:36.000
CURRENT_PAGE	varchar	URL of the Page View, without query parameters.	https://learn.atest.com/simplify-retention-starter-kit.html
CURRENT_PAGE_RAW	varchar	URL of the Page View, including any query parameters.	https://learn.atest.com/simplify-retention-starter-kit.html?x=nGfrBF&utm_medium=cpc&utm_source=intensify
IP_ADDRESS	varchar	The recorded IP address.	159.203.142.127
TYPE	varchar	Indicates the type of Event.	HostMapping
USER_AGENT_STRING	varchar	Device and browser recorded at the time of the Page View.	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36
CLIENT_SEQUENCE	varchar	Indicates the order in which the Page View occurred in the Session.	2
CLIENT_RANDOM	varchar	Used for internal auditing and processing.	566868
IS_DUPLICATED	boolean	Indicates if the record is considered a duplicate.	false
IS_PROCESSED	boolean	Used for internal processing.	true
MAPPING_TYPE	varchar	The type of Id which is mapped to the Marketo Measure cookie Id.	Adobe_OrgId_Ecid
MAPPING_ORD_ID	varchar	Adobe IMS Org Id.	8CC867C25245ADC30A490D4C
MAPPING_COOKIE_ID	varchar	Adobe ECID for the given Org Id.	09860926390077352923264316157493772857
_CREATED_DATE	timestamp_ntz	Date the record was created in Snowflake.	2020-01-01 01:01:00.000
_MODIFIED_DATE	timestamp_ntz	Date the record was last modified in Snowflake.	2020-01-01 01:01:00.000
_DELETED_DATE	timestamp_ntz	Date the record was marked as deleted in Snowflake.	2020-01-01 01:01:00.000

Sample Queries

How many Buyer Touchpoints (BTs) were there for each channel/subchannel last month?

--Note: This query can quickly be modified to show Buyer Attribution Touchpoint (BAT) counts by switching the biz_touchpoints table to the biz_attribution_touchpoints table.

select trim(split(ch.name,'.')[0])  as channel
      ,trim(split(ch.name,'.')[1])  as subchannel
      ,count(bt.id)                 as buyer_touchpoint_count
  from biz_user_touchpoints     ut
       left outer join
       biz_touchpoints          bt
        on bt.user_touchpoint_id    = ut.id
       and bt._deleted_date         is null
       left outer join
       biz_channels             ch
        on ut.channel               = ch.id
       and ch._deleted_date         is null
 where ut._deleted_date is null
   and ut.touchpoint_date between add_months(date_trunc(month,current_date),-1) and last_day(dateadd(month,-1,current_date))
group by 1,2

How much Attributed Revenue for each channel was closed in the past month, for the full path attribution model?

--Note: This query does not perform any currency conversion.  If your data contains multiple currencies, you will need to add in logic to perform the conversion to the desired currency using the biz_conversion_rates table.

select trim(split(ch.name,'.')[0])  as channel
      ,sum(opp.amount*(bat.full_path_percentage/100))   as attributed_revenue
  from biz_user_touchpoints         ut
       inner join
       biz_attribution_touchpoints  bat
        on bat.user_touchpoint_id   = ut.id
       and bat._deleted_date        is null
       inner join
       biz_opportunities            opp
        on bat.opportunity_id       = opp.id
       and opp._deleted_date        is null
       and opp.is_closed            = true
       and opp.is_won               = true
       and opp.close_date between add_months(date_trunc(month,current_date),-1) and last_day(dateadd(month,-1,current_date))
       left outer join
       biz_channels                 ch
        on ut.channel               = ch.id
       and ch._deleted_date         is null
 where ut._deleted_date is null
group by 1

What is the entire journey for one person? (Show all Touchpoints for a single email address.)

select ut.touchpoint_date
      ,ut.marketing_touch_type
      ,listagg(distinct ifnull(sdl.stage_name,sdo.stage_name),',')           as touchpoint_position
  from biz_user_touchpoints         ut
       left outer join
       biz_touchpoints              bt
        on bt.user_touchpoint_id    = ut.id
       and bt._deleted_date         is null
       left outer join
       biz_attribution_touchpoints  bat
        on bat.user_touchpoint_id   = ut.id
       and bat._deleted_date        is null
       left outer join
       biz_lead_stage_transitions   lst
        on lst.touchpoint_id        = bt.id
       and lst._deleted_date        is null
       and lst.is_pending           = false
       and lst.is_non_transitional  = false
       left outer join
       biz_stage_definitions        sdl
        on lst.stage_id             = sdl.id
       and sdl._deleted_date        is null
       left outer join
       biz_opp_stage_transitions    ost
        on ost.touchpoint_id        = bat.id
       and ost._deleted_date        is null
       and ost.is_pending           = false
       and ost.is_non_transitional  = false
       left outer join
       biz_stage_definitions        sdo
        on ost.stage_id             = sdo.id
       and sdo._deleted_date        is null
 where ut._deleted_date     is null
   and ut.email             = [email address]
group by 1,2
order by 1

Show all Buyer Attribution Touchpoints (BATs) and their Attributed Revenue for a single opportunity.