Build a Cross-Platform Paid Media Report

The opportunity

Paid media teams often compare screenshots or exports that use different currencies, attribution windows, and conversion definitions. A useful report must preserve those differences before it combines totals. BizSidekick reads each connected advertising account, normalizes the agreed metrics, and makes gaps visible instead of silently treating every platform number as equivalent.

The result supports a recurring operating review: where spend moved, which campaigns changed materially, and which conclusions remain limited by attribution or incomplete data.

How it works

1. Confirm the reporting scope — Select accounts, complete dates, base currency, comparison period, and the conversion metric used for the review.
2. Read each advertising platform — Pull account, campaign, and ad-set or ad-group delivery metrics from Meta Ads, Google Ads, and TikTok Ads.
3. Normalize comparable fields — Align currency, date boundaries, naming, and metric definitions while retaining platform-specific attribution.
4. Calculate totals and trends — Produce account totals, campaign detail, period-over-period movement, and pacing against the selected budget.
5. Detect reporting anomalies — Flag missing days, inactive campaigns with spend, sudden metric shifts, and changes in conversion coverage.
6. Deliver the review pack — Return an executive summary, sortable campaign table, methodology notes, and prioritized follow-up questions.

Safety boundary

This workflow is read-only. If accounts, dates, currencies, or conversion definitions do not align, BizSidekick labels the limitation and avoids presenting an unsupported blended ROAS.

@BizSidekick Build a paid media performance report for Meta Ads, Google Ads, and TikTok Ads for the last 30 complete days. Normalize currency and metric definitions, compare with the previous period, and explain any missing data.