Snowflake Data Warehouse Schema Version 3

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.

Entity Relationship Diagrams

Click an image for its full-size version

CRM Data Touchpoint Creation Data

Touchpoint Attributes Spend Data

BIZ_ACCOUNTS

All CRM Accounts that are imported, along with custom Bizible fields.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

CRM AccountId

0013100001kpAZxAAM

X


CREATED_DATE

timestamp_ntz

The created date of the Account from the CRM

2016-08-28 00:32:55.000



MODIFIED_DATE

timestamp_ntz

The last modified date of the Account from the CRM

2018-08-01 17:38:30.000



NAME

varchar

The Account Name, as recorded in the CRM

bizible



WEB_SITE

varchar

Website that is entered for the Account, used for Lead2Account mapping

www.bizible.com



ENGAGEMENT_RATING

varchar

A letter grade (A, B, C, D, N/A) that is generated from Bizible’s Machine Learning model. This will be null if ABM is disabled.

B



ENGAGEMENT_SCORE

number(38,19)

A numerical score calculated by Bizible’s 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.

bizible



IS_DELETED

boolean

Whether or not the record is deleted in the CRM.

FALSE



CUSTOM_PROPERTIES varchar Custom CRM properties that Bizible has imported from the CRM in JSON format
{"Account_Type__c": "Security", "Foo":"Bar"}


BIZ_ACCOUNT_TO_EMAILS

Lead and Contact email addresses that are mapped and known under CRM Accounts. This table will be empty if ABM is disabled.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ACCOUNT_ID

varchar

CRM AccountId

0013100001phrBAAAY

X

BIZ_ACCOUNTS.ID

EMAIL

varchar

Any email address that has been mapped to the Account, whether through Contact relationships or from Lead2Account mapping

email@bizible.com

X

MODIFIED_DATE

timestamp_ntz

The last modified date of the Account from the CRM

2018-08-31 23:53:39.000



CREATED_DATE

timestamp_ntz

The created date of the Account from the CRM

2018-08-18 22:01:32.000



IS_DELETED

boolean

Whether or not the record is considered deleted

FALSE



BIZ_ACTIVITIES

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

Id of the activity in the CRM

number or GUID depending on the source system

X

BIZ_USER_TOUCHPOINTS.CRM_ACTIVITY_ID

LEAD_ID

varchar

Id of person associated with this activity



CONTACT_ID

timestamp_ntz

Id of person associated with this activity



ACTIVITY_TYPE_ID

boolean

Type Id as defined by the source system



ACTIVITY_TYPE_NAME

varchar

Name as defined by the source system



START_DATE

timestamp_ntz

Start of the activity



END_DATE

timestamp_ntz

End of the activity



CAMPAIGN_ID

varchar

Id of the campaign the activity is part or



SOURCE_SYSTEM

varchar

Type of CRM

Dynamics, Marketo



CREATED_DATE timestamp_ntz The created date of the activity from the CRM
 
    


MODIFIED_DATE timestamp_ntz The last modified date of the activity from the CRM
 
    


BIZ_ADS

Table that stores all ads downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the ad

fb.106851586409075.6052044288804.6052044290004.6053457066804

X

DISPLAY_ID

varchar

The ad id?

6053457066804



AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the ad

fb.106851586409075


BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the ad

Bizible



ADVERTISER_UNIQUE_ID

varchar

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

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

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

Bizible Marketing Analytics



AD_GROUP_UNIQUE_ID

varchar

The ID of the ad group for the ad

fb.106851586409075.6052044288804.6052044290004


BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The name of the ad group for the ad

US - 18+



AD_CAMPAIGN_UNIQUE_ID

varchar

The ID of the campaign for the ad

fb.106851586409075.6052044288804


BIZ_AD_CAMPAIGNS.ID

AD_CAMPAIGN_NAME

varchar

The name of the campaign for the ad

Lead generation Campaign



IS_ACTIVE

boolean

Whether or not the ad is still active in the ads account

FALSE



IS_DELETED

boolean

Whether or not the ad has been deleted in the ads account

FALSE



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-02 06:35:59.000



FIRST_IMPORTED

timestamp_ntz

The date that the ad was first downloaded by Bizible

2018-08-02 06:35:59.000



NAME

varchar

The name of the ad

Ad 2



NEEDS_UPDATE

boolean

Whether or not the ad needs to get updated to get Bizible tagging

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

The name of the ads provider for the ad

Facebook



URL_CURRENT

varchar





URL_OLD

varchar





URL_REQUESTED

varchar





URL_ALTENATIVES

varchar





ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

6008900572523230000


BIZ_FACTS.AD_KEY

BIZ_ADVERTISERS

Table that stores all advertisers downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the advertiser


X

DISPLAY_ID

varchar





AD_ACCOUNT_UNIQUE_ID

varchar




BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar





ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser, specifically for Doubleclick.

300181641



ADVERTISER_NAME

varchar

The name of the advertiser, specifically for Doubleclick.

Bizible 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


BIZ_AD_GROUPS.ID

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


BIZ_AD_CAMPAIGNS.ID

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 ads platform

TRUE



IS_DELETED

boolean

Whether or not the advertiser has been deleted in the ads platform

FALSE



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-02 06:35:59.000



FIRST_IMPORTED

timestamp_ntz

The date and time that this row was first added to the table

2018-08-02 06:35:59.000



NAME

varchar

The name of the advertiser

Bizible Marketing Analytics



NEEDS_UPDATE

boolean

Whether or not this row needs to have Bizible update its tags

FALSE



GROUPING_KEY

varchar





ENTITY_TYPE

varchar

The main object or entity for this table. In this case, “Advertisers”

Advertisers



PROVIDER_TYPE

varchar

The ad provider for the advertiser

Doubleclick



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

6008900572523230000


BIZ_FACTS.ADVERTISER_KEY

BIZ_AD_ACCOUNTS

Table that stores all ads accounts downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the ad account

aw.6601259029

X

DISPLAY_ID

varchar


6601259029



AD_ACCOUNT_UNIQUE_ID

varchar


NULL



AD_ACCOUNT_NAME

varchar


NULL



ADVERTISER_UNIQUE_ID

varchar

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

NULL


BIZ_ADVERTISERS.ID

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


BIZ_AD_GROUPS.ID

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


BIZ_AD_CAMPAIGNS.ID

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 advertiser is still active in the ads platform

TRUE



IS_DELETED

boolean

Whether or not the advertiser has been deleted in the ads platform

FALSE



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-09-06 12:54:37.000



FIRST_IMPORTED

timestamp_ntz

The date and time that this row was first added to the table

2018-08-02 06:35:58.000



NAME

varchar

The name of the ad account

Bizible



NEEDS_UPDATE

boolean

Whether or not the tagging needs to get updatedfor this ads account.

FALSE



GROUPING_KEY

varchar


NULL



ENTITY_TYPE

varchar

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

Account



PROVIDER_TYPE

varchar

The name of the ads provider for the ad account

AdWords



ACCOUNT_CURRENCY_UNIT

varchar

The currency code that is used for the ads account.

USD



COMPANY_ID

varchar


NULL



SOURCE

varchar


NULL



MEDIUM

varchar


NULL



LAST_30_DAYS_COST

number(38,19)

The amount of spend imported for the last 30 days.

17260.000000000000000000



LAST_30_DAYS_IMPRESSIONS

number(38,0)

The number of impressions from the last 30 days

730060



LAST_30_DAYS_CLICKS

number(38,0)

The number of clicks from the last 30 days

3400



LAST_30_DAYS_CONVERSIONS

number(38,0)

The number of conversions reported from the last 30 days

180



TRACKING_URL_TEMPLATE

varchar


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



TRACKING_URL_TEMPLATE_OLD

varchar


NULL



TRACKING_URL_TEMPLATE_REQUESTED

varchar


NULL



TRACKING_URL_TEMPLATE_APPLIED

varchar

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

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



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-4609512587744160000


BIZ_FACTS.AD_ACCOUNT_KEY

BIZ_AD_CAMPAIGNS

Table that stores all campaigns downloaded from any connected ads accounts or UTM campaigns.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the campaign

aw.6601259029.285114995

X

DISPLAY_ID

varchar


285114995



AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the campaign

aw.6601259029


BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the campaign

Bizible



ADVERTISER_UNIQUE_ID

varchar

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

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

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

Bizible 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


BIZ_AD_GROUPS.ID

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

The ID of the campaign

NULL



AD_CAMPAIGN_NAME

varchar

The name of the campaign

NULL



IS_ACTIVE

boolean

Whether or not the campaign is still active in the ads account

TRUE



IS_DELETED

boolean

Whether or not the campaign has been deleted in the ads account

FALSE



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-02 06:35:58.000



FIRST_IMPORTED

timestamp_ntz

The date that the campaign was first downloaded by Bizible

2018-08-02 06:35:58.000



NAME

varchar

The name of the campaign

Partner Retargeting



NEEDS_UPDATE

boolean

Whether or not the campaign needs to get updated to get Bizible tagging

FALSE



GROUPING_KEY

varchar


aw.6601259029



ENTITY_TYPE

varchar

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

Campaign



PROVIDER_TYPE

varchar

The name of the ads 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


NULL



TRACKING_URL_TEMPLATE_OLD

varchar


NULL



TRACKING_URL_TEMPLATE_REQUESTED

varchar


NULL



TRACKING_URL_TEMPLATE_APPLIED

varchar

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

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



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-6008900572523230000


BIZ_FACTS.CAMPAIGN_KEY

BIZ_AD_GROUPS

Table that stores all ad groups downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the ad group

aw.6601259029.317737955.23105326115

X

DISPLAY_ID

varchar


23105326115



AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the ad group

aw.6601259029


BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the ad group

Bizible



ADVERTISER_UNIQUE_ID

varchar

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

NULL


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

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

NULL



AD_GROUP_UNIQUE_ID

varchar

The ID of the ad group for the ad group

NULL



AD_GROUP_NAME

varchar

The name of the ad group for the ad group

NULL



AD_CAMPAIGN_UNIQUE_ID

varchar

The ID of the campaign for the ad group

aw.6601259029.317737955


BIZ_AD_CAMPAIGNS.ID

AD_CAMPAIGN_NAME

varchar

The name of the campaign for the ad group

Revenue Attribution



IS_ACTIVE

boolean

Whether or not the ad group is still active in the ads account

TRUE



IS_DELETED

boolean

Whether or not the ad group has been deleted in the ads account

FALSE



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-02 06:36:14.000



FIRST_IMPORTED

timestamp_ntz

The date that the ad group was first downloaded by Bizible

2018-08-02 06:36:14.000



NAME

varchar

The name of the ad group

Revenue Attribution - Account Based



NEEDS_UPDATE

boolean

Whether or not the ad group needs to get updated to get Bizible tagging

FALSE



GROUPING_KEY

varchar


aw.6601259029.317737955



ENTITY_TYPE

varchar

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

AdGroup



PROVIDER_TYPE

varchar

The name of the ads 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


NULL



TRACKING_URL_TEMPLATE_OLD

varchar


NULL



TRACKING_URL_TEMPLATE_REQUESTED

varchar


NULL



TRACKING_URL_TEMPLATE_APPLIED

varchar

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

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



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-5594512713562690000


BIZ_FACTS.AD_GROUP_KEY

BIZ_AD_PROVIDERS

Table that stores all ad providers recognized from any connected ads accounts. This includes an entry for “SelfReported” costs so that it can link to the costs table.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the ad provider

Bing

X

NAME

varchar

The name of the ad provider

Bing



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

4783788151269206864


BIZ_FACTS.AD_PROVIDER_KEY

BIZ_ATTRIBUTION_TOUCHPOINTS

All touchpoints that are associated with an Opportunity. This table will be empty if Opportunity Touchpoints is disabled.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the touchpoint

