Data Warehouse Schema data-warehouse-schema

Data Warehouse allows you to track as much as you want, report on your attribution data wherever you want, and plug it in to other data sets.

IMPORTANT
  • Rows with a value for _DELETED_DATE will be retained for 7 days, then removed from Snowflake.
  • The time zones used in Snowflake adhere to Coordinated Universal Time (UTC).
NOTE
Click here to see sample queries at the bottom of this article.

Entity Relationship Diagrams entity-relationship-diagrams

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

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

Click an image for its full-size version

Data Warehouse Data Model
Ads Dimensional Data Model

Views views

BIZ_ACCOUNTS biz-accounts

Accounts imported from the source system.

Column
Data Type
Description
Sample Data
ID
varchar
The Account Id from the source system.
0013100001kpAZxAAM
CREATED_DATE
timestamp_ntz
The created date of the Account, from the source system.
2016-08-28 00:32:55.000
MODIFIED_DATE
timestamp_ntz
The last modified date of the Account, from the source system.
2018-08-01 17:38:30.000
NAME
varchar
The Account Name, from the source system.
Marketo Measure
WEB_SITE
varchar
Website for the Account, as recorded in the source system, used for Lead to Account mapping.
www.adobe.com
ENGAGEMENT_RATING
varchar
A letter grade (A, B, C, D, N/A) that is generated from the Marketo Measure Machine Learning model. This will be null if ABM is disabled.
B
ENGAGEMENT_SCORE
number(38,19)
A numerical score calculated by Marketo Measure Machine Learning to generate the Predictive Engagement Score (Engagement_Rating). This will be null if ABM is disabled.
0.1417350147058800000
DOMAIN
varchar
The parsed down version of the website, only storing the domain.
adobe
IS_DELETED
boolean
Whether or not the record is deleted in the source system.
false
CUSTOM_PROPERTIES
varchar
Custom properties that Marketo Measure has imported from the source system, in JSON format.
{"Account_Type__c": "Security", "Foo":"Bar"}
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000
INDUSTRY
varchar
Primary business of the Account.
Retail, Telecommunication
COUNTRY
varchar
Country portion of the Account's address.
USA, Canada

Only available in Marketo Measure Ultimate

BIZ_ACCOUNT_TO_EMAILS biz-account-to-emails

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

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

BIZ_ACTIVITIES biz-activities

Activities imported from a source system or connected Ad Account.

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

BIZ_ADS biz-ads

Ads imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Ad.
fb.106851586409075.6052044288804.6052044290004.6053457066804
DISPLAY_ID
varchar
The Ad Id from the source system.
6053457066804
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Ad was imported.
fb.106851586409075
AD_ACCOUNT_NAME
varchar
Name of the Ad Account from which the Ad was imported.
Marketo Measure Account
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser for the Ad, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
Name of the Advertiser for the Ad, specifically for Doubleclick.
Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
Id of the Ad Group for the Ad.
fb.106851586409075.6052044288804.6052044290004
AD_GROUP_NAME
varchar
Name of the Ad Group for the Ad.
Ad Set for Ad B
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the Ad.
fb.106851586409075.6052044288804
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the Ad.
Lead generation Campaign
IS_ACTIVE
boolean
Whether or not the Ad is still active in the source system.
false
IS_DELETED
boolean
Whether or not the Ad has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:35:59.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:35:59.000
NAME
varchar
Name of the Ad, from the source system.
Ad 2
NEEDS_UPDATE
boolean

Whether or not the Ad needs to be updated for Marketo Measure tagging.

