Goal
Create a column that stores the recent performance from the parent campaign for each group (e.g, Average CTR over the last 28 days) to use as a benchmark for individual groups' current performance.
What can I do with this?
- Compare current group performance with a benchmark
- Combine with other Benchmark scripts to automatically flag under and over-performing groups
Example
How it works
The script calculates the average of the metric for all the groups in each campaigns that share a dimension value and sets it as the benchmark.
Requirements
Setup
- For each metric, you need a dimension to hold the benchmark.
Report
- Account
- Campaign
- Group
- <<Metric 1>>
- <<Metric 2>>
- …
Customization
- The script can be adapted to any reference any metric in Marin
- Change the date range
- Use the overall average for the benchmark