Schema: Data Warehouse - MTA Tiers Changelog Table

Updated by Emily Shreero

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


How did we do?