Create a column that stores the recent performance across the account (e.g Average CTR over last 28 days) to use a as benchmark for the current performance of individual campaigns.
What can I do with this?
- Compare current campaign performance with a benchmark
- Combine with other Benchmark scripts to automatically flag under and over-performing campaigns
Example
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/14413/direct/1709596074191-image.png)
How it works
The script calculates the overall average for all campaigns and sets it as the benchmark.
Requirements
Setup
- For each metric, you need a dimension to hold the benchmark.
Report
- Account
- Campaign
- <<Metric>>
Customization
- The script can be adapted to any reference any metric in Marin
- Change the date range
- Use the overall campaign average for benchmark, or the average of all campaigns sharing a dimension
Script
Coming soon.