Schema: Data Warehouse - Buckets Breakdown
Order | Name | Description | Type |
1 | type | The report type (e.g., platform_data) | str |
2 | report | The name of the report | str |
3 | advertiser | Rockerbox Account ID | str |
4 | identifier | conversion segment id | 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 cache record was updated most recently | timestamp |