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