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:
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 |
EXTRACTION EXAMPLE
Depending on the extraction method put several links to Sharepoint here that will reference the following:
- File Method: video showing connecting to data file