Rockerbox Integration Extractor Info

Rockerbox Extractor Document

download.png

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)
email email 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

 

Was this article helpful?
0 out of 0 found this helpful