BAT2_0060Z00000lFHtOQAW_

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

X


MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-09-01 04:53:53.000



USER_TOUCHPOINT_ID

varchar

A lookup to the Biz_User_Touchpoints table to select columns such as email, campaignmember_id, session_id

email@bizible.com


BIZ_USER_TOUCHPOINTS.ID

OPPORTUNITY_ID

varchar

A lookup to the Biz_Opportunities table to select columns such as Amount or Close Date

0060Z00000lFHtOQAW


BIZ_OPPORTUNITIES.ID

CONTACT_ID

varchar

A lookup to the Biz_Contacts table to select columns such as Created Date

0030Z00003K5bpKQAR


BIZ_CONTACTS.ID

ACCOUNT_ID

varchar

A lookup to the Biz_Accounts table to select columns such as Website or Engagement Rating

0013100001otbIAAAY


BIZ_ACCOUNTS.ID

TOUCHPOINT_DATE

timestamp_ntz

The date of the recorded touchpoint, which is the date that the session occurred

2017-06-20 01:05:20.000



MARKETING_TOUCH_TYPE

varchar

Referred to in the CRM as “Touchpoint Type.” This records the type of activity, whether it was a Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity

Web Form



CHANNEL

varchar

Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Bizible App.

Social.LinkedIn



CATEGORY1

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 1st Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

ABC, or NULL



CATEGORY2

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 2nd Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

Yes, or NULL



CATEGORY3

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 3rd Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

SMB, or NULL



CATEGORY4

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 4th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

New Business, or NULL



CATEGORY5

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 5th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY6

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 6th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY7

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 7th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY8

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 8th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY9

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 9th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY10

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 10th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY11

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 11th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY12

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 12th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY13

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 13th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY14

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 14th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY15

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 15th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



BROWSER_NAME

varchar

From the javascript and IP address, the detected browser that the user was on during the session. For example, Chrome or Internet Explorer.

Chrome



BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer.

58



PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows.

Mac



PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows.

10_12



LANDING_PAGE

varchar

Referred to in the CRM as “Landing Page” This is the first landing page of the session that resulted in a touchpoint.

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



LANDING_PAGE_RAW

varchar

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

http://www.bizible.com/blog/uncover-truth -behind-cost-per-lead?utm_content=27322869&utm_

medium=social&utm_source=linkedin



REFERRER_PAGE

varchar

Referred to in the CRM as “Referrer Page” This is the usually the external landing page immediately before the user comes onto the website.

https://www.linkedin.com/



REFERRER_PAGE_RAW

varchar

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

https://www.linkedin.com/



FORM_PAGE

varchar

Referred to in the CRM as “Form URL.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table.

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



FORM_PAGE_RAW

varchar

Referred to in the CRM as “Form URL - Raw.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table. A raw form page may contain query parameters in the URL.

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



FORM_DATE

timestamp_ntz

The date that the form submission occurred.

2017-06-20 01:06:41.000



CITY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver.

San Francisco



REGION

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia.

California



COUNTRY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada.

United States



MEDIUM

varchar

Used to define the medium that resulted in the touchpoint. This can either be parsed out from the URL from utm_medium or if Bizible is able to resolve an ad, it may be values such as “cpc” or “display.”

social



WEB_SOURCE

varchar

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

linkedin



SEARCH_PHRASE

varchar

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

google bizible



AD_PROVIDER

varchar

The ad platform that Bizible was able to resolve from, typically one of our integration partners.

Google



ACCOUNT_UNIQUE_ID

varchar

The Id of the ads account in which the ad was resolved from.

aw.6601259029


BIZ_AD_ACCOUNTS.ID

ACCOUNT_NAME

varchar

The name of the ads account in which the ad was resolved from, such as Bizible-US.

Bizible



ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser from the ads accounts in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser from the ads account in which the ad was resolved from, such as Bizible Inc. This only applies to Doubleclick Campaign Manager.

Bizible Marketing Analytics



SITE_UNIQUE_ID

varchar

The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651


BIZ_SITES.ID

SITE_NAME

varchar

The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager.

Quora.com



PLACEMENT_UNIQUE_ID

varchar

The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827


BIZ_PLACEMENTS.ID

PLACEMENT_NAME

varchar

The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager.

roadblock



CAMPAIGN_UNIQUE_ID

varchar

The Id of the campaign from the ads account in which the ad was resolved from.

aw.6601259029.317738075


BIZ_AD_CAMPAIGNS.ID

CAMPAIGN_NAME

varchar

The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar.

Marketing Attribution



AD_GROUP_UNIQUE_ID

varchar

The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords.

aw.6601259029.317738075.23105327435


BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords.

Marketing Attribution - General



AD_UNIQUE_ID

varchar

The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

NULL


BIZ_ADS.ID

AD_NAME

varchar

The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display).

NULL



CREATIVE_UNIQUE_ID

varchar

The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.317738075.23105327435.182716179597


BIZ_CREATIVES.ID

CREATIVE_NAME

varchar

The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. 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, which is pulled from the ads 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, which is pulled from the ads 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, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

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



CREATIVE_DISPLAY_URL

varchar

The friendly URL name that’s shown on the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

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



KEYWORD_UNIQUE_ID

varchar

The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads

aw.6601259029.317738075.23105327435.4838421670


BIZ_KEYWORDS.ID

KEYWORD_NAME

varchar

The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search)

"marketing attribution"



KEYWORD_MATCH_TYPE

varchar

The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact”

Phrase



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

The stages that the touchpoint has gone through

Qualified Discovery, Demo Scheduled



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 that gets 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 that gets allocated to this touchpoint because it’s a lead creation touch (See Is_Last_Anon_Click_Percentage)

0.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 (See Is_First_Touch and Is_Lead_Creation_Touch)

0.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 (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_Touch)

0.0153374234214425



FULL_PATH_PERCENTAGE

number(22,19)

The calculated percentage that gets 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 that gets 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, Stages_Touched)

0.0143061513081193



IS_DELETED

boolean

Whether this touchpoint is deleted or not. Used for diagnostics to see if a record was deleted in CRM.

FALSE



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-2712935512233520000


BIZ_FACTS.ATP_KEY

OPPORTUNITY_ROW_KEY

number(38,0)


-2712935512233520000



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)



BIZ_CAMPAIGN_MEMBERS

All CRM Campaign Members that are imported, along with custom Bizible fields. This table will be empty if Campaign Sync is disabled.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

CRM CampaignMember Id

00v0Z00001VVzdLQAT

X


MODIFIED_DATE

timestamp_ntz

The last modified date of the Campaign Member from the CRM

2018-08-31 20:49:54.000



CREATED_DATE

timestamp_ntz

The created date of the Campaign Member from the CRM

2018-08-31 20:49:54.000



BIZIBLE_TOUCH_POINT_DATE

timestamp_ntz

(optional) The date and time that 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

The Id for the related Lead that this Campaign Member is tied to

00Q0Z000013dw4GUAQ


BIZ_LEADS.ID

LEAD_EMAIL

varchar

The email for the related Lead that this Campaign Member is tied to

email@bizible.com



CONTACT_ID

varchar

The Id for the related Contact that this Campaign Member is tied to

00331000032hMxRAAU


BIZ_CONTACTS.ID

CONTACT_EMAIL

varchar

The email for the related Contact that this Campaign Member is tied to

email@bizible.com



STATUS

varchar

The Campaign Member’s status, 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

FALSE



HAS_RESPONDED

boolean

A true/false value that tells if the Campaign Member was marked as “Responded” from the Status picker

TRUE



FIRST_RESPONDED_DATE

timestamp_ntz

A date field that is automatically populated if Has_Responded is marked as true

2018-08-30 07:00:00.000



CAMPAIGN_NAME

varchar

The name for the related Campaign that this Campaign Member is apart of

Fast CMO Interviews



CAMPAIGN_ID

varchar

The Id for the related Campaign that this Campaign Member is apart of

7010Z000001TcKlQAK


BIZ_AD_CAMPAIGNS.ID

CAMPAIGN_TYPE

varchar

The Type that’s selected on the related Campaign that this Campaign Member is apart of. The Type is used to map the Marketing Channel.

Offline



CAMPAIGN_SYNC_TYPE

varchar

Used to determine which Campaign Members to create touchpoints for. The possible values are: Include All Campaign Members, Include “Responded” Campaign Members, Exclude All Campaign Members

Include_All



LEAD_SYNC_STATUS

varchar

Used as an audit field to tell whether or not a touchpoint was generated for this Lead as a Bizible Touchpoint and if not, the reason why it didn’t qualify

No Touchpoint: Date outside model



CONTACT_SYNC_STATUS

varchar

Used as an audit field to tell whether or not a touchpoint was generated for this Contact as a Bizible Touchpoint and if not, the reason why it didn’t qualify

Touchpoint Created



OPP_SYNC_STATUS

varchar

Used as an audit field to tell whether or not a touchpoint was generated for this Contact as a Bizible Attribution Touchpoint and if not, the reason why it didn’t qualify

Touchpoint Created



IS_DELETED

boolean

Finds whether or not the Campaign Member that was in the system is deleted. Used for diagnostics to see if a record was deleted in CRM.

FALSE



CUSTOM_PROPERTIES varchar Custom CRM properties that Bizible has imported from the CRM in JSON format {"Campaign_Type__c":"Dinners","Foo":"Bar"}

BIZ_CHANNELS

Table that stores all marketing channels, as created by the customer.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for each marketing channel

Paid Search

X

NAME

varchar

The name of each marketing channel, as created by the customer

Paid Search



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

2018-08-30 07:00:00.000


BIZ_FACTS.CHANNEL_KEY

BIZ_CONVERSION_RATES

Currency conversion rate data from the CRM.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins
ID number(38,0) A unique value for each currency and start_date combination
X
CURRENCY_ID number(38,0) The unique id value for the currency 7493833133899044458
BIZ_CURRENCIES.ID
SOURCE_ISO_CODE varchar The currency ISO code from the CRM source USD

START_DATE timestamp_ntz The start date of the conversion rate

2018-11-01 00:00:00.000



END_DATE timestamp_ntz The next start date for the conversion rate (i.e. 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) The rate used to convert the currency to the corporate currency 0.76728300

CREATED_DATE timestamp_ntz

2019-03-30 00:54:50.000



MODIFIED_DATE timestamp_ntz

2019-03-30 00:54:50.000



IS_DELETED boolean Used to determine if the row/value was deleted from the CRM FALSE

BIZ_CONTACTS

All CRM Contacts that are imported, along with custom Bizible fields.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

CRM Contact Id

0030Z00003OzioeQAB

X


MODIFIED_DATE

timestamp_ntz

The last modified date of the Contact from the CRM

2018-09-05 05:17:53.000



CREATED_DATE

timestamp_ntz

The created date of the Contact from the CRM

2018-09-05 05:17:51.000



EMAIL

varchar

The email address of the Contact from the CRM

email@bizible.com



ACCOUNTID

varchar

The Id of the related Account that this Contact is tied to

0013100001b44aGAAQ


BIZ_ACCOUNTS.ID

LEAD_SOURCE

varchar

The source in which the contact was created

NULL



BIZIBLE_STAGE

varchar

The current stage that the Contact is sitting in, recognized as a custom stage that can be created in Bizible’s application.

Demo Scheduled



BIZIBLE_STAGE_PREVIOUS

varchar

A string of all stages that the Contact had previously gone through, recognized as custom stages that can be created in Bizible’s application.

Open - Contact



ODDS_OF_CONVERSION

number(38,19)

Bizible’s algorithm of estimating whether a contact will help an opportunity close based on the age and stage

NULL



BIZIBLE_COOKIE_ID

varchar

Bizible’s CookieId value that is 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

Finds whether or not the Contact that was in the system is deleted

FALSE



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