(Diagnostic field, used by internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, used for internal processing.
fb.106851586409075.6052044288804.6052044290004
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Ad".
Ad
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Ad.
Facebook
URL_CURRENT
varchar

The URL for the landing page.

(Diagnostic field, for internal processing.)

URL_OLD
varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED
varchar

What the URL will be decorated with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

URL_ALTENATIVES
varchar

Imported from the source system.

(Diagnostic field, for internal processing.)

ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
6008900572523230000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_ADVERTISERS biz-advertisers

Advertisers imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Advertiser.
dc.6114.9143143
DISPLAY_ID
varchar
The Advertiser Id from the source system.
9143143
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Ad was imported.
fb.106851586409075
AD_ACCOUNT_NAME
varchar
Name of the Ad Account from which the Ad was imported.
Marketo Measure Account
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
Name of the Advertiser, specifically for Doubleclick.
Marketo Measure Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
Expected to be null since there is no Ad Group above the Advertiser in any ads hierarchy.
null
AD_GROUP_NAME
varchar
Expected to be null since there is no Ad Group above the Advertiser in any ads hierarchy.
null
AD_CAMPAIGN_UNIQUE_ID
varchar
Expected to be null since there is no Ad Campaign above the Advertiser in any ads hierarchy.
null
AD_CAMPAIGN_NAME
varchar
Expected to be null since there is no Campaign above the Ad Advertiser in any ads hierarchy.
null
IS_ACTIVE
boolean
Whether or not the Advertiser is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Advertiser has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:35:59.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:35:59.000
NAME
varchar
Name of the Advertiser, from the source system.
Marketo Measure Marketing Analytics
NEEDS_UPDATE
boolean

Whether or not the Advertiser needs to be updated for Marketo Measure tagging.

(Diagnostic field, used by internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, used for internal processing.
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Advertiser".
Advertiser
PROVIDER_TYPE
varchar
The Ad Provider for the Advertiser.
Doubleclick
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
6008900572523230000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_AD_ACCOUNTS biz-ad-accounts

Ad Accounts imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique identifier for the Ad Account.
aw.6601259029
DISPLAY_ID
varchar
The Ad Account Id from the source system.
6601259029
AD_ACCOUNT_UNIQUE_ID
varchar
Expected to be null since this is the record for the Ad Accounts in the ads hierarchy.
null
AD_ACCOUNT_NAME
varchar
Expected to be null since this is the record for the Ad Accounts in the ads hierarchy.
null
ADVERTISER_UNIQUE_ID
varchar
Expected to be null since there is no Advertiser above the Ad Accounts in any ads hierarchy.
null
ADVERTISER_NAME
varchar
Expected to be null since there is no Advertiser above the Ad Accounts in any ads hierarchy.
null
AD_GROUP_UNIQUE_ID
varchar
Expected to be null since there is no Ad Group above the Ad Accounts in any ads hierarchy.
null
AD_GROUP_NAME
varchar
Expected to be null since there is no Ad Group above the Ad Accounts in any ads hierarchy.
null
AD_CAMPAIGN_UNIQUE_ID
varchar
Expected to be null since there is no Ad Campaign above the Ad Accounts in any ads hierarchy.
null
AD_CAMPAIGN_NAME
varchar
Expected to be null since there is no Ad Campaign above the Ad Accounts in any ads hierarchy.
null
IS_ACTIVE
boolean
Whether or not the Ad Account is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Ad Account has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-09-06 12:54:37.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:35:58.000
NAME
varchar
Name of the Ad Account, from the source system.
Marketo Measure Ad Account
NEEDS_UPDATE
boolean

Whether or not the Advertiser needs to be updated for Marketo Measure tagging.

(Diagnostic field, used by internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, used for internal processing.
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Account".
Account
PROVIDER_TYPE
varchar
The name of the Ad Provider for the Ad Account.
AdWords
ACCOUNT_CURRENCY_UNIT
varchar
The currency code used for the Ad Account, from the source system.
USD
COMPANY_ID
varchar
Used for internal processing.
1933789
SOURCE
varchar
Parsed from the URL from utm_source.
Social
MEDIUM
varchar
Parsed from the URL from utm_medium.
lisu07261601
LAST_30_DAYS_COST
number(38,19)
The amount of spend imported for the last 30 days, only applicable to AdWords.
17260.000000000000000000
LAST_30_DAYS_IMPRESSIONS
number(38,0)
The number of impressions from the last 30 days, only applicable to AdWords.
730060
LAST_30_DAYS_CLICKS
number(38,0)
The number of clicks from the last 30 days, only applicable to AdWords.
3400
LAST_30_DAYS_CONVERSIONS
number(38,0)
The number of conversions reported from the last 30 days, only applicable to AdWords.
180
TRACKING_URL_TEMPLATE
varchar
Used for internal diagnostics.
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
TRACKING_URL_TEMPLATE_OLD
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_APPLIED
varchar
The tracking template added on the Ad Account level for AdWords or Bing for tagging landing pages.
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
-4609512587744160000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_AD_CAMPAIGNS biz-ad-campaigns

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

Column
Data Type
Description
Sample Data
ID
varchar
Unique Id for the Campaign.
aw.6601259029.285114995
DISPLAY_ID
varchar
The Campaign Id from the source system.
285114995
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Campaign was imported.
aw.6601259029
AD_ACCOUNT_NAME
varchar
Name for the Ad Account from which the Campaign was imported.
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser for the Campaign, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
Name of the Advertiser for the Campaign, specifically for Doubleclick.
Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
Expected to be null since there is no Ad Group above the Campaign in any ads hierarchy.
null
AD_GROUP_NAME
varchar
Expected to be null since there is no Ad Group above the Campaign in any ads hierarchy.
null
AD_CAMPAIGN_UNIQUE_ID
varchar
Unique Id for the Campaign, use the Id field instead.
AD_CAMPAIGN_NAME
varchar
Name of the Campaign, use the Name field instead.
IS_ACTIVE
boolean
Whether or not the Campaign is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Campaign has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:35:58.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:35:58.000
NAME
varchar
Name of the Campaign.
Partner Retargeting
NEEDS_UPDATE
boolean

Whether or not the Campaign needs to be updated for Marketo Measure tagging.

(Diagnostic field, used by internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, used for internal processing.
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Campaign".
Campaign
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Campaign.
AdWords
DAILY_BUDGET
number(38,19)
The daily budget that's set in the Ad Platform for the Campaign.
0.0000000000000000000
TRACKING_URL_TEMPLATE
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_OLD
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_APPLIED
varchar
The tracking template added on the Campaign level for AdWords or Bing for tagging landing pages.
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
-6008900572523230000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_AD_FORMS biz-ad-forms

Ad Forms imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Ad Form.
li.507063119.3757704
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Ad Form was imported.
li.507063119
AD_ACCOUNT_NAME
varchar
Name of the Ad Account from which the Ad Form was imported.
Marketo Measure
IS_DELETED
boolean
Deleted status from the source system. Set to deleted if the status is Draft, Archived, or Canceled.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:35:58.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:35:58.000
NAME
varchar
Name of the Ad Form.
NSPA Ebook LGF (May 2020)
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "AdForm".
AdForm
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Ad Form.
LinkedIn
DESCRIPTION
varchar
Description of the Ad Form.
Learn how intelligent automation can increase process efficiency in mortgage refinance loan applications.
HEADLINE
varchar
Headline of the Ad Form.
It's Time to Automate the Refinancing Application Process
LANDING_URL
varchar
Landing URL of the Ad Form.
https://adobe.com/blog/refinancing-application-process/
QUESTIONS
varchar
List of Questions for the Ad Form.
First name:Last name:Email address:Country/Region:Job title:Company name
STATUS
varchar
Status of the Ad Form.
submitted
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000
SOURCE_ID
varchar
Id for the Source from which the record originated.
aw.3284209

BIZ_AD_GROUPS biz-ad-groups

Ad Groups imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Ad Group.
aw.6601259029.317737955.23105326115
DISPLAY_ID
varchar
The Ad Group Id from the source system.
23105326115
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Ad Group was imported.
aw.6601259029
AD_ACCOUNT_NAME
varchar
Name for the Ad Account from which the Ad Group was imported.
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
Expected to be null since there is no Ad Group in the Doubleclick ads hierarchy.
null
ADVERTISER_NAME
varchar
Expected to be null since there is no Ad Group in the Doubleclick ads hierarchy.
null
AD_GROUP_UNIQUE_ID
varchar
Expected to be null since this is the record for the Ad Group in the hierarchy.
null
AD_GROUP_NAME
varchar
Expected to be null since this is the record for the Ad Group in the hierarchy.
null
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the Ad Group.
aw.6601259029.317737955
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the Ad Group.
Revenue Attribution
IS_ACTIVE
boolean
Whether or not the Ad Account is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Ad Account has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:36:14.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:36:14.000
NAME
varchar
Name of the Ad Group.
Revenue Attribution - Account Based
NEEDS_UPDATE
boolean

Whether or not the Advertiser needs to be updated for Marketo Measure tagging.

(Diagnostic field, used by internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, used for internal processing.
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "AdGroup".
AdGroup
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Ad Group.
AdWords
AD_NETWORK_TYPE
varchar
The medium(s) that the Ad Group is running on.
Search, Display, YouTube_Search, YouTube_Watch
TRACKING_URL_TEMPLATE
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_OLD
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_APPLIED
varchar
The tracking template added on the Ad Account level for AdWords or Bing for tagging landing pages.
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
-5594512713562690000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_AD_PROVIDERS

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

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

BIZ_ATTRIBUTION_TOUCHPOINTS biz-attribution-touchpoints

Buyer Attribution Touchpoints, all touchpoints associated with an Opportunity.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Buyer Attribution Touchpoint (BAT).

BAT2_0060Z00000lFHtOQAW_

0030Z00003K5bpKQAR_2017-06-20:01-05-20-6193330.0b5c5678807c

MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-09-01 04:53:53.000
OPPORTUNITY_ID
varchar
Id for the Opportunity the BAT is attributed to.
0060Z00000lFHtOQAW
CONTACT_ID
varchar
Id for the Contact associated with the BAT.
0030Z00003K5bpKQAR
EMAIL
varchar
Email address associated with the BAT.
person@adobe.com
ACCOUNT_ID
varchar
Id for the Account the BAT is attributed to.
0013100001otbIAAAY
USER_TOUCHPOINT_ID
varchar
Id for the User Touchpoint which generated the BAT.
person@adobe.com_00v1B00003ZbWzHQAV
TOUCHPOINT_DATE
timestamp_ntz
Date of the touchpoint.
2017-06-20 01:05:20.000
VISITOR_ID
varchar
Id for the visitor associated with the BAT.
v_277d79d01678498fea067c9b631bf6df
MARKETING_TOUCH_TYPE
varchar
The type of activity, Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity. Referred to in the CRM as "Touchpoint Type."
Web Form
CHANNEL
varchar
The channel the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. Referred to in the CRM as "Marketing Channel - Path."
Social.LinkedIn
CATEGORY1
varchar
The segment value for the 1st Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
ABC
CATEGORY2
varchar
The segment value for the 2nd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
Yes
CATEGORY3
varchar
The segment value for the 3rd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
SMB
CATEGORY4
varchar
The segment value for the 4th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
New Business
CATEGORY5
varchar
The segment value for the 5th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY6
varchar
The segment value for the 6th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY7
varchar
The segment value for the 7th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY8
varchar
The segment value for the 8th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY9
varchar
The segment value for the 9th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY10
varchar
The segment value for the 10th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY11
varchar
The segment value for the 11th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY12
varchar
The segment value for the 12th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY13
varchar
The segment value for the 13th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY14
varchar
The segment value for the 14th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
CATEGORY15
varchar
The segment value for the 15th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."
BROWSER_NAME
varchar
From the javascript and IP address, the detected browser that the user was on during the session.
Chrome
BROWSER_VERSION
varchar
From the javascript and IP address, the detected version of the browser that the user was on during the session.
58
PLATFORM_NAME
varchar
From the javascript and IP address, the detected platform that the user was on during the session.
Mac
PLATFORM_VERSION
varchar
From the javascript and IP address, the detected version of the platform that the user was on during the session.
10_12
LANDING_PAGE
varchar
The first landing page of the session which resulted in a touchpoint. Referred to in the CRM as "Landing Page".
http://www.adobe.com/blog/uncover- truth-behind-cost-per-lead
LANDING_PAGE_RAW
varchar
The first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. Referred to in the CRM as "Landing Page - Raw".
http://www.adobe.com/blog/uncover-truth -behind-cost-per-lead?utm_content=27322869&utm_ medium=social&utm_source=linkedin
REFERRER_PAGE
varchar
Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".
https://www.linkedin.com/
REFERRER_PAGE_RAW
varchar
Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".
https://www.linkedin.com/
FORM_PAGE
varchar
The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. Referred to in the CRM as "Form URL".
http://info.adobe.com/intro-guide-b2b-marketing-attribution
FORM_PAGE_RAW
varchar
The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. A raw form page may contain query parameters in the URL. Referred to in the CRM as "Form URL - Raw".
http://info.adobe.com/intro-guide-b2b-marketing-attribution
FORM_DATE
timestamp_ntz
Date the form submission occurred.
2017-06-20 01:06:41.000
CITY
varchar
From the javascript and IP address, the detected city the user was in during the session.
San Francisco
REGION
varchar
From the javascript and IP address, the detected region the user was in during the session.
California
COUNTRY
varchar
From the javascript and IP address, the detected country the user was in during the session.
United States
MEDIUM
varchar
Used to define the medium which resulted in the touchpoint. This can either be parsed out from the URL from utm_medium. Or, if Marketo Measure is able to resolve an ad, it may be values such as "cpc" or "display."
social
WEB_SOURCE
varchar
Used to define the source which resulted in the touchpoint. This can be parsed out from the URL from utm_source, generically set as "CRM Campaign" if it was synced from the CRM, or if Marketo Measure is able to resolve an ad, it may be values such as "Google AdWords" or "Facebook." Referred to in the CRM as "Touchpoint Source".
linkedin
SEARCH_PHRASE
varchar
The value which the user entered in the browser to search for and ended up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform.
google Marketo Measure
AD_PROVIDER
varchar
Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.
Google
ACCOUNT_UNIQUE_ID
varchar
Id of the Ad Account in which the ad was resolved from.
aw.6601259029
ACCOUNT_NAME
varchar
Name of the Ad Account in which the ad was resolved from.
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.
300181641
ADVERTISER_NAME
varchar
Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.
Marketo Measure Marketing Analytics
SITE_UNIQUE_ID
varchar
Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.
1695651
SITE_NAME
varchar
Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.
Quora.com
PLACEMENT_UNIQUE_ID
varchar
Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.
120839827
PLACEMENT_NAME
varchar
Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.
roadblock
CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign from the Ad Account in which the Ad was resolved from.
aw.6601259029.317738075
CAMPAIGN_NAME
varchar
Name of the Campaign from the Ad Account in which the Ad was resolved from.
Marketing Attribution
AD_GROUP_UNIQUE_ID
varchar
Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords.
aw.6601259029.317738075.23105327435
AD_GROUP_NAME
varchar
Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords.
Marketing Attribution - General
AD_UNIQUE_ID
varchar
Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).
dc.6114.8882972.25272734.492579576
AD_NAME
varchar
Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).
Budget Webinar - sidebar
CREATIVE_UNIQUE_ID
varchar
Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).
aw.6601259029.317738075.23105327435.182716179597
CREATIVE_NAME
varchar
Name of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).
B2B Marketing Attribution
CREATIVE_DESCRIPTION_1
varchar
The first line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).
Download The CMOs Guide
CREATIVE_DESCRIPTION_2
varchar
The second line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).
Learn how attribution measures ROI by connecting marketing activities to revenue
CREATIVE_DESTINATION_URL
varchar
The landing page that clicks through from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).
http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution
CREATIVE_DISPLAY_URL
varchar
The friendly URL name that's shown on the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).
http://info.adobe.com/CMOs-Guide
KEYWORD_UNIQUE_ID
varchar
Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).
aw.6601259029.317738075.23105327435.4838421670
KEYWORD_NAME
varchar
Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search)
"marketing attribution"
KEYWORD_MATCH_TYPE
varchar
The type of match found between the search phrase and the purchased keyword.
Exact
IS_FIRST_TOUCH
boolean
Whether or not this touchpoint is treated as the first touch of the opportunity journey.
false
IS_LEAD_CREATION_TOUCH
boolean
Whether or not this touchpoint is treated as the lead creation touch of the opportunity journey.
false
IS_OPP_CREATION_TOUCH
boolean
Whether or not this touchpoint is treated as the opportunity creation touch of the opportunity journey.
false
IS_CLOSED_TOUCH
boolean
Whether or not this touchpoint is treated as the closed touch of the opportunity journey.
false
STAGES_TOUCHED
varchar
This field has been deprecated. Use the Stage_Transitions tables for stage information.
null
IS_FORM_SUBMISSION_TOUCH
boolean
Whether or not this touchpoint had a form fill during the session.
true
IS_IMPRESSION_TOUCH
boolean
Whether or not this touchpoint is treated as the first impression touch of the opportunity journey
false
FIRST_CLICK_PERCENTAGE
number(22,19)
The calculated percentage allocated to this touchpoint because it's a first touch (See Is_First_Touch).
0.0000000000000000000
LAST_ANON_CLICK_PERCENTAGE
number(22,19)
The calculated percentage allocated to this touchpoint because it's a lead creation touch (See Is_Lead_Creation_Touch).
0.0000000000000000000
U_SHAPE_PERCENTAGE
number(22,19)
The calculated percentage allocated to this touchpoint because it's part of a u-shaped touch (See Is_First_Touch and Is_Lead_Creation_Touch).
0.0000000000000000000
W_SHAPE_PERCENTAGE
number(22,19)
The calculated percentage allocated to this touchpoint because it's part of a w-shaped touch (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch).
0.0153374234214425
FULL_PATH_PERCENTAGE
number(22,19)
The calculated percentage allocated to this touchpoint because it's part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch).
0.0143061513081193
CUSTOM_MODEL_PERCENTAGE
number(22,19)
The calculated percentage allocated to this touchpoint because it's part of a custom model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch).
0.0143061513081193
IS_DELETED
boolean
Whether this touchpoint is deleted.
false
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
-2712935512233520000
OPPORTUNITY_ROW_KEY
number(38,0)
LANDING_PAGE_KEY
number(38,0)
REFERRER_PAGE_KEY
number(38,0)
FORM_PAGE_KEY
number(38,0)
ACCOUNT_ROW_KEY
number(38,0)
ADVERTISER_ROW_KEY
number(38,0)
SITE_ROW_KEY
number(38,0)
PLACEMENT_ROW_KEY
number(38,0)
CAMPAIGN_ROW_KEY
number(38,0)
AD_ROW_KEY
number(38,0)
AD_GROUP_ROW_KEY
number(38,0)
CREATIVE_ROW_KEY
number(38,0)
KEYWORD_ROW_KEY
number(38,0)
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_ATTRIBUTION_AI_TOUCHPOINTS biz-attribution-ai-touchpoints

