Marketing spend ingest (test)

Run Fivetran-backed Google / Meta / Xero normalisation into cost_events (spend) and cost_campaign_stats (campaign × day delivery metrics for ad platforms).

Firm

Recent campaign × day metrics

Latest rows from cost_campaign_stats (Google Ads + Meta). Run ingest first if empty.

No campaign stats loaded. Pick a firm, run ingest, then click “Load campaign stats”.

Xero ingest lines (preview)

Raw rows from xero_ingest_raw after ingest. Net spend is total_amount (line − tax) and matches spend_aud_cents.

No lines loaded. Pick a firm, run ingest, then click “Load Xero invoice lines”.

Firm spend by month

Monthly rollup from cost_events. Xero invoice rows use ex-GST spend_aud_cents (stored as total_amount in xero_ingest_raw).

No monthly spend loaded yet. Pick a firm and click “Load monthly spend”.