3263982503087870000



CUSTOM_PROPERTIES varchar Custom CRM properties that Bizible has imported from the CRM in JSON format {"Contact_Type__c":"CMO", "Foo":"Bar"}

IS_DUPLICATE boolean Default is 'FALSE'. This column exists to mark any persons (leads, contacts) that exist in both Marketo and CRM as duplicate true. If there are duplicates, the Marketo Source lead will be marked IS_DUPLICATE = true (see BIZ_LEADS) FALSE / TRUE

SOURCE_SYSTEM varchar Default is 'Crm'. This column exists to capture the 'source' (Marketo or Crm) from where a contact was imported into our system.

CRM / Marketo



OTHER_SYSTEM_ID

varchar

Default is 'NULL'. This column exists to map a person from Marketo with a Contact from Crm. The value would be the corresponding ID (from Marketo or CRM)

1234 / 00Q0Z00001OohgTUAR



BIZ_COSTS

All cost data, either from third party integrations or self reported marketing spend, segmented by various dimensions like Account, Channel, Campaign, Creative, Keyword, AdGroup, Site, Placement.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the cost record

aw.6601259029.285114995.21703163075.[AdWords Display]_2018-09-06

X

MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-09-06 12:22:45.000



COST_DATE

timestamp_ntz

The date that the cost was reported on

2018-09-06 00:00:00.000



SOURCE

varchar

The source of the reported cost

[AdWords Display]



COST_IN_MICRO

number(38,0)

The reported cost of the day in millions. User will need to divide the value by 1000000 before using this column.

1410000



CLICKS

number(38,0)

The number of clicks reported for the group for the day

4



IMPRESSIONS

number(38,0)

The number of impressions reported for the group for the day

4187



ESTIMATED_TOTAL_POSSIBLE_IMPRESSIONS

number(38,0)

The total number of impressions that are estimated from DCM for the group for the day

5024



AD_PROVIDER

varchar

The known provider (Google, Bing, Facebook, LinkedIn, SelfReported) in which the cost was pulled from, which could include costs uploaded through Marketing Spend

Google



CHANNEL_UNIQUE_ID

varchar

The Id for the marketing channel, created by Bizible

Display.Google


BIZ_CHANNELS.ID

CHANNEL_NAME

varchar

The name for the marketing channel, created by the customer in the Bizible application

Display.Google



CHANNEL_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the channel, filter this column by “TRUE”

FALSE



ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser pulled from the ads connection, specifically for Doubleclick connections

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser pulled from the ads connection, specifically for Doubleclick connections

Bizible Marketing Analytics



ADVERTISER_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the advertiser, filter this column by “TRUE”

FALSE



ACCOUNT_UNIQUE_ID

varchar

The Id of the ads account pulled from the ads connection

aw.6601259029


BIZ_AD_ACCOUNTS.ID

ACCOUNT_NAME

varchar

The name of the ads account pulled from the ads connection

Bizible



ACCOUNT_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the ads account, filter this column by “TRUE”

FALSE



CAMPAIGN_UNIQUE_ID

varchar

The Id of the campaign pulled from the ads connection

aw.6601259029.285114995


BIZ_AD_CAMPAIGNS.ID

CAMPAIGN_NAME

varchar

The name of the campaign pulled from the ads connection

Partner Retargeting



CAMPAIGN_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the campaign, filter this column by “TRUE”

FALSE



AD_GROUP_UNIQUE_ID

varchar

The Id of the ad group pulled from the ads connection

aw.6601259029.285114995.21703163075


BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The name of the ad group pulled from the ads connection

ClosedOpp



AD_GROUP_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the ad group, filter this column by “TRUE”

TRUE



AD_UNIQUE_ID

varchar

The Id of the ad pulled from the ads connection



BIZ_ADS.ID

AD_NAME

varchar

The name of the ad pulled from the ads connection




AD_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the ad, filter this column by “TRUE”

FALSE



CREATIVE_UNIQUE_ID

varchar

The Id of the creative pulled from the ads connection

aw.6601259029.285114995.51749608028.266050115160


BIZ_CREATIVES.ID

CREATIVE_NAME

varchar

The name of the creative pulled from the ads connection

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



CREATIVE_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the creative, filter this column by “TRUE”

FALSE



KEYWORD_UNIQUE_ID

varchar

The Id of the keyword pulled from the ads connection

aw.6601259029.669328935.39419128772.99608705795


BIZ_KEYWORDS.ID

KEYWORD_NAME

varchar

The name of the keyword pulled from the ads connection

sfdc marketing attribution



KEYWORD_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the keyword, filter this column by “TRUE”

FALSE



PLACEMENT_UNIQUE_ID

varchar

The Id of the placement pulled from the ads connection

120839827


BIZ_PLACEMENTS.ID

PLACEMENT_NAME

varchar

The name of the placement pulled from the ads connection

roadblock



PLACEMENT_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the placement, filter this column by “TRUE”

FALSE



SITE_UNIQUE_ID

varchar

The Id of the site pulled from the ads connection

1695651


BIZ_SITES.ID

SITE_NAME

varchar

The name of the site pulled from the ads connection

quora.com

SITE_IS_AGGREGATABLE_COST

boolean

If rolling up costs and summarizing by the site, filter this column by “TRUE”

FALSE



IS_DELETED

boolean

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

FALSE



ROW_KEY number(38,0)


BIZ_FACTS.COST_KEY

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)



ISO_CURRENCY_CODE varchar The ISO currency code as imported from costs data source. USD

CURRENCY_ID number(38,0)


BIZ_CURRENCIES.ID

BIZ_CREATIVES

Table that stores all creatives downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the creative

ba.3284209.132855866.4556709270.10426699711

X

DISPLAY_ID

varchar


10426699711



AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the creative

ba.3284209


BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the creative

Bizible



ADVERTISER_UNIQUE_ID

varchar

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

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

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

Bizible Marketing Analytics



AD_GROUP_UNIQUE_ID

varchar

The ID of the ad group for the creative

ba.3284209.132855866.4556709270


BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The name of the ad group for the creative

PipelineMarketing.com - General



AD_CAMPAIGN_UNIQUE_ID

varchar

The ID of the campaign for the creative

ba.3284209.132855866


BIZ_AD_CAMPAIGNS.ID

AD_CAMPAIGN_NAME

varchar

The name of the campaign for the creative

PipelineMarketing.com



IS_ACTIVE

boolean

Whether or not the creative is still active in the ads account

TRUE



IS_DELETED

boolean

Whether or not the creative has been deleted in the ads account

FALSE



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-02 06:36:25.000



FIRST_IMPORTED

timestamp_ntz

The date that the creative was first downloaded by Bizible

2018-08-02 06:36:25.000



NAME

varchar

The name of the creative

PipelineMarketing.com



NEEDS_UPDATE

boolean

Whether or not the creative needs to get updated to get Bizible tagging

FALSE



GROUPING_KEY

varchar


ba.3284209.132855866.4556709270



ENTITY_TYPE

varchar

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

Creative



PROVIDER_TYPE

varchar

The name of the ads provider for the creative

BingAds



URL_CURRENT

varchar

The current version of the URL including all tags

cdn.bizible.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





URL_REQUESTED

varchar





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

The URL tracking template that Bizible added to the creative

http://cdn.bizible.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)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

4609512587744160000


BIZ_FACTS.CREATIVE_KEY

BIZ_CRM_EVENTS

All CRM Events that are imported, along with custom Bizible fields.

Requirements: Enable Activities Sync: True

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

CRM Event Id

00U3100000VLUnEEAX

X


CREATED_DATE

timestamp_ntz

The created date of the Event from the CRM

2016-12-12 19:32:53.000



MODIFIED_DATE

timestamp_ntz

The last modified date of the Event from the CRM

2018-09-03 08:39:51.000



LEAD_ID

varchar

The Id of the related Lead that this Event is tied to

00Q0Z000013eVrxUAE


BIZ_LEADS.ID

LEAD_EMAIL

varchar

The email of the related Lead that this Event is tied to

email@bizible.com



CONTACT_ID

varchar

The Id of the related Contact that this Event is tied to

0030Z00003OyjbOQAR


BIZ_CONTACTS.ID

CONTACT_EMAIL

varchar

The email of the related Contact that this Event is tied to

email@bizible.com



BIZIBLE_COOKIE_ID

varchar

Bizible’s CookieId value that is 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

The Type value that’s pulled from the CRM for the Event

Email



EVENT_START_DATE

timestamp_ntz

The start date of the Event record, one of the options used to determine the Bizible Touchpoint Date

2016-12-16 19:30:00.000



EVENT_END_DATE

timestamp_ntz

The end date of the Event record, one of the options used to determine the Bizible Touchpoint Date

2016-12-16 21:30:00.000



IS_DELETED

boolean

Finds whether or not the Event that was in the system is deleted

FALSE



CUSTOM_PROPERTIES varchar Custom CRM properties that Bizible has imported from the CRM in JSON format {"Contact_Type__c":"CMO","Foo":"Bar"}

BIZ_CRM_TASKS

All CRM Tasks that are imported, along with custom Bizible fields.

Requirements: Enable Activities Sync: True OR Enable Call Tracking: True

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

CRM Task Id

00T0Z00004Rf62rUAB

X


CREATED_DATE

timestamp_ntz

The created date of the Task from the CRM

2018-08-27 18:30:25.000



MODIFIED_DATE

timestamp_ntz

The last modified date of the Task from the CRM

2018-08-27 18:31:53.000



LEAD_ID

varchar

The Id of the related Lead that this Task is tied to

00Q0Z000013eVrxUAE


BIZ_LEADS.ID

LEAD_EMAIL

varchar

The email of the related Lead that this Task is tied to

email@bizible.com



CONTACT_ID

varchar

The Id of the related Contact that this Task is tied to

00331000038uGfhAAE


BIZ_CONTACTS.ID

CONTACT_EMAIL

varchar

The email of the related Contact that this Task is tied to

email@bizible.com



BIZIBLE_COOKIE_ID

varchar

Bizible’s CookieId value that is used to populate from an integration partner to map an offline Task to a web session. Requirement: Enable Call Tracking: True

08c1063cb0a64349ad0d2d862f5cc700



ACTIVITY_TYPE

varchar

Used to describe the type of Task, usually along the lines of Call or Email or any other custom value. For Activities, this value is used to populate the Touchpoint Type and Medium.

Call



ACTIVITY_DATE

timestamp_ntz

The date that the Task occurred, one of the options used to determine the Bizible Touchpoint Date

2018-08-27 07:00:00.000



IS_DELETED

boolean

Finds whether or not the Task that was in the system is deleted

FALSE



CUSTOM_PROPERTIES varchar Custom CRM properties that Bizible has imported from the CRM in JSON format {"Contact_Type__c":"CMO", "Foo":"Bar"}

BIZ_CURRENCIES

Table of all ISO currencies.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

number(38,0) A unique Id for the currency record 139474809945095870 X
ISO_CODE varchar The 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 CRM or not FALSE


MODIFIED_DATE timestamp_ntz The last modified date from Bizible 2018-08-27 18:30:25.000


MODIFIED_DATE_CRM timestamp_ntz The last modified date of the currency from the CRM 2018-08-27 18:30:25.000

CREATED_DATE timestamp_ntz The created date from Bizible 2018-08-27 18:30:25.000

CREATED_DATE_CRM timestamp_ntz The created date of the currency from the CRM 2018-08-27 18:30:25.000

ISO_NUMERIC number(38,0) The ISO standard numeric code 048

EXPONENT number(38,0)
2

NAME varchar The name of the currency Argentine Peso

BIZ_CUSTOMER_AB_TESTS

AB Tests that have been recorded which contain a VisitorId and is related to a Biz_Session. This will contain the experiment and variation that the user was shown.

Requirement: Enable AB Tests: Yes

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