Data generated from the Attribution AI integration. These fields are only populated for Marketo Measure Ultimate customers.

Column
Data Type
Description
Sample Data
CONVERSION_DATE
Timestamp_ntz
date of the conversion
2020-01-01 01:01:00.000
CONVERSION_NAME
varchar
name of the conversion event (as specified by the customer in the UI setting)
CONVERSION_ID
varchar
id for the conversion event (this is the original unique id value sent with the event data record in the source dataset)
0013100001b44aGAAQ
CONVERSION_EVENT_ID
varchar
original MM event id for the conversion event
maps to a user touchpoint or a stage transition
00U0Z00000pCZmyUAG
CONVERSION_ACCOUNT_ID
varchar
original MM account id for the conversion event
0013100001kpAZxAAM
CONVERSION_OPPORTUNITY_ID
varchar
original MM opportunity id for the conversion event
0060Z00000lFHtOQAW
CONVERSION_LEAD_ID
varchar
original MM lead id for the conversion event
likely to be null most of the time
00Q0Z000013dw4GUAQ
CONVERSION_CONTACT_ID
varchar
original MM contact id for the conversion event
likely to be null most of the time
00331000032hMxRAAU
CONVERSION_EVENT_TYPE
varchar
type of conversion event (b2b = lead conversion, b2c = opportunity conversion)
b2b
SCORE_DATE
Timestamp_ntz
date the touchpoints were last scored
2020-01-01 01:01:00.000
INFLUENCED_PERCENT
number(38,35)
the fraction of the conversion that each touchpoint is responsible for
0.10
INCREMENTAL_PERCENT
number(38,35)
the amount of marginal impact directly caused by a touchpoint
0.25
TOUCHPOINT_DATE
Timestamp_ntz
the touchpoint or stage transition date
2020-01-01 01:01:00.000
TOUCHPOINT_EVENT_ID
varchar
id for the event which generated the touchpoint
00U3100000VLUnEEAX
TOUCHPOINT_OPPORTUNITY_ID
varchar
id for the opportunity associated with the touchpoint
0060Z00000lFHtOQAW
TOUCHPOINT_ACCOUNT_ID
varchar
id for the account associated with the touchpoint
0013100001kpAZxAAM
TOUCHPOINT_LEAD_ID
varchar
id for the lead associated with the touchpoint
00Q0Z000013dw4GUAQ
TOUCHPOINT_CONTACT_ID
varchar
id for the contact associated with the touchpoint
00331000032hMxRAAU
COUNT_TO_CONVERSION
number(38,0)
the rank or ordinal value of the touchpoint in the chain leading to the conversion event
10000
AAI_SOURCE_ID
varchar
foreign key to the attribution ai sources table
_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 deleted in Snowflake
2020-01-01 01:01:00.000

