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 | Will be 1 if this marketing touchpoint is the first interaction. Otherwise will be 0. | int |
14 | ntf_first_touch | First touch conversions, filtered by new to file users | int |
15 | revenue_first_touch | If the marketing touchpoint is the first interaction, it will get full revenue credit. Otherwise will be 0. | float |
16 | ntf_revenue_first_touch | First touch revenue, filtered by new to file users | float |
17 | last_touch | Will be 1 if this marketing touchpoint is the last interaction. Otherwise will be 0 | int |
18 | ntf_last_touch | Last touch conversions, filtered by new to file users | int |
19 | revenue_last_touch | If the marketing touchpoint is the last interaction, it will get full revenue credit. Otherwise will be 0. | float |
20 | ntf_revenue_last_touch | Last touch revenue, filtered by new to file users | float |
21 | even | Fractional credit a marketing touchpoint receives if each touchpoint gets equal weight | float |
22 | ntf_even | Even weight conversions, filtered by new to file users | float |
23 | revenue_even | Using the even weight, the portion of conversion revenue that is attributed to this marketing touchpoint | float |
24 | ntf_revenue_even | Even weight revenue, filtered by new to file users | float |
25 | normalized | Weight given to this marketing touchpoint, as determined by the multi-touch attribution model | float |
26 | ntf_normalized | Modeled weight conversions, filtered by new to file users | float |
27 | revenue_normalized | Using the normalized weight, the portion of conversion revenue that is attributed to this marketing touchpoint | float |
28 | ntf_revenue_normalized | Modeled weight revenue, filtered by new to file users | 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 |