VISITOR_ID

varchar

The first cookie of the related visitor Id



BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

COOKIE_ID

varchar

The recorded cookie Id at the time the chat was logged.




EVENT_DATE

timestamp_ntz

The date and time that the chat was logged.




MODIFIED_DATE timestamp_ntz



IP_ADDRESS

varchar

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




EXPERIMENT_ID

varchar

The Id of the experiment that’s pulled from the AB test platform.




EXPERIMENT_NAME

varchar

The name of the experiment that’s pulled from the AB test platform.




VARIATION_ID

varchar

The Id of the experiment’s variation that’s pulled from the AB test platform.




VARIATION_NAME

varchar

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




ABTEST_USER_ID

varchar

The Id of the user that was served the experiment that’s pulled from the AB test platform.




IS_DELETED

boolean

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




BIZ_CUSTOMER_EVENTS

Web events that have been recorded using custom events in the Javascript which contain a VisitorId and is related to a Biz_Session.

Requirement: Enable Bizible Events: True

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

VISITOR_ID

varchar

The first cookie of the related visitor Id



BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

COOKIE_ID

varchar

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




EVENT_DATE

timestamp_ntz

The date and time that the event was triggered from the custom javascript.




MODIFIED_DATE timestamp_ntz



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 that was triggered from the custom javascript. For example, “Video View”




VALUE

varchar

A value that’s given from the event that was triggered from the custom javascript. For example, “75% viewed”




IS_DELETED

boolean

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




BIZ_CUSTOM_LANDING_PAGES

Table that stores all landing pages downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the row


X

DISPLAY_ID

varchar





AD_ACCOUNT_UNIQUE_ID

varchar




BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar





ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser for the landing page, specifically for Doubleclick.

300181641

BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser for the landing page, specifically for Doubleclick.

Bizible Marketing Analytics



AD_GROUP_UNIQUE_ID

varchar




BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar





AD_CAMPAIGN_UNIQUE_ID

varchar




BIZ_AD_CAMPAIGNS.ID

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





AD_DISPLAY_ID

varchar





CREATIVE_DISPLAY_ID

varchar





URL_CURRENT

varchar





URL_OLD

varchar





BIZ_EMAIL_TO_VISITOR_IDS

Email addresses mapped to the Visitor_Id.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

EMAIL

varchar

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

email@bizible.com

X

VISITOR_ID

varchar

The first cookie of the related visitor Id

v_36ec805b4db344d6e92c972c86aee34a

X


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 was deleted, used for diagnostics and auditing.

FALSE



IS_IGNORED boolean



BIZ_FACTS

The biz_facts table unions together Impressions, Page Views, Visits, Form Submits, User Touchpoints, Touchpoints (BT), Attribution Touchpoints (BAT), and Cost data. It is used internally to support Bizible reporting in Discover.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins
COST_KEY number(38,0) The key that relates this table to the BIZ_COSTS table to join the dimensions 2672629811884560039
BIZ_COSTS.ROW_KEY

ATP_KEY

number(38,0)

The key that relates this table to the BIZ_ATTRIBUTION_TOUCHPOINTS table to join the dimensions

2672629811884560039


BIZ_ATTRIBUTION_TOUCHPOINTS.ROW_KEY

TP_KEY

number(38,0)

The key that relates this table to the BIZ_TOUCHPOINTS table to join the dimensions

5028390208679093800


BIZ_TOUCHPOINTS.ROW_KEY

PAGE_VIEW_KEY

number(38,0)

The key that relates this table to the BIZ_PAGE_VIEWS table to join the dimensions

-8044063242541720607


BIZ_PAGE_VIEWS.ROW_KEY

SESSION_KEY

number(38,0)

The key that relates this table to the BIZ_SESSIONS table to join the dimensions

8817975702393619368


BIZ_SESSIONS_ROW_KEY

VISITOR_ID

varchar

The Id that relates this table to the BIZ_EMAIL_TO_VISITOR_IDS table to join the dimensions

v_530d8334c455460df0d48f48270a4b23


BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

COOKIE_ID varchar



FORM_SUBMIT_KEY

number(38,0)

The key that relates this table to the BIZ_FORM_SUBMITS table to join the dimensions

-8659572802702769670


BIZ_FORM_SUBMITS.ROW_KEY

IMPRESSION_KEY

number(38,0)

The key that relates this table to the BIZ_IMPRESSIONS table to join the dimensions

8817975702393619368


BIZ_IMPRESSIONS.ROW_KEY

CURRENT_PAGE_KEY

number(38,0)


4079876040770132443


BIZ_URLS.ROW_KEY

REFERRER_PAGE_KEY

number(38,0)


8817975702393619368


BIZ_URLS.ROW_KEY

FORM_PAGE_KEY

number(38,0)


8817975702393619368



AD_PROVIDER_KEY

number(38,0)

The key that relates this table to the BIZ_AD_PROVIDERS table to join the dimensions

8817975702393619368


BIZ_AD_PROVIDERS.ROW_KEY

CHANNEL_KEY

number(38,0)

The key that relates this table to the BIZ_CHANNELS table to join the dimensions

-1921844114032355934


BIZ_CHANNELS.ROW_KEY

CAMPAIGN_KEY

number(38,0)

The key that relates this table to the BIZ_AD_CAMPAIGNS table to join the dimensions

252687814634577606


BIZ_AD_CAMPAIGNS.ROW_KEY

KEYWORD_KEY

number(38,0)

The key that relates this table to the BIZ_KEYWORDS table to join the dimensions

8817975702393619368


BIZ_KEYWORDS.ROW_KEY

AD_KEY

number(38,0)

The key that relates this table to the BIZ_ADS table to join the dimensions

8817975702393619368


BIZ_ADS.ROW_KEY

AD_GROUP_KEY

number(38,0)

The key that relates this table to the BIZ_AD_GROUPS table to join the dimensions

8817975702393619368


BIZ_AD_GROUPS.ROW_KEY

CREATIVE_KEY

number(38,0)

The key that relates this table to the BIZ_CREATIVES table to join the dimensions

-2333871387956621113


BIZ_CREATIVES.ROW_KEY

SITE_KEY

number(38,0)

The key that relates this table to the BIZ_SITES table to join the dimensions

8817975702393619368


BIZ_SITES.ROW_KEY

ADVERTISER_KEY

number(38,0)

The key that relates this table to the BIZ_ADVERTISERS table to join the dimensions

8817975702393619368


BIZ_ADVERTISERS.ROW_KEY

AD_ACCOUNT_KEY

number(38,0)

The key that relates this table to the BIZ_AD_ACCOUNTS table to join the dimensions

1825012532740770032


BIZ_AD_ACCOUNTS.ROW_KEY

PLACEMENT_KEY

number(38,0)

The key that relates this table to the BIZ_PLACEMENTS table to join the dimensions

8817975702393619368


BIZ_PLACEMENTS.ROW_KEY

CATEGORY_01_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_02_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_03_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_04_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_05_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_06_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_07_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_08_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_09_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_10_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_11_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_12_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_13_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_14_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY
CATEGORY_15_KEY number(38,0)


BIZ_SEGMENTS.ROW_KEY

TYPE

number(38,0)

Maps the row to the category it belongs to:

TPOpp = 1,
Cost = 2,
TPLead = 3,
TPUser = 4,
PageView = 5,
Session = 6,
FormSubmit = 7,
Impression = 8

3



DATE

date


2018-08-28



TIMESTAMP

timestamp_ntz


2018-08-28 19:39:15.000



MODIFIED_DATE

timestamp_ntz

The date and time the row was last modified

2018-08-29 00:46:47.000



COST_IN_MICRO

number(38,0)

The reported cost of the day in millions. User will need to divide the value by 1000000 before using this column.

27370000



IMPRESSIONS

number(38,0)

The number of impressions reported for the day

340



CLICKS

number(38,0)

The number of clicks reported for the day

4



FIRST_CLICK_PERCENTAGE

number(22,19)

The calculated percentage that gets allocated to this touchpoint because it’s a first touch (See Is_First_Touch)

100.0000000000000000000



LAST_ANON_CLICK_PERCENTAGE

number(22,19)

