Schema: Data Warehouse - MTA Tiers Changelog Table
The mta_tiers_changelog_status table provides context about the changes to conversions and spend in each update to your Buckets Breakdown (MTA Tiers) datasets. This table is updated with one new record whenever Rockerbox syncs a new version of any Buckets Breakdown dataset to your data warehouse.
Best practices for leveraging this table can be found here.
Name | Description | Type |
advertiser | Rockerbox account ID | str |
type | The report type (e.g., platform_data) | str |
rb_platform | The name of the platform (e.g., Rockerbox) | str |
report | The name of the report for which status is being tracked | str |
table_name | Name of the table maintained by Rockerbox in your data warehouse for which status is being tracked | str |
identifier | Conversion segment ID | str |
date | Dataset date | date |
updated_at | Timestamp that dataset was published in Rockerbox | timestamp |
changed_rows | Numbers of rows that changed in this update for the identifier + date | int |
total_rows | Total number of rows for the identifier + date | int |
changed_conversions | Sum of conversions for the rows that changed in this update for the identifier + date | int |
total_conversions | Total conversions for the identifier + date | int |
changed_spend | Sum of spend for the rows that changed in this update for the identifier + date | float |
total_spend | Total spend for the identifier + date | float |
changed_spend_platform_count | Count of platforms with spend for the rows that changed for the identifier + date | int |
total_spend_platform_count | Count of all platforms with spend greater than $0 for the identifier + date | int |
changed_spend_platforms | List of platforms with spend for the rows that changed for the identifier + date | str |
total_spend_platforms | List of all platforms with spend greater than $0 for the identifier and date | |
most_recent | Boolean field that indicates if the record describes the latest update in the status table for a table_name + identifier + date | bool |