Reference: Demandbase One Data Available with Data Stream

  • Updated

This article contains a list of the Demandbase data available with Data Stream. 

Datasets Listing

Data Stream (new)  Data Stream (old)

Account

Contains key information of each account including scores

Account Scores

Lookup table of the details of all the account score

Account Site-Page Metrics

Historical daily site-page metrics by account and base URL

Account List

List of all account lists

Account List Account

Mapping between accounts and their account lists

Keyword Set

List of all keyword sets

Keyword Set Keyword

All the keywords and its details in every keyword set

Account Keyword Intent

Current keyword intent based around keyword set

Account Keyword Historical Rollup

Historical rollups of current account list account keyword intent

Campaign Performance Rollup

Historical rollups of current ad campaign performance

Campaign Account Performance

Current ad campaign by account lifetime performance

Account

Basic information of all the unique account on the platform within the account

Field Name  Datatype Required? Business Key Notes

Account ID

STRING

TRUE

Demandbase One account ID

Account Domain

STRING

TRUE

   

Account Name

STRING

TRUE

   

Creation Time

TIMESTAMP

TRUE

 

UTC

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Account Score

Snapshot of account scores by account including all scores on the platform 


Field Name Datatype Required? Business Key  Notes

Account Domain

STRING

TRUE

   

Account ID

STRING

TRUE

Voltron account id

Keyword Sets

ARRAY[UINT32]

TRUE

 

Array of keyword set ID and name for the qualification score.

Score Type

ENUM[STRING]

TRUE

Qualification, Pipeline Predict

Score Rating

ENUM[STRING]

TRUE

 

“Unlikely”, “Likely”, “Highly Likely”

Score

DOUBLE

TRUE

   

Merge Key

STRING

TRUE

   

Partition Date

DATE

TRUE

   

Account Site-Page Metric

Site-page metrics per identified account. Not limited to current account list-accounts. One calendar year of historical rollups is provided per delivery.

Field Name Datatype Required? Business Key Notes

Account ID

STRING

TRUE

   

Date

DATE

TRUE

Calendar date of activity.

Base Page

STRING

FALSE

Base page visited by the account and does not include query string params-values.

Page Views Count

UINT32

TRUE

 

Number of page views on particular day

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Account List

Table of all account lists with ID and name

 

Field Name Datatype Required? Business Key Notes

ID

STRING

TRUE

Account list ID

Name

STRING

TRUE

   

Creation Time

TIMESTAMP

TRUE

 

UTC

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Account List Account

Mapping from accounts to to the account list(s)

Field Name Datatype Required?  Business Key Notes

Account List ID

STRING

TRUE

 

Account ID

STRING

TRUE

 

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Keyword Set

Snapshot of keyword set. Can be used to map keyword set id to name.

Field Name  Datatype Required? Business Key Notes

ID

STRING

TRUE

Keyword set id

Name

STRING

TRUE

 

Keyword set name

Competitive

BOOLEAN

TRUE

 

Whether the keywords in the keyword set correspond to intent to buy a competitor

Creation Time

TIMESTAMP

TRUE

 

UTC

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Keyword Set Keyword 

Mapping from keywords to their keyword sets

Field Name Datatype Required? Business Key Notes

Keyword Set ID

STRING

TRUE

 

Keyword

STRING

TRUE

 

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Account Keyword Intent

Snapshot of account and keyword details in the past 365 days.

Field Name  Datatype Required? Business Key Notes

Account ID

STRING

TRUE

Canonical id for account

Keyword

STRING

TRUE

Intent Keyword

Is Trending

BOOLEAN

TRUE

 

True = Is Trending. Trending state is measured as a burst in intent activity in the last week relative to averages for the prior seven weeks.

Intent strength

ENUM[STRING]

   

HIGH, MEDIUM, LOW

Keyword set ID

STRING

 

 

People Researching Count

UINT32

TRUE

 

Count of people researching the keyword in the last 360 days.

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Account Keyword Intent Rollup

Time-based historical rollups of current audience-account keywords. Includes 12 entries of 30-day rollups backward looking from current date (360 days total). 

Field Name  Datatype Required? Business Key Notes

Account ID

STRING

TRUE

Canonical domain for account

Keyword

STRING

TRUE

Intent Keyword

