Guide

Digital marketing audit

A digital marketing audit is a structured review of what your advertising actually did in a defined period: what was spent, what it returned, and which of those numbers you can trust. This page explains how to run one on your own exported data, and what CaptainRoo AI checks when you import that data here.

How to run a digital marketing audit

1. Export the report you already have

Take a campaign report, and a search-term report if you have one, out of your advertising account as a CSV for a defined period. Include spend, impressions, clicks, conversions and conversion value where your account records them.

2. Check the data before you read it

Confirm one currency, one reporting grain and no duplicated rows. An audit built on mixed currencies or part-exported columns will read as a performance problem when it is really an export problem.

3. Reconcile the totals

Add the rows up and compare them with the account totals for the same period. Where a figure was never exported, record it as unavailable — not as zero. A zero you invented becomes a decision you regret.

4. Look for the patterns that cost money

Spend concentrated in one campaign, spend with no recorded conversions, cost per conversion drifting against the first half of the period, return on ad spend under your own target, and search terms that spent without converting.

5. Write down the method and the limits

Every finding needs the calculation behind it and what it cannot tell you. A finding with no method is an opinion.

6. Decide, then act in your own account

Approve, defer or decline each next step, make the change yourself in your advertising account, then re-import the following period and measure whether it moved.

What CaptainRoo checks for you

You import the CSV you exported. CaptainRoo maps the columns, reconciles the totals and runs the same checks every time, so two audits of the same data give the same answer. Each finding carries the figures it came from, how it was calculated and what it cannot tell you.

  • Spend concentration across campaigns
  • Spend recorded against no conversions
  • Cost-per-conversion movement across the period
  • Click-through-rate movement across the period
  • Cost per conversion against your own target
  • Return on ad spend against your own target
  • Missing or partial conversion value
  • Inconsistent currency or reporting grain in the import
  • Search terms that spent without converting

What this audit will not do

  • It does not connect to an advertising account, and it makes no changes to one. Every next step is carried out by you, in your own account.
  • It cannot report on figures your export did not contain. Those are shown as unavailable rather than estimated.
  • It does not compare you with competitors or test creative against creative.

Audit your own report

Create a workspace, import the CSV you already export, and run an audit. You will get findings with evidence, a branded PDF you can send on, and a weekly or monthly schedule if you want it repeated.