Rockerbox Extractor Document
INTEGRATION OVERVIEW
This integration allows 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.
Key Topics
Integration Availability
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 |