Data Warehouse Schema

Last update: 2023-12-06

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

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

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

Entity Relationship Diagrams

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

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

Click an image for its full-size version

Data Warehouse Data Model Ads Dimensional Data Model

Views

BIZ_ACCOUNTS

Accounts imported from the source system.

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

BIZ_ACCOUNT_TO_EMAILS

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

Column Data Type Description Sample Data
ID varchar A unique Id for the record. 0013800001MMPPiAAP_person@adobe.com|2022-01-05 17:22:13.000

ACCOUNT_ID

varchar

Source system Account Id.

0013100001phrBAAAY

EMAIL

varchar

Email address that has been mapped to the Account, either through Contact relationships or Lead to Account mapping.

person@adobe.com

MODIFIED_DATE

timestamp_ntz

The last modified date of the Account, from the source system.

2018-08-31 23:53:39.000

CREATED_DATE

timestamp_ntz

The created date of the Account, from the source system.

2018-08-18 22:01:32.000

IS_DELETED

boolean

Whether or not the record is considered deleted.

false

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_ACTIVITIES

Activities imported from a source system or connected Ad Account.

Column Data Type Description Sample Data

ID

varchar

The Activity Id from the source system.

1678625515

LEAD_ID

varchar

Id for the Lead associated with the Activity.

15530482

CONTACT_ID

varchar

Id for the Contact associated with the Activity.

13792552

ACTIVITY_TYPE_ID

varchar

Id for the Activity Type, from the source system.

104

ACTIVITY_TYPE_NAME varchar The Activity Name, from the source system.

change status in progression

START_DATE timestamp_ntz Start Date of the Activity, from the source system. 2020-01-01 01:01:00.000
END_DATE timestapm_ntz End Date of the Activity, from the source system. 2020-01-01 01:01:00.000
CAMPAIGN_ID varchar Id for the Campaign the Activity is a part of, from the source system.

li.508038570.147643566

SOURCE_SYSTEM varchar Identifies the source system type. Marketo
CREATED_DATE timestamp_ntz Date the row was created in the source system. 2020-01-01 01:01:00.000
MODIFIED_DATE timestamp_ntz Date the row was last modified in the source system. 2020-01-01 01:01:00.000
IS_DELETD boolean Whether or not the record is considered deleted in the source system. false
AD_FORM_ID varchar Id for the Ad Form the Activity is part of, from the source system. li.507063119.3757704
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_ADS

Ads imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Ad.

fb.106851586409075.6052044288804.6052044290004.6053457066804

DISPLAY_ID

varchar

The Ad Id from the source system.

6053457066804

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Ad was imported.

fb.106851586409075

AD_ACCOUNT_NAME

varchar

Name of the Ad Account from which the Ad was imported.

Marketo Measure Account

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser for the Ad, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser for the Ad, specifically for Doubleclick.

Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group for the Ad.

fb.106851586409075.6052044288804.6052044290004

AD_GROUP_NAME

varchar

Name of the Ad Group for the Ad.

Ad Set for Ad B

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the Ad.

fb.106851586409075.6052044288804

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the Ad.

Lead generation Campaign

IS_ACTIVE

boolean

Whether or not the Ad is still active in the source system.

false

IS_DELETED

boolean

Whether or not the Ad has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:35:59.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:35:59.000

NAME

varchar

Name of the Ad, from the source system.

Ad 2

NEEDS_UPDATE

boolean

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

