Data Warehouse Schema

ACCOUNT_ID

varchar

Source system Account Id.

0013100001phrBAAAY

EMAIL

varchar

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

person@adobe.com

MODIFIED_DATE

timestamp_ntz

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

2018-08-31 23:53:39.000

CREATED_DATE

timestamp_ntz

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

2018-08-18 22:01:32.000

IS_DELETED

boolean

Whether or not the record is considered deleted.

false

ID

varchar

The Activity Id from the source system.

1678625515

LEAD_ID

varchar

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

change status in progression

li.508038570.147643566

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

fb.106851586409075.6052044288804.6052044290004

ENTITY_TYPE

varchar

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

Ad

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Ad.

Facebook

URL_CURRENT

varchar

The URL for the landing page.

(Diagnostic field, for internal processing.)

URL_OLD

varchar

Previous value for URL_CURRENT.

(Diagnostic field, for internal processing.)

URL_REQUESTED

varchar

What the URL will be decorated with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

URL_ALTENATIVES

varchar

Imported from the source system.

(Diagnostic field, for internal processing.)

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

6008900572523230000

ID

varchar

A unique Id for the Advertiser.

dc.6114.9143143

DISPLAY_ID

varchar

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

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

ID

varchar

A unique identifier for the Ad Account.

aw.6601259029

DISPLAY_ID

varchar

6601259029

AD_ACCOUNT_UNIQUE_ID

varchar

AD_ACCOUNT_NAME

varchar

ADVERTISER_UNIQUE_ID

varchar

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

ADVERTISER_NAME

varchar

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

AD_GROUP_UNIQUE_ID

varchar

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

AD_GROUP_NAME

varchar

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

AD_CAMPAIGN_UNIQUE_ID

varchar

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

AD_CAMPAIGN_NAME

varchar

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

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

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

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

SOURCE

varchar

Social

MEDIUM

varchar

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

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

TRACKING_URL_TEMPLATE_OLD

varchar

TRACKING_URL_TEMPLATE_REQUESTED

varchar

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

ID

varchar

Unique Id for the Campaign.

aw.6601259029.285114995

DISPLAY_ID

varchar

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.

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

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

TRACKING_URL_TEMPLATE_OLD

varchar

TRACKING_URL_TEMPLATE_REQUESTED

varchar

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

ID

varchar

A unique Id for the Ad Form.

li.507063119.3757704

AD_ACCOUNT_UNIQUE_ID

varchar

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

li.507063119

AD_ACCOUNT_NAME

varchar

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

Marketo Measure

IS_DELETED

boolean

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

false

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

2018-08-02 06:35:58.000

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.

2018-08-02 06:35:58.000

NAME

varchar

Name of the Ad Form.

NSPA Ebook LGF (May 2020)

ENTITY_TYPE

varchar

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

AdForm

PROVIDER_TYPE

varchar

Name of the Ad Provider for the Ad Form.

LinkedIn

DESCRIPTION

varchar

Description of the Ad Form.

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

HEADLINE

varchar

It's Time to Automate the Refinancing Application Process

LANDING_URL

varchar

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

QUESTIONS

varchar

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

STATUS

varchar

Status of the Ad Form.

submitted

ID

varchar

A unique Id for the Ad Group.

aw.6601259029.317737955.23105326115

DISPLAY_ID

varchar

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

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

TRACKING_URL_TEMPLATE_OLD

varchar

TRACKING_URL_TEMPLATE_REQUESTED

varchar

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

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

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

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

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

New Business

CATEGORY5

varchar

CATEGORY6

varchar

CATEGORY7

varchar

CATEGORY8

varchar

CATEGORY9

varchar

CATEGORY10

varchar

CATEGORY11

varchar

CATEGORY12

varchar

CATEGORY13

varchar

CATEGORY14

varchar

CATEGORY15

varchar

BROWSER_NAME

varchar

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

Chrome

BROWSER_VERSION

varchar

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

58

PLATFORM_NAME

varchar

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

Mac

PLATFORM_VERSION

varchar

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

10_12

LANDING_PAGE

varchar

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

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

LANDING_PAGE_RAW

varchar

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

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

REFERRER_PAGE

varchar

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

https://www.linkedin.com/

REFERRER_PAGE_RAW

varchar

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

https://www.linkedin.com/

FORM_PAGE

varchar

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

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

FORM_PAGE_RAW

varchar

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

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

FORM_DATE

timestamp_ntz

Date the form submission occurred.

2017-06-20 01:06:41.000

CITY

varchar

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

San Francisco

REGION

