Skip to content
home

Data and analytics engineering · 2 min read

Pulling spend from every ad platform reliably

APIs, connectors, currencies, time zones and the re-pull window that keeps spend accurate.

By WebIQ Analytics · 18 June 2026

Spend data looks simple: each platform tells you what you spent. In practice it's one of the most common sources of reporting errors. Different time zones, currencies, late adjustments and expiring access tokens all creep in.

Choose how to extract

  • Platform APIs directly (Google Ads, Microsoft Ads, Meta, TikTok, LinkedIn and others). Most control, more engineering.
  • Managed connectors. Faster to set up; check how they handle re-pulls, schema changes and historical backfills.
  • Manual exports. Fine for a one-off analysis; not for anything that feeds a model or a board report.
From platform APIs to reconciled weekly spend.Platform APIs orconnectorsGoogle, Microsoft,Meta, TikTok, LinkedInRaw daily spendAccount currency andtime zoneStandardiseOne currency, one timezone, channel mappedRe-pull windowOverwrite the last 7to 30 daysReconcileAgainst invoicesmonthlyPlatforms revise recent spend (invalid clicks, late adjustments), so re-pull a rolling window rather than loading each dayonce.Illustrative. Window length depends on the platform.
From platform APIs to reconciled weekly spend.

Standardise before you aggregate

  1. Currency. Convert to one reporting currency using a documented rate source and date.
  2. Time zone. Platforms report in the account's time zone. Align to one, or weekly totals won't match.
  3. Spend definition. Media cost only, or including platform and agency fees? Pick one and apply it everywhere.
  4. Channel mapping. Apply your channel taxonomy at this stage, so every downstream table agrees.

Re-pull a rolling window

Platforms revise recent figures: invalid-click credits, late conversions affecting spend-based bidding, billing adjustments. If you load each day once, those revisions are lost. Instead, re-pull and overwrite the most recent 7 to 30 days on every run, depending on the platform.

Reconcile with finance

Once a month, compare platform spend with invoices or finance's media cost figures. Agree a tolerance (for example 1% to 2%) and investigate anything outside it. Common causes: fees, currency timing, credits and campaigns billed through agencies.

Watch for silent failures

  • Expired tokens: extraction runs but returns nothing. Alert when spend for a platform drops to zero unexpectedly.
  • New accounts: spend in an account nobody connected. Keep a list of accounts and check it against billing.
  • Schema changes: a renamed field breaks a transformation. Tests on row counts and totals catch it.

The payoff

Reliable spend is the foundation for every efficiency metric and every mix model. It's unglamorous work, and it's the difference between numbers finance accepts and numbers it questions.

The data foundations your measurement depends on

No model is better than the data under it. We build the weekly, validated dataset your mix models, tests and dashboards need, and keep it trustworthy.