BIZ_CAMPAIGN_MEMBERS biz-campaign-members

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

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

BIZ_CHANNELS biz-channels

Marketing Channels, as created in the Marketo Measure application.

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

BIZ_CONTACTS biz-contacts

Contacts imported from the source system.

Column
Data Type
Description
Sample Data
ID
varchar
The Contact Id from the source system.
0030Z00003OzioeQAB
MODIFIED_DATE
timestamp_ntz
Date the Contact record was last modified, from the source system.
2018-09-05 05:17:53.000
CREATED_DATE
timestamp_ntz
Date the Contact record was created, from the source system.
2018-09-05 05:17:51.000
EMAIL
varchar
Email address of the Contact, from the source system.
persona@adobe.com
ACCOUNTID
varchar
Id of the Account related to the Contact.
0013100001b44aGAAQ
LEAD_SOURCE
varchar
Source in which the Lead was created.
Advertisement
BIZIBLE_STAGE
varchar
Current stage of the Contact, recognized as a custom stage which can be created in the Marketo Measure application.
Demo Scheduled
BIZIBLE_STAGE_PREVIOUS
varchar
All previous stages for the Contact, recognized as custom stages which can be created in the Marketo Measure application.
Open - Contact
ODDS_OF_CONVERSION
number(38,19)
This feature has been deprecated. 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

