Set benchmark from parent campaign

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

 

Written by Wes MacLaggan

Last published at: June 3rd, 2024