Dynamic Strategy Rules Datasets

💡
Discover some useful queries you can run against these datasets.

Placement Definitions

Individual placement details

Name	Column Name	Description
Creation Date	CREATED string	Creation date and time of the placement in `YYYY-MM-DD HH:MM:SS.0000` format
Description	DESCRIPTION string	Description of the placement
Enabled	ENABLED boolean	Indicates if the placement should be loaded This value impacts `IS_DELIVERABLE`.
ID	ID string	Unique identifier for a placement
Is Deleted	IS_DELETED boolean	Indicates whether the placement is deleted
Is Deliverable	IS_DELIVERABLE boolean	Indicates if the placement is deliverable Placements can only be served when `IS_DELIVERABLE` is `true`. To be have a value of `true`, the following conditions must be met: The placement must have an associated strategy. The strategy must be valid. The strategy must have a `ready`status. The placement must be enabled.
Last Modified	LAST_MODIFIED string	Date and time of the last update to the placement in `YYYY-MM-DD HH:MM:SS.0000` format
Name	NAME string	Name of the placement
Site ID	SITE_ID string	Unique alphanumeric identifier of the site
Strategy ID	STRATEGY_ID string	Unique identifier of the strategy metadata loaded within the placement Multiple record may be returned representing all versions of the strategy. Use the latest version to the current strategy configuration when joining on this column.

Placement Sessions

Placement-level ping data

Name	Column Name	Description
Analytics ID	ANALYTICS_ID string	22-character alphanumeric ID representing a grouping of properties
Browser	BROWSER string	Browser on which the placement is embedded
Browser Version	BROWSER_VERSION string	Browser version this user was using
City	CITY string	City from which the user accessed the placement This value is derived from the city associated with the requesting IP or device.
Client ID	CLIENT_ID string	Unique cookie ID for a particular domain This ID can only be used to track a particular viewer within one site, not across different sites
Continent Code	CONTINENT_CODE string	Two-letter continent code for the user who was accessing the placement, such as EU and AF
Country Code	COUNTRY_CODE string	Country code from which this user was accessing the placement
Device Type	DEVICE_TYPE string	Device on which the user experienced the placement, such as Desktop, Phone, Tablet, TV, Other, and Unknown
DMA Code	DMA_CODE string	Designated Market Area for placement ad targeting purposes
Eastern Date	EASTERN_DATE string	Date, Eastern Time. YYYY-MM-DD
Embed Script Version	EMBED_SCRIPT_VERSION string	Version of the placement-embed-js script that loaded on the placement
End Time	END_TIME string	End time of a placement session in UTC (`YYYY-MM-DD HH:MM:SS.0000`) This corresponds to the final ping for a given placement embed ID.
Is Frame Placement	IS_IFRAME_PLACEMENT boolean	Indicates whether the placement is currently running inside of an iFrame Possible Values: `1`: The placement runs inside an iFrame. `0`: The placement does not run inside an iFrame.
Operating System	OPERATING_SYSTEM string	Operating system on device used for given session
Operating System Version	OS_VERSION string	Version for the operating system of the device the placement was experienced on, such as 10.1.
Page Domain	PAGE_DOMAIN string	Domain of the page where the placement occurred
Page Title	PAGE_TITLE string	Title of the page where the placement occurred
Page URL	PAGE_URL string	URL of the page where the placement occurred (window.location.href)
Page URL Normalized	PAGE_URL_NORMALIZED string	URL of the page stripped of query parameters and fragments The path is also encoded using UTF-8. Invalid URLs will be an empty string.
Placement Embed Attempts	PLACEMENT_EMBED_ATTEMPTS number	Number of attempts to embed a specific placement ID
Placement Embed ID	PLACEMENT_EMBED_ID string	Unique identifier generated for each placement instance that is embedded on a page
Placement Embeds	PLACEMENT_EMBEDS number	Number of successful placement embeds for a given placement ID
Placement Evaluation ID	PLACEMENT_EVAL_ID string	Unique identifier generated for each evaluation of a placement on a page
Placement ID	PLACEMENT_ID string	Unique identifier for a placement This is the primary key used when embedding a placement within a publisher's page.
Postal Code	POSTAL_CODE string	Postal or zip code
Referrer URL	REFERRER_URL string	Referring URL that was logged in NGINX
Region	REGION string	Region from which the ping was received
Start Time	START_TIME string	Starting time of a placement session in UTC (`YYYY-MM-DD HH:MM:SS.0000`) This corresponds to the first ping for a given placement embed ID.
Strategy Evaluation Errors	STRATEGY_EVALUATION_ERRORS number	Number of failed strategy evaluations
Strategy Evaluations	STRATEGY_EVALUATIONS number	Number of successful strategy evaluations for a specific placement embed ID
Strategy Outcome ID	STRATEGY_OUTCOME_ID string	Unique identifier for a strategy outcome
Tracker Version	TRACKER_VERSION string	Version of the placement ping plugin
Viewer ID	VIEWER_ID string	Hashed representation of a viewer's user agent and IP address
Viewer Timezone Offset	VIEWER_TZ_OFFSET number	Timezone offset from which the ping was received