The calculated percentage that gets allocated to this touchpoint because it’s a lead creation touch (See Is_Last_Anon_Click_Percentage)

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 (See Is_First_Touch and Is_Lead_Creation_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 (See Is_First_Touch, Is_Lead_Creation_Touch, and Is_Opp_Creation_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 (See Is_First_Touch, Is_Lead_Creation_Touch, Is_Opp_Creation_Touch,

Is_Closed_Touch)

0.0000000000000000000



CUSTOM_MODEL_PERCENTAGE

number(22,19)

The calculated percentage that gets 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, Stages_Touched)

0.0000000000000000000



AMOUNT

number(38,8)

The deal amount that is expected or closed from the Opportunity

42000.00000000



IS_WON

boolean

Whether or not the Opportunity has been moved to a stage that is considered Won

FALSE



IS_OPP_CLOSED

boolean

Whether or not the Opportunity has been moved to a stage that is considered closed, which can either be Won or Lost

FALSE



OPPORTUNITY_ID

varchar

The Id that relates this table to the BIZ_OPPORTUNITIES table to join the dimension

0060Z00000nFEfEQAW


BIZ_OPPORTUNITIES.ID

OPP_CREATED_DATE

timestamp_ntz

The created date of the Opportunity from the CRM

2018-08-31 15:45:47.000



OPP_CLOSE_DATE

timestamp_ntz

The anticipated or actual Close Date set on the Opportunity

2018-12-31 07:00:00.000



CONTACT_CREATED_DATE

timestamp_ntz

The created date of the Contact from the CRM

2018-08-07 20:49:07.000



CONTACT_ID

varchar

The Id that relates this table to the BIZ_CONTACTS table to join the dimensions

0030Z00003ORVJmQAP


BIZ_CONTACTS.ID

EMAIL varchar



LEAD_CREATED_DATE

timestamp_ntz

The created date of the Lead from the CRM

2017-04-28 00:21:52.000



LEAD_ID

varchar

The Id that relates this table to the BIZ_LEADS table to join the dimensions

00Q3100001GMPIsEAP


BIZ_LEADS.ID

IS_AGGREGATABLE_COST_AD

boolean

If rolling up costs and summarizing by the ad, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_ADVERTISER

boolean

If rolling up costs and summarizing by the advertiser, filter this column by “TRUE”

TRUE



IS_AGGREGATABLE_COST_AD_ACCOUNT

boolean

If rolling up costs and summarizing by the ad account, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_AD_GROUP

boolean

If rolling up costs and summarizing by the ad group, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_CAMPAIGN

boolean

If rolling up costs and summarizing by the campaign, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_CHANNEL

boolean

If rolling up costs and summarizing by the channel, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_CREATIVE

boolean

If rolling up costs and summarizing by the creative, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_KEYWORD

boolean

If rolling up costs and summarizing by the keyword, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_PLACEMENT

boolean

If rolling up costs and summarizing by the placement, filter this column by “TRUE”

FALSE



IS_AGGREGATABLE_COST_SITE

boolean

If rolling up costs and summarizing by the site, filter this column by “TRUE”

FALSE



IS_DELETED

boolean

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

FALSE



ISO_CODE varchar



CURRENCY_ID number(38,0)


BIZ_CURRENCIES.ID

BIZ_FORM_SUBMITS

All form submissions that occurred which contain a VisitorId and is related to a Biz_Session.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the form submission

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

X

COOKIE_ID

varchar

The recorded cookie Id at the time the form was submitted

9bc63c34482f4de8c2e3b9d8d9f0df56



VISITOR_ID

varchar

The first cookie of the related visitor Id

v_9bc63c34482f4de8c2e3b9d8d9f0df56


BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

SESSION_ID

varchar

The recorded session Id at the time the form was submitted

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


BIZ_SESSIONS.ID

EVENT_DATE

timestamp_ntz

The date and time that form was submitted

2018-08-06 01:35:21.000



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-07 23:09:52.000



CURRENT_PAGE

varchar

The URL where the form was submitted without query parameters.

https://info.bizible.com/webinar-marketo-bizible-impact



CURRENT_PAGE_RAW

varchar

The URL where the form was submitted. The current page may contain query parameters in the URL.

https://info.bizible.com/webinar-marketo-bizible-impact?utm_source=partner&mkt_tok=eyJpIjoiTnpBeE1EVml PV0UyWlRObSIsInQiOiI3MEFIek04ZVJiWm9renc1Z29RXC9kXC92YkxycFRYclE0MVhOaH
Nwdml3YTZBZDdPdXh4Q0RmcnBJWXhwZTF1Z0RrbXlDVmxJNzIwNkhWOExxNFZLRmphc

ThVXC9xc3FvR2pET2lXT1ZOMjlKZXEyd3lSMVU3YmljeWdZVWUyZU5iWiJ9



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

The device and browser that the person is using 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

The email address provided that’s pulled directly from the form, as captured from the javascript.

email@bizible.com



FORM_TYPE

varchar


Form



FORM_SOURCE

varchar

The method in which the form was recognized, such as onSubmit or AjaxIntercept

onSubmit



FORM_IDENTIFIER

varchar


-956012665



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-6255315750913680000


BIZ_FACTS.FORM_SUBMIT_KEY

CURRENT_PAGE_KEY number(38,0)



BIZ_IMPRESSIONS

All impressions that have been fired and recorded which contain a VisitorId and is related to the Biz_Touchpoints. This will contain the resolved ads information of the served impression.

Requirements: Enable View Through: True, Doubleclick by Google: True

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the impression


X


COOKIE_ID

varchar

The recorded cookie Id at the time of the impression




VISITOR_ID

varchar

The first cookie of the related visitor Id



BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

SESSION_ID

varchar

The recorded session Id at the time of the impression.



BIZ_SESSIONS.ID

EVENT_DATE

timestamp_ntz

The date and time that the impression was served




MODIFIED_DATE

timestamp_ntz

The last modified date of the row




CURRENT_PAGE

varchar

The URL where the impression was served without query parameters.




CURRENT_PAGE_RAW

varchar

The URL where the form was submitted. The current page may contain query parameters in the URL.




IP_ADDRESS

varchar

The recorded IP address at the time of the impression




TYPE

varchar





USER_AGENT_STRING

varchar

The device and browser that the person is using 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

Referred to in the CRM as “Referrer Page” This is the usually the external landing page immediately before the user comes onto the website.




REFERRER_PAGE-RAW

varchar

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




CITY

varchar

The resolved city from the IP address. For example, Seattle or Vancouver.

Seattle



REGION

varchar

The resolved region from the IP address. For example, Washington or British Columbia.

Washington



COUNTRY

varchar

The resolved country from the IP address. For example, United States or Canada.

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

The ad platform that Bizible was able to resolve from, typically one of our integration partners.




ACCOUNT_UNIQUE_ID

varchar

The Id of the ads account in which the ad was resolved from.



BIZ_AD_ACCOUNTS.ID

ACCOUNT_NAME

varchar

The name of the ads account in which the ad was resolved from, such as Bizible-US.




ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically for Doubleclick connections.

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser from the ads account in which the ad was resolved from, specifically for Doubleclick connections.

Bizible Marketing Analytics



SITE_UNIQUE_ID

varchar

The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651


BIZ_SITES.ID

SITE_NAME

varchar

The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager.

Quora.com



PLACEMENT_UNIQUE_ID

varchar

The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827


BIZ_PLACEMENTS.ID

PLACEMENT_NAME

varchar

The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager.

roadblock



CAMPAIGN_UNIQUE_ID

varchar

The Id of the campaign from the ads account in which the ad was resolved from.



BIZ_AD_CAMPAIGNS.ID

CAMPAIGN_NAME

varchar

The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar.




AD_GROUP_UNIQUE_ID

varchar

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

NULL


BIZ_AD_GROUPS.ID

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

The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).

68035923


BIZ_ADS.ID

AD_NAME

varchar

The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. 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


BIZ_CREATIVES.ID

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 Creative in the Doubleclick hierarchy for impressions

NULL


BIZ_KEYWORDS.ID

KEYWORD_NAME

varchar

Expected to be NULL since there is no Creative in the Doubleclick hierarchy for impressions

NULL



KEYWORD_MATCH_TYPE

varchar

Expected to be NULL since there is no Creative 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. For example, Chrome or Internet Explorer.

Chrome



BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer.

58



PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows.

Mac



PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows.

10_12



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-2712935512233520000


BIZ_FACTS.IMPRESSION_KEY

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)



BIZ_KEYWORDS

Table that stores all keywords downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the keyword

ba.3284209.132630532.3646889365.39464932147

X

DISPLAY_ID

varchar


39464932147



AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the keyword

ba.3284209


BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the keyword

Bizible



ADVERTISER_UNIQUE_ID

varchar

Expected to be NULL since there is no Keyword in the Doubleclick ads hierarchy.

NULL


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

Expected to be NULL since there is no Keyword in the Doubleclick ads hierarchy.

NULL



AD_GROUP_UNIQUE_ID

varchar

The ID of the ad group for the keyword

ba.3284209.132630532.3646889365


BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The name of the ad group for the keyword

Revenue Attribution - B2B



AD_CAMPAIGN_UNIQUE_ID

varchar

The ID of the campaign for the keyword

ba.3284209.132630532


BIZ_AD_CAMPAIGNS.ID

AD_CAMPAIGN_NAME

varchar

The name of the campaign for the keyword

Revenue Attribution



IS_ACTIVE

boolean

Whether or not the keyword is still active in the ads account

TRUE



IS_DELETED

boolean

Whether or not the keyword has been deleted in the ads account

FALSE



MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-02 06:37:29.000



FIRST_IMPORTED

timestamp_ntz

The date that the keyword was first downloaded by Bizible

2018-08-02 06:37:29.000



NAME

varchar

The name of the keyword

[revenue attribution b2b]



NEEDS_UPDATE

boolean

Whether or not the keyword needs to get updated to get Bizible tagging

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

The name of the ads provider for the keyword

BingAds



URL_CURRENT

varchar





URL_OLD

varchar





IS_UPGRADED_URL

boolean


TRUE



WORD

varchar


revenue attribution b2b



MATCH_TYPE

varchar

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

Exact



TRACKING_URL_TEMPLATE

varchar





TRACKING_URL_TEMPLATE_OLD

varchar





TRACKING_URL_TEMPLATE_REQUESTED

varchar





TRACKING_URL_TEMPLATE_APPLIED

varchar


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



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics



BIZ_FACTS.KEYWORD_KEY

BIZ_LANDING_PAGES

Table that stores all landing pages downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the touchpoint


X

DISPLAY_ID

varchar





AD_ACCOUNT_UNIQUE_ID

varchar




BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar





ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser for the landing page, specifically for Doubleclick.

300181641

BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser for the landing page, specifically for Doubleclick.

Bizible Marketing Analytics


AD_GROUP_UNIQUE_ID

varchar




BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar





AD_CAMPAIGN_UNIQUE_ID

varchar




BIZ_AD_CAMPAIGNS.ID

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





BIZ_LEADS

All CRM Leads that are imported, along with custom Bizible fields.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

CRM Lead Id

00Q0Z00001MZcj8UAD

X


MODIFIED_DATE

timestamp_ntz

The last modified date of the Lead from the CRM

2018-08-27 21:52:10.000



CREATED_DATE

timestamp_ntz

The created date of the Lead from the CRM

2018-08-27 21:47:05.000



EMAIL

varchar

The email address of the Lead from the CRM

email@bizible.com



WEB_SITE

varchar

Website that is entered for the Lead, used for Lead2Account mapping

bizible.com



COMPANY

varchar

The company name that is entered for the Lead, used for Lead2Account mapping

Bizible



LEAD_SOURCE

varchar

The value of the Lead Source, as entered in the CRM

NULL



IS_CONVERTED

boolean

Whether or not the Lead has been converted to a Contact

TRUE



CONVERTED_OPPORTUNITY_ID

varchar

The Id of the related Opportunity once the Lead has been converted, if applicable

NULL


BIZ_OPPORTUNITIES.ID

CONVERTED_DATE

timestamp_ntz

The date that the Lead was converted to a Contact, if applicable

2018-08-27 07:00:00.000



CONVERTED_CONTACT_ID

varchar

The Id of the related Contact once the Lead has been converted, if applicable

0030Z00003Oyp25QAB


BIZ_CONTACTS.ID

ACCOUNTID

varchar

The Id of the mapped Account based off of domain and company name matching.

Requirements: Enable ABM

0010Z0000236F9GQAU


BIZ_ACCOUNTS.ID

BIZIBLE_STAGE

varchar

The current stage that the Lead is sitting in, recognized as a custom stage that can be created in Bizible’s application.

Demo Scheduled



BIZIBLE_STAGE_PREVIOUS

varchar

A string of all stages that the Lead had previously gone through, recognized as custom stages that can be created in Bizible’s application.

MQL



ODDS_OF_CONVERSION

number(38,19)

Bizible’s algorithm of estimating if a Lead will convert based on the age and stage

NULL



LEAD_SCORE_MODEL

varchar

(deprecated)

NULL



LEAD_SCORE_RESULTS

varchar

(deprecated)

NULL



BIZIBLE_COOKIE_ID

varchar

Bizible’s CookieId value that is 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

Finds whether or not the Lead that was in the system is deleted

FALSE



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

4609512587744160000



CUSTOM_PROPERTIES varchar Custom CRM properties that Bizible has imported from the CRM in JSON format {"Lead_Type__c":"Sales Created", "Foo":"Bar"}

IS_DUPLICATE

boolean

Default is 'FALSE'. This column exists to mark any persons (leads) that exists in both Marketo and CRM as duplicate true. If there are duplicates, the Marketo Source lead will be marked IS_DUPLICATE = true

FALSE / TRUE



SOURCE_SYSTEM

varchar

Default is 'Crm'. This column exists to capture the 'source' (Marketo or Crm) from where a contact was imported into our system.

CRM / Marketo



OTHER_SYSTEM_ID

varchar

Default is 'NULL'. This column exists to map a person from Marketo with a Contact from Crm. The value would be the corresponding ID (from Marketo or CRM)

1234 / 00Q0Z00001OohgTUAR



BIZ_LEAD_STAGE_TRANSITIONS

Stores all stage transitions that occur on the Lead or Contact, tying it to a touchpoint to generate funnels and velocity calculations.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the transition

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

X

EMAIL

varchar

The provided email address for the related Lead/Contact

email@bizible.com



LEAD_ID

varchar

A lookup to the Lead Id to get data such as created date.

00Q3100001Fx6AlEAJ


BIZ_LEADS.ID

CONTACT_ID

varchar

A lookup to the Contact Id to get data such as created date.

0033100003Aq9grAAB


BIZ_CONTACTS.ID

TOUCHPOINT_ID

varchar

A lookup to the Touchpoint Id to get data such as channel or count.

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


BIZ_TOUCHPOINTS.ID

TRANSITION_DATE

timestamp_ntz

The date that the record transitioned into the stage.

2018-08-27 16:05:34.000



STAGE_ID

varchar

An identifier for the stage, which can either be a position value or external Id. It will be a value if it’s a custom stage, otherwise it will be an Id from the CRM if it’s a Lead Status or Opportunity Stage.

_bizible_FT


BIZ_STAGE_DEFINITIONS.ID

STAGE

varchar

An entry for the current stage and current transition that’s being recorded.

FT



RANK

number(38,0)

The numerical rank of the stage, as ordered in Bizible’s Stage Mapping settings.

