Buckets Breakdown - Primary Use Cases

In this guide, we review how to leverage the Marketing Performance (Buckets Breakdown) and walk through the below primary use cases:

1. CPA/ROAS at the channel and placement level

2. New vs. Repeat user CPA/ROAS

3. Comparing CPA/ROAS by attribution type


Please reference Marketing Performance Report (Buckets Breakdown) for more details on this report.


1. CPA/ROAS at the channel and placement level

Follow the steps below to see CPA/ROAS at the channel & placement level:

  1. Download buckets breakdown for the desired timeframe - See Sending Ad hoc Reports for more information
  2. Create a pivot table
  3. Add Tiers 1-5 in Rows
  4. Add conversions, revenue, spend to values
  5. Create a custom field: CPA and/or ROAS (See here for calculations to use)


2. New vs. Repeat User CPA/ROAS

Follow the steps below to see CPA/ROAS for new vs. repeat users:

  1. Download buckets breakdown for the desired timeframe - See Sending Ad hoc Reports for more information
  2. Create a pivot table
  3. Add Tiers 1-5 in Rows
  4. Add conversions, revenue, spend to values
  5. Create custom fields: New vs. Repeat CPA and/or ROAS (See here for formulas to use)


3. Comparing CPA/ROAS by attribution type

Follow the steps below to see CPA/ROAS by attribution type:

  1. Download buckets breakdown for the desired timeframe - See Sending Ad hoc Reports for more information
  2. Create a pivot table
  3. Add Tiers 1-5 in Rows
  4. Add conversions, revenue, spend to values
  5. Create custom fields: CPA and/or ROAS by attribution type (See here for formulas to use)

Resources for Reference
Excel pivot table guide Google sheets pivot table guide

How did we do?