Only available in Marketo Measure Ultimate

BIZ_CONVERSION_RATES biz-conversion-rates

Currency conversion rates imported from the source system.

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

BIZ_COSTS biz-costs

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

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

BIZ_CREATIVES biz-creatives

Creatives imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Creative.
ba.3284209.132855866.4556709270.10426699711
DISPLAY_ID
varchar
The Creative Id from the source system.
10426699711
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Creative was imported.
fb.106851586409075
AD_ACCOUNT_NAME
varchar
Name for the Ad Account from which the Creative was imported.
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser for the Creative, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
Name of the Advertiser for the Creative, specifically for Doubleclick.
Marketo Measure Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
Id of the Ad Group for the Creative.
fb.106851586409075.6052044288804.6052044290004
AD_GROUP_NAME
varchar
Name of the Ad Group for the Creative.
Ad Set for Ad B
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the Creative.
ba.3284209.132855866
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the Creative.
PipelineMarketing.com
IS_ACTIVE
boolean
Whether or not the Creative is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Creative has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:36:25.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:36:25.000
NAME
varchar
Name of the Creative, from the source system.
PipelineMarketing.com
NEEDS_UPDATE
boolean

Whether or not the Creative needs to be updated for Marketo Measure tagging.

(Diagnostic field, used by internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, for internal processing.
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Creative".
Creative
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Creative.
BingAds
URL_CURRENT
varchar

The current version of the URL including all tags.

(Diagnostic field, for internal processing.)

cdn.adobe.com/redir?lp=http%3a%2f%2fwww.pipelinemarketing.com%2f&_bt={creative}&_bk={keyword}&_bm={matchType}&utm_content={adid}&utm_term={keyword}&utm_campaign=PipelineMarketing.com&utm_source=bing&utm_medium=cpc
URL_DISPLAY
varchar
The shortened and friendly URL that's displayed on the Creative.
PipelineMarketing.com
URL_OLD
varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED
varchar

What the URL will be decorated with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

URL_SHORTENED
varchar
The shortened and friendly URL that's displayed on the Creative. (Used for LinkedIn Ads only.)
AD_TYPE
varchar
The type of Creative, which could be Text or Display
Text
IS_UPGRADED_URL
boolean
Whether or not the creative is using Upgraded URLs.
false
HEADLINE
varchar
The top line (headline) of the creative
PipelineMarketing.com
DESCRIPTION_LINE_1
varchar
The copy from the first line of the creative
Connect & Learn From Revenue-Driven B2B Marketers. Join the Community.
DESCRIPTION_LINE_2
varchar
The copy from the second line of the creative
Have You Used Analytics? Leave a Review Today!
TRACKING_URL_TEMPLATE
varchar
Diagnostics field, for internal processing.
TRACKING_URL_TEMPLATE_OLD
varchar
Diagnostics field, for internal processing.
TRACKING_URL_TEMPLATE_REQUESTED
varchar
Diagnostics field, for internal processing.
TRACKING_URL_TEMPLATE_APPLIED
varchar
Diagnostics field, for internal processing.
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
SHARE_URN
varchar
The share Id. (Used for LinkedIn Ads only.)
urn:li:share:6376987561897848832
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
6008900572523230000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_CRM_EVENTS biz-crm-events

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

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

BIZ_CRM_TASKS biz-crm-tasks

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

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

BIZ_CURRENCIES biz-currencies

Table of all ISO currencies.

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

BIZ_CUSTOMER_AB_TESTS biz-customer-ab-tests

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

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

BIZ_CUSTOMER_EVENTS biz-customer-events

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

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

BIZ_CUSTOM_LANDING_PAGES biz-custom-landing-pages

Landing Pages downloaded from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the record.
DISPLAY_ID
varchar
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the landing page was imported.
AD_ACCOUNT_NAME
varchar
Name of the Ad Account from which the landing page was imported
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser for the landing page, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
Name of the Advertiser for the landing page, specifically for Doubleclick.
Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
Id of the Ad Group for the landing page.
AD_GROUP_NAME
varchar
Name of the Ad Group for the landing page.
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the landing page.
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the landing page.
IS_ACTIVE
boolean
IS_DELETED
boolean
MODIFIED_DATE
timestamp_ntz
The last modified date of the row
FIRST_IMPORTED
timestamp_ntz
NAME
varchar
NEEDS_UPDATE
boolean
GROUPING_KEY
varchar
ENTITY_TYPE
varchar
PROVIDER_TYPE
varchar
AD_DISPLAY_ID
varchar
CREATIVE_DISPLAY_ID
varchar
URL_CURRENT
varchar
URL_OLD
varchar
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_EMAIL_TO_VISITOR_IDS biz-email-to-visitor-ids

Mapping table for email addresses and visitor ids.

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

BIZ_FACTS biz-facts

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

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

BIZ_FORM_SUBMITS biz-forms-submits

Captured Form Submissions.

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

BIZ_IMPRESSIONS biz-impressions

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

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Impression.
6acd7b43290490fe5c53eed31281d09a|2020-05-18:22:20:59|0000|0|2869369052
COOKIE_ID
varchar
The recorded cookie id at the time of the Impression.
08c1063cb0a64349ad0d2d862f5cc700
VISITOR_ID
varchar
The first cookie id of the related visitor id.
v_08c1063cb0a64349ad0d2d862f5cc700
SESSION_ID
varchar
The recorded Session Id at the time the Impression was logged.
2018-08-06:01-35-24-1231230.9bc63c34482f
EVENT_DATE
timestamp_ntz
Date the Impression was served.
2020-01-01 01:01:00.000
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2020-01-01 01:01:00.000
CURRENT_PAGE
varchar
URL where the Impression was served, without query parameters.
https://info.adobe.com/webinar-marketo-measure-impact
CURRENT_PAGE_RAW
varchar
URL where the Impression was served, including any query parameters.
https://info.adobe.com/webinar-marketo-measure-impact?utm_source=partner&mkt_tok=eyJpIjoiTnpBeE1EVml PV0UyWlRObSIsInQiOiI3MEFIek04ZVJiWm9renc1Z29RXC9kXC92YkxycFRYclE0MVhOaH Nwdml3YTZBZDdPdXh4Q0RmcnBJWXhwZTF1Z0RrbXlDVmxJNzIwNkhW
IP_ADDRESS
varchar
The recorded IP address at the time of the Impression.
174.127.184.158
TYPE
varchar
Indicates the type of Event.
Impression
USER_AGENT_STRING
varchar
Device and browser recorded at the time of the Form Submit.
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1.2 Safari/605.1.15
CLIENT_SEQUENCE
varchar
Indicates the order in which the Page View occurred in the Session.
4
CLIENT_RANDOM
varchar
Used for internal auditing and processing.
20042b6b7af44512b43f6244d86faf4c
IS_DUPLICATED
boolean
Indicates if the record is considered a duplicate.
false
IS_PROCESSED
boolean
Used for internal processing.
true
REFERRER_PAGE
varchar
Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".
https://www.linkedin.com/
REFERRER_PAGE-RAW
varchar
Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".
https://www.linkedin.com/
CITY
varchar
The resolved city from the IP address.
Seattle
REGION
varchar
The resolved region from the IP address.
Washington
COUNTRY
varchar
The resolved country from the IP address.
United States
ISP_NAME
varchar
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_ROW_KEY
number(38,0)
AD_GROUP_ROW_KEY
number(38,0)
CREATIVE_ROW_KEY
number(38,0)
KEYWORD_ROW_KEY
number(38,0)
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_KEYWORDS biz-keywords

Keywords imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Keyword.
ba.3284209.132630532.3646889365.39464932147
DISPLAY_ID
varchar
The Keyword Id from the source system.
39464932147
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Keyword was imported.
fb.106851586409075
AD_ACCOUNT_NAME
varchar
Name of the Ad Account from which the Keyword was imported.
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.
null
ADVERTISER_NAME
varchar
Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.
null
AD_GROUP_UNIQUE_ID
varchar
Id of the Ad Group for the Keyword.
ba.3284209.132630532.3646889365
AD_GROUP_NAME
varchar
Name of the Ad Group for the Keyword.
Revenue Attribution - B2B
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the Keyword.
ba.3284209.132630532
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the Keyword.
Revenue Attribution
IS_ACTIVE
boolean
Whether or not the Keyword is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Keyword has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:37:29.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:37:29.000
NAME
varchar
Name of the Keyword, from the source system.
[revenue attribution b2b]
NEEDS_UPDATE
boolean

Whether or not the Keyword needs to be updated for Marketo Measure tagging.

(Diagnostic field, used for internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, used for internal processing.
ba.3284209.132630532.3646889365
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Keyword".
Keyword
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Keyword.
BingAds
URL_CURRENT
varchar

The URL for the landing page.

(Diagnostic field, for internal processing.)

URL_OLD
varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED
varchar

The URL for the landing page with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

IS_UPGRADED_URL
boolean
Diagnostic field, for internal processing.
false
WORD
varchar
The search phase the user entered.
revenue attribution b2b
MATCH_TYPE
varchar
The type of match that was found between the search phrase and the Keyword.
Exact
TRACKING_URL_TEMPLATE
varchar
Used for internal diagnostics.
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
TRACKING_URL_TEMPLATE_OLD
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_REQUESTED
varchar
Used for internal diagnostics.
TRACKING_URL_TEMPLATE_APPLIED
varchar
The URL tracking template Marketo Measure added to the Keyword.
http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
-2712935512233520000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_LANDING_PAGES biz-landing-pages

Landing Pages imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Landing Page.
DISPLAY_ID
varchar
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the landing page was imported.
AD_ACCOUNT_NAME
varchar
Name of the Ad Account from which the landing page was imported.
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser for the landing page, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
Name of the Advertiser for the landing page, specifically for Doubleclick.
Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
Id of the Ad Group for the landing page.
AD_GROUP_NAME
varchar
Name of the Ad Group for the landing page.
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the landing page.
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the landing page.
IS_ACTIVE
boolean
IS_DELETED
boolean
MODIFIED_DATE
timestamp_ntz
The last modified date of the row.
FIRST_IMPORTED
timestamp_ntz
NAME
varchar
NEEDS_UPDATE
boolean
GROUPING_KEY
varchar
ENTITY_TYPE
varchar
PROVIDER_TYPE
varchar
URL_CURRENT
varchar
URL_OLD
varchar
URL_REQUESTED
varchar
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_LEADS biz-leads

Leads imported from the source system.

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

BIZ_LEAD_STAGE_TRANSITIONS biz-lead-stage-transitions

Stage transitions for Leads or Contacts.

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

BIZ_OPPORTUNITIES biz-opportunities

Opportunities imported from the source system.

Column
Data Type
Description
Sample Data
ID
varchar
The Opportunity Id from the source system.
0060Z00000o89I4QAI
MODIFIED_DATE
timestamp_ntz
The last modified date of the Opportunity, from the source system.
2017-11-28 21:26:44.000
CREATED_DATE
timestamp_ntz
The created date of the Opportunity, from the source system.
2017-11-28 21:26:44.000
ACCOUNT_ID
varchar
Id of the related Account.
001i000000qbyeoAAA
NAME
varchar
The Opportunity Name, from the source system.
Mareketo Measure Renewal
IS_WON
boolean
Indicates if the Opportunity has moved to a stage considered won.
false
IS_CLOSED
boolean
Indicates if the Opportunity has moved to a stage considered closed.
false
CLOSE_DATE
timestamp_ntz
Anticipated or actual close date of the Opportunity, from the source system.
2019-08-28 07:00:00.000
BIZIBLE_CUSTOM_MODEL_DATE
timestamp_ntz
(deprecated)
null
AMOUNT
number(38,8)
Deal amount which is expected or closed from the Opportunity, from the source system.
8988.00000000
CONVERTED_FROM_LEAD_ID
varchar

The Id of the related Lead that had converted into this Opportunity.

Note that this field is not set and returns null in Snowflake for all customers.

null
CONVERTED_FROM_LEAD_EMAIL
varchar

The email of the related Lead that had converted into this Opportunity.

Note that this field is not set and returns null in Snowflake for all customers.

null
PRIMARY_CONTACT_ID
varchar
If Primary Contact Role is used, the Id of the related Contact listed as the primary contact role.
00331000038uGfhAAE
PRIMARY_CONTACT_EMAIL
varchar
If Primary Contact Role is used, the email of the related Contact listed as the primary contact role.
personb@adobe.com
ODDS_OF_CONVERSION
number(38,19)
This feature has been deprecated. 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

Only available in Marketo Measure Ultimate

BIZ_OPP_STAGE_TRANSITIONS biz-opp-stage-transitions

Stage transitions for Opportunities.

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

BIZ_PAGE_VIEWS biz-page-views

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

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Page View.
2018-08-19:16-49-58-24340.277d79d0167849
COOKIE_ID
varchar
The recorded cookie id at the time the Page View was logged.
277d79d01678498fea067c9b631bf6df
VISITOR_ID
varchar
The first cookie of the related visitor id.
v_277d79d01678498fea067c9b631bf6df
SESSION_ID
varchar
The Session id correlated with the Page View.
2018-08-19:16-49-58-24340.277d79d0167849
EVENT_DATE
timestamp_ntz
Date the Page View occurred.
2018-08-19 16:49:58.000
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-19 16:55:37.000
CURRENT_PAGE
varchar
URL of the Page View, without query parameters.
https://info.adobe.com/demo
CURRENT_PAGE_RAW
varchar
URL of the Page View, including any query parameters.
https://info.adobe.com/demo?hsCtaTracking=207219e9-87b6-4105-8f4b-0a3b62ae1af8%7C48060522-3aeb-4c72-8ce5-fd4b1017f069
IP_ADDRESS
varchar
The recorded IP address at the time the Form was submitted.
174.127.184.158
TYPE
varchar
Indicates the type of Event.
PageView
USER_AGENT_STRING
varchar
Device and browser recorded at the time of the Form Submit.
Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0
CLIENT_SEQUENCE
varchar(1)
Indicates the order in which the Page View occurred in the Session.
1
CLIENT_RANDOM
varchar
Used for internal auditing and processing.
103532
IS_DUPLICATED
boolean
Indicates if the record is considered a duplicate.
false
IS_PROCESSED
boolean
Used for internal processing.
true
REFERRER_PAGE
varchar
URL where the Page View originated from, without query parameters.
http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution
REFERRER_PAGE_RAW
varchar
URL where the Page View originated from, including any query parameters.
http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution?utm_source=linkedin&utm_medium=Social&utm_campaign=SU%20-%20CMO%20JT&utm_content=CMOs%20Guide&utm_term=lisu05091601
PAGE_TITLE
varchar
Title of the Page.
The CMO's Guide to B2B Marketing Attribution Download
EMAIL
varchar
Email address provided on a Form, as captured from the javascript.
personc@adobe.com
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
-6255315750913680000
CURRENT_PAGE_KEY
number(38,0)
Foreign Key to the Url table.
6255315750913680000
REFERRER_PAGE_KEY
number(38,0)
Foreign Key to the Url table.
6255315750913680000
HAS_USER_CONSENT
boolean
Indicates if the user has consented to tracking. False means the Page View has been collected because user consent is not required. True means the Page View has been collected and the user has given consent to be tracked.
true
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

BIZ_PLACEMENTS biz-placements

Table that stores all placements downloaded from any connected ads accounts, an object from the Doubleclick integration.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Placement.
ba.3284209.132855866.4556709270.10426699711
DISPLAY_ID
varchar
The Placement Id from the source system.
10426699711
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Placement was imported.
fb. 106851586409075
AD_ACCOUNT_NAME
varchar
Name for the Ad Account from which the Placement was imported.
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
Id of the Advertiser for the Placement, specifically for Doubleclick.
300184624
ADVERTISER_NAME
varchar
Name of the Advertiser for the Placement, specifically for Doubleclick.
Marketo Measure Analytics
AD_GROUP_UNIQUE_ID
varchar
Expected to be null since there is no Ad Group above the Placement in any ads hierarchy.
null
AD_GROUP_NAME
varchar
Expected to be null since there is no Ad Group above the Placement in any ads hierarchy.
null
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the Placement.
ba.3284209.132855866
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the Placement.
Pipeline Marketing
IS_ACTIVE
boolean
Whether or not the Placement is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Placement has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:36:25.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:36:25.000
NAME
varchar
Name of the Placement, from the source system.
Market
NEEDS_UPDATE
boolean

Whether or not the Placement needs to be updated for Marketo Measure tagging.

(Diagnostic field, used by internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, for internal processing.
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Placement".
Placement
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Placement.
BingAds
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
6008900572523230000
_CREATED_DATE
timestamp_ntz
Snowflake's created date of the record
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Snowflake's modified date of the record
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Snowflake's deleted date of the record if it has been deleted
2020-01-01 01:01:00.000

BIZ_SEGMENTS biz-segments

Segment values as defined in the Marketo Measure application.

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

BIZ_SEGMENT_NAMES biz-segment-names

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

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

BIZ_SESSIONS biz-sessions

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

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

BIZ_SITES biz-sites

Sites imported from any connected Ad Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the Site.
aw.3284209
DISPLAY_ID
varchar
The Site Id from the source system.
39464932147
AD_ACCOUNT_UNIQUE_ID
varchar
Id for the Ad Account from which the Site was imported.
aw.3284209
AD_ACCOUNT_NAME
varchar
Name of the Ad Account from which the Site was imported.
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
The Id of the advertiser for the site, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
The name of the advertiser for the site, specifically for Doubleclick.
Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
Expected to be null since there is no Ad Group above Site in any ads hierarchy.
null
AD_GROUP_NAME
varchar
Expected to be null since there is no Ad Group above Site in any ads hierarchy.
null
AD_CAMPAIGN_UNIQUE_ID
varchar
Id of the Campaign for the Site.
ba.3284209.132630532
AD_CAMPAIGN_NAME
varchar
Name of the Campaign for the Site.
Revue Attribution
IS_ACTIVE
boolean
Whether or not the Site is still active in the source system.
true
IS_DELETED
boolean
Whether or not the Site has been deleted in the source system.
false
MODIFIED_DATE
timestamp_ntz
Date the record was last modified.
2018-08-02 06:37:29.000
FIRST_IMPORTED
timestamp_ntz
Date the record was first imported from the source system.
2018-08-02 06:37:29.000
NAME
varchar
Name of the Site, from the source system.
Revenue
NEEDS_UPDATE
boolean

Whether or not the Site needs to be updated for Marketo Measure tagging.

(Diagnostic field, used for internal processing.)

false
GROUPING_KEY
varchar
Diagnostic field, used for internal processing.
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "Site".
Site
PROVIDER_TYPE
varchar
Name of the Ad Provider for the Site.
AdWords
ROW_KEY
number(38,0)
Foreign Key to the Biz_Facts view.
-2712935512233520000
_CREATED_DATE
timestamp_ntz
Date the record was created in Snowflake.
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Date the record was last modified in Snowflake.
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Date the record was marked as deleted in Snowflake.
2020-01-01 01:01:00.000

Sites Links from any connected Ads Account.

Column
Data Type
Description
Sample Data
ID
varchar
A unique Id for the site link
aw.6601259029.285077795.1654234342
DISPLAY_ID
varchar
1654234342
AD_ACCOUNT_UNIQUE_ID
varchar
The ID of the connected ads account for the site link
aw.6601259029
AD_ACCOUNT_NAME
varchar
The name of the connected ads account for the site link
Marketo Measure
ADVERTISER_UNIQUE_ID
varchar
The Id of the advertiser for the site link, specifically for Doubleclick.
300181641
ADVERTISER_NAME
varchar
The name of the advertiser for the site link, specifically for Doubleclick.
Marketing Analytics
AD_GROUP_UNIQUE_ID
varchar
The ID of the ad group for the site link
aw.6601259029.208548635.16750166675
AD_GROUP_NAME
varchar
The name of the ad group for the site link
Brand - Core
AD_CAMPAIGN_UNIQUE_ID
varchar
The ID of the campaign for the site link
aw.6601259029.285077795
AD_CAMPAIGN_NAME
varchar
The name of the campaign for the site link
Brand
IS_ACTIVE
boolean
Whether or not the site link is still active in the ads account
TRUE
IS_DELETED
boolean
Whether or not the site link has been deleted in the ads account
FALSE
MODIFIED_DATE
timestamp_ntz
The last modified date of the row
2018-08-02 06:36:50.000
FIRST_IMPORTED
timestamp_ntz
The date that the site link was first downloaded by Marketo Measure
2018-08-02 06:36:50.000
NAME
varchar
The name of the site link
Link A
NEEDS_UPDATE
boolean
Whether or not the site link needs to get updated to get Marekto Measure tagging
FALSE
GROUPING_KEY
varchar
aw.6601259029.285077795
ENTITY_TYPE
varchar
The main object or entity for this table. In this case, "SiteLink"
SiteLink
PROVIDER_TYPE
varchar
The name of the ads provider for the site link
AdWords
URL_CURRENT
varchar

The URL for the landing page.

(Diagnostic field, for internal processing.)

http://adobe.com/b2b-marketing-attribution?_bt

{creative}&_bk={keyword}&_bm={matchType}

URL_OLD
varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED
varchar

What the URL will be decorated with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

_CREATED_DATE
timestamp_ntz
Snowflake's created date of the record
2020-01-01 01:01:00.000
_MODIFIED_DATE
timestamp_ntz
Snowflake's modified date of the record
2020-01-01 01:01:00.000
_DELETED_DATE
timestamp_ntz
Snowflake's deleted date of the record if it has been deleted
2020-01-01 01:01:00.000

BIZ_STAGE_DEFINITIONS biz-stage-definitions

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

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

BIZ_TOUCHPOINTS biz-touchpoints

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

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

BIZ_URLS biz-urls

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

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

BIZ_USER_TOUCHPOINTS biz-user-touchpoints

All Touchpoints created from any event tied to an email.

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

BIZ_WEB_HOST_MAPPINGS biz-web-host-mappings

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

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

Sample Queries sample-queries

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

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

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

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

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

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

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

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

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

NOTE
This query returns attributed revenue for the w shape model. Change the model by updating the field in the attributed revenue calculation.
select bat.id
      ,bat.touchpoint_date
      ,bat.email
      ,opp.amount*(bat.w_shape_percentage/100)             as attributed_revenue
      ,listagg(osd.stage_name,', ')                        as touchpoint_position
  from biz_opportunities               opp
       inner join
       biz_attribution_touchpoints     bat
        on bat.opportunity_id      = opp.id
       and bat._deleted_date       is null
       left outer join
       biz_opp_stage_transitions       ost
        on ost.touchpoint_id       = bat.id
       and ost._deleted_date       is null
       and ost.is_pending          = false
       and ost.is_non_transitional = false
       left outer join
       biz_stage_definitions            osd
        on ost.stage_id             = osd.id
       and osd._deleted_date        is null
 where opp._deleted_date    is null
   and opp.id               = [opportunity id]
group by 1,2,3,4
order by touchpoint_date

Back to top

recommendation-more-help
9deee213-85c8-4c42-8ba8-089345b91d20