1



INDEX

varchar(1)

For the occurrence of the stage (to be used later for Rebound Stages)

NULL



LAST_INDEX

varchar(1)


NULL



IS_PENDING

boolean

Whether or not the touchpoint is considered “pending” and not yet closed lost or closed won. This only appears for customers with Full Path.

FALSE



IS_NON_TRANSITIONAL

boolean

Whether or not 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 be FALSE.

FALSE



PREVIOUS_STAGE_DATE

timestamp_ntz

The transition date for the previous stage, according to the stage rank.

2017-11-28 21:26:44.000



NEXT_STAGE_DATE

timestamp_ntz

The transition date for the next stage, according to the stage rank.

2017-12-11 22:39:17.000



MODIFIED_DATE

timestamp_ntz

The last time the entry or record was modified

2018-08-28 15:31:10.000



IS_DELETED

boolean

Whether or not the record exists in the source table, primarily used for auditing.

FALSE



BIZ_OPPORTUNITIES

All CRM Opportunities that are imported, along with custom Bizible fields.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

CRM Opportunity Id

0060Z00000o89I4QAI

X


MODIFIED_DATE

timestamp_ntz

The last modified date of the Opportunity from the CRM

2018-09-04 17:00:12.000



CREATED_DATE

timestamp_ntz

The created date of the Opportunity from the CRM

2018-09-04 16:07:07.000



ACCOUNT_ID

varchar

The Id of the related Account that this Opportunity is tied to

001i000000qbyeoAAA


BIZ_ACCOUNTS.ID

NAME

varchar

The name of the Opportunity

NULL



IS_WON

boolean

Whether or not the Opportunity has been moved to a stage that is considered Won

FALSE



IS_CLOSED

boolean

Whether or not the Opportunity has been moved to a stage that is considered closed, which can either be Won or Lost

FALSE



CLOSE_DATE

timestamp_ntz

The anticipated or actual Close Date set on the Opportunity

2019-08-28 07:00:00.000



BIZIBLE_CUSTOM_MODEL_DATE

timestamp_ntz

A custom close date, if Close_Date is not used in the CRM, set within the Bizible App to determine which custom Close Date field is being used

NULL



AMOUNT

number(38,8)

The deal amount that is expected or closed from the Opportunity

8988.00000000



CONVERTED_FROM_LEAD_ID

varchar

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

00Q0Z000013eVrxUAE


BIZ_LEADS.ID

CONVERTED_FROM_LEAD_EMAIL

varchar

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

email@bizible.com



PRIMARY_CONTACT_ID

varchar

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

00331000038uGfhAAE


BIZ_CONTACTS.ID

PRIMARY_CONTACT_EMAIL

varchar

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

email@bizible.com



ODDS_OF_CONVERSION

number(38,19)

Bizible’s algorithm of estimating whether an opportunity will close based on the age and stage

0.8225108385086060000



BIZIBLE_STAGE

varchar

The current stage that the Contact is sitting in, recognized as a custom stage that can be created in Bizible’s application.

DM Demo



BIZIBLE_STAGE_PREVIOUS

varchar

A string of all stages that the Contact had previously gone through, recognized as custom stages that can be created in Bizible’s application.

Qualified Discovery, Demo Scheduled



IS_DELETED

boolean

Finds whether or not the Contact that was in the system is deleted

FALSE



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

4609512587744160000



CURRENCY_ISO_CODE varchar



CURRENCY_ID number(38,0)
4609512587744160000
BIZ_CURRENCIES.ID
CUSTOM_PROPERTIES varchar Custom CRM properties that Bizible has imported from the CRM in JSON format {"Opportunity_Location__c":"Seattle", "Foo":"Bar"}

BIZ_OPP_STAGE_TRANSITIONS

Stores all stage transitions that occur on the Opportunity, tying it to a touchpoint to generate funnels and velocity calculations.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the transition

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

X

ACCOUNT_ID

varchar

A lookup to the Account Id to get data such as created date or predictive engagement score (ABM)

0013100001b44nTAAQ


BIZ_ACCOUNTS.ID

OPPORTUNITY_ID

varchar

A lookup to the Opportunity Id to get data such as record type or (opportunity) stage.

0060Z00000nEgjlQAC


BIZ_OPPORTUNITIES.ID

CONTACT_ID

varchar

A lookup to the Contact Id to get data such as created date.

0030Z00003IjojKQAR


BIZ_CONTACTS.ID

TOUCHPOINT_ID

varchar

A lookup to the Lead Id to get data such as channel or count.

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


BIZ_ATTRIBUTION_TOUCHPOINTS.ID

TRANSITION_DATE

timestamp_ntz

The date that the record transitioned into the stage.

2018-05-26 07:29:43.000



STAGE

varchar

An entry for the current stage and current transition that’s being recorded.

Demo Scheduled



STAGE_ID

varchar

An identifier for the stage, which can either be a position value or external Id. It will be a value if it’s a custom stage, otherwise it will be an Id from the CRM if it’s a Lead Status or Opportunity Stage.



BIZ_STAGE_DEFINITIONS.ID

RANK

number(38,0)

The numerical rank of the stage, as ordered in Bizible’s Stage Mapping settings.

4



INDEX

varchar(1)

For the occurrence of the stage (to be used later for Rebound Stages)

1



LAST_INDEX

varchar(1)


1



IS_PENDING

boolean

Whether or not the touchpoint is considered “pending” and not yet closed lost or closed won. This would appear for customers with Full Path if a record is still open.

FALSE



IS_NON_TRANSITIONAL

boolean

Whether or not 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 be FALSE.

FALSE



PREVIOUS_STAGE_DATE

timestamp_ntz

The transition date for the previous stage, according to the stage rank.

2015-07-16 17:41:49.000



NEXT_STAGE_DATE

timestamp_ntz

The transition date for the next stage, according to the stage rank.

2018-08-27 19:40:52.000



MODIFIED_DATE

timestamp_ntz

The last time the entry or record was modified

2018-08-28 03:53:33.000



IS_DELETED

boolean

Whether or not the record exists in the source table, primarily used for auditing.

FALSE



BIZ_PAGE_VIEWS

Page views from web visits with a VisitorId and is related to Biz_Session. Multiple page views can compose of a single session.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the page view

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

X

COOKIE_ID

varchar

The recorded cookie Id at the time of the page view

277d79d01678498fea067c9b631bf6df



VISITOR_ID

varchar

The first cookie of the related visitor Id

v_277d79d01678498fea067c9b631bf6df


BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

SESSION_ID

varchar

The recorded session Id at the time of the page view

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


BIZ_SESSIONS.ID

EVENT_DATE

timestamp_ntz

The date and time of the page view

2018-08-19 16:49:58.000



MODIFIED_DATE

timestamp_ntz

The last time the entry or record was modified

2018-08-19 16:55:37.000



CURRENT_PAGE

varchar

The URL of the current page view without query parameters.

https://info.bizible.com/demo



CURRENT_PAGE_RAW

varchar

The URL of the current page view. The current page may contain query parameters in the URL.

https://info.bizible.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

The device and browser that the person is using 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)

The order in which the page view occurred in the user’s session

1



CLIENT_RANDOM

varchar


103532



IS_DUPLICATED

boolean


FALSE



IS_PROCESSED

boolean


TRUE



REFERRER_PAGE

varchar

The URL where page view originated from without query parameters

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



REFERRER_PAGE_RAW

varchar

The URL where the page view originated from. The referrer page may contain query parameters in the URL.

http://info.bizible.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

The title of the page view

The CMO's Guide to B2B Marketing Attribution Download



EMAIL

varchar





ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-6255315750913680000


BIZ_FACTS.PAGE_VIEW_KEY

CURRENT_PAGE_KEY number(38,0)


BIZ_URLS.ROW_KEY
REFERRER_PAGE_KEY number(38,0)


BIZ_URLS.ROW_KEY

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 Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the placement


X

DISPLAY_ID

varchar





AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the placement



BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the placement




ADVERTISER_UNIQUE_ID

varchar




BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar





AD_GROUP_UNIQUE_ID

varchar

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



BIZ_AD_GROUPS.ID

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

The ID of the campaign for the placement



BIZ_AD_CAMPAIGNS.ID

AD_CAMPAIGN_NAME

varchar

The name of the campaign for the placement




IS_ACTIVE

boolean

Whether or not the placement is still active in the ads account




IS_DELETED

boolean

Whether or not the placement has been deleted in the ads account




MODIFIED_DATE

timestamp_ntz

The last modified date of the row




FIRST_IMPORTED

timestamp_ntz

The date that the placement was first downloaded by Bizible




NAME

varchar

The name of the placement




NEEDS_UPDATE

boolean

Whether or not the placement needs to get updated to get Bizible tagging




GROUPING_KEY

varchar





ENTITY_TYPE

varchar

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




PROVIDER_TYPE

varchar

The name of the ads provider for the placement




ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics



BIZ_FACTS.PLACEMENT_KEY

BIZ_SEGMENTS

Table that stores all segment values that the customer has created.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the segment name

New Business

X

NAME

varchar

The name of the segment created

New Business



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

1028715376434030000


BIZ_FACTS.CATEGORY_01_KEY
BIZ_FACTS.CATEGORY_02_KEY
BIZ_FACTS.CATEGORY_03_KEY
BIZ_FACTS.CATEGORY_04_KEY
BIZ_FACTS.CATEGORY_05_KEY
BIZ_FACTS.CATEGORY_06_KEY
BIZ_FACTS.CATEGORY_07_KEY
BIZ_FACTS.CATEGORY_08_KEY
BIZ_FACTS.CATEGORY_09_KEY
BIZ_FACTS.CATEGORY_10_KEY
BIZ_FACTS.CATEGORY_11_KEY
BIZ_FACTS.CATEGORY_12_KEY
BIZ_FACTS.CATEGORY_13_KEY
BIZ_FACTS.CATEGORY_14_KEY
BIZ_FACTS.CATEGORY_15_KEY

BIZ_SESSIONS

All recorded sessions associated with a VisitorId. Multiple sessions can be associated to a single visitor.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the session

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

X


VISITOR_ID

varchar

The first cookie of the related visitor Id

v_33163948f0a34303f2f4759e5d31a620


BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

COOKIE_ID

varchar

The recorded cookie Id from the session

33163948f0a34303f2f4759e5d31a620



EVENT_DATE

timestamp_ntz

The date and time of the session

2016-08-01 14:24:21.000



MODIFIED DATE

timestamp_ntz

The last modified date of the row

2018-09-01 03:49:10.000



CHANNEL

varchar

Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Bizible App.

Paid Search.AdWords



PAGE_TITLE

varchar

The name of the web page

Salesforce Google Analytics | Bizible



LANDING_PAGE

varchar

Referred to in the CRM as “Landing Page” This is the first landing page of the session that resulted in a touchpoint.

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



LANDING_PAGE_RAW

varchar

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

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



REFERRER_PAGE

varchar

Referred to in the CRM as “Referrer Page” This is the usually the external landing page immediately before the user comes onto the website.

https://www.google.com/



REFERRER_PAGE_RAW

varchar

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

https://www.google.com/



REFERRER_NAME

varchar

The name of the referrer web page

Google



SEARCH_PHRASE

varchar

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

bizible google salesforce



WEB_SOURCE

varchar

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

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 session came from a CRM activity record

FALSE



DEVICE

varchar

The browser and operating system the user is using during the web session

Chrome (65.0), Windows (6.1)



AD_PROVIDER

varchar

The ad platform that Bizible was able to resolve from, typically one of our integration partners.

Google



ACCOUNT_UNIQUE_ID

varchar

The Id of the ads account in which the ad was resolved from.

aw.6601259029


BIZ_AD_ACCOUNTS.ID

ACCOUNT_NAME

varchar

