Data Warehouse Schema
- Topics:
- Data Warehouse
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.
- 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).
Entity Relationship Diagrams
The Data Warehouse Data Model ERD shows how data in the data warehouse is intended to flow and be linked together. This diagram does not include all tables available in the data warehouse because some of them represent mapping tables, views of other tables already present, or deprecated tables we don’t recommend using any more. See the detailed descriptions of tables and columns present in the data warehouse below. Many of these tables contain denormalized fields, however, this diagram is the recommended data model, leveraging data from dimensional tables instead.
The additional Ads Dimensional Data Model ERD presents a view of how tables for ads specific dimensions can be best linked back to the tables in the main data model. Though ads dimensions are also denormalized in other tables, this represents the recommended model for joining these dimensions.
Click an image for its full-size version
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 |
∗ INDUSTRY | varchar | Primary business of the Account. | Retail, Telecommunication |
∗ COUNTRY | varchar | Country portion of the Account's address. | USA, Canada |
∗ Only available in Marketo Measure Ultimate
BIZ_ACCOUNT_TO_EMAILS
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 |
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_DELETED | boolean | Whether or not the record is considered deleted in the source system. | false |
AD_FORM_ID | varchar | Id for the Ad Form the Activity is part of, from the source system. | li.507063119.3757704 |
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
BIZ_ADS
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. | |
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. | |
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 |
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". | |
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. | |
ACCOUNT_UNIQUE_ID | varchar | Id of the Ad Account in which the ad was resolved from. | aw.6601259029 |
ACCOUNT_NAME | varchar | Name of the Ad Account in which the ad was resolved from. | Marketo Measure |
ADVERTISER_UNIQUE_ID | varchar | Id of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager. | 300181641 |
ADVERTISER_NAME | varchar | Name of the Advertiser from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager. | Marketo Measure Marketing Analytics |
SITE_UNIQUE_ID | varchar | Id of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager. | 1695651 |
SITE_NAME | varchar | Name of the Site from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager. | Quora.com |
PLACEMENT_UNIQUE_ID | varchar | Id of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager. | 120839827 |
PLACEMENT_NAME | varchar | Name of the Placement from the Ad Account in which the Ad was resolved from. This only applies to Doubleclick Campaign Manager. | roadblock |
CAMPAIGN_UNIQUE_ID | varchar | Id of the Campaign from the Ad Account in which the Ad was resolved from. | aw.6601259029.317738075 |
CAMPAIGN_NAME | varchar | Name of the Campaign from the Ad Account in which the Ad was resolved from. | Marketing Attribution |
AD_GROUP_UNIQUE_ID | varchar | Id of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google Adwords. | aw.6601259029.317738075.23105327435 |
AD_GROUP_NAME | varchar | Name of the Ad Group from the Ad Account in which the Ad was resolved from. This only applies to Google AdWords. | Marketing Attribution - General |
AD_UNIQUE_ID | varchar | Id of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display). | dc.6114.8882972.25272734.492579576 |
AD_NAME | varchar | Name of the Ad from the Ad Account in which the Ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display). | Budget Webinar - sidebar |
CREATIVE_UNIQUE_ID | varchar | Id of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search). | aw.6601259029.317738075.23105327435.182716179597 |
CREATIVE_NAME | varchar | Name of the Creative from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search). | B2B Marketing Attribution |
CREATIVE_DESCRIPTION_1 | varchar | The first line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search). | Download The CMOs Guide |
CREATIVE_DESCRIPTION_2 | varchar | The second line of the Creative from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search). | Learn how attribution measures ROI by connecting marketing activities to revenue |
CREATIVE_DESTINATION_URL | varchar | The landing page that clicks through from the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search). | http://info.adobe.com/cmos-guide-to-b2b-marketing-attribution |
CREATIVE_DISPLAY_URL | varchar | The friendly URL name that's shown on the search Ad, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search). | http://info.adobe.com/CMOs-Guide |
KEYWORD_UNIQUE_ID | varchar | Id of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search). | aw.6601259029.317738075.23105327435.4838421670 |
KEYWORD_NAME | varchar | Name of the Keyword purchased from the Paid Search buy, pulled from the Ad Account in which the Ad was resolved from. This applies to Google AdWords and Bing Ads (search) | "marketing attribution" |
KEYWORD_MATCH_TYPE | varchar | The type of match found between the search phrase and the purchased keyword. | Exact |
IS_FIRST_TOUCH | boolean | Whether or not this touchpoint is treated as the first touch of the opportunity journey. | false |
IS_LEAD_CREATION_TOUCH | boolean | Whether or not this touchpoint is treated as the lead creation touch of the opportunity journey. | false |
IS_OPP_CREATION_TOUCH | boolean | Whether or not this touchpoint is treated as the opportunity creation touch of the opportunity journey. | false |
IS_CLOSED_TOUCH | boolean | Whether or not this touchpoint is treated as the closed touch of the opportunity journey. | false |
STAGES_TOUCHED | varchar | This field has been deprecated. Use the Stage_Transitions tables for stage information. | null |
IS_FORM_SUBMISSION_TOUCH | boolean | Whether or not this touchpoint had a form fill during the session. | true |
IS_IMPRESSION_TOUCH | boolean | Whether or not this touchpoint is treated as the first impression touch of the opportunity journey | false |
FIRST_CLICK_PERCENTAGE | number(22,19) | The calculated percentage allocated to this touchpoint because it's a first touch (See Is_First_Touch). | 0.0000000000000000000 |
LAST_ANON_CLICK_PERCENTAGE | number(22,19) | The calculated percentage allocated to this touchpoint because it's a lead creation touch (See Is_Lead_Creation_Touch). | 0.0000000000000000000 |
U_SHAPE_PERCENTAGE | number(22,19) | The calculated percentage allocated to this touchpoint because it's part of a u-shaped touch (See Is_First_Touch and Is_Lead_Creation_Touch). | 0.0000000000000000000 |
W_SHAPE_PERCENTAGE | number(22,19) | The calculated percentage allocated to this touchpoint because it's part of a w-shaped touch (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch). | 0.0153374234214425 |
FULL_PATH_PERCENTAGE | number(22,19) | The calculated percentage allocated to this touchpoint because it's part of a full path model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch). | 0.0143061513081193 |
CUSTOM_MODEL_PERCENTAGE | number(22,19) | The calculated percentage allocated to this touchpoint because it's part of a custom model (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch, Is_Closed_Touch). | 0.0143061513081193 |
IS_DELETED | boolean | Whether this touchpoint is deleted. | false |
ROW_KEY | number(38,0) | Foreign Key to the Biz_Facts view. | -2712935512233520000 |
OPPORTUNITY_ROW_KEY | number(38,0) | ||
LANDING_PAGE_KEY | number(38,0) | ||
REFERRER_PAGE_KEY | number(38,0) | ||
FORM_PAGE_KEY | number(38,0) | ||
ACCOUNT_ROW_KEY | number(38,0) | ||
ADVERTISER_ROW_KEY | number(38,0) | ||
SITE_ROW_KEY | number(38,0) | ||
PLACEMENT_ROW_KEY | number(38,0) | ||
CAMPAIGN_ROW_KEY | number(38,0) | ||
AD_ROW_KEY | number(38,0) | ||
AD_GROUP_ROW_KEY | number(38,0) | ||
CREATIVE_ROW_KEY | number(38,0) | ||
KEYWORD_ROW_KEY | number(38,0) | ||
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
BIZ_ATTRIBUTION_AI_TOUCHPOINTS
Data generated from the Attribution AI integration. These fields are only populated for Marketo Measure Ultimate customers.
Column | Data Type | Description | Sample Data |
---|---|---|---|
CONVERSION_DATE | Timestamp_ntz | date of the conversion | 2020-01-01 01:01:00.000 |
CONVERSION_NAME | varchar | name of the conversion event (as specified by the customer in the UI setting) | |
CONVERSION_ID | varchar | id for the conversion event (this is the original unique id value sent with the event data record in the source dataset) | 0013100001b44aGAAQ |
CONVERSION_EVENT_ID | varchar | original MM event id for the conversion event maps to a user touchpoint or a stage transition | 00U0Z00000pCZmyUAG |
CONVERSION_ACCOUNT_ID | varchar | original MM account id for the conversion event | 0013100001kpAZxAAM |
CONVERSION_OPPORTUNITY_ID | varchar | original MM opportunity id for the conversion event | 0060Z00000lFHtOQAW |
CONVERSION_LEAD_ID | varchar | original MM lead id for the conversion event likely to be null most of the time | 00Q0Z000013dw4GUAQ |
CONVERSION_CONTACT_ID | varchar | original MM contact id for the conversion event likely to be null most of the time | 00331000032hMxRAAU |
CONVERSION_EVENT_TYPE | varchar | type of conversion event (b2b = lead conversion, b2c = opportunity conversion) | b2b |
SCORE_DATE | Timestamp_ntz | date the touchpoints were last scored | 2020-01-01 01:01:00.000 |
INFLUENCED_PERCENT | number(38,35) | the fraction of the conversion that each touchpoint is responsible for | 0.10 |
INCREMENTAL_PERCENT | number(38,35) | the amount of marginal impact directly caused by a touchpoint | 0.25 |
TOUCHPOINT_DATE | Timestamp_ntz | the touchpoint or stage transition date | 2020-01-01 01:01:00.000 |
TOUCHPOINT_EVENT_ID | varchar | id for the event which generated the touchpoint | 00U3100000VLUnEEAX |
TOUCHPOINT_OPPORTUNITY_ID | varchar | id for the opportunity associated with the touchpoint | 0060Z00000lFHtOQAW |
TOUCHPOINT_ACCOUNT_ID | varchar | id for the account associated with the touchpoint | 0013100001kpAZxAAM |
TOUCHPOINT_LEAD_ID | varchar | id for the lead associated with the touchpoint | 00Q0Z000013dw4GUAQ |
TOUCHPOINT_CONTACT_ID | varchar | id for the contact associated with the touchpoint | 00331000032hMxRAAU |
COUNT_TO_CONVERSION | number(38,0) | the rank or ordinal value of the touchpoint in the chain leading to the conversion event | 10000 |
AAI_SOURCE_ID | varchar | foreign key to the attribution ai sources table | |
_CREATED_DATE | Timestamp_ntz | date the record was created in Snowflake | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | Timestamp_ntz | date the record was last modified in Snowflake | 2020-01-01 01:01:00.000 |
_DELETED_DATE | Timestamp_ntz | date the record was deleted in Snowflake | 2020-01-01 01:01:00.000 |
BIZ_CAMPAIGN_MEMBERS
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 |
varchar | Email address of the Contact, from the source system. | persona@adobe.com | |
ACCOUNTID | varchar | Id of the Account related to the Contact. | 0013100001b44aGAAQ |
LEAD_SOURCE | varchar | Source in which the Lead was created. | Advertisement |
BIZIBLE_STAGE | varchar | Current stage of the Contact, recognized as a custom stage which can be created in the Marketo Measure application. | Demo Scheduled |
BIZIBLE_STAGE_PREVIOUS | varchar | All previous stages for the Contact, recognized as custom stages which can be created in the Marketo Measure application. | Open - Contact |
ODDS_OF_CONVERSION | number(38,19) | This feature has been deprecated. Do not use this column. | N/A |
BIZIBLE_COOKIE_ID | varchar | The Marketo Measure Cookie Id used to populate from an integration partner to map an offline event to a web session. Requirement: Enable Call Tracking: True | 08c1063cb0a64349ad0d2d862f5cc700 |
IS_DELETED | boolean | Whether or not the record is deleted in the source system. | false |
IS_DUPLICATE | boolean | Used to de-duplicate records if both a CRM and Marketo integration are set up. If there are duplicates, the Marketo Contact is marked true. | false |
SOURCE_SYSTEM | varchar | Indicates if the record came from a CRM or a Marketo integration. | Crm |
OTHER_SYSTEM_ID | varchar | Maps a person from a Marketo integration with a Contact from a CRM integration. If both a CRM and Marketo integration exist, the value is the corresponding Id. | 1234 / 00Q0Z00001OohgTUAR |
CUSTOM_PROPERTIES | varchar | Custom properties that Marketo Measure has imported from the source system , in JSON format. | {"Contact_Type__c":"CMO", "Foo":"Bar"} |
ROW_KEY | number(38,0) | Foreign Key to the Biz_Facts view. | 3263982503087870000 |
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
∗ JOB_TITLE | varchar | Job Title of the Contact. | CEO, Vice President |
∗ Only available in Marketo Measure Ultimate
BIZ_CONVERSION_RATES
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. | |
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. | |
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 |
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 |
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 |
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 | Expected to be null since the field is obsolete. | NULL |
AD_PROVIDER | varchar | Ad platform Marketo Measure was able to resolve from, typically one of our integration partners. | |
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 |
varchar | Email address of the Lead, from the source system. | persona@adobe.com | |
WEB_SITE | varchar | Website entered for the Lead, from the source system, used for Lead2Account mapping. | adobe.com |
COMPANY | varchar | Company name entered for the Lead, from the source system, used for Lead2Account mapping. | Marketo Measure |
LEAD_SOURCE | varchar | Source in which the Lead was created. | Advertisement |
IS_CONVERTED | boolean | Whether or not the Lead has been converted to a Contact. | true |
CONVERTED_OPPORTUNITY_ID | varchar | Id of the related Opportunity once the Lead has been converted. | 0013100001b44aGAAQ |
CONVERTED_DATE | timestamp_ntz | Date the Lead was converted to a Contact. | 2018-08-27 07:00:00.000 |
CONVERTED_CONTACT_ID | varchar | Id of the related Contact once the Lead has been converted. | 0030Z00003Oyp25QAB |
ACCOUNTID | varchar | Id of the mapped Account. Requirements: Enable ABM | 0010Z0000236F9GQAU |
BIZIBLE_STAGE | varchar | Current stage of the Lead, recognized as a custom stage which can be created in the Marketo Measure application. | Demo Scheduled |
BIZIBLE_STAGE_PREVIOUS | varchar | All previous stages for the Lead, recognized as custom stages which can be created in the Marketo Measure application. | MQL |
ODDS_OF_CONVERSION | number(38,19) | This feature has been deprecated. Do not use this column. | N/A |
LEAD_SCORE_MODEL | varchar | (deprecated) | null |
LEAD_SCORE_RESULTS | varchar | (deprecated) | null |
BIZIBLE_COOKIE_ID | varchar | The Marketo Measure Cookie Id used to populate from an integration partner to map an offline event to a web session. Requirement: Enable Call Tracking: True | 08c1063cb0a64349ad0d2d862f5cc700 |
IS_DELETED | boolean | Whether or not the record is deleted in the source system. | false |
ROW_KEY | number(38,0) | Foreign Key to the Biz_Facts view. | 3263982503087870000 |
CUSTOM_PROPERTIES | varchar | Custom properties that Marketo Measure has imported from the source system , in JSON format. | {"Lead_Type__c":"Sales Created", "Foo":"Bar"} |
IS_DUPLICATE | boolean | Used to de-duplicate records if both a CRM and Marketo integration are set up. If there are duplicates, the Marketo Lead is marked true. | true |
SOURCE_SYSTEM | varchar | Indicates if the record came from a CRM or a Marketo integration. | Crm |
OTHER_SYSTEM_ID | varchar | Maps a person from a Marketo integration with a Lead from a CRM integration. If both a CRM and Marketo integration exist, the value is the corresponding Id. | 1234 |
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
BIZ_LEAD_STAGE_TRANSITIONS
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 |
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. Do not use this column. | N/A |
BIZIBLE_STAGE | varchar | Current stage of the Opportunity, as defined in the Marketo Measure application. | DM Demo |
BIZIBLE_STAGE_PREVIOUS | varchar | A string of all stages the Opportunity has previously gone through, as defined in the Marketo Measure application. | Qualified Discovery, Demo Scheduled |
IS_DELETED | boolean | Whether or not the record is deleted in the source system. | false |
ROW_KEY | number(38,0) | Foreign Key to the Biz_Facts view. | 4609512587744160000 |
CURRENCY_ISO_CODE | varchar | ISO code for the currency, imported from the source system. | USD |
CURRENCY_ID | number(38,0) | Id value of the Currency for the record. | 4609512587744160000 |
CUSTOM_PROPERTIES | varchar | Custom properties that Marketo Measure has imported from the source system , in JSON format. | {"Opportunity_Location__c":"Seattle", "Foo":"Bar"} |
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
∗ OPPORTUNITY_TYPE | varchar | Type of Opportunity, such as New Business, Renewal, etc. | Renewal, Prospect |
∗ Only available in Marketo Measure Ultimate
BIZ_OPP_STAGE_TRANSITIONS
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 |
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 |
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. | |
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. | |
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. | |
MEDIUM | varchar | Parsed from the URL from utm_medium. | Social |
TERM | varchar | Parsed from the URL from utm_term. | lisu07261601 |
CONTENT | varchar | Parsed from the URL from utm_content. | 2016 AdWords Benchmark Report |
CITY | varchar | The resolved city from the IP address. | Vancouver |
REGION | varchar | The resolved region from the IP address. | British Columbia |
COUNTRY | varchar | The resolved country from the IP address. | Canada |
ISP_NAME | varchar | Expected to be null since the field is obsolete. | NULL |
IP_ADDRESS | varchar | The recorded IP address at the time the Session. | 174.127.184.158 |
IS_DELETED | boolean | Determines if this Session was merged with another and should be deleted. | false |
ROW_KEY | number(38,0) | Foreign Key to the Biz_Facts view. | -2712935512233520000 |
LANDING_PAGE_KEY | number(38,0) | ||
REFERRER_PAGE_KEY | number(38,0) | ||
ACCOUNT_ROW_KEY | number(38,0) | ||
ADVERTISER_ROW_KEY | number(38,0) | ||
SITE_ROW_KEY | number(38,0) | ||
PLACEMENT_ROW_KEY | number(38,0) | ||
CAMPAIGN_ROW_KEY | number(38,0) | ||
AD_ROW_KEY | number(38,0) | ||
AD_GROUP_ROW_KEY | number(38,0) | ||
CREATIVE_ROW_KEY | number(38,0) | ||
KEYWORD_ROW_KEY | number(38,0) | ||
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
BIZ_SITES
Sites imported from any connected Ad Account.
Column | Data Type | Description | Sample Data |
---|---|---|---|
ID | varchar | A unique Id for the Site. | aw.3284209 |
DISPLAY_ID | varchar | The Site Id from the source system. | 39464932147 |
AD_ACCOUNT_UNIQUE_ID | varchar | Id for the Ad Account from which the Site was imported. | aw.3284209 |
AD_ACCOUNT_NAME | varchar | Name of the Ad Account from which the Site was imported. | Marketo Measure |
ADVERTISER_UNIQUE_ID | varchar | The Id of the advertiser for the site, specifically for Doubleclick. | 300181641 |
ADVERTISER_NAME | varchar | The name of the advertiser for the site, specifically for Doubleclick. | Marketing Analytics |
AD_GROUP_UNIQUE_ID | varchar | Expected to be null since there is no Ad Group above Site in any ads hierarchy. | null |
AD_GROUP_NAME | varchar | Expected to be null since there is no Ad Group above Site in any ads hierarchy. | null |
AD_CAMPAIGN_UNIQUE_ID | varchar | Id of the Campaign for the Site. | ba.3284209.132630532 |
AD_CAMPAIGN_NAME | varchar | Name of the Campaign for the Site. | Revue Attribution |
IS_ACTIVE | boolean | Whether or not the Site is still active in the source system. | true |
IS_DELETED | boolean | Whether or not the Site has been deleted in the source system. | false |
MODIFIED_DATE | timestamp_ntz | Date the record was last modified. | 2018-08-02 06:37:29.000 |
FIRST_IMPORTED | timestamp_ntz | Date the record was first imported from the source system. | 2018-08-02 06:37:29.000 |
NAME | varchar | Name of the Site, from the source system. | Revenue |
NEEDS_UPDATE | boolean |
Whether or not the Site needs to be updated for Marketo Measure tagging. (Diagnostic field, used for internal processing.) | false |
GROUPING_KEY | varchar | Diagnostic field, used for internal processing. | |
ENTITY_TYPE | varchar | The main object or entity for this table. In this case, "Site". | Site |
PROVIDER_TYPE | varchar | Name of the Ad Provider for the Site. | AdWords |
ROW_KEY | number(38,0) | Foreign Key to the Biz_Facts view. | -2712935512233520000 |
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
BIZ_SITE_LINKS
Sites Links from any connected Ads Account.
Column | Data Type | Description | Sample Data |
---|---|---|---|
ID | varchar | A unique Id for the site link | aw.6601259029.285077795.1654234342 |
DISPLAY_ID | varchar | 1654234342 | |
AD_ACCOUNT_UNIQUE_ID | varchar | The ID of the connected ads account for the site link | aw.6601259029 |
AD_ACCOUNT_NAME | varchar | The name of the connected ads account for the site link | Marketo Measure |
ADVERTISER_UNIQUE_ID | varchar | The Id of the advertiser for the site link, specifically for Doubleclick. | 300181641 |
ADVERTISER_NAME | varchar | The name of the advertiser for the site link, specifically for Doubleclick. | Marketing Analytics |
AD_GROUP_UNIQUE_ID | varchar | The ID of the ad group for the site link | aw.6601259029.208548635.16750166675 |
AD_GROUP_NAME | varchar | The name of the ad group for the site link | Brand - Core |
AD_CAMPAIGN_UNIQUE_ID | varchar | The ID of the campaign for the site link | aw.6601259029.285077795 |
AD_CAMPAIGN_NAME | varchar | The name of the campaign for the site link | Brand |
IS_ACTIVE | boolean | Whether or not the site link is still active in the ads account | TRUE |
IS_DELETED | boolean | Whether or not the site link has been deleted in the ads account | FALSE |
MODIFIED_DATE | timestamp_ntz | The last modified date of the row | 2018-08-02 06:36:50.000 |
FIRST_IMPORTED | timestamp_ntz | The date that the site link was first downloaded by Marketo Measure | 2018-08-02 06:36:50.000 |
NAME | varchar | The name of the site link | Link A |
NEEDS_UPDATE | boolean | Whether or not the site link needs to get updated to get Marekto Measure tagging | FALSE |
GROUPING_KEY | varchar | aw.6601259029.285077795 | |
ENTITY_TYPE | varchar | The main object or entity for this table. In this case, "SiteLink" | SiteLink |
PROVIDER_TYPE | varchar | The name of the ads provider for the site link | AdWords |
URL_CURRENT | varchar |
The URL for the landing page. (Diagnostic field, for internal processing.) |
http://adobe.com/b2b-marketing-attribution?_bt{creative}&_bk={keyword}&_bm={matchType} |
URL_OLD | varchar |
Previous value for URL_CURRENT. (Diagnostic field, for internal processing.) | |
URL_REQUESTED | varchar |
What the URL will be decorated with Marketo Measure parameters. (Diagnostic field, for internal processing.) | |
_CREATED_DATE | timestamp_ntz | Snowflake's created date of the record | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Snowflake's modified date of the record | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Snowflake's deleted date of the record if it has been deleted | 2020-01-01 01:01:00.000 |
BIZ_STAGE_DEFINITIONS
List of stages as imported or defined in the Marketo Measure application.
Column | Data Type | Description | Sample Data |
---|---|---|---|
ID | varchar | A unique Id for the Stage. | 01J3100000QE753EAD |
MODIFIED_DATE | timestamp_ntz | Date the record was last modified. | 2018-08-22 17:27:27.000 |
STAGE_NAME | varchar | Name of the Stage. | Verbal |
IS_INACTIVE | boolean | Indicates if the Stage is considered inactive. | false |
IS_IN_CUSTOM_MODEL | boolean | Indicates if the Stage is selected to track in the custom model. | false |
IS_BOOMERANG | boolean | Indicates if the Stage is selected to track as a boomerang stage. | false |
IS_TRANSITION_TRACKING | boolean | Indicates if the Stage is selected to track for transitions. | false |
STAGE_STATUS | varchar | Status of the Stage, as defined in the Marketo Measure application Stage Mapping. | Open |
IS_FROM_SALESFORCE | boolean | Indicates if the Stage is imported from an external source system. | true |
IS_DEFAULT | boolean | Indicates if the Stage is set as a default. | false |
RANK | number(38,0) | The numerical rank of the Stage, used to sort Stages in transitional order. | 53 |
IS_DELETED | boolean | Whether or not the Stage has been deleted. | false |
_CREATED_DATE | timestamp_ntz | Date the record was created in Snowflake. | 2020-01-01 01:01:00.000 |
_MODIFIED_DATE | timestamp_ntz | Date the record was last modified in Snowflake. | 2020-01-01 01:01:00.000 |
_DELETED_DATE | timestamp_ntz | Date the record was marked as deleted in Snowflake. | 2020-01-01 01:01:00.000 |
BIZ_TOUCHPOINTS
Buyer Touchpoints, all touchpoints associated with a Lead or Contact. This table will be empty if Lead Touchpoints or Contact Touchpoints are disabled.
Column | Data Type | Description | Sample Data |
---|---|---|---|
ID | varchar | A unique Id for the Buyer Touchpoint (BT). | TP2_Person_00Q0Z000013e2PYUAY_2018-08-27:20-04-40-5655690.1ee8567c175a |
MODIFIED_DATE | timestamp_ntz | Date the record was last modified. | 2018-08-29 22:29:30.000 |
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". | |
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. | |
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 |
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". | |
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. | |
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.
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
Marketo Measure
- Overview
- Introduction to Marketo Measure
- Marketo Measure Tracking
- Setting Up Tracking
- Best Practices for Implementing Marketo Measure JavaScript
- Adding Marketo Measure Script
- Adding Marketo Measure Script via Google Tag Manager
- Data Collected by JavaScript
- Adding Marketo Measure Script to Different Form Providers
- Adding Marketo Measure JavaScript to Pardot
- Adding Marketo Measure Script to Lightbox Forms
- Adding Marketo Measure Script to Sitecore Pages
- Adding Marketo Measure Script to Uberflip Forms
- Adding Marketo Measure to Act-On Forms
- Adding Marketo Measure to Hubspot
- Adding Marketo Measure to Marketo Landing Pages
- AJAX Form Handling
- Connecting Marketo Measure to Unbounce Script Manager
- IFrame Forms and Marketo Measure
- Excluding Marketo Measure from Specific Forms
- Marketo Measure Cookies
- Definition of Marketo Measure Web Sessions
- Best Practices for Testing
- Setting Up Tracking
- Configuration and Setup
- Getting Started with Marketo Measure
- Marketo Measure and Salesforce
- Marketo Measure Salesforce Package Installation and Set Up
- Salesforce Package Consolidation
- Connect Marketo Measure to Salesforce
- Best Practices for Marketo Measure CRM Package
- Marketo Measure Salesforce Objects
- Error Handling for CRM Exports
- How Marketo Measure and Salesforce Interact
- Marketo Measure Object and Field Taxonomy
- Marketo Measure Fields on Standard Salesforce Objects
- Page Layout Instructions
- Hiding Unnecessary Report Types
- Creating a Marketo Measure Profile
- Marketo Measure Permission Sets
- Recommended Salesforce Permissions for Marketo Measure Connected User
- Sandbox Testing
- Marketo Measure Insights (Canvas App)
- Channel Tracking and Setup
- API Connections
- Marketing Spend
- Advanced Marketo Measure Features
- Marketo Measure Discover UI
- Dashboards
- Discover Dashboard Basics
- New Discover Dashboard Guide
- Dashboard Data Visibility Policy
- Attributed Opportunity Dashboard
- Attributed Revenue Dashboard
- Engagement Dashboard
- Keyword ROI Dashboard
- Lead Velocity Dashboard
- Opportunity Velocity Dashboard
- Passport Dashboard
- Revenue Overview Dashboard
- ROI Dashboard
- Web Traffic Dashboard
- Dashboards
- Marketo Measure and Adobe
- Marketo Measure and Dynamics
- Marketo Measure and Marketo
- Marketo Measure Salesforce Reporting
- Marketo Measure Data Warehouse
- BI Report Templates
- Security and Compliance
- Marketo Measure Ultimate
- Miscellaneous
- Other Related Resources
- Marketo Measure Maintenance
- Marketo Measure Resource List
- Call Tracking Integration
- Difference between a Google Analytics Conversion and a Buyer Touchpoint
- Email Tracking Parameter
- Granting Salesforce Access to Marketo Measure Support
- Privacy Request
- Remove Marketo Measure Tracking Parameters from the Landing Page URL in Google Analytics
- Transitioning to Marketo Measure from Full Circle
- Other Related Resources
- Release Notes
Marketo Migration to the Adobe Admin Console - (Pre-Migration)
Experience Cloud Tech Sessions
Tuesday, Mar 4, 6:00 PM UTC
Join Adobe's Customer Experience and Identity Team to prepare for a smooth Marketo migration to the Adobe Admin Console. Learn key steps, best practices, and how to avoid roadblocks for a seamless transition.
RegisterMarketo Migration to the Adobe Admin Console - (Post-Migration)
Experience Cloud Tech Sessions
Tuesday, Mar 11, 4:00 PM UTC
Migrated Marketo to the Adobe Admin Console? Join our webinar to master key features, best practices, and troubleshooting tips. Learn how to manage users,, settings, and more. register now!
Register