varchar

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

California

COUNTRY

varchar

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

United States

MEDIUM

varchar

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

social

WEB_SOURCE

varchar

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

linkedin

SEARCH_PHRASE

varchar

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

google Marketo Measure

AD_PROVIDER

varchar

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

Google

ACCOUNT_UNIQUE_ID

varchar

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

aw.6601259029

ACCOUNT_NAME

varchar

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

Marketo Measure

ADVERTISER_UNIQUE_ID

varchar

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

300181641

ADVERTISER_NAME

varchar

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

Marketo Measure Marketing Analytics

SITE_UNIQUE_ID

varchar

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

1695651

SITE_NAME

varchar

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

Quora.com

PLACEMENT_UNIQUE_ID

varchar

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

120839827

PLACEMENT_NAME

varchar

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

roadblock

CAMPAIGN_UNIQUE_ID

varchar

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

aw.6601259029.317738075

CAMPAIGN_NAME

varchar

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

Marketing Attribution

AD_GROUP_UNIQUE_ID

varchar

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

aw.6601259029.317738075.23105327435

AD_GROUP_NAME

varchar

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

Marketing Attribution - General

AD_UNIQUE_ID

varchar

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

dc.6114.8882972.25272734.492579576

AD_NAME

varchar

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

Budget Webinar - sidebar

CREATIVE_UNIQUE_ID

varchar

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

aw.6601259029.317738075.23105327435.182716179597

CREATIVE_NAME

varchar

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

B2B Marketing Attribution

CREATIVE_DESCRIPTION_1

varchar

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

Download The CMOs Guide

CREATIVE_DESCRIPTION_2

varchar

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

Learn how attribution measures ROI by connecting marketing activities to revenue

CREATIVE_DESTINATION_URL

varchar

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

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

CREATIVE_DISPLAY_URL

varchar

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

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

KEYWORD_UNIQUE_ID

varchar

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

aw.6601259029.317738075.23105327435.4838421670

KEYWORD_NAME

varchar

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

"marketing attribution"

KEYWORD_MATCH_TYPE

varchar

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

Exact

IS_FIRST_TOUCH

boolean

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

false

IS_LEAD_CREATION_TOUCH

boolean

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

false

IS_OPP_CREATION_TOUCH

boolean

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

false

IS_CLOSED_TOUCH

boolean

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

false

STAGES_TOUCHED

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

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)

PLACEMENT_ROW_KEY

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

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

ID

varchar

The Contact Id from the source system.

0030Z00003OzioeQAB

MODIFIED_DATE

timestamp_ntz

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

2018-09-05 05:17:53.000

CREATED_DATE

timestamp_ntz

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

2018-09-05 05:17:51.000

EMAIL

varchar

Email address of the Contact, from the source system.

persona@adobe.com

ACCOUNTID

varchar

Id of the Account related to the Contact.

0013100001b44aGAAQ

LEAD_SOURCE

varchar

Source in which the Lead was created.

Advertisement

BIZIBLE_STAGE

varchar

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

Demo Scheduled

BIZIBLE_STAGE_PREVIOUS

varchar

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

Open - Contact

ODDS_OF_CONVERSION

number(38,19)

The Marketo Measure algorithm of estimating whether a Contact will help an Opportunity close based on the age and stage

.290034

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.

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

3263982503087870000

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

Foreign Key to the Biz_Facts view.

ACCOUNT_ROW_KEY

-3253183181619994799

ID

varchar

A unique Id for the Creative.

ba.3284209.132855866.4556709270.10426699711

DISPLAY_ID

varchar

10426699711

AD_ACCOUNT_UNIQUE_ID

varchar

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

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.

AD_GROUP_NAME

varchar

Name of the Ad Group for the Creative.

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

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

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

TRACKING_URL_TEMPLATE_OLD

varchar

TRACKING_URL_TEMPLATE_REQUESTED

varchar

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.

ID

varchar

The Event Id from the source system.

00U3100000VLUnEEAX

CREATED_DATE

timestamp_ntz

Date the Event was created, from the source system.

2016-12-12 19:32:53.000

MODIFIED_DATE

timestamp_ntz

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

2018-09-03 08:39:51.000

LEAD_ID

varchar

Id for the Lead associated with the Event.

00Q0Z000013eVrxUAE

LEAD_EMAIL

varchar

Email for the Lead associated with the Event.

person@adobe.com

CONTACT_ID

varchar

Id for the Contact associated with the Event.

0030Z00003OyjbOQAR

CONTACT_EMAIL

varchar

Email for the Contact associated with the Event.