The name of the ads account in which the ad was resolved from, such as Bizible-US.

Bizible



ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically from Doubleclick connection.

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser from the ads account in which the ad was resolved from, such as Bizible Inc.

Bizible Marketing Analytics



SITE_UNIQUE_ID

varchar

The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651


BIZ_SITES.ID

SITE_NAME

varchar

The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager.

Quora.com



PLACEMENT_UNIQUE_ID

varchar

The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827


BIZ_PLACEMENTS.ID

PLACEMENT_NAME

varchar

The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager.

roadblock



CAMPAIGN_UNIQUE_ID

varchar

The Id of the campaign from the ads account in which the ad was resolved from.

aw.6601259029.321586235


BIZ_AD_CAMPAIGNS.ID

CAMPAIGN_NAME

varchar

The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar.

Salesforce



AD_GROUP_UNIQUE_ID

varchar

The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords.

aw.6601259029.321586235.23182235435


BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords.

Salesforce - Google Analytics



AD_UNIQUE_ID

varchar

The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).



BIZ_ADS.ID

AD_NAME

varchar

The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display).




CREATIVE_UNIQUE_ID

varchar

The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.321586235.23182235435.83558988035


BIZ_CREATIVES.ID

CREATIVE_NAME

varchar

The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. 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, which is pulled from the ads 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, which is pulled from the ads 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, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

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



CREATIVE_DISPLAY_URL

varchar

The friendly URL name that’s shown on the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Bizible.com/Salesforce-for-GA



KEYWORD_UNIQUE_ID

varchar

The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search

aw.6601259029.321586235.23182235435.35934468937


BIZ_KEYWORDS.ID

KEYWORD_NAME

varchar

The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search)

google analytics salesforce



KEYWORD_MATCH_TYPE

varchar

The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact”

Phrase



CAMPAIGN

varchar

This is parsed out from the URL from utm_campaign

SU - ABC Accounts - Paid Media Skills



SOURCE

varchar

This is parsed out from the URL from utm_source

linkedin



MEDIUM

varchar

This is parsed out from the URL from utm_medium

Social



TERM

varchar

This is parsed out from the URL from utm_term

lisu07261601



CONTENT

varchar

This is parsed out from the URL from utm_content

2016 AdWords Benchmark Report



CITY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver.

Seattle



REGION

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia.

Washington



COUNTRY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada.

United States



ISP_NAME

varchar

The internet service provider of the user

AT&T U-verse



IP_ADDRESS

varchar

The recorded IP address at the time the session

174.127.184.158



IS_DELETED

boolean

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

FALSE



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-251659132606672000


BIZ_FACTS.SESSION_KEY

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)



BIZ_SITES

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

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the site


X

DISPLAY_ID

varchar





AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the site



BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the site




ADVERTISER_UNIQUE_ID

varchar

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

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

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

Bizible Marketing Analytics



AD_GROUP_UNIQUE_ID

varchar

Expected to be NULL since there is no Ad Group above the Site in any ads hierarchy



BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

Expected to be NULL since there is no Ad Group above the Site in any ads hierarchy




AD_CAMPAIGN_UNIQUE_ID

varchar

The ID of the campaign for the site



BIZ_AD_CAMPAIGNS.ID

AD_CAMPAIGN_NAME

varchar

The name of the campaign for the site




IS_ACTIVE

boolean

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




IS_DELETED

boolean

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




MODIFIED_DATE

timestamp_ntz

The last modified date of the row




FIRST_IMPORTED

timestamp_ntz

The date that the site was first downloaded by Bizible




NAME

varchar

The name of the site




NEEDS_UPDATE

boolean

Whether or not the site needs to get updated to get Bizible tagging




GROUPING_KEY

varchar





ENTITY_TYPE

varchar

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




PROVIDER_TYPE

varchar

The name of the ads provider for the site




ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics



BIZ_FACTS.SITE_KEY

Table that stores all site links downloaded from any connected ads accounts.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the site link

aw.6601259029.285077795.1654234342

X

DISPLAY_ID

varchar


1654234342



AD_ACCOUNT_UNIQUE_ID

varchar

The ID of the connected ads account for the site link

aw.6601259029


BIZ_AD_ACCOUNTS.ID

AD_ACCOUNT_NAME

varchar

The name of the connected ads account for the site link

Bizible



ADVERTISER_UNIQUE_ID

varchar

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

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

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

Bizible Marketing Analytics



AD_GROUP_UNIQUE_ID

varchar

The ID of the ad group for the site link



BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The name of the ad group for the site link




AD_CAMPAIGN_UNIQUE_ID

varchar

The ID of the campaign for the site link

aw.6601259029.285077795


BIZ_AD_CAMPAIGNS.ID

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 Bizible

2018-08-02 06:36:50.000



NAME

varchar

The name of the site link




NEEDS_UPDATE

boolean

Whether or not the site link needs to get updated to get Bizible 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


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

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



URL_OLD

varchar





URL_REQUESTED

varchar





BIZ_STAGE_DEFINITIONS

Lists all Lead Statuses and Opportunity Stages from the CRM, as well as any custom stages defined in Bizible Settings.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique identifier for the stage

01J3100000QE753EAD

X

MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-22 17:27:27.000



STAGE_NAME

varchar

The name of the stage

Verbal



IS_INACTIVE

boolean


FALSE



IS_IN_CUSTOM_MODEL

boolean

Whether or not the stage has been selected to track in the custom attribution model

FALSE



IS_BOOMERANG

boolean

Whether or not the stage has been selected to track as a boomerang stage

FALSE



IS_TRANSITION_TRACKING

boolean


FALSE



STAGE_STATUS

varchar

The status of the stage, whether it’s an Open, Lost, or Won stage

Open



IS_FROM_SALESFORCE

boolean

Whether or not the stage is pulled from Salesforce

TRUE



IS_DEFAULT

boolean


FALSE



RANK

number(38,0)

The numerical rank of the stage that can be used to sort all stages

53



IS_DELETED

boolean

Whether or not the stage has been deleted

FALSE



BIZ_TOUCHPOINTS

All touchpoints that are associated with a Lead and/or Contact. This table will be empty if Lead Touchpoints or Contact Touchpoints are disabled.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the touchpoint record

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

X


MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-08-29 22:29:30.000



EMAIL

varchar

The known email address that’s tied to this touchpoint via a Lead or Contact

email@bizible.com



CONTACT_ID

varchar

A lookup to the Biz_Contacts table to select columns such as Created Date

0030Z00003Fhe7qQAB


BIZ_CONTACTS.ID

ACCOUNT_ID

varchar

A lookup to the Biz_Accounts table to select columns such as Website or Engagement Rating

0013100001lSLScAAO


BIZ_ACCOUNTS.ID

LEAD_ID

varchar

A lookup to the Biz_Leads table to select columns such as Created Date

00Q0Z000013e2PYUAY


BIZ_LEADS.ID

UNIQUE_ID_PERSON

varchar

The parent person record that relates to a Lead or Contact

Person_00Q0Z000013e2PYUAY



USER_TOUCHPOINT_ID

varchar

A lookup to the Biz_User_Touchpoints table to select columns such as session_id

email@bizible.com_2018-08-29:18-14-53-8102030.10df92cbb414


BIZ_USER_TOUCHPOINTS.ID

VISITOR_ID varchar


BIZ_EMAIL_TO_VISITOR_IDS.VISITOR_ID

TOUCHPOINT_DATE

timestamp_ntz

The date of the recorded touchpoint, which is the date that the session occurred

2018-08-27 20:04:40.000



MARKETING_TOUCH_TYPE

varchar

Referred to in the CRM as “Touchpoint Type.” This records the type of activity, whether it was a Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity

Web Form



CHANNEL

varchar

Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Bizible App.

Social.LinkedIn



CATEGORY1

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 1st Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

ABC, or NULL



CATEGORY2

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 2nd Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

Yes, or NULL



CATEGORY3

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 3rd Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

Other, or NULL



CATEGORY4

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 4th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

Partner, or NULL



CATEGORY5

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 5th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY6

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 6th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY7

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 7th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY8

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 8th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY9

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 9th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY10

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 10th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY11

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 11th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY12

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 12th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY13

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 13th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY14

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 14th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



CATEGORY15

varchar

Referred to in the CRM as “Segments.” This is the segment value for the 15th Category that the touchpoint falls into, as defined in the segment definitions within the Bizible App.

NULL



BROWSER_NAME

varchar

From the javascript and IP address, the detected browser that the user was on during the session. For example, Chrome or Internet Explorer.

Chrome



BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer.

68



PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows.

Windows



PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows.

6.1



LANDING_PAGE

varchar

Referred to in the CRM as “Landing Page.” This is the first landing page of the session that resulted in a touchpoint.

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



LANDING_PAGE_RAW

varchar

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

https://info.bizible.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

Referred to in the CRM as “Referrer Page.” This is the usually the external landing page immediately before the user comes onto the website.

https://www.linkedin.com/feed



REFERRER_PAGE_RAW

varchar

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

https://www.linkedin.com/feed



FORM_PAGE

varchar

Referred to in the CRM as “Form - URL.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table.

https://info.bizible.com/demo



FORM_DATE

timestamp_ntz

The date that the form submission occurred.

https://info.bizible.com/demo?hsCtaTracking=98adcc2f-afe2-40c4-9d79-40dcc41663ee%7C3cfaa909-39cb-4f5d-93eb-be05de6b0180



CITY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver.

New York



REGION

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia.

New York



COUNTRY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada.

United States



MEDIUM

varchar

Used to define the medium that resulted in the touchpoint. This can either be parsed out from the URL from utm_medium or if Bizible is able to resolve an ad, it may be values such as “cpc” or “display.”

Social



WEB_SOURCE

varchar

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

LinkedIn



SEARCH_PHRASE

varchar

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

bizible attribution



AD_PROVIDER

varchar

The ad platform that Bizible was able to resolve from, typically one of our integration partners.

LinkedIn



ACCOUNT_UNIQUE_ID

varchar

The Id of the ads account in which the ad was resolved from.

li.502664737


BIZ_AD_ACCOUNTS.ID

ACCOUNT_NAME

varchar

The name of the ads account in which the ad was resolved from, such as Bizible-US.

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



ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically for Doubleclick connections.

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser from the ads account in which the ad was resolved from, specifically for Doubleclick connections.

Bizible Marketing Analytics



SITE_UNIQUE_ID

varchar

The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651


BIZ_SITES.ID

SITE_NAME

varchar

The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager.

Quora.com



PLACEMENT_UNIQUE_ID

varchar

The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827


BIZ_PLACEMENTS.ID

PLACEMENT_NAME

varchar

The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager.

roadblock



CAMPAIGN_UNIQUE_ID

varchar

The Id of the campaign from the ads account in which the ad was resolved from.

li.502664737.138949954


BIZ_AD_CAMPAIGNS.ID

CAMPAIGN_NAME

varchar

The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar.

SU - COM Accounts - Demand Skills



AD_GROUP_UNIQUE_ID

varchar

The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords.



BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords.




AD_UNIQUE_ID

varchar

The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).



BIZ_ADS.ID

AD_NAME

varchar

The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display).




CREATIVE_UNIQUE_ID

varchar

The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

li.502664737.138949954.66452504


BIZ_CREATIVES.ID

CREATIVE_NAME

varchar

The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Google AdWords and Bing Ads (search).

lisu03151846



CREATIVE_DESCRIPTION_1

varchar

The first line of the creative from the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

Lead gen is dead



CREATIVE_DESCRIPTION_2

varchar

The second line of the creative from the search ad, which is pulled from the ads 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, which is pulled from the ads 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, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

bizible.com/guide



KEYWORD_UNIQUE_ID

varchar

The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search

__GAId__lisu03151846


BIZ_KEYWORDS.ID