Duration Type

ENUM[STRING]

TRUE

Options(DAY), DAY is single option currently

Duration Count

UINT32

TRUE

The duration of the rollup (e.g. 7 days, 30 days, 365 days)

Backward Ordinal

UINT32

TRUE

 

A backward looking ordinal of historical rollups. For example, the ordinal value ‘1’ of duration 30 days is the last 1-30 days, ‘2’ is last 31 to 60 days.

Start Date

DATE

TRUE

Inclusive calendar start date of rollup

People Researching Count

UINT32

TRUE

 

Count of people researching account keyword in rollup period

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Campaign

Field Name  Datatype Required? Business Key Notes

Campaign ID

STRING

TRUE

Unique Campaign ID

Campaign Name

STRING

TRUE

 

Campaign Name

Account List ID

STRING

TRUE

 

Key to Account List for Campaign

Keyword Set ID

STRING

FALSE

 

Key to the Keyword Set if the campaign has an associated Keyword Set

Creation Time

TIMESTAMP

TRUE

 

UTC

Campaign Start

TIMESTAMP

TRUE

 

UTC

Campaign End

TIMESTAMP

TRUE

 

UTC

Effective Spend Cents

UINT64

TRUE

 

Spend/Cost of campaign account in USD cents

Total Accounts

UINT64

TRUE

   

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Campaign Account (Lifetime) Performance

Cumulative/lifetime performance of current targeting ad campaigns. Includes campaigns where lifetime is within one calendar year of current delivery.

Field Name Datatype Required? Business Key Notes

Campaign ID

STRING

TRUE

Unique Campaign Id

Account ID

STRING

TRUE

 

Is Current Account

BOOLEAN

TRUE

 

True if current audience-account

Effective Spend Cents

UINT64

TRUE

 

Spend/Cost of campaign in USD cents

Impression Count

UINT32

TRUE

   

Click Count

UINT32

TRUE

   

Page Views Count

UINT32

TRUE

   

Click Through Rate

FLOAT

TRUE

 

As a percent, 0-100. Up to 3 decimal places

Effective CPM Cents

UINT32

TRUE

 

CPM for Effective Spend in USD cents

Effective CPC Cents

UINT32

TRUE

 

CPC for Effective Spend in USD cents

Total Users Reached

UINT32

TRUE

 

The number of unique user impressions

High Intent Users Reached

UINT32

TRUE

 

The number of high intent user impressions

Page View Lift

FLOAT

TRUE

 

The percent increase in page views from the account directed through the campaign

Accounts Opportunity Total

UINT32

TRUE

   

Accounts Won Total

UINT32

TRUE

   

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

Campaign Performance Historical Rollup

Historical time-based rollup of performance of current audience-accounts in Targeting ad campaign. One calendar year of historical rollups is provided.

Field Name  Datatype Required? Business Key Notes

Campaign ID

STRING

TRUE

Unique Campaign Id

Account ID

STRING

TRUE

 

Is Current Account

BOOLEAN

TRUE

 

True if current audience-account

Effective Spend Cents

UINT64

TRUE

 

Spend/Cost of campaign in USD cents

Impression Count

UINT32

TRUE

   

Click Count

UINT32

TRUE

   

Page Views Count

UINT32

TRUE

   

Click Through Rate

FLOAT

TRUE

 

As a percent, 0-100. Up to 3 decimal places

Effective CPM Cents

UINT32

TRUE

 

CPM for Effective Spend in USD cents

Effective CPC Cents

UINT32

TRUE

 

CPC for Effective Spend in USD cents

Total Users Reached

UINT32

TRUE

 

The number of unique user impressions

High Intent Users Reached

UINT32

TRUE

 

The number of high intent user impressions

Page View Lift

FLOAT

TRUE

 

The percent increase in page views from the account directed through the campaign

Accounts Opportunity Total

UINT32

TRUE

   

Accounts Won Total

UINT32

TRUE

   

Merge Key

STRING

TRUE

 

Global identifier of record that encodes the business keys, including the partition date. Useful for identifying unique records for merging.

Partition Date

DATE

TRUE

 

Calendar date of refresh - done daily end-of-day. If it is partition column in a partitioned dataset, becomes part of business key.

 

Was this article helpful?

0 out of 1 found this helpful