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