KEYWORD_NAME

varchar

The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search)

lisu03151846



KEYWORD_MATCH_TYPE

varchar

The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact”

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. Because this is the lead model, this is expected to be 0.

FALSE



IS_CLOSED_TOUCH

boolean

Whether or not this touchpoint is treated as the closed touch of the opportunity journey. Because this is the lead model, this is expected to be 0.

FALSE



STAGES_TOUCHED

varchar

The stages that the touchpoint has gone through

Open, MQL



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 that gets 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 that gets allocated to this touchpoint because it’s a lead creation touch (See Is_Last_Anon_Click_Percentage)

100



U_SHAPE_PERCENTAGE

number(22,19)

The calculated percentage that gets 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 that gets 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). Because this is the lead model, this is expected to be 0.

0



FULL_PATH_PERCENTAGE

number(22,19)

The calculated percentage that gets 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). Because this is the lead model, this is expected to be 0.

0



CUSTOM_MODEL_PERCENTAGE

number(22,19)

The calculated percentage that gets 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, Stages Touch). Because this is the lead model, this is expected to be 0.

0



IS_DELETED

boolean

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

FALSE



ROW_KEY

number(38,0)

The key that relates this table to the BIZ_FACTS table to fetch all the metrics

-9004910726709710000


BIZ_FACTS.TP_KEY

CONTACT_ROW_KEY

number(38,0)


8817975702393610000



LEAD_ROW_KEY

number(38,0)


-2198155202365030000



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)



BIZ_URLS

A table of all recognized URLs from landing pages or referrer pages or page visits, aggregated into a single table.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

The full URL, from landing pages or referrer pages or page visits

https://www.bizible.com/blog/strategic-marketing-plangoals



SCHEME

varchar

The secure communication of the web page over the network, whether it’s HTTP or HTTPS

https



HOST

varchar

The domain of the URL, with any subdomains

www.bizible.com



PORT

varchar

The port from an internet host, optional in a URL

NULL



PATH

varchar

The part of the URL that points to a specific location on the host.

/blog/strategic-marketing-plangoals



ROW_KEY

number(38,0)


5686109553536636820

X


BIZ_USER_TOUCHPOINTS

Any touchpoint recorded that can be tied to an email, so it can be a web visit, web form, chat, or offline event.

Column

Data Type

Description Sample Data Primary Key Foreign Keys/Joins

ID

varchar

A unique Id for the user touchpoint

email@bizible.com_2018-01-05:16-47-02-8803320.ddf67c101f58

X


MODIFIED_DATE

timestamp_ntz

The last modified date of the row

2018-09-05 23:30:53.000



EMAIL

varchar

The email address that this Touchpoint is created from

email@bizible.com



SESSION_ID

varchar

The Id of the related Session that this Touchpoint is created from

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


BIZ_SESSIONS.ID

CAMPAIGN_MEMBER_ID

varchar

The Id of the related Campaign Member that this Touchpoint is created from

00v0Z00001VTgv1QAD


BIZ_CAMPAIGN_MEMBERS.ID

CRM_EVENT_ID

varchar

The Id of the related Event that this Touchpoint is created from

00U0Z00000pCZmyUAG


BIZ_CRM_EVENTS.ID

CRM_TASK_ID

varchar

The Id of the related Task that this Touchpoint is created from

00T0Z00004Qbd1jUAB


BIZ_CRM_TASKS.ID

IMPRESSION_ID

varchar

The Id of the related Impression that this Touchpoint is created from



BIZ_IMPRESSIONS.ID

TOUCHPOINT_DATE

timestamp_ntz

The date of the recorded touchpoint, which is the date that the session occurred

2018-01-05 16:47:02.000



MARKETING_TOUCH_TYPE

varchar

Referred to in the CRM as “Touchpoint Type.” This records the type of activity, whether it was a Web Visit, Web Form, Web Chat, Phone Call, [CRM] Campaign, or [CRM] Activity

Web Form



CHANNEL

varchar

Referred to in the CRM as “Marketing Channel - Path.” This is the channel that the touchpoint falls into, as defined in the custom channel definitions within the Bizible App.

Social.LinkedIn



BROWSER_NAME

varchar

From the javascript and IP address, the detected browser that the user was on during the session. For example, Chrome or Internet Explorer.

Firefox



BROWSER_VERSION

varchar

From the javascript and IP address, the detected version of the browser that the user was on during the session. For example, Chrome or Internet Explorer.

33



PLATFORM_NAME

varchar

From the javascript and IP address, the detected platform that the user was on during the session. For example, Mac or Windows.

Mac



PLATFORM_VERSION

varchar

From the javascript and IP address, the detected version of the platform that the user was on during the session. For example, Mac or Windows.

10_12



LANDING_PAGE

varchar

Referred to in the CRM as “Landing Page.” This is the first landing page of the session that resulted in a touchpoint.

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



LANDING_PAGE_RAW

varchar

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

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



REFERRER_PAGE

varchar

Referred to in the CRM as “Referrer Page.” This is the usually the external landing page immediately before the user comes onto the website.

https://www.google.com/



REFERRER_PAGE_RAW

varchar

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

https://www.google.com/



FORM_PAGE

varchar

Referred to in the CRM as “Form Page” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table.

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



FORM_PAGE_RAW

varchar

Referred to in the CRM as “Form Page - Raw.” This is the first form that is recorded in a session that resulted in a touchpoint. Subsequent form submissions will not show up in the Biz_Attribution_Touchpoints table, but rather in the Biz_Form_Submits table. A raw form page may contain query parameters in the URL.

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



FORM_DATE

timestamp_ntz

The date that the form submission occurred.

2015-06-03 17:49:10.000



CITY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Seattle or Vancouver.

Oakland



REGION

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, Washington or British Columbia.

California



COUNTRY

varchar

From the javascript and IP address, the detected city that the user was in during the session. For example, United States or Canada.

United States



MEDIUM

varchar

Used to define the medium that resulted in the touchpoint. This can either be parsed out from the URL from utm_medium or if Bizible is able to resolve an ad, it may be values such as “cpc” or “display.”

paid



WEB_SOURCE

varchar

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

linkedin



SEARCH_PHRASE

varchar

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

bizible



AD_PROVIDER

varchar

The ad platform that Bizible was able to resolve from, typically one of our integration partners.

Google



ACCOUNT_UNIQUE_ID

varchar

The Id of the ads account in which the ad was resolved from.

aw.6601259029


BIZ_AD_ACCOUNTS.ID

ACCOUNT_NAME

varchar

The name of the ads account in which the ad was resolved from, such as Bizible-US.

Bizible



ADVERTISER_UNIQUE_ID

varchar

The Id of the advertiser from the ads accounts in which the ad was resolved from, specifically for Doubleclick connections.

300181641


BIZ_ADVERTISERS.ID

ADVERTISER_NAME

varchar

The name of the advertiser from the ads account in which the ad was resolved from, specifically for Doubleclick connections.

Bizible Marketing Analytics



SITE_UNIQUE_ID

varchar

The Id of the site from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

1695651


BIZ_SITES.ID

SITE_NAME

varchar

The site name from the ads account in which the ad was resolved from, such as Quantcast or TechCrunch. This only applies to Doubleclick Campaign Manager.

Quora.com



PLACEMENT_UNIQUE_ID

varchar

The Id placement from the ads account in which the ad was resolved from. This only applies to Doubleclick Campaign Manager.

120839827


BIZ_PLACEMENTS.ID

PLACEMENT_NAME

varchar

The placement name from the ads account in which the ad was resolved from, such as 300x250 or Home Page Takeover. This only applies to Doubleclick Campaign Manager.

roadblock



CAMPAIGN_UNIQUE_ID

varchar

The Id of the campaign from the ads account in which the ad was resolved from.

aw.6601259029.208548635


BIZ_AD_CAMPAIGNS.ID

CAMPAIGN_NAME

varchar

The campaign name from the ads account in which the ad was resolved from, such as Winter Promotion 2018 or Planning Your Budget Webinar.

Brand



AD_GROUP_UNIQUE_ID

varchar

The Id of the ad group from the ads account in which the ad was resolved from. This only applies to Google Adwords.

aw.6601259029.208548635.16750166675


BIZ_AD_GROUPS.ID

AD_GROUP_NAME

varchar

The ad group name from the ads account in which the ad was resolved from. This only applies to Google AdWords.

Brand - Core



AD_UNIQUE_ID

varchar

The id of the ad from the ads account in which the ad was resolved from. This applies to Doubleclick Campaign Manager and Facebook (display).



BIZ_AD.ID

AD_NAME

varchar

The ad name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Doubleclick Campaign Manager and Facebook (display).




CREATIVE_UNIQUE_ID

varchar

The id of the creative from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

aw.6601259029.208548635.16750166675.195329631298


BIZ_CREATIVES.ID

CREATIVE_NAME

varchar

The creative name from the ads account in which the ad was resolved from, such as Winter Promo - Green button or Budget Webinar - sidebar. This applies to Google AdWords and Bing Ads (search).

Bizible Official Site



CREATIVE_DESCRIPTION_1

varchar

The first line of the creative from the search ad, which is pulled from the ads 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, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

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



CREATIVE_DESTINATION_URL

varchar

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

http://info.bizible.com/demo



CREATIVE_DISPLAY_URL

varchar

The friendly URL name that’s shown on the search ad, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search).

bizible.com/demo



KEYWORD_UNIQUE_ID

varchar

The Id of the keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from. This applies to Google AdWords and Bing Ads (search

aw.6601259029.208548635.16750166675.46267805426


BIZ_KEYWORDS.ID

KEYWORD_NAME

varchar

The keyword that was purchased from the Paid Search buy, which is pulled from the ads account in which the ad was resolved from, such as Software Discount or Annual Budget. This applies to Google AdWords and Bing Ads (search)

[bizible]



KEYWORD_MATCH_TYPE

varchar

The type of match that was found between the search phrase and the purchased keyword, such as “broad” or “exact”

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 record was deleted, used for diagnostics and auditing.

FALSE



ROW_KEY

number(38,0)


-5269090762570690000



Sample Queries

How many Leads had sessions from Paid Search in 1-month?

select sum (tp.first_click_percentage)
from biz_leads leads
  join biz_touchpoints tp
    on leads.Id = tp.Lead_Id
  join biz_user_touchpoints utp
    on tp.User_Touchpoint_Id = utp.Id
where utp.touchpoint_date >= '2017-08-01' and utp.touchpoint_date < '2017-09-01' and utp.Channel like
'Paid Search%'

How many sessions are there per Opportunity in Custom Model?

select top 100 opps.Id, count(utp.*)
from biz_opportunities opps
  inner join biz_attribution_touchpoints tp
    on opps.Id = tp.Opportunity_Id
  inner join biz_user_touchpoints utp
    on tp.User_Touchpoint_Id = utp.Id
where tp.Custom_Model_Percentage > 0
group by opps.Id

What is the revenue per channel in Custom model per month?

select tp.Channel, extract(year from tp.Touchpoint_date) as year, extract(month from tp.Touchpoint_date) as month, sum(opps.Amount * tp.Custom_Model_percentage) as amountWithAttribution
from biz_opportunities opps
  join biz_attribution_touchpoints tp
    on opps.Id = tp.Opportunity_Id
group by tp.Channel, extract(year from tp.Touchpoint_date), extract(month from tp.Touchpoint_date) order by 1, 2, 3

How many anonymous sessions by channel?

select channel, count
from biz_sessions
group by channel

What is the top landing page for Leads?

select top 5 landing_page, count
from biz_sessions
group by landing_page

On this page

Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Summit Banner

A virtual event April 27-28.

Expand your skills and get inspired.

Register for free
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now
Adobe Maker Awards Banner

Time to shine!

Apply now for the 2021 Adobe Experience Maker Awards.

Apply now