Schema: Data Warehouse - Buckets Breakdown
Overview
The Buckets Breakdown table offers granular marketing performance reporting including spend, attributed conversions, and revenue. This dataset is aggregated for each date down to the lowest level of granularity that ad data is tracked in Rockerbox (e.g., ad group level for Google Ads, ad level for Meta).
Because Rockerbox data can change over time as Rockerbox receives new data from each of the sources it aggregates, Rockerbox includes a status table to provide context about the conversions and spend that are included in each update to your Buckets Breakdown dataset(s).
When you create your first buckets breakdown table in your Rockerbox data share, a status table called mta_tiers_changelog_status is also created. See here for the status table schema and more information on how to leverage this table.
Schema
Order | Name | Description | Type |
1 | type | The report type (e.g., platform_data) Note: this static column is only visible in Snowflake integrations | str |
2 | report | The name of the report Note: this static column is only visible in Snowflake integrations | str |
3 | advertiser | Rockerbox Account ID Note: this static column is only visible in Snowflake integrations | str |
4 | identifier | conversion segment id Note: this static column is only visible in Snowflake integrations | int |
5 | date | Date when the action occurred | date |
6 | tier_1 | Marketing channel categorization level 1 (most broad), as defined in your mapping rules. For example, a link where referrer url = Google and utm_campaign = cpc may be mapped as tier_1 = Paid Search and tier_2 = Google | str |
7 | tier_2 | Marketing channel categorization level 2 | str |
8 | tier_3 | Marketing channel categorization level 3 | str |
9 | tier_4 | Marketing channel categorization level 4 | str |
10 | tier_5 | Marketing channel categorization level 5 (most specific) | str |
11 | platform | The name of the platform (e.g., Facebook) | str |
12 | platform_join_key | The ID used to pull spend from an advertising platform. This is typically the Ad ID, but may differ based on your account setup. | str |
13 | first_touch | Conversions attributed via first touch attribution methodology | int |
14 | ntf_first_touch | Conversions for new customers attributed via first touch attribution methodology | int |
15 | revenue_first_touch | Conversion revenue attributed via first touch attribution methodology | float |
16 | ntf_revenue_first_touch | Conversion revenue for new customers attributed via first touch attribution methodology | float |
17 | last_touch | Conversions attributed via last touch attribution methodology | int |
18 | ntf_last_touch | Conversions for new customers attributed via last touch attribution methodology | int |
19 | revenue_last_touch | Conversion revenue attributed via last touch attribution methodology | float |
20 | ntf_revenue_last_touch | Conversion revenue for new customers attributed via last touch attribution methodology | float |
21 | even | Conversions attributed via even weight attribution methodology | float |
22 | ntf_even | Conversions for new customers attributed via even weight attribution methodology | float |
23 | revenue_even | Conversion revenue attributed via even weight attribution methodology | float |
24 | ntf_revenue_even | Conversion revenue for new customers attributed via even weight attribution methodology | float |
25 | normalized | Conversions attributed via multi-touch attribution model | float |
26 | ntf_normalized | Conversions for new customers attributed via multi-touch attribution model | float |
27 | revenue_normalized | Conversion revenue attributed via multi-touch attribution model | float |
28 | ntf_revenue_normalized | Conversion revenue for new customers attributed via multi-touch attribution model | float |
29 | spend | Total spend in the advertisers reporting currency | float |
30 | currency_code | The advertiser reporting currency for both revenue and spend | str |
31 | fx_rate_to_usd | The exchange rate from the local currency to USD for the date. If currency_code is USD, this value will be 1. | float |
32 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | int |
33 | updated_at | Time the record was updated most recently Note: Rockerbox aggregates data on a identifier + date granularity; therefore, when a specific type of data (ex conversion for a single channel) is edited, all records data from the full date are replaced and the updated_at timestamp will be updated for all rows for that identifier + date. | timestamp |