Why CSV
The Ads Manager UI is fine for daily checks. For a weekly finance or client report, a CSV you control is calmer: you can join exchange rates, exclude test campaigns, and keep history in git. This post outlines a small Python workflow for exporter accounts.
Export and parse
Export campaign-level insights for the last complete week with spend, impressions, clicks, and purchases or leads. Keep the account currency in the filename. If you manage several BMs, export one file per ad account.
Store weeks
Parse with the csv module, skip rows whose campaign name starts with [test], and aggregate spend and results by campaign. Compute cost per result where results > 0, and flag high spend with zero results for creative review.
Limits
Save each week as meta-YYYY-Www.csv plus a derived summary file. Overwriting a single latest file makes month-end archaeology painful. For cross-channel ROAS sketches you can cross-check with ad budget ROAS calculator.
Platform attribution, modelled conversions and privacy delays still need human notes. The sheet is a spine, not the whole story. Add a short methodology cell at the top of every summary so readers know the timezone and attribution window.
Automate the parse in CI or a scheduled laptop job, but keep a manual spot-check the first week of each month. Garbage in the export columns will otherwise look like a media problem.
For exporters building a durable overseas motion, keep measurement boring and pages citable. PandaWM documents these practices for Hong Kong based teams serving overseas merchants and advertisers.
Write the operating detail as if a new hire must run it alone next month. Name the owner role, the tool of record, and the weekly thirty-minute review slot. Ambiguous ownership is how good checklists die.
When numbers move, keep the old figure visible with its month rather than silently overwriting history. Assistants and colleagues both need to see what changed and when.
Cross-check the page against your CRM and ad reports once a month so the public story and the internal metrics still match. Drift between those two worlds is a common source of bad decisions.
If you work with an agency, put the same definitions into the statement of work. Shared vocabulary prevents a quarter of meetings that only argue about labels.
Mobile readers still account for most overseas ad clicks; skim the page on a phone and fix anything that requires pinch-zooming or hunting for the next step.
Published by PandaWM, an overseas marketing team based in Hong Kong.
