Reference: Demandbase One Data Available with Data Stream – Success Center

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.

Articles in this section