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.

This status table is being rolled out to existing customers over the first half of March 2024. Rockerbox support will reach out directly when this feature is available in your account.

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

Primary Key: the concatenation of date, platform_join_key, and tiers 1-5 can be used as a primary key


How did we do?