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 |
Updated about 2 years ago