(Diagnostic field, used by internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, used for internal processing.

fb.106851586409075.6052044288804.6052044290004

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Ad".

Ad

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Ad.

Facebook

URL_CURRENT

varchar

The URL for the landing page.

(Diagnostic field, for internal processing.)

URL_OLD

varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED

varchar

What the URL will be decorated with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

URL_ALTENATIVES

varchar

Imported from the source system.

(Diagnostic field, for internal processing.)

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

6008900572523230000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_ADVERTISERS

Advertisers imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Advertiser.

dc.6114.9143143

DISPLAY_ID

varchar

The Advertiser Id from the source system. 9143143

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Ad was imported.

fb.106851586409075

AD_ACCOUNT_NAME

varchar

Name of the Ad Account from which the Ad was imported.

Marketo Measure Account

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser, specifically for Doubleclick.

Marketo Measure Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

Expected to be null since there is no Ad Group above the Advertiser in any ads hierarchy.

null

AD_GROUP_NAME

varchar

Expected to be null since there is no Ad Group above the Advertiser in any ads hierarchy.

null

AD_CAMPAIGN_UNIQUE_ID

varchar

Expected to be null since there is no Ad Campaign above the Advertiser in any ads hierarchy.

null

AD_CAMPAIGN_NAME

varchar

Expected to be null since there is no Campaign above the Ad Advertiser in any ads hierarchy.

null

IS_ACTIVE

boolean

Whether or not the Advertiser is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Advertiser has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:35:59.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:35:59.000

NAME

varchar

Name of the Advertiser, from the source system.

Marketo Measure Marketing Analytics

NEEDS_UPDATE

boolean

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

(Diagnostic field, used by internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, used for internal processing.

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Advertiser".

Advertiser

PROVIDER_TYPE

varchar

The Ad Provider for the Advertiser.

Doubleclick

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

6008900572523230000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_AD_ACCOUNTS

Ad Accounts imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique identifier for the Ad Account.

aw.6601259029

DISPLAY_ID

varchar

The Ad Account Id from the source system.

6601259029

AD_ACCOUNT_UNIQUE_ID

varchar

Expected to be null since this is the record for the Ad Accounts in the ads hierarchy. null

AD_ACCOUNT_NAME

varchar

Expected to be null since this is the record for the Ad Accounts in the ads hierarchy. null

ADVERTISER_UNIQUE_ID

varchar

Expected to be null since there is no Advertiser above the Ad Accounts in any ads hierarchy.

null

ADVERTISER_NAME

varchar

Expected to be null since there is no Advertiser above the Ad Accounts in any ads hierarchy.

null

AD_GROUP_UNIQUE_ID

varchar

Expected to be null since there is no Ad Group above the Ad Accounts in any ads hierarchy.

null

AD_GROUP_NAME

varchar

Expected to be null since there is no Ad Group above the Ad Accounts in any ads hierarchy.

null

AD_CAMPAIGN_UNIQUE_ID

varchar

Expected to be null since there is no Ad Campaign above the Ad Accounts in any ads hierarchy.

null

AD_CAMPAIGN_NAME

varchar

Expected to be null since there is no Ad Campaign above the Ad Accounts in any ads hierarchy.

null

IS_ACTIVE

boolean

Whether or not the Ad Account is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Ad Account has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-09-06 12:54:37.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:35:58.000

NAME

varchar

Name of the Ad Account, from the source system.

Marketo Measure Ad Account

NEEDS_UPDATE

boolean

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

(Diagnostic field, used by internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, used for internal processing.

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Account".

Account

PROVIDER_TYPE

varchar

The name of the Ad Provider for the Ad Account.

AdWords

ACCOUNT_CURRENCY_UNIT

varchar

The currency code used for the Ad Account, from the source system.

USD

COMPANY_ID

varchar

Used for internal processing. 1933789

SOURCE

varchar

Parsed from the URL from utm_source.

Social

MEDIUM

varchar

Parsed from the URL from utm_medium.

lisu07261601

LAST_30_DAYS_COST

number(38,19)

The amount of spend imported for the last 30 days, only applicable to AdWords.

17260.000000000000000000

LAST_30_DAYS_IMPRESSIONS

number(38,0)

The number of impressions from the last 30 days, only applicable to AdWords.

730060

LAST_30_DAYS_CLICKS

number(38,0)

The number of clicks from the last 30 days, only applicable to AdWords.

3400

LAST_30_DAYS_CONVERSIONS

number(38,0)

The number of conversions reported from the last 30 days, only applicable to AdWords.

180

TRACKING_URL_TEMPLATE

varchar

Used for internal diagnostics.

http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}

TRACKING_URL_TEMPLATE_OLD

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_REQUESTED

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_APPLIED

varchar

The tracking template added on the Ad Account level for AdWords or Bing for tagging landing pages.

http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-4609512587744160000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_AD_CAMPAIGNS

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

Column

Data Type

Description

Sample Data

ID

varchar

Unique Id for the Campaign.

aw.6601259029.285114995

DISPLAY_ID

varchar

The Campaign Id from the source system.

285114995

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Campaign was imported.

aw.6601259029

AD_ACCOUNT_NAME

varchar

Name for the Ad Account from which the Campaign was imported.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser for the Campaign, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser for the Campaign, specifically for Doubleclick.

Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

Expected to be null since there is no Ad Group above the Campaign in any ads hierarchy.

null

AD_GROUP_NAME

varchar

Expected to be null since there is no Ad Group above the Campaign in any ads hierarchy.

null

AD_CAMPAIGN_UNIQUE_ID

varchar

Unique Id for the Campaign, use the Id field instead.

AD_CAMPAIGN_NAME

varchar

Name of the Campaign, use the Name field instead.

IS_ACTIVE

boolean

Whether or not the Campaign is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Campaign has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:35:58.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:35:58.000

NAME

varchar

Name of the Campaign.

Partner Retargeting

NEEDS_UPDATE

boolean

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

(Diagnostic field, used by internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, used for internal processing.

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Campaign".

Campaign

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Campaign.

AdWords

DAILY_BUDGET

number(38,19)

The daily budget that's set in the Ad Platform for the Campaign.

0.0000000000000000000

TRACKING_URL_TEMPLATE

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_OLD

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_REQUESTED

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_APPLIED

varchar

The tracking template added on the Campaign level for AdWords or Bing for tagging landing pages.

http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-6008900572523230000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_AD_FORMS

Ad Forms imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Ad Form.

li.507063119.3757704

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Ad Form was imported.

li.507063119

AD_ACCOUNT_NAME

varchar

Name of the Ad Account from which the Ad Form was imported.

Marketo Measure

IS_DELETED

boolean

Deleted status from the source system. Set to deleted if the status is Draft, Archived, or Canceled.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:35:58.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:35:58.000

NAME

varchar

Name of the Ad Form.

NSPA Ebook LGF (May 2020)

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "AdForm".

AdForm

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Ad Form.

LinkedIn

DESCRIPTION

varchar

Description of the Ad Form.

Learn how intelligent automation can increase process efficiency in mortgage refinance loan applications.

HEADLINE

varchar

Headline of the Ad Form.

It's Time to Automate the Refinancing Application Process

LANDING_URL

varchar

Landing URL of the Ad Form.

https://adobe.com/blog/refinancing-application-process/

QUESTIONS

varchar

List of Questions for the Ad Form.

First name:Last name:Email address:Country/Region:Job title:Company name

STATUS

varchar

Status of the Ad Form.

submitted

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000
SOURCE_ID varchar Id for the Source from which the record originated. aw.3284209

BIZ_AD_GROUPS

Ad Groups imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Ad Group.

aw.6601259029.317737955.23105326115

DISPLAY_ID

varchar

The Ad Group Id from the source system.

23105326115

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Ad Group was imported.

aw.6601259029

AD_ACCOUNT_NAME

varchar

Name for the Ad Account from which the Ad Group was imported.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Expected to be null since there is no Ad Group in the Doubleclick ads hierarchy.

null

ADVERTISER_NAME

varchar

Expected to be null since there is no Ad Group in the Doubleclick ads hierarchy.

null

AD_GROUP_UNIQUE_ID

varchar

Expected to be null since this is the record for the Ad Group in the hierarchy.

null

AD_GROUP_NAME

varchar

Expected to be null since this is the record for the Ad Group in the hierarchy.

null

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the Ad Group.

aw.6601259029.317737955

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the Ad Group.

Revenue Attribution

IS_ACTIVE

boolean

Whether or not the Ad Account is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Ad Account has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:36:14.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:36:14.000

NAME

varchar

Name of the Ad Group.

Revenue Attribution - Account Based

NEEDS_UPDATE

boolean

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

(Diagnostic field, used by internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, used for internal processing.

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "AdGroup".

AdGroup

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Ad Group.

AdWords

AD_NETWORK_TYPE

varchar

The medium(s) that the Ad Group is running on.

Search, Display, YouTube_Search, YouTube_Watch

TRACKING_URL_TEMPLATE

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_OLD

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_REQUESTED

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_APPLIED

varchar

The tracking template added on the Ad Account level for AdWords or Bing for tagging landing pages.

http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-5594512713562690000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_AD_PROVIDERS

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

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Ad Provider.

Bing

NAME

varchar

Name of the Ad Provider.

Bing

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

4783788151269206864

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_ATTRIBUTION_TOUCHPOINTS

Buyer Attribution Touchpoints, all touchpoints associated with an Opportunity.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Buyer Attribution Touchpoint (BAT).

BAT2_0060Z00000lFHtOQAW_

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

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-09-01 04:53:53.000

OPPORTUNITY_ID

varchar

Id for the Opportunity the BAT is attributed to.

0060Z00000lFHtOQAW

CONTACT_ID

varchar

Id for the Contact associated with the BAT.

0030Z00003K5bpKQAR

EMAIL varchar Email address associated with the BAT. person@adobe.com

ACCOUNT_ID

varchar

Id for the Account the BAT is attributed to.

0013100001otbIAAAY

USER_TOUCHPOINT_ID

varchar

Id for the User Touchpoint which generated the BAT.

person@adobe.com_00v1B00003ZbWzHQAV

TOUCHPOINT_DATE

timestamp_ntz

Date of the touchpoint.

2017-06-20 01:05:20.000

VISITOR_ID varchar Id for the visitor associated with the BAT. v_277d79d01678498fea067c9b631bf6df

MARKETING_TOUCH_TYPE

varchar

The type of activity, Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity. Referred to in the CRM as "Touchpoint Type."

Web Form

CHANNEL

varchar

The channel the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. Referred to in the CRM as "Marketing Channel - Path."

Social.LinkedIn

CATEGORY1

varchar

The segment value for the 1st Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

ABC

CATEGORY2

varchar

The segment value for the 2nd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

Yes

CATEGORY3

varchar

The segment value for the 3rd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

SMB

CATEGORY4

varchar

The segment value for the 4th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

New Business

CATEGORY5

varchar

The segment value for the 5th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY6

varchar

The segment value for the 6th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY7

varchar

The segment value for the 7th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY8

varchar

The segment value for the 8th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY9

varchar

The segment value for the 9th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY10

varchar

The segment value for the 10th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY11

varchar

The segment value for the 11th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY12

varchar

The segment value for the 12th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY13

varchar

The segment value for the 13th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY14

varchar

The segment value for the 14th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

CATEGORY15

varchar

The segment value for the 15th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments."

BROWSER_NAME

varchar

From the javascript and IP address, the detected browser that the user was on during the session.

Chrome

BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session.

58

PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session.

Mac

PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session.

10_12

LANDING_PAGE

varchar

The first landing page of the session which resulted in a touchpoint. Referred to in the CRM as "Landing Page".

http://www.adobe.com/blog/uncover- truth-behind-cost-per-lead

LANDING_PAGE_RAW

varchar

The first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. Referred to in the CRM as "Landing Page - Raw".

http://www.adobe.com/blog/uncover-truth -behind-cost-per-lead?utm_content=27322869&utm_ medium=social&utm_source=linkedin

REFERRER_PAGE

varchar

Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".

https://www.linkedin.com/

REFERRER_PAGE_RAW

varchar

Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".

https://www.linkedin.com/

FORM_PAGE

varchar

The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. Referred to in the CRM as "Form URL".

http://info.adobe.com/intro-guide-b2b-marketing-attribution

FORM_PAGE_RAW

varchar

The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. A raw form page may contain query parameters in the URL. Referred to in the CRM as "Form URL - Raw".

http://info.adobe.com/intro-guide-b2b-marketing-attribution

FORM_DATE

timestamp_ntz

Date the form submission occurred.

2017-06-20 01:06:41.000

CITY

varchar

From the javascript and IP address, the detected city the user was in during the session.

San Francisco

REGION

varchar

From the javascript and IP address, the detected region the user was in during the session.

California

COUNTRY

varchar

From the javascript and IP address, the detected country the user was in during the session.

United States

MEDIUM

varchar

Used to define the medium which resulted in the touchpoint. This can either be parsed out from the URL from utm_medium. Or, if Marketo Measure is able to resolve an ad, it may be values such as "cpc" or "display."

social

WEB_SOURCE

varchar

Used to define the source which resulted in the touchpoint. This can be parsed out from the URL from utm_source, generically set as "CRM Campaign" if it was synced from the CRM, or if Marketo Measure is able to resolve an ad, it may be values such as "Google AdWords" or "Facebook." Referred to in the CRM as "Touchpoint Source".

linkedin

SEARCH_PHRASE

varchar

The value which the user entered in the browser to search for and ended up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform.

google Marketo Measure

AD_PROVIDER

varchar

Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.

Google

ACCOUNT_UNIQUE_ID

varchar

Id of the Ad Account in which the ad was resolved from.

aw.6601259029

ACCOUNT_NAME

varchar

Name of the Ad Account in which the ad was resolved from.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Marketo Measure Marketing Analytics

SITE_UNIQUE_ID

varchar

Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651

SITE_NAME

varchar

Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Quora.com

PLACEMENT_UNIQUE_ID

varchar

Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827

PLACEMENT_NAME

varchar

Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

roadblock

CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign from the Ad Account in which the Ad was resolved from.

aw.6601259029.317738075

CAMPAIGN_NAME

varchar

Name of the Campaign from the Ad Account in which the Ad was resolved from.

Marketing Attribution

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords.

aw.6601259029.317738075.23105327435

AD_GROUP_NAME

varchar

Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords.

Marketing Attribution - General

AD_UNIQUE_ID

varchar

Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

dc.6114.8882972.25272734.492579576

AD_NAME

varchar

Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

Budget Webinar - sidebar

CREATIVE_UNIQUE_ID

varchar

Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.317738075.23105327435.182716179597

CREATIVE_NAME

varchar

Name of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

B2B Marketing Attribution

CREATIVE_DESCRIPTION_1

varchar

The first line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Download The CMOs Guide

CREATIVE_DESCRIPTION_2

varchar

The second line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Learn how attribution measures ROI by connecting marketing activities to revenue

CREATIVE_DESTINATION_URL

varchar

The landing page that clicks through from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution

CREATIVE_DISPLAY_URL

varchar

The friendly URL name that's shown on the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

http://info.adobe.com/CMOs-Guide

KEYWORD_UNIQUE_ID

varchar

Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.317738075.23105327435.4838421670

KEYWORD_NAME

varchar

Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search)

"marketing attribution"

KEYWORD_MATCH_TYPE

varchar

The type of match found between the search phrase and the purchased keyword.

Exact

IS_FIRST_TOUCH

boolean

Whether or not this touchpoint is treated as the first touch of the opportunity journey.

false

IS_LEAD_CREATION_TOUCH

boolean

Whether or not this touchpoint is treated as the lead creation touch of the opportunity journey.

false

IS_OPP_CREATION_TOUCH

boolean

Whether or not this touchpoint is treated as the opportunity creation touch of the opportunity journey.

false

IS_CLOSED_TOUCH

boolean

Whether or not this touchpoint is treated as the closed touch of the opportunity journey.

false

STAGES_TOUCHED

varchar This field has been deprecated. Use the Stage_Transitions tables for stage information. null

IS_FORM_SUBMISSION_TOUCH

boolean

Whether or not this touchpoint had a form fill during the session.

true

IS_IMPRESSION_TOUCH

boolean

Whether or not this touchpoint is treated as the first impression touch of the opportunity journey

false

FIRST_CLICK_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's a first touch (See Is_First_Touch).

0.0000000000000000000

LAST_ANON_CLICK_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's a lead creation touch (See Is_Lead_Creation_Touch).

0.0000000000000000000

U_SHAPE_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's part of a u-shaped touch (See Is_First_Touch and Is_Lead_Creation_Touch).

0.0000000000000000000

W_SHAPE_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's part of a w-shaped touch (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch).

0.0153374234214425

FULL_PATH_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch).

0.0143061513081193

CUSTOM_MODEL_PERCENTAGE

number(22,19) The calculated percentage allocated to this touchpoint because it's part of a custom model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch). 0.0143061513081193

IS_DELETED

boolean

Whether this touchpoint is deleted.

false

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-2712935512233520000

OPPORTUNITY_ROW_KEY

number(38,0)

LANDING_PAGE_KEY number(38,0)
REFERRER_PAGE_KEY number(38,0)
FORM_PAGE_KEY number(38,0)
ACCOUNT_ROW_KEY number(38,0)
ADVERTISER_ROW_KEY number(38,0)
SITE_ROW_KEY number(38,0)

PLACEMENT_ROW_KEY

number(38,0)
CAMPAIGN_ROW_KEY number(38,0)
AD_ROW_KEY number(38,0)
AD_GROUP_ROW_KEY number(38,0)
CREATIVE_ROW_KEY number(38,0)
KEYWORD_ROW_KEY number(38,0)
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CAMPAIGN_MEMBERS

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

Column

Data Type

Description

Sample Data

ID

varchar

The Campaign Member Id from the source system.

00v0Z00001VVzdLQAT

MODIFIED_DATE

timestamp_ntz

The last modified date of the Campaign Member, from the source system.

2018-08-31 20:49:54.000

CREATED_DATE

timestamp_ntz

The created date of the Campaign Member, from the source system.

2018-08-31 20:49:54.000

BIZIBLE_TOUCH_POINT_DATE

timestamp_ntz

Date and time the customer sets to override the campaign date and use this value for the Touchpoint Date instead.

2018-08-30 18:00:00.000

LEAD_ID

varchar

Id for the Lead the Campaign Member is tied to.

00Q0Z000013dw4GUAQ

LEAD_EMAIL

varchar

Email for the Lead the Campaign Member is tied to.

persona@adobe.com

CONTACT_ID

varchar

Id for the Contact the Campaign Member is tied to.

00331000032hMxRAAU

CONTACT_EMAIL

varchar

Email for the Contact the Campaign Member is tied to.

persona@adobe.com

STATUS

varchar

Status of the Campaign Member, usually set to Sent or Responded or another custom value. This status is tied to the Campaign_Sync_Type to determine which Campaign Members to create touchpoints for.

Sent

HAS_RESPONDED

boolean

Tells if the Campaign Member was marked as "Responded" from the Status picker.

true

FIRST_RESPONDED_DATE

timestamp_ntz

Date the Campaign Member first responded.

2018-08-30 07:00:00.000

CAMPAIGN_NAME

varchar

Name of the related Campaign the Campaign Member is a part of.

Fast CMO Interviews

CAMPAIGN_ID

varchar

Id of the related Campaign the Campaign Member is a part of.

7010Z000001TcKlQAK

CAMPAIGN_TYPE

varchar

Type selected on the related Campaign the Campaign Member is a part of. The Type is used to map the Marketing Channel.

Offline

CAMPAIGN_SYNC_TYPE

varchar

Determines which Campaign Members to create touchpoints for. The possible values are: Include_All, Include_Responded, Exclude_All.

Include_All

LEAD_SYNC_STATUS

varchar

Audit field, states whether or not a Buyer Touchpoint was generated for the Lead. If no touchpoint was created, the reason why it didn't qualify is given.

No Touchpoint: Date outside model

CONTACT_SYNC_STATUS

varchar

Audit field, states whether or not a Buyer Touchpoint was generated for the Contact. If no touchpoint was created, the reason why it didn't qualify is given.

Touchpoint Created

OPP_SYNC_STATUS

varchar

Audit field, states whether or not a Buyer Attribution Touchpoint was generated for the Opportunity. If no touchpoint was created, the reason why it didn't qualify is given.

Touchpoint Created

IS_DELETED

boolean

Whether or not the record is considered deleted in the source system .

false

CUSTOM_PROPERTIES varchar Custom properties that Marketo Measure has imported from the source system, in JSON format. {"Campaign_Type__c":"Dinners","Foo":"Bar"}
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CHANNELS

Marketing Channels, as created in the Marketo Measure application.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Channel.

Organic Search.Google

NAME

varchar

Name of the Channel.

Organic Search.Google

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

6008900572523230000

_CREATED_DATE timestamp_ntz The date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz The date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz The date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CONTACTS

Contacts imported from the source system.

Column

Data Type

Description

Sample Data

ID

varchar

The Contact Id from the source system.

0030Z00003OzioeQAB

MODIFIED_DATE

timestamp_ntz

Date the Contact record was last modified, from the source system.

2018-09-05 05:17:53.000

CREATED_DATE

timestamp_ntz

Date the Contact record was created, from the source system.

2018-09-05 05:17:51.000

EMAIL

varchar

Email address of the Contact, from the source system.

persona@adobe.com

ACCOUNTID

varchar

Id of the Account related to the Contact.

0013100001b44aGAAQ

LEAD_SOURCE

varchar

Source in which the Lead was created.

Advertisement

BIZIBLE_STAGE

varchar

Current stage of the Contact, recognized as a custom stage which can be created in the Marketo Measure application.

Demo Scheduled

BIZIBLE_STAGE_PREVIOUS

varchar

All previous stages for the Contact, recognized as custom stages which can be created in the Marketo Measure application.

Open - Contact

ODDS_OF_CONVERSION

number(38,19)

This feature has been deprecated. Please do not use this column.

N/A

BIZIBLE_COOKIE_ID

varchar

The Marketo Measure Cookie Id used to populate from an integration partner to map an offline event to a web session. Requirement: Enable Call Tracking: True

08c1063cb0a64349ad0d2d862f5cc700

IS_DELETED

boolean

Whether or not the record is deleted in the source system.

false
IS_DUPLICATE boolean Used to de-duplicate records if both a CRM and Marketo integration are set up. If there are duplicates, the Marketo Contact is marked true. false
SOURCE_SYSTEM varchar Indicates if the record came from a CRM or a Marketo integration. Crm
OTHER_SYSTEM_ID varchar Maps a person from a Marketo integration with a Contact from a CRM integration. If both a CRM and Marketo integration exist, the value is the corresponding Id. 1234 / 00Q0Z00001OohgTUAR
CUSTOM_PROPERTIES varchar Custom properties that Marketo Measure has imported from the source system , in JSON format. {"Contact_Type__c":"CMO", "Foo":"Bar"}

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

3263982503087870000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CONVERSION_RATES

Currency conversion rates imported from the source system.

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

BIZ_COSTS

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

Column Data Type Description Sample Data
ID varchar A unique Id for the Cost record. aw.6601259029.285114995.21703163075.[AdWords Display]_2018-09-06
MODIFIED_DATE timestamp_ntz Date the record was last modified. 2018-09-06 12:22:45.000
COST_DATE timestamp_ntz Date the Cost was incurred (or attributed to). 2018-09-06 00:00:00.000
SOURCE varchar Source of the reported Cost. [AdWords Display]
COST_IN_MICRO number(38,0) Cost amount in millions. User will need to divide the value by 1000000. 1410000
CLICKS number(38,0) Number of clicks reported for the group for the day. 4
IMPRESSIONS number(38,0) Number of impressions reported for the group for the day. 4187
ESTIMATED_TOTAL_POSSIBLE_IMPRESSIONS number(38,0) Total number of impressions estimated from DCM for the group for the day. 5024
AD_PROVIDER varchar Provider for which the Cost was pulled. Google
CHANNEL_UNIQUE_ID varchar Id for the marketing Channel, created by Marketo Measure. Display.Google
CHANNEL_NAME varchar Name for the marketing Channel, created by the customer in the Marketo Measure app. Display.Google
CHANNEL_IS_AGGREGATABLE_COST boolean Indicates if the row contains Cost which can be summed up by Channel. (i.e. to get Channel Cost, sum rows where this column equals true.) false
ADVERTISER_UNIQUE_ID varchar Id of the Advertiser pulled from the Ad connection, specifically for Doubleclick connections. 300181641
ADVERTISER_NAME varchar Name of the Advertiser pulled from the Ad connection, specifically for Doubleclick connections. Marketo Measure Marketing Analytics
ADVERTISER_IS_AGGREGATABLE_COST boolean Indicates if the row contains Cost which can be summed up by Advertiser. (i.e. to get Advertiser Cost, sum rows where this column equals true.) false

ACCOUNT_UNIQUE_ID

varchar

Id of the Ad Account pulled from the Ad connection.

aw.6601259029

ACCOUNT_NAME

varchar

Name of the Ad Account pulled from the Ad connection.

Marketo Measure

ACCOUNT_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Account. (i.e. to get Account Cost, sum rows where this column equals true.)

false

CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign pulled from the Ad connection.

aw.6601259029.285114995

CAMPAIGN_NAME

varchar

Name of the Campaign pulled from the Ad connection.

Partner Retargeting

CAMPAIGN_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Campaign. (i.e. to get Campaign Cost, sum rows where this column equals true.)

true

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group pulled from the Ad connection.

aw.6601259029.285114995.21703163075

AD_GROUP_NAME

varchar

Name of the Ad Group pulled from the Ad connection.

Attribution Management Software | Phrase

AD_GROUP_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Ad Group. (i.e. to get Ad Group Cost, sum rows where this column equals true.)

false

AD_UNIQUE_ID

varchar

Id of the Ad pulled from the Ad connection.

dc.6114.9131003.24149929.467969200

AD_NAME

varchar

Name of the Ad pulled from the Ad connection.

Ad name: Ad3-320x50.gif; 320 x 50

AD_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Ad. (i.e. to get Ad Cost, sum rows where this column equals true.)

false

CREATIVE_UNIQUE_ID

varchar

Id of the Creative pulled from the Ad connection.

aw.6601259029.285114995.51749608028.266050115160

CREATIVE_NAME

varchar

Name of the Creative pulled from the Ad connection.

Gartner Magic Quadrant 2019

CREATIVE_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Creative. (i.e. to get Creative Cost, sum rows where this column equals true.)

false

KEYWORD_UNIQUE_ID

varchar

Id of the Keyword pulled from the Ad connection.

aw.6601259029.669328935.39419128772.99608705795

KEYWORD_NAME

varchar

Name of the Keyword pulled from the Ad connection.

sfdc marketing attribution

KEYWORD_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Keyword. (i.e. to get Keyword Cost, sum rows where this column equals true.)

false

PLACEMENT_UNIQUE_ID

varchar

Id of the Placement pulled from the Ad connection.

120839827

PLACEMENT_NAME

varchar

Name of the Placement pulled from the Ad connection.

roadblock

PLACEMENT_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Placement. (i.e. to get Placement Cost, sum rows where this column equals true.)

false

SITE_UNIQUE_ID

varchar

Id of the Site pulled from the Ad connection.

1695651

SITE_NAME

varchar

Name of the Site pulled from the Ad connection.

Quora.com

SITE_IS_AGGREGATABLE_COST

boolean

Indicates if the row contains Cost which can be summed up by Site . (i.e. to get Site Cost, sum rows where this column equals true.)

false

IS_DELETED

boolean

Whether or not the record is considered deleted in the source system .

false

ISO_CURRENCY_CODE varchar ISO code for the currency, imported from the source system. USD
SOURCE_ID varchar Id for the Source from which the record originated. aw.3284209
ROW_KEY number(38,0)

Foreign Key to the Biz_Facts view.

6008900572523230000

ACCOUNT_ROW_KEY

number(38,0)
ADVERTISER_ROW_KEY number(38,0)
SITE_ROW_KEY number(38,0)
PLACEMENT_ROW_KEY number(38,0)
CAMPAIGN_ROW_KEY number(38,0)
AD_ROW_KEY number(38,0)
AD_GROUP_ROW_KEY number(38,0)
CREATIVE_ROW_KEY number(38,0)
KEYWORD_ROW_KEY number(38,0)
CURRENCY_ID number(38,0) Id value of the Currency for the record.

-3253183181619994799

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CREATIVES

Creatives imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Creative.

ba.3284209.132855866.4556709270.10426699711

DISPLAY_ID

varchar

The Creative Id from the source system.

10426699711

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Creative was imported.

fb.106851586409075

AD_ACCOUNT_NAME

varchar

Name for the Ad Account from which the Creative was imported.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser for the Creative, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser for the Creative, specifically for Doubleclick.

Marketo Measure Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group for the Creative.

fb.106851586409075.6052044288804.6052044290004

AD_GROUP_NAME

varchar

Name of the Ad Group for the Creative.

Ad Set for Ad B

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the Creative.

ba.3284209.132855866

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the Creative.

PipelineMarketing.com

IS_ACTIVE

boolean

Whether or not the Creative is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Creative has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:36:25.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:36:25.000

NAME

varchar

Name of the Creative, from the source system.

PipelineMarketing.com

NEEDS_UPDATE

boolean

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

(Diagnostic field, used by internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, for internal processing.

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Creative".

Creative

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Creative.

BingAds

URL_CURRENT

varchar

The current version of the URL including all tags.

(Diagnostic field, for internal processing.)

cdn.adobe.com/redir?lp=http%3a%2f%2fwww.pipelinemarketing.com%2f&_bt={creative}&_bk={keyword}&_bm={matchType}&utm_content={adid}&utm_term={keyword}&utm_campaign=PipelineMarketing.com&utm_source=bing&utm_medium=cpc

URL_DISPLAY

varchar

The shortened and friendly URL that's displayed on the Creative.

PipelineMarketing.com

URL_OLD

varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED

varchar

What the URL will be decorated with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

URL_SHORTENED

varchar

The shortened and friendly URL that's displayed on the Creative. (Used for LinkedIn Ads only.)

AD_TYPE

varchar

The type of Creative, which could be Text or Display

Text

IS_UPGRADED_URL

boolean

Whether or not the creative is using Upgraded URLs.

false

HEADLINE

varchar

The top line (headline) of the creative

PipelineMarketing.com

DESCRIPTION_LINE_1

varchar

The copy from the first line of the creative

Connect & Learn From Revenue-Driven B2B Marketers. Join the Community.

DESCRIPTION_LINE_2

varchar

The copy from the second line of the creative

Have You Used Analytics? Leave a Review Today!

TRACKING_URL_TEMPLATE

varchar

Diagnostics field, for internal processing.

TRACKING_URL_TEMPLATE_OLD

varchar

Diagnostics field, for internal processing.

TRACKING_URL_TEMPLATE_REQUESTED

varchar

Diagnostics field, for internal processing.

TRACKING_URL_TEMPLATE_APPLIED

varchar

Diagnostics field, for internal processing.

http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}

SHARE_URN

varchar

The share Id. (Used for LinkedIn Ads only.)

urn:li:share:6376987561897848832

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

6008900572523230000
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CRM_EVENTS

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

Column

Data Type

Description

Sample Data

ID

varchar

The Event Id from the source system.

00U3100000VLUnEEAX

CREATED_DATE

timestamp_ntz

Date the Event was created, from the source system.

2016-12-12 19:32:53.000

MODIFIED_DATE

timestamp_ntz

Date the Event was last modified, from the source system.

2018-09-03 08:39:51.000

LEAD_ID

varchar

Id for the Lead associated with the Event.

00Q0Z000013eVrxUAE

LEAD_EMAIL

varchar

Email for the Lead associated with the Event.

person@adobe.com

CONTACT_ID

varchar

Id for the Contact associated with the Event.

0030Z00003OyjbOQAR

CONTACT_EMAIL

varchar

Email for the Contact associated with the Event.

person@adobe.com

BIZIBLE_COOKIE_ID

varchar

The Marketo Measure Cookie Id used to populate from an integration partner to map an offline event to a web session. Requirement: Enable Call Tracking: True

08c1063cb0a64349ad0d2d862f5cc700

ACTIVITY_TYPE

varchar

Activity Type Name, from the source system.

Email

EVENT_START_DATE

timestamp_ntz

Start date for the Event, one of the options used to determine the Touchpoint date.

2016-12-16 19:30:00.000

EVENT_END_DATE

timestamp_ntz

End date for the Event, one of the options used to determine the Touchpoint date.

2016-12-16 21:30:00.000

IS_DELETED

boolean

Whether or not the record is considered deleted in the source system.

False

CUSTOM_PROPERTIES varchar Custom properties that Marketo Measure has imported from the source system, in JSON format. {"Contact_Type__c":"CMO","Foo":"Bar"}
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CRM_TASKS

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

Column

Data Type

Description

Sample Data

ID

varchar

The Task Id from the source system.

00T0Z00004Rf62rUAB

CREATED_DATE

timestamp_ntz

Date the Task was created, from the source system.

2018-08-27 18:30:25.000

MODIFIED_DATE

timestamp_ntz

Date the Task was last modified, from the source system.

2018-08-27 18:31:53.000

LEAD_ID

varchar

Id for the Lead associated with the Task.

00Q0Z000013eVrxUAE

LEAD_EMAIL

varchar

Email for the Lead associated with the Task.

person@adobe.com

CONTACT_ID

varchar

Id for the Contact associated with the Task.

00331000038uGfhAAE

CONTACT_EMAIL

varchar

Email for the Contact associated with the Task.

person@adobe.com

BIZIBLE_COOKIE_ID

varchar

The Marketo Measure Cookie Id used to populate from an integration partner to map an offline event to a web session. Requirement: Enable Call Tracking: True

08c1063cb0a64349ad0d2d862f5cc700

ACTIVITY_TYPE

varchar

Activity Type Name, from the source system.

Call

ACTIVITY_DATE

timestamp_ntz

Date the Task occurred, one of the options used to determine the Touchpoint date.

2018-08-27 07:00:00.000

IS_DELETED

boolean

Whether or not the record is considered deleted in the source system.

false

CUSTOM_PROPERTIES varchar Custom properties that Marketo Measure has imported from the source system, in JSON format. {"Contact_Type__c":"CMO", "Foo":"Bar"}
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CURRENCIES

Table of all ISO currencies.

Column Data Type Description Sample Data

ID

number(38,0) A unique Id for the Currency record. 139474809945095870
ISO_CODE varchar ISO code for the Currency. USD
IS_CORPORATE boolean Designates if the Currency is the corporate Currency.

false

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

BIZ_CUSTOMER_AB_TESTS

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

Column

Data Type

Description

Sample Data

VISITOR_ID

varchar

The first cookie id of the related visitor id.

v_36ec805b4db344d6e92c972c86aee34a

COOKIE_ID

varchar

The recorded cookie id at the time the event was logged.

36ec805b4db344d6e92c972c86aee34a

EVENT_DATE

timestamp_ntz

Date the chat was logged.

2020-01-01 01:01:00.000
MODIFIED_DATE timestamp_ntz Date the record was last modified. 2020-01-01 01:01:00.000
IP_ADDRESS

varchar

The recorded IP address at the time the experiment was logged.

192.0.2.1

EXPERIMENT_ID

varchar

The id of the experiment pulled from the AB test platform.

123

EXPERIMENT_NAME

varchar

The name of the experiment pulled from the AB test platform.

Experiment A

VARIATION_ID

varchar

The variation id of the experiment pulled from the AB test platform.

456

VARIATION_NAME

varchar

The variation name of the experiment pulled from the AB test platform.

Blue Test

ABTEST_USER_ID

varchar

The id of the user who was served the experiment pulled from the AB test platform.

584d64et

IS_DELETED

boolean

Whether or not the record was deleted, used for diagnostics and auditing.

false
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CUSTOMER_EVENTS

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

Column

Data Type

Description

Sample Data

VISITOR_ID

varchar

The first cookie id of the related visitor id.

v_36ec805b4db344d6e92c972c86aee34a

COOKIE_ID

varchar

The recorded cookie id at the time the event was triggered from the custom javascript.

36ec805b4db344d6e92c972c86aee34a

EVENT_DATE

timestamp_ntz

The date the event was triggered from the custom javascript.

2020-01-01 01:01:00.000
MODIFIED_DATE timestamp_ntz The last date the record was modified. 2020-01-01 01:01:00.000

IP_ADDRESS

varchar

The recorded IP address at the time the event was triggered from the custom javascript.

192.0.2.1

KEY

varchar

The name given to the event which was triggered from the custom javascript.

Video View

VALUE

varchar

The value given to the event which was triggered from the custom javascript.

75% viewed

IS_DELETED

boolean

Whether or not the record was deleted, used for diagnostics and auditing.

false
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_CUSTOM_LANDING_PAGES

Landing Pages downloaded from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the record.

DISPLAY_ID

varchar

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the landing page was imported.

AD_ACCOUNT_NAME

varchar

Name of the Ad Account from which the landing page was imported

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser for the landing page, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser for the landing page, specifically for Doubleclick.

Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group for the landing page.

AD_GROUP_NAME

varchar

Name of the Ad Group for the landing page.

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the landing page.

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the landing page.

IS_ACTIVE

boolean

IS_DELETED

boolean

MODIFIED_DATE

timestamp_ntz

The last modified date of the row

FIRST_IMPORTED

timestamp_ntz

NAME

varchar

NEEDS_UPDATE

boolean

GROUPING_KEY

varchar

ENTITY_TYPE

varchar

PROVIDER_TYPE

varchar

AD_DISPLAY_ID

varchar

CREATIVE_DISPLAY_ID

varchar

URL_CURRENT

varchar

URL_OLD

varchar

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_EMAIL_TO_VISITOR_IDS

Mapping table for email addresses and visitor ids.

Column

Data Type

Description

Sample Data

ID varchar A unique Id for the record.

0013800001MMPPiAAP_person@adobe.com|2022-01-05 17:22:13.000

EMAIL

varchar

A known email address that's tied to a given visitor Id from a session

person@adobe.com

VISITOR_ID

varchar

The first cookie of the related visitor Id

v_36ec805b4db344d6e92c972c86aee34a

MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-14 23:55:03.000

CREATED_DATE

timestamp_ntz

The created date of the row

2018-08-14 23:55:03.000

IS_DELETED

boolean

Whether or not the record is considered deleted, used for diagnostics and auditing.

false

IS_IGNORE boolean Indicates if the email or visitor id is considered noise or spam, used for internal processing. false
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_FACTS

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

Column Data Type Description Sample Data
COST_KEY number(38,0) Used to join to the Costs table. 2672629811884560039
ATP_KEY number(38,0) Used to join to the Attribution Touchpoints table. 2672629811884560039
TP_KEY number(38,0) Used to join to the Touchpoints or User Touchpoints tables. 5028390208679093800
PAGE_VIEW_KEY number(38,0) Used to join to the Page Views table. -8044063242541720607
SESSION_KEY number(38,0) Used to join to the Sessions table. 8817975702393619368
VISITOR_ID varchar The first cookie id of the related visitor id. v_530d8334c455460df0d48f48270a4b23
COOKIE_ID varchar The recorded cookie id at the time the event was logged. 530d8334c455460df0d48f48270a4b23
FORM_SUBMIT_KEY number(38,0) Used to join to the Form Submits table. -8659572802702769670
IMPRESSION_KEY number(38,0) Used to join to the Impressions table. 8817975702393619368
CURRENT_PAGE_KEY number(38,0) Used to join to the Urls table. 4079876040770132443
REFERRER_PAGE_KEY number(38,0) Used to join to the Urls table. 8817975702393619368
FORM_PAGE_KEY number(38,0) Used to join to the Urls table. 8817975702393619368
AD_PROVIDER_KEY number(38,0) Used to join to the Ad Providers table. 8817975702393619368

CHANNEL_KEY

number(38,0)

Used to join to the Channels table.

-1921844114032355934

CAMPAIGN_KEY

number(38,0)

Used to join to the Ad Campaigns table.

252687814634577606

KEYWORD_KEY

number(38,0)

Used to join to the Keywords table.

8817975702393619368

AD_KEY

number(38,0)

Used to join to the Ads table.

8817975702393619368

AD_GROUP_KEY

number(38,0)

Used to join to the Ad Groups table.

8817975702393619368

CREATIVE_KEY

number(38,0)

Used to join to the Creatives table.

-2333871387956621113

SITE_KEY

number(38,0)

Used to join to the Sites table.

8817975702393619368

ADVERTISER_KEY

number(38,0)

Used to join to the Advertisers table.

8817975702393619368

AD_ACCOUNT_KEY

number(38,0)

Used to join to the Ad Accounts table.

1825012532740770032

PLACEMENT_KEY

number(38,0)

Used to join to the Placements table.

8817975702393619368

CATEGORY_01_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_02_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_03_KEY nubmer(38,0) Used to join to the Segments table. -2333871387956621113
CATEGORY_04_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_05_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_06_KEY nubmer(38,0) Used to join to the Segments table. -2333871387956621113
CATEGORY_07_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_08_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_09_KEY nubmer(38,0) Used to join to the Segments table. 2333871387956621113
CATEGORY_10_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_11_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_12_KEY nubmer(38,0) Used to join to the Segments table. -2333871387956621113
CATEGORY_13_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_14_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
CATEGORY_15_KEY nubmer(38,0) Used to join to the Segments table. 8817975702393619368
TYPE number(38,0) Indicates the fact type of the row. 1 = Buyer Attribution Touchpoint 2 = Cost 3 = Buyer Touchpoint 4 = User Touchpoint 5 = Page View 6 = Session 7 = Form Submit 8 = Impression 3
DATE date Date the event occurred. 2018-08-28
TIMESTAMP timestamp_ntz Date and time the event occurred. 2018-08-28 19:39:15.000

MODIFIED_DATE

timestamp_ntz

Date the row was last modified.

2018-08-29 00:46:47.000

COST_IN_MICRO

number(38,0)

Cost amount in millions. User will need to divide the value by 1000000.

27370000

IMPRESSIONS

number(38,0)

Number of impressions reported for the group for the day.

340

CLICKS

number(38,0)

Number of clicks reported for the group for the day.

4

FIRST_CLICK_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's a first touch.

0.0000000000000000000

LAST_ANON_CLICK_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's a lead creation touch.

100.0000000000000000000

U_SHAPE_PERCENTAGE

number(22,19)

The calculated percentage that gets allocated to this touchpoint because it's part of a u-shaped touch.

100.0000000000000000000

W_SHAPE_PERCENTAGE

number(22,19)

The calculated percentage that gets allocated to this touchpoint because it's part of a w-shaped touch.

0.0000000000000000000

FULL_PATH_PERCENTAGE

number(22,19)

The calculated percentage that gets allocated to this touchpoint because it's part of a full path model.

0.0000000000000000000

CUSTOM_MODEL_PERCENTAGE

number(22,19)

The calculated percentage that gets allocated to this touchpoint because it's part of a custom model.

0.0000000000000000000

AMOUNT

number(38,8)

Amount of the Opportuity, from the source system.

42000.00000000

IS_WON

boolean

Indicates if the Opportunity has been moved to a stage which is classified as won.

false

IS_OPP_CLOSED

boolean

Indicates if the Opportunity has moved to a stage which is classifed as closed.

false

OPPORTUNITY_ID

varchar

Opportunity Id from the source system.

0060Z00000nFEfEQAW

OPP_CREATED_DATE

timestamp_ntz

Date the Opportunity was created, from the source system.

2018-08-31 15:45:47.000

OPP_CLOSE_DATE

timestamp_ntz

Close date for the Opportunity, from the source system.

2018-12-31 07:00:00.000

CONTACT_CREATED_DATE

timestamp_ntz

Date the Contact record was created, from the source system.

2017-04-28 00:21:52.000

CONTACT_ID

varchar

Contact Id from the source system.

0030Z00003ORVJmQAP

EMAIL varchar Email address for the record. personb@adobe.com

LEAD_CREATED_DATE

timestamp_ntz

Date the Lead record was created, from the source system.

2017-04-28 00:21:52.000

LEAD_ID

varchar

Lead Id from the source system.

00Q3100001GMPIsEAP

IS_AGGREGATABLE_COST_AD

boolean

Indicates if the row contains Cost which can be summed up by Ad. (i.e. to get Ad Cost, sum rows where this column equals true.)

false

IS_AGGREGATABLE_COST_ADVERTISER

boolean

Indicates if the row contains Cost which can be summed up by Advertiser. (i.e. to get Advertiser Cost, sum rows where this column equals true.)

true

IS_AGGREGATABLE_COST_AD_ACCOUNT

boolean

Indicates if the row contains Cost which can be summed up by Account. (i.e. to get Account Cost, sum rows where this column equals true.)

false

IS_AGGREGATABLE_COST_AD_GROUP

boolean

Indicates if the row contains Cost which can be summed up by Ad Group. (i.e. to get Ad Group Cost, sum rows where this column equals true.)

false

IS_AGGREGATABLE_COST_CAMPAIGN

boolean

Indicates if the row contains Cost which can be summed up by Campaign. (i.e. to get Campaign Cost, sum rows where this column equals true.)

true

IS_AGGREGATABLE_COST_CHANNEL

boolean

Indicates if the row contains Cost which can be summed up by Channel. (i.e. to get Channel Cost, sum rows where this column equals true.)

false

IS_AGGREGATABLE_COST_CREATIVE

boolean

Indicates if the row contains Cost which can be summed up by Creative. (i.e. to get Creative Cost, sum rows where this column equals true.)

false

IS_AGGREGATABLE_COST_KEYWORD

boolean

Indicates if the row contains Cost which can be summed up by Keyword. (i.e. to get Keyword Cost, sum rows where this column equals true.)

false

IS_AGGREGATABLE_COST_PLACEMENT

boolean

Indicates if the row contains Cost which can be summed up by Placement. (i.e. to get Placement Cost, sum rows where this column equals true.)

false

IS_AGGREGATABLE_COST_SITE

boolean

Indicates if the row contains Cost which can be summed up by Site . (i.e. to get Site Cost, sum rows where this column equals true.)

false

IS_DELETED

boolean

Whether or not the record was deleted, used as an audit trail.

false

CURRENCY_ID number(38,0) Id value of the Currency for the record. -3253183181619994799
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_FORM_SUBMITS

Captured Form Submissions.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Form Submit.

2018-08-06:01-35-21-927280.9bc63c34482f4

COOKIE_ID

varchar

The recorded cookie id at the time the Form Submit was logged.

9bc63c34482f4de8c2e3b9d8d9f0df56

VISITOR_ID

varchar

The first cookie id of the related visitor id. If the record is marked as is_duplicated = true, this field will be null.

v_9bc63c34482f4de8c2e3b9d8d9f0df56

SESSION_ID

varchar

The recorded Session Id at the time the Form Submit was logged. If the record is marked as is_duplicated = true, this field will be null.

2018-08-06:01-35-24-1231230.9bc63c34482f

EVENT_DATE

timestamp_ntz

Date the Form was submitted.

2018-08-06 01:35:21.000

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-07 23:09:52.000

CURRENT_PAGE

varchar

URL where the Form was submitted, without query parameters.

https://info.adobe.com/webinar-marketo-measure-impact

CURRENT_PAGE_RAW

varchar

URL where the Form was submitted, including any query parameters.

https://info.adobe.com/webinar-marketo-measure-impact?utm_source=partner&mkt_tok=eyJpIjoiTnpBeE1EVml PV0UyWlRObSIsInQiOiI3MEFIek04ZVJiWm9renc1Z29RXC9kXC92YkxycFRYclE0MVhOaH Nwdml3YTZBZDdPdXh4Q0RmcnBJWXhwZTF1Z0RrbXlDVmxJNzIwNkhW

IP_ADDRESS

varchar

The recorded IP address at the time the Form was submitted.

174.127.184.158

TYPE

varchar

Indicates the type of Event.

FormSubmit

USER_AGENT_STRING

varchar

Device and browser recorded at the time of the Form Submit.

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1.2 Safari/605.1.15

CLIENT_SEQUENCE

varchar

Indicates the order in which the Page View occurred in the Session.

4

CLIENT_RANDOM

varchar

Used for internal auditing and processing.

20042b6b7af44512b43f6244d86faf4c

IS_DUPLICATED

boolean

Indicates if the record is considered a duplicate.

false

IS_PROCESSED

boolean

Used for internal processing.

true

EMAIL

varchar

Email address provided on the Form, as captured from the javascript.

personc@adobe.com

FORM_TYPE

varchar

Indicates the type of Form submitted.

Chat

FORM_SOURCE

varchar

Indicates the method in which the Form was recognized, such as onSubmit or AjaxIntercept

onSubmit

FORM_IDENTIFIER

varchar

Id value for the Form.

-956012665

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-6255315750913680000

CURRENT_PAGE_KEY number(38,0) Foreign Key to the Url table. 6255315750913680000
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_IMPRESSIONS

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

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Impression.

6acd7b43290490fe5c53eed31281d09a|2020-05-18:22:20:59|0000|0|2869369052

COOKIE_ID

varchar

The recorded cookie id at the time of the Impression.

08c1063cb0a64349ad0d2d862f5cc700

VISITOR_ID

varchar

The first cookie id of the related visitor id.

v_08c1063cb0a64349ad0d2d862f5cc700

SESSION_ID

varchar

The recorded Session Id at the time the Impression was logged.

2018-08-06:01-35-24-1231230.9bc63c34482f

EVENT_DATE

timestamp_ntz

Date the Impression was served.

2020-01-01 01:01:00.000

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2020-01-01 01:01:00.000

CURRENT_PAGE

varchar

URL where the Impression was served, without query parameters.

https://info.adobe.com/webinar-marketo-measure-impact

CURRENT_PAGE_RAW

varchar

URL where the Impression was served, including any query parameters.

https://info.adobe.com/webinar-marketo-measure-impact?utm_source=partner&mkt_tok=eyJpIjoiTnpBeE1EVml PV0UyWlRObSIsInQiOiI3MEFIek04ZVJiWm9renc1Z29RXC9kXC92YkxycFRYclE0MVhOaH Nwdml3YTZBZDdPdXh4Q0RmcnBJWXhwZTF1Z0RrbXlDVmxJNzIwNkhW

IP_ADDRESS

varchar

The recorded IP address at the time of the Impression.

174.127.184.158

TYPE

varchar

Indicates the type of Event. Impression

USER_AGENT_STRING

varchar

Device and browser recorded at the time of the Form Submit.

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1.2 Safari/605.1.15

CLIENT_SEQUENCE

varchar

Indicates the order in which the Page View occurred in the Session.

4

CLIENT_RANDOM

varchar

Used for internal auditing and processing.

20042b6b7af44512b43f6244d86faf4c

IS_DUPLICATED

boolean

Indicates if the record is considered a duplicate.

false

IS_PROCESSED

boolean

Used for internal processing.

true

REFERRER_PAGE

varchar

Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".

https://www.linkedin.com/

REFERRER_PAGE-RAW

varchar

Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".

https://www.linkedin.com/

CITY

varchar

The resolved city from the IP address.

Seattle

REGION

varchar

The resolved region from the IP address.

Washington

COUNTRY

varchar

The resolved country from the IP address.

United States

ISP_NAME

varchar

The name of the internet service provider, used by customers with advanced Geo IP tracking.

AT&T U-verse

AD_PROVIDER

varchar

Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.

Google

ACCOUNT_UNIQUE_ID

varchar

Id of the Ad Account in which the ad was resolved from.

aw.6601259029

ACCOUNT_NAME

varchar

Name of the Ad Account in which the ad was resolved from.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Market Measure Marketing Analytics

SITE_UNIQUE_ID

varchar

Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651

SITE_NAME

varchar

Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Quora.com

PLACEMENT_UNIQUE_ID

varchar

Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827

PLACEMENT_NAME

varchar

Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

roadblock

CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign from the Ad Account in which the Ad was resolved from.

aw.6601259029.317738075

CAMPAIGN_NAME

varchar

Name of the Campaign from the Ad Account in which the Ad was resolved from.

Marketing Attribution

AD_GROUP_UNIQUE_ID

varchar

Expected to be null since there is no Ad Group in the Doubleclick hierarchy for impressions

null

AD_GROUP_NAME

varchar

Expected to be null since there is no Ad Group in the Doubleclick hierarchy for impressions

null

AD_UNIQUE_ID

varchar

Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

68035923

AD_NAME

varchar

Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

centurylink_banner_98121

CREATIVE_UNIQUE_ID

varchar

Expected to be null since there is no Creative in the Doubleclick hierarchy for Impressions.

null

CREATIVE_NAME

varchar

Expected to be null since there is no Creative in the Doubleclick hierarchy for Impressions.

null

CREATIVE_DESCRIPTION_1

varchar

Expected to be null since there is no Creative in the Doubleclick hierarchy for Impressions.

null

CREATIVE_DESCRIPTION_2

varchar

Expected to be null since there is no Creative in the Doubleclick hierarchy for Impressions.

null

CREATIVE_DESTINATION_URL

varchar

Expected to be null since there is no Creative in the Doubleclick hierarchy for Impressions.

null

CREATIVE_DISPLAY_URL

varchar

Expected to be null since there is no Creative in the Doubleclick hierarchy for Impressions.

null

KEYWORD_UNIQUE_ID

varchar

Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.

null

KEYWORD_NAME

varchar

Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.

null

KEYWORD_MATCH_TYPE

varchar

Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.

null

BROWSER_NAME

varchar

From the javascript and IP address, the detected browser that the user was on during the session.

Chrome

BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session.

58

PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session.

Mac

PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session.

10_12

ROW_KEY

number(38,0)

Foreign Key to the BIZ_FACTS view.

-2712935512233520000

CURRENT_PAGE_KEY

number(38,0)
REFERRER_PAGE_KEY number(38,0)
ACCOUNT_ROW_KEY number(38,0)
ADVERTISER_ROW_KEY number(38,0)
SITE_ROW_KEY number(38,0)
PLACEMENT_ROW_KEY number(38,0)
CAMPAIGN_ROW_KEY number(38,0)
AD_ROW_KEY number(38,0)
AD_GROUP_ROW_KEY number(38,0)
CREATIVE_ROW_KEY number(38,0)
KEYWORD_ROW_KEY number(38,0)
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_KEYWORDS

Keywords imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Keyword.

ba.3284209.132630532.3646889365.39464932147

DISPLAY_ID

varchar

The Keyword Id from the source system.

39464932147

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Keyword was imported.

fb.106851586409075

AD_ACCOUNT_NAME

varchar

Name of the Ad Account from which the Keyword was imported.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.

null

ADVERTISER_NAME

varchar

Expected to be null since there is no Keyword in the Doubleclick hierarchy for Impressions.

null

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group for the Keyword.

ba.3284209.132630532.3646889365

AD_GROUP_NAME

varchar

Name of the Ad Group for the Keyword.

Revenue Attribution - B2B

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the Keyword.

ba.3284209.132630532

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the Keyword.

Revenue Attribution

IS_ACTIVE

boolean

Whether or not the Keyword is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Keyword has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:37:29.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:37:29.000

NAME

varchar

Name of the Keyword, from the source system.

[revenue attribution b2b]

NEEDS_UPDATE

boolean

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

(Diagnostic field, used for internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, used for internal processing.

ba.3284209.132630532.3646889365

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Keyword".

Keyword

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Keyword.

BingAds

URL_CURRENT

varchar

The URL for the landing page.

(Diagnostic field, for internal processing.)

URL_OLD

varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED varchar

The URL for the landing page with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

IS_UPGRADED_URL

boolean

Diagnostic field, for internal processing.

false

WORD

varchar

The search phase the user entered.

revenue attribution b2b

MATCH_TYPE

varchar

The type of match that was found between the search phrase and the Keyword.

Exact

TRACKING_URL_TEMPLATE

varchar

Used for internal diagnostics. http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}

TRACKING_URL_TEMPLATE_OLD

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_REQUESTED

varchar

Used for internal diagnostics.

TRACKING_URL_TEMPLATE_APPLIED

varchar

The URL tracking template Marketo Measure added to the Keyword.

http://cdn.adobe.com/redir?lp={lpurl}&_bt={creative}&_bk={keyword}&_bm={matchType}

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-2712935512233520000
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_LANDING_PAGES

Landing Pages imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Landing Page.

DISPLAY_ID

varchar

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the landing page was imported.

AD_ACCOUNT_NAME

varchar

Name of the Ad Account from which the landing page was imported.

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser for the landing page, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser for the landing page, specifically for Doubleclick.

Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group for the landing page.

AD_GROUP_NAME

varchar

Name of the Ad Group for the landing page.

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the landing page.

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the landing page.

IS_ACTIVE

boolean

IS_DELETED

boolean

MODIFIED_DATE

timestamp_ntz

The last modified date of the row.

FIRST_IMPORTED

timestamp_ntz

NAME

varchar

NEEDS_UPDATE

boolean

GROUPING_KEY

varchar

ENTITY_TYPE

varchar

PROVIDER_TYPE

varchar

URL_CURRENT

varchar

URL_OLD

varchar

URL_REQUESTED

varchar

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_LEADS

Leads imported from the source system.

Column

Data Type

Description

Sample Data

ID

varchar

The Lead Id from the source system.

00Q0Z00001MZcj8UAD

MODIFIED_DATE

timestamp_ntz

Date the Lead record was last modified, from the source system.

2018-08-27 21:52:10.000

CREATED_DATE

timestamp_ntz

Date the Lead record was created, from the source system.

2018-08-27 21:52:10.000

EMAIL

varchar

Email address of the Lead, from the source system.

persona@adobe.com

WEB_SITE

varchar

Website entered for the Lead, from the source system, used for Lead2Account mapping.

adobe.com

COMPANY

varchar

Company name entered for the Lead, from the source system, used for Lead2Account mapping.

Marketo Measure

LEAD_SOURCE

varchar

Source in which the Lead was created.

Advertisement

IS_CONVERTED

boolean

Whether or not the Lead has been converted to a Contact.

true

CONVERTED_OPPORTUNITY_ID

varchar

Id of the related Opportunity once the Lead has been converted.

0013100001b44aGAAQ

CONVERTED_DATE

timestamp_ntz

Date the Lead was converted to a Contact.

2018-08-27 07:00:00.000

CONVERTED_CONTACT_ID

varchar

Id of the related Contact once the Lead has been converted.

0030Z00003Oyp25QAB

ACCOUNTID

varchar

Id of the mapped Account. Requirements: Enable ABM

0010Z0000236F9GQAU

BIZIBLE_STAGE

varchar

Current stage of the Lead, recognized as a custom stage which can be created in the Marketo Measure application.

Demo Scheduled

BIZIBLE_STAGE_PREVIOUS

varchar

All previous stages for the Lead, recognized as custom stages which can be created in the Marketo Measure application.

MQL

ODDS_OF_CONVERSION

number(38,19)

This feature has been deprecated. Please do not use this column.

N/A

LEAD_SCORE_MODEL

varchar

(deprecated)

null

LEAD_SCORE_RESULTS

varchar

(deprecated)

null

BIZIBLE_COOKIE_ID

varchar

The Marketo Measure Cookie Id used to populate from an integration partner to map an offline event to a web session. Requirement: Enable Call Tracking: True

08c1063cb0a64349ad0d2d862f5cc700

IS_DELETED

boolean

Whether or not the record is deleted in the source system.

false

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

3263982503087870000
CUSTOM_PROPERTIES varchar Custom properties that Marketo Measure has imported from the source system , in JSON format. {"Lead_Type__c":"Sales Created", "Foo":"Bar"}
IS_DUPLICATE boolean Used to de-duplicate records if both a CRM and Marketo integration are set up. If there are duplicates, the Marketo Lead is marked true. true
SOURCE_SYSTEM varchar Indicates if the record came from a CRM or a Marketo integration. Crm
OTHER_SYSTEM_ID varchar Maps a person from a Marketo integration with a Lead from a CRM integration. If both a CRM and Marketo integration exist, the value is the corresponding Id. 1234
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_LEAD_STAGE_TRANSITIONS

Stage transitions for Leads or Contacts.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the transition.

ST_0030Z00003FhkRXQAZ__FT-1_TP2_Person_0030Z00003FhkRXQAZ_2018-08-27:17-05-45-9474800.0d5c18c29d7b

EMAIL

varchar

The provided email address for the related Lead/Contact.

persone@adobe.com

LEAD_ID

varchar

Id for the Lead associated to the transition.

00Q3100001Fx6AlEAJ

CONTACT_ID

varchar

Id for the Contact associated to the transition.

0033100003Aq9grAAB

TOUCHPOINT_ID

varchar

Id for the Buyer Touchpoint tied to the transition.

TP2_Person_00Q3100001Fx6AlEAJ_2018-08-28:14-41-06-1674260.d00ceb09fbd3

TRANSITION_DATE

timestamp_ntz

Date the record transitioned into the stage.

2018-08-27 16:05:34.000

STAGE_ID

varchar

Id value of the stage for the transition.

_bizible_FT

STAGE

varchar

Name of the stage for the transition.

FT

RANK

number(38,0)

The numerical rank of the stage, as ordered in the Marketo Measure Stage Mapping settings.

5

INDEX

varchar(1)

Used in internal processing for indexing and ordering boomerang stages.

1

LAST_INDEX

varchar(1)

Used in internal processing for indexing and ordering boomerang stages.

1

IS_PENDING

boolean

Indicates if the touchpoint is considered pending and not yet closed. This only appears for customers with full path attribution model.

false

IS_NON_TRANSITIONAL

boolean

Indicates if the the row is tied to a milestone stage transition. For example, if there are 3 stages/entries (FT, LC, MQL) and 4 touchpoints, the 1 touchpoint without a stage on it is considered "non-transitional" so the value would equal true.

false

PREVIOUS_STAGE_DATE

timestamp_ntz

Transition date for the previous stage, according to the stage rank.

2017-11-28 21:26:44.000

NEXT_STAGE_DATE

timestamp_ntz

Transition date for the next stage, according to the stage rank.

2017-12-11 22:39:17.000

MODIFIED_DATE

timestamp_ntz

Last modified date of the record.

2018-08-28 15:31:10.000

IS_DELETED

boolean

Whether or not the transition record is considered deleted.

false

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_OPPORTUNITIES

Opportunities imported from the source system.

Column

Data Type

Description

Sample Data

ID

varchar

The Opportunity Id from the source system.

0060Z00000o89I4QAI

MODIFIED_DATE

timestamp_ntz

The last modified date of the Opportunity, from the source system.

2017-11-28 21:26:44.000

CREATED_DATE

timestamp_ntz

The created date of the Opportunity, from the source system.

2017-11-28 21:26:44.000

ACCOUNT_ID

varchar

Id of the related Account.

001i000000qbyeoAAA

NAME

varchar

The Opportunity Name, from the source system.

Mareketo Measure Renewal

IS_WON

boolean

Indicates if the Opportunity has moved to a stage considered won.

false

IS_CLOSED

boolean

Indicates if the Opportunity has moved to a stage considered closed.

false

CLOSE_DATE

timestamp_ntz

Anticipated or actual close date of the Opportunity, from the source system.

2019-08-28 07:00:00.000

BIZIBLE_CUSTOM_MODEL_DATE

timestamp_ntz

(deprecated)

null

AMOUNT

number(38,8)

Deal amount which is expected or closed from the Opportunity, from the source system.

8988.00000000

CONVERTED_FROM_LEAD_ID

varchar

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

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

null

CONVERTED_FROM_LEAD_EMAIL

varchar

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

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

null

PRIMARY_CONTACT_ID

varchar

If Primary Contact Role is used, the Id of the related Contact listed as the primary contact role.

00331000038uGfhAAE

PRIMARY_CONTACT_EMAIL

varchar

If Primary Contact Role is used, the email of the related Contact listed as the primary contact role.

personb@adobe.com

ODDS_OF_CONVERSION

number(38,19)

This feature has been deprecated. Please do not use this column.

N/A

BIZIBLE_STAGE

varchar

Current stage of the Opportunity, as defined in the Marketo Measure application.

DM Demo

BIZIBLE_STAGE_PREVIOUS

varchar

A string of all stages the Opportunity has previously gone through, as defined in the Marketo Measure application.

Qualified Discovery, Demo Scheduled

IS_DELETED

boolean

Whether or not the record is deleted in the source system.

false

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

4609512587744160000

CURRENCY_ISO_CODE varchar ISO code for the currency, imported from the source system. USD
CURRENCY_ID number(38,0) Id value of the Currency for the record. 4609512587744160000
CUSTOM_PROPERTIES varchar Custom properties that Marketo Measure has imported from the source system , in JSON format. {"Opportunity_Location__c":"Seattle", "Foo":"Bar"}
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_OPP_STAGE_TRANSITIONS

Stage transitions for Opportunities.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the transition.

ST_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_Demo Scheduled-1_BAT2_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_2018-06-01:19-51-38-1685390.beec556e7757

ACCOUNT_ID

varchar

Id for the Account associated with the Opportunity.

0013100001b44nTAAQ

OPPORTUNITY_ID

varchar

Id for the Opportunity associatedto the transition.

0060Z00000nEgjlQAC

CONTACT_ID

varchar

Id for the Contact associated to the transition.

0030Z00003IjojKQAR

EMAIL

varchar

The provided email address for the related Contact.

persone@adobe.com

TOUCHPOINT_ID

varchar

Id for the Buyer Attribution Touchpoint tied to the transition.

BAT2_0060Z00000nEgjlQAC_0030Z00003IjojKQAR_2018-06-01:19-51-38-1685390.beec556e7757

TRANSITION_DATE

timestamp_ntz

Date the record transitioned into the stage.

2018-05-26 07:29:43.000

STAGE

varchar

Name of the stage for the transition.

Demo Scheduled

STAGE_ID

varchar

Id value of the stage for the transition.

_bizible_FT

RANK

number(38,0)

The numerical rank of the stage, as ordered in the Marketo Measure Stage Mapping settings.

4

INDEX

varchar(1)

Used in internal processing for indexing and ordering boomerang stages.

1

LAST_INDEX

varchar(1)

Used in internal processing for indexing and ordering boomerang stages.

1

IS_PENDING

boolean

Indicates if the touchpoint is considered pending and not yet closed. This only appears for customers with full path attribution model.

false

IS_NON_TRANSITIONAL

boolean

Indicates if the the row is tied to a milestone stage transition. For example, if there are 3 stages/entries (FT, LC, MQL) and 4 touchpoints, the 1 touchpoint without a stage on it is considered "non-transitional" so the value would equal true.

false

PREVIOUS_STAGE_DATE

timestamp_ntz

Transition date for the previous stage, according to the stage rank.

2015-07-16 17:41:49.000

NEXT_STAGE_DATE

timestamp_ntz

Transition date for the next stage, according to the stage rank.

2018-08-27 19:40:52.000

MODIFIED_DATE

timestamp_ntz

Last modified date of the record.

2018-08-28 03:53:33.000

IS_DELETED

boolean

Whether or not the transition record is considered deleted.

false

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_PAGE_VIEWS

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

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Page View.

2018-08-19:16-49-58-24340.277d79d0167849

COOKIE_ID

varchar

The recorded cookie id at the time the Page View was logged.

277d79d01678498fea067c9b631bf6df

VISITOR_ID

varchar

The first cookie of the related visitor id.

v_277d79d01678498fea067c9b631bf6df

SESSION_ID

varchar

The Session id correlated with the Page View.

2018-08-19:16-49-58-24340.277d79d0167849

EVENT_DATE

timestamp_ntz

Date the Page View occurred.

2018-08-19 16:49:58.000

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-19 16:55:37.000

CURRENT_PAGE

varchar

URL of the Page View, without query parameters.

https://info.adobe.com/demo

CURRENT_PAGE_RAW

varchar

URL of the Page View, including any query parameters.

https://info.adobe.com/demo?hsCtaTracking=207219e9-87b6-4105-8f4b-0a3b62ae1af8%7C48060522-3aeb-4c72-8ce5-fd4b1017f069

IP_ADDRESS

varchar

The recorded IP address at the time the Form was submitted.

174.127.184.158

TYPE

varchar

Indicates the type of Event.

PageView

USER_AGENT_STRING

varchar

Device and browser recorded at the time of the Form Submit.

Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0

CLIENT_SEQUENCE

varchar(1)

Indicates the order in which the Page View occurred in the Session.

1

CLIENT_RANDOM

varchar

Used for internal auditing and processing.

103532

IS_DUPLICATED

boolean

Indicates if the record is considered a duplicate. false

IS_PROCESSED

boolean

Used for internal processing. true

REFERRER_PAGE

varchar

URL where the Page View originated from, without query parameters.

http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution

REFERRER_PAGE_RAW

varchar

URL where the Page View originated from, including any query parameters.

http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution?utm_source=linkedin&utm_medium=Social&utm_campaign=SU%20-%20CMO%20JT&utm_content=CMOs%20Guide&utm_term=lisu05091601

PAGE_TITLE

varchar

Title of the Page.

The CMO's Guide to B2B Marketing Attribution Download

EMAIL

varchar

Email address provided on a Form, as captured from the javascript.

personc@adobe.com

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-6255315750913680000

CURRENT_PAGE_KEY number(38,0) Foreign Key to the Url table. 6255315750913680000
REFERRER_PAGE_KEY number(38,0) Foreign Key to the Url table. 6255315750913680000
HAS_USER_CONSENT boolean Indicates if the user has consented to tracking. False means the Page View has been collected because user consent is not required. True means the Page View has been collected and the user has given consent to be tracked. true
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_PLACEMENTS

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

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Placement.

ba.3284209.132855866.4556709270.10426699711

DISPLAY_ID

varchar

The Placement Id from the source system. 10426699711

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Placement was imported.

fb. 106851586409075

AD_ACCOUNT_NAME

varchar

Name for the Ad Account from which the Placement was imported.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser for the Placement, specifically for Doubleclick.

300184624

ADVERTISER_NAME

varchar

Name of the Advertiser for the Placement, specifically for Doubleclick.

Marketo Measure Analytics

AD_GROUP_UNIQUE_ID

varchar

Expected to be null since there is no Ad Group above the Placement in any ads hierarchy.

null

AD_GROUP_NAME

varchar

Expected to be null since there is no Ad Group above the Placement in any ads hierarchy.

null

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the Placement.

ba.3284209.132855866

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the Placement.

Pipeline Marketing

IS_ACTIVE

boolean

Whether or not the Placement is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Placement has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:36:25.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:36:25.000

NAME

varchar

Name of the Placement, from the source system.

Market

NEEDS_UPDATE

boolean

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

(Diagnostic field, used by internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, for internal processing.

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Placement".

Placement

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Placement.

BingAds

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

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

BIZ_SEGMENTS

Segment values as defined in the Marketo Measure application.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Segment.

New Business

NAME

varchar

Name of the Segment.

New Business

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

1028715376434030000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_SEGMENT_NAMES

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

Column

Data Type

Description

Sample Data

CATEGORY

varchar

Indicates the category the segment name is mapped to.

CategoryOne

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2022-02-28 18:12:35.000

SEGMENT_NAME

varchar

Name of the segment mapped to the category.

1028715376434030000

IS_ACTIVE boolean Indicates if the category is in use. true
IS_DELETED boolean Indicates if the record is deleted. false
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_SESSIONS

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

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Session.

2016-08-01:14-24-21-9079480.33163948f0a3

VISITOR_ID

varchar

The first cookie of the related visitor id.

v_277d79d01678498fea067c9b631bf6df

COOKIE_ID

varchar

The recorded cookie id of the Session.

277d79d01678498fea067c9b631bf6df

EVENT_DATE

timestamp_ntz

Date of the Session.

2016-08-01 14:24:21.000

MODIFIED DATE

timestamp_ntz

Date the record was last modified.

2018-09-01 03:49:10.000

IS_FIRST_SESSION boolean Indicates if this is the first Session for the visitor id. true

CHANNEL

varchar

Channel attirbuted to the Session, as defined by the Channel definitions set in the Marketo Measure application.

Paid Search.AdWords

PAGE_TITLE

varchar

Name of the web page.

Salesforce Google Analytics | Marketo Measure

LANDING_PAGE

varchar

URL of the first Page View of the Session, without query parameters.

http://www.adobe.com/salesforce-google-analytics

LANDING_PAGE_RAW

varchar

URL of the first Page View of the Session, including any query parameters.

http://www.adobe.com/salesforce-google-analytics?_bt=83558988035&_bk=google%20analytics%20salesforce&_bm= p&gclid=CMvd5YTLo84CFUI9gQodd-kLEQ

REFERRER_PAGE

varchar

URL where the Session originated from, without query parameters.

https://www.google.com/

REFERRER_PAGE_RAW

varchar

URL where the Session originated from, including any query parameters.

https://www.google.com/

REFERRER_NAME

varchar

Name of the referrer page.

Google

SEARCH_PHRASE

varchar

The value that the user entered in the browser to search for and ended up on the website.

Marketo Measure google salesforce

WEB_SOURCE

varchar

Used to define the source that resulted in the Session. This can be parsed out from the URL from utm_source or set to an Ad Provider if Marketo Measure is able to resolve an ad.

Google AdWords

HAS_FORM

boolean

Whether or not the Session contained a Form fill,

true

HAS_CHAT

boolean

Whether or not the Session contained a web chat.

false

HAS_EMAIL

boolean

Whether or not the Session had an email address.

false

HAS_CRM_ACTIVITY

boolean

Whether or not the Sesssion came from a CRM activity record.

false

DEVICE

varchar

The browser and operating system of the user during the Session.

Chrome (65.0), Windows (6.1)

AD_PROVIDER

varchar

The Ad platform Marketo Measure resolvde from, typically one of our integration partners.

Google

ACCOUNT_UNIQUE_ID

varchar

Id of the Ad Account which the ad was resolved from.

aw.6601259029

ACCOUNT_NAME

varchar

Name of the Ad Account which the ad was resolved from.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser the Ad was resolved from, specifically from Doubleclick connection.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser the Ad was resolved from, specifically from Doubleclick connection.

Marketing Analytics

SITE_UNIQUE_ID

varchar

Id of the Site the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651

SITE_NAME

varchar

Name of the Site the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Quora.com

PLACEMENT_UNIQUE_ID

varchar

Id of the Palcement the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827

PLACEMENT_NAME

varchar

Name of the Placement the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

roadblock

CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign the Ad was resolved from.

aw.6601259029.321586235

CAMPAIGN_NAME

varchar

Name of the Campaign the Ad was resolved from.

Planning Your Budget Webinar

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group the Ad was resolved from. This only applies to Google Adwords.

aw.6601259029.321586235.23182235435

AD_GROUP_NAME

varchar

Name of the Ad Group the Ad was resolved from. This only applies to Google Adwords.

Salesforce - Google Analytics

AD_UNIQUE_ID

varchar

Id of the Ad resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

aw.6601259029.321586235.23182235435

AD_NAME

varchar

Name of the Ad resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

Winter Promo - Green

CREATIVE_UNIQUE_ID

varchar

Id of the Creative the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.321586235.23182235435.83558988035

CREATIVE_NAME

varchar

Name of the Creative the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Integrate GA & Salesforce

CREATIVE_DESCRIPTION_1

varchar

The first line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Integrate Salesforce & Analytics To

CREATIVE_DESCRIPTION_2

varchar

The second line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Optimize for Revenue. Learn How.

CREATIVE_DESTINATION_URL

varchar

The landing page that clicks through from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

http://www.adobe.com/salesforce-google-analytics

CREATIVE_DISPLAY_URL

varchar

The friendly URL name that's shown on the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

adobe.com/Salesforce-for-GA

KEYWORD_UNIQUE_ID

varchar

Id of the Keyword the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.321586235.23182235435.35934468937

KEYWORD_NAME

varchar

Name of the Keyword the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

google analytics salesforce

KEYWORD_MATCH_TYPE

varchar

The type of match found between the search phrase and the purchased keyword.

Phrase

CAMPAIGN

varchar

Parsed from the URL from utm_campaign.

SU - ABC Accounts - Paid Media Skills

SOURCE

varchar

Parsed from the URL from utm_source.

linkedin

MEDIUM

varchar

Parsed from the URL from utm_medium.

Social

TERM

varchar

Parsed from the URL from utm_term.

lisu07261601

CONTENT

varchar

Parsed from the URL from utm_content.

2016 AdWords Benchmark Report

CITY

varchar

The resolved city from the IP address.

Vancouver

REGION

varchar

The resolved region from the IP address.

British Columbia

COUNTRY

varchar

The resolved country from the IP address.

Canada

ISP_NAME

varchar

The internet service provider of the user

AT&T U-verse

IP_ADDRESS

varchar

The recorded IP address at the time the Session.

174.127.184.158

IS_DELETED

boolean

Determines if this Session was merged with another and should be deleted.

false

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-2712935512233520000

LANDING_PAGE_KEY number(38,0)
REFERRER_PAGE_KEY number(38,0)
ACCOUNT_ROW_KEY number(38,0)
ADVERTISER_ROW_KEY number(38,0)
SITE_ROW_KEY number(38,0)
PLACEMENT_ROW_KEY number(38,0)
CAMPAIGN_ROW_KEY number(38,0)
AD_ROW_KEY number(38,0)
AD_GROUP_ROW_KEY number(38,0)
CREATIVE_ROW_KEY number(38,0)
KEYWORD_ROW_KEY number(38,0)
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_SITES

Sites imported from any connected Ad Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Site.

aw.3284209

DISPLAY_ID

varchar

The Site Id from the source system. 39464932147

AD_ACCOUNT_UNIQUE_ID

varchar

Id for the Ad Account from which the Site was imported.

aw.3284209

AD_ACCOUNT_NAME

varchar

Name of the Ad Account from which the Site was imported.

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser for the site, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

The name of the advertiser for the site, specifically for Doubleclick.

Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

Expected to be null since there is no Ad Group above Site in any ads hierarchy.

null

AD_GROUP_NAME

varchar

Expected to be null since there is no Ad Group above Site in any ads hierarchy.

null

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the Site.

ba.3284209.132630532

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the Site.

Revue Attribution

IS_ACTIVE

boolean

Whether or not the Site is still active in the source system.

true

IS_DELETED

boolean

Whether or not the Site has been deleted in the source system.

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:37:29.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:37:29.000

NAME

varchar

Name of the Site, from the source system.

Revenue

NEEDS_UPDATE

boolean

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

(Diagnostic field, used for internal processing.)

false

GROUPING_KEY

varchar

Diagnostic field, used for internal processing.

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "Site".

Site

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Site.

AdWords

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-2712935512233520000

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

Sites Links from any connected Ads Account.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the site link

aw.6601259029.285077795.1654234342

DISPLAY_ID

varchar

1654234342

AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the site link

aw.6601259029

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the site link

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser for the site link, specifically for Doubleclick.

300181641

ADVERTISER_NAME

varchar

The name of the advertiser for the site link, specifically for Doubleclick.

Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

The ID of the ad group for the site link

aw.6601259029.208548635.16750166675

AD_GROUP_NAME

varchar

The name of the ad group for the site link

Brand - Core

AD_CAMPAIGN_UNIQUE_ID

varchar

The ID of the campaign for the site link

aw.6601259029.285077795

AD_CAMPAIGN_NAME

varchar

The name of the campaign for the site link

Brand

IS_ACTIVE

boolean

Whether or not the site link is still active in the ads account

TRUE

IS_DELETED

boolean

Whether or not the site link has been deleted in the ads account

FALSE

MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-02 06:36:50.000

FIRST_IMPORTED

timestamp_ntz

The date that the site link was first downloaded by Marketo Measure

2018-08-02 06:36:50.000

NAME

varchar

The name of the site link

Link A

NEEDS_UPDATE

boolean

Whether or not the site link needs to get updated to get Marekto Measure tagging

FALSE

GROUPING_KEY

varchar

aw.6601259029.285077795

ENTITY_TYPE

varchar

The main object or entity for this table. In this case, "SiteLink"

SiteLink

PROVIDER_TYPE

varchar

The name of the ads provider for the site link

AdWords

URL_CURRENT

varchar

The URL for the landing page.

(Diagnostic field, for internal processing.)

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

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

URL_OLD

varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED

varchar

What the URL will be decorated with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

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

BIZ_STAGE_DEFINITIONS

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

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the Stage.

01J3100000QE753EAD

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-22 17:27:27.000

STAGE_NAME

varchar

Name of the Stage.

Verbal

IS_INACTIVE

boolean

Indicates if the Stage is considered inactive.

false

IS_IN_CUSTOM_MODEL

boolean

Indicates if the Stage is selected to track in the custom model.

false

IS_BOOMERANG

boolean

Indicates if the Stage is selected to track as a boomerang stage.

false

IS_TRANSITION_TRACKING

boolean

Indicates if the Stage is selected to track for transitions.

false

STAGE_STATUS

varchar

Status of the Stage, as defined in the Marketo Measure application Stage Mapping.

Open

IS_FROM_SALESFORCE

boolean

Indicates if the Stage is imported from an external source system.

true

IS_DEFAULT

boolean

Indicates if the Stage is set as a default.

false

RANK

number(38,0)

The numerical rank of the Stage, used to sort Stages in transitional order.

53

IS_DELETED

boolean

Whether or not the Stage has been deleted.

false

_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_TOUCHPOINTS

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

Column Data Type Description Sample Data

ID

varchar

A unique Id for the Buyer Touchpoint (BT).

TP2_Person_00Q0Z000013e2PYUAY_2018-08-27:20-04-40-5655690.1ee8567c175a

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-29 22:29:30.000

EMAIL

varchar

Email address associated with the BT.

person@adobe.com

CONTACT_ID

varchar

Id for the Contact associated with the BT.

0030Z00003K5bpKQAR

ACCOUNT_ID

varchar

Id for the Account associated with the BT.

0013100001lSLScAAO

LEAD_ID

varchar

Id for the Lead associated with the BT.

00Q0Z000013e2PYUAY

UNIQUE_ID_PERSON

varchar

The parent person record that relates to a Lead or Contact.

Person_00Q0Z000013e2PYUAY

USER_TOUCHPOINT_ID

varchar

Id for the User Touchpoint which generated the BT.

person@adobe.com_2018-08-29:18-14-53-8102030.10df92cbb414

VISITOR_ID varchar Id for the visitor associated with the BT. v_277d79d01678498fea067c9b631bf6df

TOUCHPOINT_DATE

timestamp_ntz

Date of the touchpoint.

2018-08-27 20:04:40.000

MARKETING_TOUCH_TYPE

varchar

The type of activity, Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity. Referred to in the CRM as "Touchpoint Type."

Web Form

CHANNEL

varchar

The channel the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. Referred to in the CRM as "Marketing Channel - Path."

Social.LinkedIn

CATEGORY1

varchar

The segment value for the 1st Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

ABC

CATEGORY2

varchar

The segment value for the 2nd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

Yes

CATEGORY3

varchar

The segment value for the 3rd Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

Other

CATEGORY4

varchar

The segment value for the 4th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

Partner

CATEGORY5

varchar

The segment value for the 5th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY6

varchar

The segment value for the 6th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY7

varchar

The segment value for the 7th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY8

varchar

The segment value for the 8th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY9

varchar

The segment value for the 9th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY10

varchar

The segment value for the 10th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY11

varchar

The segment value for the 11th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY12

varchar

The segment value for the 12th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY13

varchar

The segment value for the 13th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY14

varchar

The segment value for the 14th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

CATEGORY15

varchar

The segment value for the 15th Category the touchpoint falls into, as defined in the segment definitions within the Marketo Measure App. Referred to in the CRM as "Segments".

BROWSER_NAME

varchar

From the javascript and IP address, the detected browser that the user was on during the session.

Chrome

BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session.

68

PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session.

Windows

PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session.

10_12

LANDING_PAGE

varchar

The first landing page of the session which resulted in a touchpoint. Referred to in the CRM as "Landing Page".

https://info.adobe.com/definitive-guide-to-pipeline-marketing

LANDING_PAGE_RAW

varchar

The first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. Referred to in the CRM as "Landing Page - Raw".

https://info.adpbe.com/definitive-guide-to-pipeline-marketing?utm_source=linkedin&utm_medium=Social&utm_campaign=SU_COM_Demand_ Skills&utm_content=DGPM&utm_term=lisu03151846&_bl=66452504

REFERRER_PAGE

varchar

Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".

https://www.linkedin.com/

REFERRER_PAGE_RAW

varchar

Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".

https://www.linkedin.com/feed

FORM_PAGE

varchar

The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Touchpoints table, but rather in the Form_Submits table. Referred to in the CRM as "Form URL".

https://info.adobe.com/demo

FORM_PAGE_RAW varchar The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Touchpoints table, but rather in the Form_Submits table. A raw form page may contain query parameters in the URL. Referred to in the CRM as "Form URL - Raw". https://info.adobe.com/demo?hsCtaTracking=98adcc2f-afe2-40c4-9d79-40dcc41663ee%7C3cfaa909-39cb-4f5d-93eb-be05de6b0180

FORM_DATE

timestamp_ntz

Date the form submission occurred.

2017-06-20 01:06:41.000

CITY

varchar

From the javascript and IP address, the detected city the user was in during the session.

New York

REGION

varchar

From the javascript and IP address, the detected region the user was in during the session.

New York

COUNTRY

varchar

From the javascript and IP address, the detected country the user was in during the session.

United States

MEDIUM

varchar

Used to define the medium which resulted in the touchpoint. This can either be parsed out from the URL from utm_medium. Or, if Marketo Measure is able to resolve an ad, it may be values such as "cpc" or "display."

Social

WEB_SOURCE

varchar

Used to define the source which resulted in the touchpoint. This can be parsed out from the URL from utm_source, generically set as "CRM Campaign" if it was synced from the CRM, or if Marketo Measure is able to resolve an ad, it may be values such as "Google AdWords" or "Facebook." Referred to in the CRM as "Touchpoint Source".

LinkedIn

SEARCH_PHRASE

varchar

The value which the user entered in the browser to search for and ended up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform.

markeot measure attribution

AD_PROVIDER

varchar

Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.

LinkedIn

ACCOUNT_UNIQUE_ID

varchar

Id of the Ad Account in which the ad was resolved from.

li.502664737

ACCOUNT_NAME

varchar

Name of the Ad Account in which the ad was resolved from.

MM SC 2016_14605342_3/7-3/31/16

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Marketo Marketing Analytics

SITE_UNIQUE_ID

varchar

Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651

SITE_NAME

varchar

Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Quora.com

PLACEMENT_UNIQUE_ID

varchar

Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827

PLACEMENT_NAME

varchar

Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

roadblock

CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign from the Ad Account in which the Ad was resolved from.

li.502664737.138949954

CAMPAIGN_NAME

varchar

Name of the Campaign from the Ad Account in which the Ad was resolved from.

SU - COM Accounts - Demand Skills

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords.

aw.6601259029.317738075.23105327435

AD_GROUP_NAME

varchar

Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords.

Marketing Attribution - General

AD_UNIQUE_ID

varchar

Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

dc.6114.8882972.25272734.492579576

AD_NAME

varchar

Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

Budget Webinar - sidebar

CREATIVE_UNIQUE_ID

varchar

Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

li.502664737.138949954.66452504

CREATIVE_NAME

varchar

Name of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

lisu03151846

CREATIVE_DESCRIPTION_1

varchar

The first line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Lead gen is done

CREATIVE_DESCRIPTION_2

varchar

The second line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Download the definitive guide to pipeline marketing: https://lnkd.in/e9xYj5M

CREATIVE_DESTINATION_URL

varchar

The landing page that clicks through from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

https://image-store.slidesharecdn.com/d29165c0-1e0b-4ffc-a494-d2c77e7cd4a6-large.jpeg

CREATIVE_DISPLAY_URL

varchar

The friendly URL name that's shown on the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

marektomeasure.com/guide

KEYWORD_UNIQUE_ID

varchar

Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

__GAId__lisu03151846

KEYWORD_NAME

varchar

Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search)

lisu03151846

KEYWORD_MATCH_TYPE

varchar

The type of match found between the search phrase and the purchased keyword.

Broad

IS_FIRST_TOUCH

boolean

Whether or not this touchpoint is treated as the first touch of the opportunity journey.

true

IS_LEAD_CREATION_TOUCH

boolean

Whether or not this touchpoint is treated as the lead creation touch of the opportunity journey.

true

IS_OPP_CREATION_TOUCH

boolean

Whether or not this touchpoint is treated as the opportunity creation touch of the opportunity journey.

false

IS_CLOSED_TOUCH

boolean

Whether or not this touchpoint is treated as the closed touch of the opportunity journey.

false

STAGES_TOUCHED varchar This field has been deprecated. Use the Stage_Transitions tables for stage information. null

IS_FORM_SUBMISSION_TOUCH

boolean

Whether or not this touchpoint had a form fill during the session.

true

IS_IMPRESSION_TOUCH

boolean

Whether or not this touchpoint is treated as the first impression touch of the opportunity journey

false

FIRST_CLICK_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's a first touch (See Is_First_Touch).

100

LAST_ANON_CLICK_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's a lead creation touch (See Is_Lead_Creation_Touch).

100

U_SHAPE_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's part of a u-shaped touch (See Is_First_Touch and Is_Lead_Creation_Touch).

100

W_SHAPE_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's part of a w-shaped touch (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch). Expected to be 0 since this is a BT.

0

FULL_PATH_PERCENTAGE

number(22,19)

The calculated percentage allocated to this touchpoint because it's part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch). Expected to be 0 since this is a BT.

0

CUSTOM_MODEL_PERCENTAGE number(22,19) The calculated percentage allocated to this touchpoint because it's part of a custom model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch). Expected to be 0 since this is a BT.

0

IS_DELETED

boolean

Whether this touchpoint is deleted.

false

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-9004910726709710000

CONTACT_ROW_KEY

number(38,0)

LEAD_ROW_KEY

number(38,0)

LANDING_PAGE_KEY number(38,0)
REFERRER_PAGE_KEY number(38,0)
FORM_PAGE_KEY number(38,0)
ACCOUNT_ROW_KEY number(38,0)
ADVERISER_ROW_KEY number(38,0)
SITE_ROW_KEY number(38,0)
PLACEMENT_ROW_KEY number(38,0)
CAMPAIGN_ROW_KEY number(38,0)
AD_ROW_KEY number(38,0)
AD_GROUP_KEY number(38,0)
CREATIVE_ROW_KEY number(38,0)
KEYWORD_ROW_KEY number(38,0)
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_URLS

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

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

BIZ_USER_TOUCHPOINTS

All Touchpoints created from any event tied to an email.

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the User Touchpoint.

person@adobe.com_2018-01-05:16-47-02-8803320.ddf67c101f58

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-09-05 23:30:53.000

EMAIL

varchar

Email address associated with the User Touchpoint.

person@adobe.com

SESSION_ID

varchar

Id for the Session which created the User Touchpoint.

2018-01-05:16-47-02-8803320.ddf67c101f58

CAMPAIGN_MEMBER_ID

varchar

Id for the Campaign Member which created the User Touchpoint.

00v0Z00001VTgv1QAD

CRM_ACTIVITY_ID varchar Id for the Activity which created the User Touchpoint. 1678625515

CRM_EVENT_ID

varchar

Id for the Event which created the User Touchpoint.

00U0Z00000pCZmyUAG

CRM_TASK_ID

varchar

TId for the Task which created the User Touchpoint.

00T0Z00004Qbd1jUAB

IMPRESSION_ID

varchar

Id for the Impression which created the User Touchpoint.

00T0Z00004Qbd1jUAB
IS_FIRST_KNOWN_TOUCH boolean Whether or not this touchpoint is treated as the first touch of the opportunity journey. false
VISITOR_ID varchar The first cookie id of the related visitor id. v_36ec805b4db344d6e92c972c86aee34a

TOUCHPOINT_DATE

timestamp_ntz

Date the User Touchpoint occured.

2018-01-05 16:47:02.000

MARKETING_TOUCH_TYPE

varchar

The type of activity, Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity. Referred to in the CRM as "Touchpoint Type."

Web Form

CHANNEL

varchar

The channel the touchpoint falls into, as defined in the custom channel definitions within the Marketo Measure App. Referred to in the CRM as "Marketing Channel - Path."

Social.LinkedIn

BROWSER_NAME

varchar

From the javascript and IP address, the detected browser that the user was on during the session.

Firefox

BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session.

33

PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session.

Mac

PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session.

10_12

LANDING_PAGE

varchar

The first landing page of the session which resulted in a touchpoint. Referred to in the CRM as "Landing Page".

https://www.adobe.com/blog/budget-and-planning-maturity-model-b2b-marketing

LANDING_PAGE_RAW

varchar

The first landing page of the session that resulted in a touchpoint. A raw landing page will contain all query parameters in the URL. Referred to in the CRM as "Landing Page - Raw".

https://www.adobe.com/blog/budget-and-planning-maturity-model-b2b-marketing?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+ marketo+%maeasure%27s+Pipeline+Marketing+Blog%29

REFERRER_PAGE

varchar

Typically the external landing page immediately before the user comes onto the website. Referred to in the CRM as "Referrer Page".

https://www.google.com/

REFERRER_PAGE_RAW

varchar

Typically the external landing page immediately before the user comes onto the website. A raw referrer page may contain query parameters in the URL. Referred to in the CRM as "Referrer Page - Raw".

https://www.google.com/

FORM_PAGE

varchar

The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. Referred to in the CRM as "Form URL".

http://info.adobe.com/adwords-for-lead-generation

FORM_PAGE_RAW

varchar

The first form recorded in a session which resulted in a touchpoint. Subsequent form submissions will not show up in the Attribution_Touchpoints table, but rather in the Form_Submits table. A raw form page may contain query parameters in the URL. Referred to in the CRM as "Form URL - Raw".

http://info.adobe.com/adwords-for-lead-generation?utm_source=linkedin&utm_medium=paid&utm_content=sfskill&utm _campaign=Content%20-%20AdWords%20Guide

FORM_DATE

timestamp_ntz

Date the form submission occurred.

2015-06-03 17:49:10.000

CITY

varchar

From the javascript and IP address, the detected city the user was in during the session.

Oakland

REGION

varchar

From the javascript and IP address, the detected region the user was in during the session.

California

COUNTRY

varchar

From the javascript and IP address, the detected country the user was in during the session.

United States

MEDIUM

varchar

Used to define the medium which resulted in the touchpoint. This can either be parsed out from the URL from utm_medium. Or, if Marketo Measure is able to resolve an ad, it may be values such as "cpc" or "display."

paid

WEB_SOURCE

varchar

Used to define the source which resulted in the touchpoint. This can be parsed out from the URL from utm_source, generically set as "CRM Campaign" if it was synced from the CRM, or if Marketo Measure is able to resolve an ad, it may be values such as "Google AdWords" or "Facebook." Referred to in the CRM as "Touchpoint Source".

linkedin

SEARCH_PHRASE

varchar

The value which the user entered in the browser to search for and ended up on the website. Depending on the keyword buys, this may or may not match the keywords purchased from the Paid Search platform.

Marketo Measure

AD_PROVIDER

varchar

Ad platform Marketo Measure was able to resolve from, typically one of our integration partners.

Google

ACCOUNT_UNIQUE_ID

varchar

Id of the Ad Account in which the ad was resolved from.

aw.6601259029

ACCOUNT_NAME

varchar

Name of the Ad Account in which the ad was resolved from.

Marketo Measure Account

ADVERTISER_UNIQUE_ID

varchar

Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

300181641

ADVERTISER_NAME

varchar

Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Marketing Analytics

SITE_UNIQUE_ID

varchar

Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651

SITE_NAME

varchar

Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

Quora.com

PLACEMENT_UNIQUE_ID

varchar

Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827

PLACEMENT_NAME

varchar

Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager.

roadblock

CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign from the Ad Account in which the Ad was resolved from.

aw.6601259029.208548635

CAMPAIGN_NAME

varchar

Name of the Campaign from the Ad Account in which the Ad was resolved from.

Brand

AD_GROUP_UNIQUE_ID

varchar

Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords.

aw.6601259029.208548635.16750166675

AD_GROUP_NAME

varchar

Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords.

Brand - Core

AD_UNIQUE_ID

varchar

Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

dc.6114.8882972.25272734.492579576

AD_NAME

varchar

Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

Budget Webinar - sidebar

CREATIVE_UNIQUE_ID

varchar

Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.208548635.16750166675.195329631298

CREATIVE_NAME

varchar

Name of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Marketo Measure Official Site

CREATIVE_DESCRIPTION_1

varchar

The first line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Revenue Planning & Attribution

CREATIVE_DESCRIPTION_2

varchar

The second line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Learn why 250+ companies choose Marketo Measure for marketing attribution. Get a demo!

CREATIVE_DESTINATION_URL

varchar

The landing page that clicks through from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

http://info.adobe.com/demo

CREATIVE_DISPLAY_URL

varchar

The friendly URL name that's shown on the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

adobe.com/demo

KEYWORD_UNIQUE_ID

varchar

Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.208548635.16750166675.46267805426

KEYWORD_NAME

varchar

Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search)

[marketo]

KEYWORD_MATCH_TYPE

varchar

The type of match found between the search phrase and the purchased keyword.

Exact

IS_FORM_SUBMISSION_TOUCH

boolean

Whether or not this touchpoint had a form fill during the session.

true

IS_IMPRESSION_TOUCH

boolean

Whether or not this touchpoint is treated as the first impression touch of the opportunity journey.

false

IS_DELETED

boolean

Whether or not the touchpoint is deleted.

false

ROW_KEY number(38,0) Foreign Key to the Biz_Facts view. -5269090762570690000
LANDING_PAGE_KEY number(38,0)
REFERRER_PAGE_KEY number(38,0)
FORM_PAGE_KEY number(38,0)
ACCOUNT_ROW_KEY number(38,0)
ADVERISER_ROW_KEY number(38,0)
SITE_ROW_KEY number(38,0)
PLACEMENT_ROW_KEY number(38,0)
CAMPAIGN_ROW_KEY number(38,0)
AD_ROW_KEY number(38,0)
AD_GROUP_KEY number(38,0)
CREATIVE_ROW_KEY number(38,0)
KEYWORD_ROW_KEY number(38,0)
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

BIZ_WEB_HOST_MAPPINGS

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

Column

Data Type

Description

Sample Data

ID

varchar

A unique Id for the mapping record.

0d643578c0c74753eff91abe668ed328|2020-06-17:19:03:36|0002|0|568668

COOKIE_ID

varchar

The Marketo Measure recorded cookie id. 0d643578c0c74753eff91abe668ed328

VISITOR_ID

varchar

The first cookie id of the related visitor id. v_0d643578c0c74753eff91abe668ed328

SESSION_ID

varchar

The Marketo Measure Session id. 2018-08-06:01-35-24-1231230.9bc63c34482f

EVENT_DATE

timestamp_ntz Date the mapping was recorded.

2020-06-17 19:03:36.000

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2020-06-17 19:03:36.000

CURRENT_PAGE

varchar

URL of the Page View, without query parameters.

https://learn.atest.com/simplify-retention-starter-kit.html

CURRENT_PAGE_RAW

varchar

URL of the Page View, including any query parameters.

https://learn.atest.com/simplify-retention-starter-kit.html?x=nGfrBF&utm_medium=cpc&utm_source=intensify

IP_ADDRESS

varchar

The recorded IP address.

159.203.142.127

TYPE

varchar

Indicates the type of Event.

HostMapping

USER_AGENT_STRING

varchar

Device and browser recorded at the time of the Page View.

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36

CLIENT_SEQUENCE varchar Indicates the order in which the Page View occurred in the Session. 2
CLIENT_RANDOM varchar Used for internal auditing and processing. 566868
IS_DUPLICATED boolean Indicates if the record is considered a duplicate. false
IS_PROCESSED boolean Used for internal processing. true
MAPPING_TYPE varchar The type of Id which is mapped to the Marketo Measure cookie Id. Adobe_OrgId_Ecid
MAPPING_ORD_ID varchar Adobe IMS Org Id. 8CC867C25245ADC30A490D4C
MAPPING_COOKIE_ID varchar Adobe ECID for the given Org Id. 09860926390077352923264316157493772857
_CREATED_DATE timestamp_ntz Date the record was created in Snowflake. 2020-01-01 01:01:00.000
_MODIFIED_DATE timestamp_ntz Date the record was last modified in Snowflake. 2020-01-01 01:01:00.000
_DELETED_DATE timestamp_ntz Date the record was marked as deleted in Snowflake. 2020-01-01 01:01:00.000

Sample Queries

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

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

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

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

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

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

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

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

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

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

On this page