Integration: Rockerbox

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.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

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:

  • Pro V2

NOTE: You are considered V2 if...

  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com

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.

WARNING: 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)

    The embedded diagram houses the ERD for the Daasity Rockerbox integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.

    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

    • 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

    Related Resources