Tutorial · About 5 minutes

Build a morning ads report

Load sample campaign data, pick the numbers that matter and get the report a person usually builds by hand.

The first hour of the day

In many teams someone starts the day by exporting yesterday's campaign numbers, pasting them into a sheet and writing the same summary. It is often the first hour of a skilled person's day, every day.

Build the report

Load the sample data, pick the metrics, and build the report. It runs in your browser on invented numbers.

Sample data.Two invented exports held in this page, with invented campaign names and figures. The report is assembled in your browser; a file you drop is read locally and never uploaded.

The export

Load one of the invented exports, paste your own, or drop a CSV file onto the box. Your own data is fine: it is read in this tab and goes nowhere.

  • Two days, six campaigns. The ordinary case: yesterday and the day before, in the platform's own column order. It trips all four rules and carries one row that will not parse.
  • Same day, columns moved. One day only, columns in a different order, a currency symbol in the spend column and a blank row. The report says it cannot compare rather than comparing against nothing.

A header row, then one row per campaign per day. Columns are matched by name: date, campaign, impressions, clicks and spend are required, conversions and channel are used when present.

What decides the flags

Four rules, printed here rather than hidden behind the output. A flag whose rule you cannot see is a flag you cannot argue with, and on a real account at least one of these is always wrong for you.

  • Spend of $100 or more with no conversions on the day.
  • Cost per acquisition more than 1.4 times the day before.
  • Click-through rate under 1 percent.
  • A campaign that reported the day before and reports nothing now.

The morning report

Sample data.

Nothing built yet. Load an export and press the button; the table, the comparison and the rows it could not read all appear here.

Read it like a buyer

The useful part is not the table, it is the comparison: which campaign moved against the day before, and by how much. That is what the person used to write by hand.

What usually breaks

The export changes shape when a platform renames a column, or a day is missing.

How it is caught

The report checks the columns it expects and says which are missing, instead of reporting a zero.

What the agent does live

Live, the report is built before anyone starts work and lands where the team reads it. This is the project it comes from.

Try another tutorial

Next step

Want this done for your business?

Tell us what is still done by hand. The free plan usually comes back within 2 business days and says what to fix first, at a fixed price.

We usually reply within 2 business days with a free plan for what to do first. No call needed.