person@adobe.com

BIZIBLE_COOKIE_ID

varchar

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

08c1063cb0a64349ad0d2d862f5cc700

ACTIVITY_TYPE

varchar

Activity Type Name, from the source system.

Email

EVENT_START_DATE

timestamp_ntz

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

2016-12-16 19:30:00.000

EVENT_END_DATE

timestamp_ntz

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

2016-12-16 21:30:00.000

IS_DELETED

boolean

False

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

false

ID

false

VISITOR_ID

varchar

The first cookie id of the related visitor id.

COOKIE_ID

varchar

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

EVENT_DATE

timestamp_ntz

Date the chat was logged.

varchar

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

EXPERIMENT_ID

varchar

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

EXPERIMENT_NAME

varchar

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

VARIATION_ID

varchar

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

VARIATION_NAME

varchar

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

ABTEST_USER_ID

varchar

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

IS_DELETED

boolean

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

VISITOR_ID

varchar

The first cookie id of the related visitor id.

COOKIE_ID

varchar

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

EVENT_DATE

timestamp_ntz

The date the event was triggered from the custom javascript.

IP_ADDRESS

varchar

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

KEY

varchar

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

VALUE

varchar

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

IS_DELETED

boolean

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

ID

varchar

A unique Id for the record.

DISPLAY_ID

varchar

AD_ACCOUNT_UNIQUE_ID

varchar

AD_ACCOUNT_NAME

varchar

ADVERTISER_UNIQUE_ID

varchar

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

ADVERTISER_NAME

varchar

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

Marketing Analytics

AD_GROUP_UNIQUE_ID

varchar

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

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

EMAIL

varchar

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

person@adobe.com

VISITOR_ID

varchar

The first cookie of the related visitor Id

v_36ec805b4db344d6e92c972c86aee34a

MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-14 23:55:03.000

CREATED_DATE

timestamp_ntz

The created date of the row

2018-08-14 23:55:03.000

IS_DELETED

boolean

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

false

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

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.

FIRST_CLICK_PERCENTAGE

number(22,19)

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

LAST_ANON_CLICK_PERCENTAGE

number(22,19)

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

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.

CONTACT_ID

varchar

Contact Id from the source system.

0030Z00003ORVJmQAP

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.)

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.)

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.)

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

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

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

4

CLIENT_RANDOM

varchar

20042b6b7af44512b43f6244d86faf4c

IS_DUPLICATED

boolean

false

IS_PROCESSED

boolean

true

EMAIL

varchar

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

personc@adobe.com

FORM_TYPE

varchar

Chat

FORM_SOURCE

varchar

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

onSubmit

FORM_IDENTIFIER

varchar

-956012665

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-6255315750913680000

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.

VISITOR_ID

varchar

The first cookie id of the related visitor id.

SESSION_ID

varchar

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

EVENT_DATE

timestamp_ntz

Date the Impression was served.

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

CURRENT_PAGE

varchar

URL where the Impression was served, without query parameters.

CURRENT_PAGE_RAW

varchar

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

IP_ADDRESS

varchar

The recorded IP address at the time of the Impression.

TYPE

varchar

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

4

CLIENT_RANDOM

varchar

20042b6b7af44512b43f6244d86faf4c

IS_DUPLICATED

boolean

false

IS_PROCESSED

boolean

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".

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".

CITY

varchar

The resolved city from the IP address.

Seattle

REGION

varchar

The resolved region from the IP address.

Washington

COUNTRY

varchar

The resolved country from the IP address.

United States

ISP_NAME

varchar

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

AT&T U-verse

AD_PROVIDER

varchar

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

ACCOUNT_UNIQUE_ID

varchar

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

ACCOUNT_NAME

varchar

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

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.

CAMPAIGN_NAME

varchar

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

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.

CREATIVE_DESCRIPTION_1

varchar

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

CREATIVE_DESCRIPTION_2

varchar

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

CREATIVE_DESTINATION_URL

varchar

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

CREATIVE_DISPLAY_URL

varchar

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

KEYWORD_UNIQUE_ID

varchar

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

KEYWORD_NAME

varchar

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

KEYWORD_MATCH_TYPE

varchar

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

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

ID

varchar

A unique Id for the Keyword.

ba.3284209.132630532.3646889365.39464932147

DISPLAY_ID

varchar

39464932147

AD_ACCOUNT_UNIQUE_ID

varchar

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

AD_ACCOUNT_NAME

varchar

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

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.

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

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.)

The URL for the landing page with Marketo Measure parameters.

(Diagnostic field, for internal processing.)

