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


Did this page help you?