Set benchmark from recent performance

Create a column that stores the recent campaign performance (e.g Average CTR over last 28 days) to use a as benchmark for current performance.

What can I do with this?

  • Compare current performance with a benchmark
  • Combine with other Benchmark scripts to automatically flag under and over performing campaigns

Example

How it works

The script copies the value for the selected metric from the report and uploads it as a dimension.

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

Written by Wes MacLaggan

Last published at: March 19th, 2024