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.
Accounts imported from the source system.
Mapping table between known Lead/Contact email addresses and Accounts. This table will be empty if ABM is disabled.
Activities imported from a source system or connected Ad Account.
Ads imported from any connected Ad Account.
Advertisers imported from any connected Ad Account.
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
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
Ad Forms imported from any connected Ad Account.
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
Ad Providers from any connected Ad Account, including an entry for self reported if applicable.
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_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
Data generated from the Attribution AI integration. These fields are only populated for Marketo Measure Ultimate customers.
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
Marketing Channels, as created in the Marketo Measure application.
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
∗ JOB_TITLE
varchar
Job Title of the Contact.
CEO, Vice President
Currency conversion rates imported from the source system.
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_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
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
Events imported from the source system. This table will be empty if Activities Sync is disabled.
Tasks imported from the source system. This table will populate if Activities Sync OR Call Tracking are enabled.
Table of all ISO currencies.
AB Tests recorded. This table will be empty if AB Tests are not enabled.
Web events that have been recorded using custom events in the Javascript. This table will be empty if Marketo Measure Events are not enabled.
Landing Pages downloaded from any connected Ad Account.
Mapping table for email addresses and visitor ids.
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
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
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
Expected to be null since the field is obsolete.
NULL
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_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
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
Landing Pages imported from any connected Ad Account.
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
Stage transitions for Leads or Contacts.
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
∗ OPPORTUNITY_TYPE
varchar
Type of Opportunity, such as New Business, Renewal, etc.
Renewal, Prospect
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
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
Table that stores all placements downloaded from any connected ads accounts, an object from the Doubleclick integration.
Segment values as defined in the Marketo Measure application.
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.)
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
Expected to be null since the field is obsolete.
NULL
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_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
Sites imported from any connected Ad Account.
Sites Links from any connected Ads Account.
List of stages as imported or defined in the Marketo Measure application.
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_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
Aggregation of URLs from landing pages, referrer pages, and page views.
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_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
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