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:
|
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
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
|
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. |
Updated 2 months ago