Rockerbox Extractor Document
INTEGRATION OVERVIEW
This integration will allow merchants to integrate both spend and channel attribution data coming from Rockerbox. This gives them access to marketing spend that Daasity may not have an integration for and a more complete channel attribution model.
This integration is available for:
- Pro V2
ERD
ENDPOINT:
https://app.rockerbox.com/documentation/reports
Buckets Breakdown TABLE
Data Mapping.
| JSON Element | Database Column | Datatype |
| date | date | timestamp |
| tier_1 | tier_1 | varchar(255) |
| tier_2 | tier_2 | varchar(255) |
| tier_3 | tier_3 | varchar(255) |
| tier_4 | tier_4 | varchar(255) |
| tier_5 | tier_5 | varchar(255) |
| first_touch | first_touch | decimal(20,4) |
| ntf_first_touch | ntf_first_touch | decimal(20,4) |
| revenue_first_touch | revenue_first_touch | decimal(20,4) |
| ntf_revenue_first_touch | ntf_revenue_first_touch | decimal(20,4) |
| last_touch | last_touch | decimal(20,4) |
| ntf_revenue_last_touch | ntf_revenue_last_touch | decimal(20,4) |
| even | even | decimal(20,4) |
| ntf_even | ntf_even | decimal(20,4) |
| revenue_even | revenue_even | decimal(20,4) |
| ntf_revenue_even | ntf_revenue_even | decimal(20,4) |
| normalized | normalized | decimal(20,4) |
| ntf_normalized | ntf_normalized | decimal(20,4) |
| revenue_normalized | revenue_normalized | decimal(20,4) |
| ntf_revenue_normalized | ntf_revenue_normalized | decimal(20,4) |
| spend | spend | decimal(20,4) |
Business Rules.
| Business Rule | Value |
| Load Type | Upsert |
| Extraction Frequency | Daily |
| Sync Key | DATE + TIER_1 +TIER_2+TIER_3+TIER_4+TIER_5 + SOURCE_ID |
MTA With UTMs TABLE
Data Mapping.
| JSON Element | Database Column | Datatype |
| uid | uid | varchar(255) |
| date | date | timestamp |
| conversion_count | conversion_count | bigint |
| onsite_min | onsite_min | timestamp |
| hash_ip_conv | hash_ip_conv | varchar(255) |
| conversion_hash_id | conversion_hash_id | varchar(255) |
| timestamp_conv | timestamp_conv | timestamp |
| onsite_count | onsite_count | bigint |
| event_id | event_id | varchar(255) |
| timestamp_events | timestamp_events | timestamp |
| total_events | total_events | bigint |
| sequence_number | sequence_number | bigint |
| original_url | original_url | varchar(255) |
| request_referrer | request_referrer | varchar(255) |
| matches | matches | varchar(255) |
| tier_1 | tier_1 | varchar(255) |
| tier_2 | tier_2 | varchar(255) |
| tier_3 | tier_3 | varchar(255) |
| tier_4 | tier_4 | varchar(255) |
| tier_5 | tier_5 | varchar(255) |
| normalized | normalized | decimal(20,4) |
| total_weight | total_weight | decimal(20,4) |
| revenue | revenue | decimal(20,4) |
| external_id | external_id | varchar(255) |
| base_id | base_id | varchar(255) |
| varchar(255) | ||
| conversion_key | conversion_key | varchar(255) |
| action | action | varchar(255) |
| first_touch | first_touch | decimal(20,4) |
| revenue_first_touch | revenue_first_touch | decimal(20,4) |
| last_touch | last_touch | decimal(20,4) |
| revenue_last_touch | revenue_last_touch | decimal(20,4) |
| even | even | decimal(20,4) |
| revenue_even | revenue_even | decimal(20,4) |
| revenue_normalized | revenue_normalized | decimal(20,4) |
| utm_medium | utm_medium | varchar(255) |
| utm_source | utm_source | varchar(255) |
| utm_campaign | utm_campaign | varchar(255) |
Business Rules.
| Business Rule | Value |
| Load Type | Upsert |
| Extraction Frequency | Daily |
| Sync Key | DATE + EVENT_ID+EXTERNAL_ID+SOURCE_ID |