UI Exports

Updated by Emily Shreero

Need to export the data you see displayed in the Rockerbox UI for your reporting or for further analysis? Use UI Exports to download on-screen data to an easy to use format.

Rockerbox is making this type of direct export reporting available on an as-requested basis. Additional datasets will likely be added in the future.

UI Export Datasets:

  • Time Period Comparisons

Time Period Comparisons

If you need to report on or perform detailed analysis on 2 time periods, use the Time Period Comparison export to get the data out of Rockerbox.

The report will reflect all the same settings as the UI view, including:

  • Conversion Event
  • New vs Repeat Customers
  • Attribution Type
  • Advanced Filters
  • Date Ranges

Column Name

Description

Tiers 1-5

Full tier granularity (tiers 1-5) is included in all export data.

To see performance less granularly, pivot by a specific tier.

You may use "Advanced Filters" to report on specific-tiers only.

Conversions Date

(separate columns per time period)

Time Period A: column name ex Conversions 2023-11-04 to 2023-12-03

Time Period B: column name Conversions_compare 2023-10-05 to 2023-11-03

If you roll up conversions by a higher level tier (ex tier 3), sum the column.

Conversions_compare Delta (%)

% delta from time period A to time period B

If you roll up conversions by a higher level tier (ex tier 3), recalculate ((SUM conversions time period A - SUM conversions time period B) / SUM conversions time period B)

% of Conversions

(separate columns per time period)

Time Period A: column name % of Conversions 2023-11-04 to 2023-12-03

Time Period B: column name ex % of Conversions_compare 2023-10-05 to 2023-11-03

If you roll up % of conversions by a higher level tier (ex tier 3), sum the column.

% of Conversions_compare Delta

% delta from time period A to time period B

If you roll up % of conversions by a higher level tier (ex tier 3), recalculate ((SUM % of conversions time period A - SUM % of conversions time period B) / SUM % of conversions time period B)

Revenue

Time Period A: column name ex Revenue 2023-11-04 to 2023-12-03

Time Period B: column name ex Revenue_compare 2023-10-05 to 2023-11-03

If you roll up revenue by a higher level tier (ex tier 3), sum the column.

Revenue_compare Delta (%)

% delta from time period A to time period B

If you roll up revenue by a higher level tier (ex tier 3), recalculate ((SUM revenue time period A - SUM revenue time period B) / SUM revenue time period B)

% of Revenue

Time Period A: column name ex % of Revenue 2023-11-04 to 2023-12-03

Time Period B: column name ex % of Revenue_compare 2023-10-05 to 2023-11-03

If you roll up % of revenue by a higher level tier (ex tier 3), sum the column.

% of Revenue_compare Delta

% delta from time period A to time period B

If you roll up % of revenue by a higher level tier (ex tier 3), recalculate ((SUM % of revenue time period A - SUM % of revenue time period B) / SUM % of revenue time period B)

Spend

Time Period A: column name ex Spend 2023-11-04 to 2023-12-03

Time Period B: column name ex Spend_compare 2023-10-05 to 2023-11-03

If you roll up Spend by a higher level tier (ex tier 3), sum the column.

Spend_compare Delta

% delta from time period A to time period B

If you roll up spend by a higher level tier (ex tier 3), recalculate ((SUM spend time period A - SUM spend time period B) / SUM spend time period B)

% of Spend

Time Period A: column name ex % of Spend 2023-11-04 to 2023-12-03

Time Period B: column name ex % of Spend_compare 2023-10-05 to 2023-11-03

If you roll up % of spend by a higher level tier (ex tier 3) sum the column.

% of Spend_compare Delta

% delta from time period A to time period B

If you roll up % of spend by a higher level tier (ex tier 3), recalculate ((SUM % of spend time period A - SUM % of spend time period B) / SUM % of spend time period B)

CPA

Time Period A: column name ex CPA 2023-11-04 to 2023-12-03

Time Period B: column name ex CPA_compare 2023-10-05 to 2023-11-03

If you roll up CPA by a higher level tier (ex tier 3), recalculate CPA using = Spend / Conversions (paying attention to use the same period period for each)

CPA_compare Delta (%)

% delta from time period A to time period B

If you roll up CPA by a higher level tier (ex tier 3), recalculate CPA using = Spend / Conversions (paying attention to use the same period period for each) and then take ((CPA time period A - CPA time period B) / CPA time period B)

ROAS

Time Period A: column name ex CPA 2023-11-04 to 2023-12-03

Time Period B: column name ex CPA_compare 2023-10-05 to 2023-11-03

If you roll up ROAS by a higher level tier (ex tier 3), recalculate ROAS using = Revenue / Spend (paying attention to use the same period period for each)

ROAS_compare Delta (%)

% delta from time period A to time period B

If you roll up ROAS by a higher level tier (ex tier 3), recalculate ROAS using = Revenue / Spend (paying attention to use the same period period for each) and then take ((ROAS time period A - ROAS time period B) / ROAS time period B)

How did we do?