Schema: Data Warehouse - MTA
| Order | Name | Description | Type |
|---|---|---|---|
| 1 | report | The name of the report | str |
| 2 | advertiser | Rockerbox Account ID | str |
| 3 | identifier | conversion segment id | int |
| 4 | date | Date when the action occurred | date |
| 5 | timestamp_conv | Timestamp of when the conversion occurred (ISO 8601 format in UTC) | timestamp |
| 6 | conversion_hash_id | Identifier per unique conversion (this is a hash of the conversion_key value) | str |
| 7 | conversion_key | An identifier used to denote a unique conversion event (this is typically your provided Order ID) | str |
| 8 | action | Name of the conversion event | str |
| 9 | new_to_file | At the time of conversion, if Rockerbox has seen that user make a Purchase before, then new_to_file = 0. Otherwise, they are considered a new customer and new_to_file = 1. | int |
| 10 | onsite_count | The total number of times a user was seen on your website | int |
| 11 | total_events | Total number of marketing touchpoints leading up to the conversion | int |
| 12 | event_id | Identifier per unique marketing touch point | str |
| 13 | timestamp_events | Timestamp of when the marketing touchpoint occurred (ISO 8601 format in UTC) | timestamp |
| 14 | sequence_number | The order of when this marketing touchpoint occurred (1 = first, 2 = second, etc.) | int |
| 15 | hash_ip_events | Hashed IP address of user for a particular marketing touchpoint | str |
| 16 | type | The report type (e.g., platform_data) | str |
| 17 | uid | Rockerbox User ID cookie | str |
| 18 | user_agent_events | User agent string associated with the user for the marketing event | str |
| 19 | base_id | Primary User ID | str |
| 20 | currency_code | The advertiser reporting currency for both revenue and spend | str |
| 21 | 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 |
| 22 | platform | The name of the platform (e.g., Facebook) | str |
| 23 | spend_key | The ID used to pull spend from an advertisting platform. This is typically the Ad ID, but may differ based on your account setup. | str |
| 24 | matches | List of categorization rules that a touchpoint has matched with. The last rule in the list is applied. | dict |
| 25 | 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 |
| 26 | tier_2 | Marketing channel categorization level 2 | str |
| 27 | tier_3 | Marketing channel categorization level 3 | str |
| 28 | tier_4 | Marketing channel categorization level 4 | str |
| 29 | tier_5 | Marketing channel categorization level 5 (most specific) | str |
| 30 | original_url | URL of the page where the marketing touchpoint occurred | str |
| 31 | request_referrer | Page Referrer (the previous site where the user came from) | str |
| 32 | utm_parameters | All URL parameters that begin with utm_ and their values | dict |
| 33 | url_parameters | All URL parameters, except for those that begin with utm_, and their values | dict |
| 34 | tier_one | One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files. | str |
| 35 | tier_two | One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files. | str |
| 36 | tier_three | One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files. | str |
| 37 | tier_four | One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files. | str |
| 38 | tier_five | One of five fields used by Rockerbox to create marketing events from impression-tracking pixels, webhooks, and batch files. | str |
| 39 | normalized | Weight given to this marketing touchpoint, as determined by the multi-touch attribution model | float |
| 40 | revenue_normalized | Using the normalized weight, the portion of conversion revenue that is attributed to this marketing touchpoint | float |
| 41 | first_touch | Will be 1 if this marketing touchpoint is the first interaction. Otherwise will be 0. | int |
| 42 | revenue_first_touch | If the marketing touchpoint is the first interaction, it will get full revenue credit. Otherwise will be 0. | float |
| 43 | last_touch | Will be 1 if this marketing touchpoint is the last interaction. Otherwise will be 0 | int |
| 44 | revenue_last_touch | If the marketing touchpoint is the last interaction, it will get full revenue credit. Otherwise will be 0. | float |
| 45 | even | Fractional credit a marketing touchpoint receives if each touchpoint gets equal weight | float |
| 46 | revenue_even | Using the even weight, the portion of conversion revenue that is attributed to this marketing touchpoint | float |
| 47 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | int |
| 48 | updated_at | Time the cache record was updated most recently | timestamp |
Updated about 2 years ago