Strategy Node Definitions

Individual node configuration details

Name	Column Name	Description
Merged Config	MERGED_CONFIG JSON object	JSON representation of the resulting configuration that will be loaded on the page given the results of any/all conditions within the tree.
Node Definition	NODE_DEFINITION JSON object	JSON representing the specific configuration of the node
Node ID	NODE_ID string	Unique identifier of a node This value is unique only within a given tree or strategy. This identifier is used when identifying the path in a strategy outcome.
Node Subtype	NODE_SUBTYPE string	Subset of the node type
Node Type	NODE_TYPE string	Type of the node Possible Values `ab_test`: Weighted traffic branches `conditional`: Visit conditions, arranged in traditional split branch format `config`: Experiences, including ads, content, and custom code `switch`: Visit conditions, arranged in new groups format `trigger`: Trigger events and actions
Site ID	SITE_ID string	Unique alphanumeric identifier of the site
Strategy ID	STRATEGY_ID string	Unique identifier of the strategy metadata loaded within the placement Multiple record may be returned representing all versions of the strategy. Use the latest version to the current strategy configuration when joining on this column.
Strategy Tree Version ID	STRATEGY_TREE_VERSION_ID string	Unique identifier of a strategy tree version Each time a strategy tree is updates, a new version is generated

Strategy Outcomes

Individual strategy outcome configurations

Name	Column Name	Description
Creation Date	CREATED string	Creation date and time of the record in `YYYY-MM-DD HH:MM:SS.0000` format
ID	ID string	Unique identifier of a strategy outcome
Merged Config	MERGED_CONFIG JSON object	JSON representation of the resulting configuration that will be loaded on the page given the results of any/all conditions within the tree.
Nodes	NODES string array	List of nodes included in the outcome of the tree
Site ID	SITE_ID string	Unique alphanumeric identifier of the site
Strategy ID	STRATEGY_ID string	Unique identifier of the strategy metadata loaded within the placement Multiple record may be returned representing all versions of the strategy. Use the latest version to the current strategy configuration when joining on this column.
Strategy Tree Version ID	STRATEGY_TREE_VERSION_ID string	Unique identifier of a strategy tree version Each time a strategy tree is updates, a new version is generated

Strategy Tree Version

Configuration description of the entire tree

Name	Column Name	Description
Creation Date	CREATED string	Creation date and time of the record in `YYYY-MM-DD HH:MM:SS.0000` format
ID	ID string	Unique identifier of a strategy tree version Each time a strategy tree is updated, a new version is generated.
Is Deleted	IS_DELETED boolean	Indicates whether the placement is deleted
Is Valid	IS_VALID boolean	Indicates if the strategy meets all validation requirements This value is used to determine if the placement is deliverable.
Reference Strategy IDs	REFERENCE_STRATEGY_IDS string array	List of strategy IDs that are referenced within the tree.
Site ID	SITE_ID string	Unique alphanumeric identifier of the site
Strategy ID	STRATEGY_ID string	Unique identifier of the strategy metadata loaded within the placement Multiple record may be returned representing all versions of the strategy. Use the latest version to the current strategy configuration when joining on this column.
Tree	TREE JSON object	Representation of the strategy

Trigger Events

Name	Column Name	Description
Analytics ID	ANALYTICS_ID string	Unique identifier for analytics
Event Time	EVENT_TIME string	Timestamp the event occurred
Node ID	NODE_ID string	Unique identifier of a node This value is unique only within a given tree or strategy. This identifier is used when identifying the path in a strategy outcome.
Placement Embed ID	PLACEMENT_EMBED_ID string	Unique identifier generated for each placement instance that is embedded on a page
Placement Evaluation ID	PLACEMENT_EVAL_ID string	Unique identifier generated for each evaluation of a placement on a page
Placement ID	PLACEMENT_ID string	Unique identifier for a placement This is the primary key used when embedding a placement within a publisher's page.