IS_UPGRADED_URL

boolean

false

WORD

varchar

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

TRACKING_URL_TEMPLATE_OLD

varchar

TRACKING_URL_TEMPLATE_REQUESTED

varchar

TRACKING_URL_TEMPLATE_APPLIED

varchar

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.

ID

varchar

A unique Id for the Landing Page.

DISPLAY_ID

varchar

AD_ACCOUNT_UNIQUE_ID

varchar

AD_ACCOUNT_NAME

varchar

ADVERTISER_UNIQUE_ID

varchar

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

ADVERTISER_NAME

varchar

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

AD_GROUP_UNIQUE_ID

varchar

AD_GROUP_NAME

varchar

AD_CAMPAIGN_UNIQUE_ID

varchar

AD_CAMPAIGN_NAME

varchar

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

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.

EMAIL

varchar

Email address of the Lead, from the source system.

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)

The Marketo Measure algorithm of estimating if a Lead will convert based on the age and stage.

.290034

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.

ID

varchar

A unique Id for the transition.

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

EMAIL

varchar

The provided email address for the related Lead/Contact.

persone@adobe.com

LEAD_ID

varchar

Id for the Lead associated to the transition.

00Q3100001Fx6AlEAJ

CONTACT_ID

varchar

Id for the Contact associated to the transition.

0033100003Aq9grAAB

TOUCHPOINT_ID

varchar

Id for the Buyer Touchpoint tied to the transition.

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

TRANSITION_DATE

timestamp_ntz

Date the record transitioned into the stage.

2018-08-27 16:05:34.000

STAGE_ID

varchar

Id value of the stage for the transition.

_bizible_FT

STAGE

varchar

Name of the stage for the transition.

FT

RANK

number(38,0)

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

5

INDEX

varchar(1)

Used in internal processing for indexing and ordering boomerang stages.

1

LAST_INDEX

varchar(1)

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

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.

CREATED_DATE

timestamp_ntz

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

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)

The Marketo Measure algorithm of estimating whether an opportunity will close based on the age and stage.

0.8225108385086060000

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.

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

4609512587744160000

ID

varchar

A unique Id for the transition.

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

ACCOUNT_ID

varchar

Id for the Account associated with the Opportunity.

0013100001b44nTAAQ

OPPORTUNITY_ID

varchar

Id for the Opportunity associatedto the transition.

0060Z00000nEgjlQAC

CONTACT_ID

varchar

Id for the Contact associated to the transition.

0030Z00003IjojKQAR

EMAIL

varchar

The provided email address for the related Contact.

persone@adobe.com

TOUCHPOINT_ID

varchar

Id for the Buyer Attribution Touchpoint tied to the transition.

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

TRANSITION_DATE

timestamp_ntz

Date the record transitioned into the stage.

2018-05-26 07:29:43.000

STAGE

varchar

Name of the stage for the transition.

Demo Scheduled

STAGE_ID

varchar

Id value of the stage for the transition.

_bizible_FT

RANK

number(38,0)

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

4

INDEX

varchar(1)

Used in internal processing for indexing and ordering boomerang stages.

LAST_INDEX

varchar(1)

Used in internal processing for indexing and ordering boomerang stages.

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

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

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

103532

IS_DUPLICATED

boolean

IS_PROCESSED

boolean

REFERRER_PAGE

varchar

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

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

REFERRER_PAGE_RAW

varchar

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

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

PAGE_TITLE

varchar

Title of the Page.

The CMO's Guide to B2B Marketing Attribution Download

EMAIL

varchar

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

ROW_KEY

number(38,0)

Foreign Key to the Biz_Facts view.

-6255315750913680000

ID

varchar

A unique Id for the Placement.

ba.3284209.132855866.4556709270.10426699711

DISPLAY_ID

varchar

AD_ACCOUNT_UNIQUE_ID

varchar

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

AD_ACCOUNT_NAME

varchar

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

ADVERTISER_UNIQUE_ID

varchar

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

ADVERTISER_NAME

varchar

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

AD_GROUP_UNIQUE_ID

varchar

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

AD_GROUP_NAME

varchar

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

AD_CAMPAIGN_UNIQUE_ID

varchar

Id of the Campaign for the Placement.

AD_CAMPAIGN_NAME

varchar

Name of the Campaign for the Placement.

IS_ACTIVE

boolean

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

IS_DELETED

boolean

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

MODIFIED_DATE

timestamp_ntz

Date the record was last modified.

FIRST_IMPORTED

timestamp_ntz

Date the record was first imported from the source system.