Set benchmark from overall average

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

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.

 

Written by Wes MacLaggan

Last published at: March 12th, 2024