Integration Specifications

This article will help you learn about how Daasity replicates data from Rockerbox, limitations to the data we can extract and where the data is stored in the Rockerbox schema.

Integration Overview

Rockerbox is a marketing attribution platform that allows businesses to evaluate marketing channel effectiveness and execute better budget channel optimization. Rockerbox incorporates attribution, multi-touch attribution, halo analysis, geo lift, in-channel testing, incrementality and media mix modeling.

The Daasity Rockerbox 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.

Integration Availability

This integration is available for:

• Enterprise

SFTP Feed

The Daasity Rockerbox extractor is built based on this Rockerbox Reports Documentation. Daasity uses an SFTP server to extract files and replicate data from Rockerbox.

You will need to contact Rockerbox to setup a feed to their SFTP server and provide Daasity with the credentials to retrieve your reports to be ingested into your account

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Rockerbox integration illustrating the different tables and keys to join across tables.

Rockerbox Schema

The Daasity Rockerbox extractor creates these tables using the reports and replication methods listed. The data is mapped from source SFTP file to the table based on the mapping logic outlined in each table.

• Spend Report
• Buckets Breakdown
• MTA with UTM

Spend Report

• Endpoint: Reports
• Update Method: UPSERT

• Table Name: [rockerbox.spend_report]

CSV Header	Database Column
date	report_date
platform	platform
tier_1	tier_1
tier_2	tier_2
tier_3	tier_3
tier_4	tier_4
tier_5	tier_5
tier_one	tier_one
tier_two	tier_two
tier_three	tier_three
tier_four	tier_four
tier_five	tier_five
tier_one_alt	tier_one_alt
tier_two_alt	tier_two_alt
tier_three_alt	tier_three_alt
tier_four_alt	tier_four_alt
tier_five_alt	tier_five_alt
spend_assignment_id	spend_assignment_id
spend	spend
imps	impressions
clicks	clicks
Daasity: source_id	__source_id
Daasity: MD5(object)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at
Daasity: account_id	_account_id

Buckets Breakdown

• Endpoint: Reports
• Update Method: UPSERT

• Table Name: [rockerbox.buckets_breakdown]

CSV Header	Database Column
date	date
tier_1	tier_1
tier_2	tier_2
tier_3	tier_3
tier_4	tier_4
tier_5	tier_5
first_touch	first_touch
ntf_first_touch	ntf_first_touch
revenue_first_touch	revenue_first_touch
ntf_revenue_first_touch	ntf_revenue_first_touch
last_touch	last_touch
ntf_last_touch	ntf_last_touch
revenue_last_touch	revenue_last_touch
ntf_revenue_last_touch	ntf_revenue_last_touch
even	even
ntf_even	ntf_even
revenue_even	revenue_even
ntf_revenue_even	ntf_revenue_even
normalized	normalized
ntf_normalized	ntf_normalized
revenue_normalized	revenue_normalized
ntf_revenue_normalized	ntf_revenue_normalized
spend	spend
Daasity: source_id	__source_id
Daasity: MD5(tier_1 + tier_2 + tier_3 + tier_4 + tier_5 + first_touch + last_touch + even + normalize + normalized + spend)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at
Daasity: account_id	_account_id

MTA with UTM

• Endpoint: Reports
• Update Method: UPSERT

• Table Name: [rockerbox.mta_with_utm]

CSV Header	Database Column
uid	uid
date	date
conversion_count	conversion_count
onsite_min	onsite_min
hash_ip_conv	hash_ip_conv
conversion_hash_id	conversion_hash_id
timestamp_conv	timestamp_conv
onsite_count	onsite_count
event_id	event_id
timestamp_events	timestamp_events
total_events	total_events
sequence_number	sequence_number
original_url	original_url
request_referrer	request_referrer
matches	matches
tier_1	tier_1
tier_2	tier_2
tier_3	tier_3
tier_4	tier_4
tier_5	tier_5
normalized	normalized
total_weight	total_weight
revenue	revenue
external_id	external_id
base_id	base_id
email	email
conversion_key	conversion_key
action	action
first_touch	first_touch
revenue_first_touch	revenue_first_touch
last_touch	last_touch
revenue_last_touch	revenue_last_touch
even	even
revenue_even	revenue_even
revenue_normalized	revenue_normalized
utm_medium	utm_medium
utm_source	utm_source
utm_campaign	utm_campaign
Daasity: source_id	__source_id
Daasity: MD5(date + event_id + external_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at
Daasity: account_id	_account_id