my campaign reporting is a mess and the numbers don't match across tools

That’s a really common problem. “The numbers don’t match” usually means one or more of these is happening:

Common causes

• Different attribution windows
  Example: one tool uses 7-day click / 1-day view, another uses 30-day click, or last-click only.

• Different conversion definitions
  One tool counts “purchase,” another counts “checkout initiated,” or one includes refunds/cancellations and the other doesn’t.

• Different time zones A campaign can land in different days depending on whether the tool reports in UTC, account time zone, or local time.

• Tracking gaps or duplicates Missing tags, double-firing pixels, blocked cookies, or server-side + client-side tracking both firing.

• Platform-reported vs analytics-reported data Ad platforms often attribute conversions they influenced, while analytics tools may only credit direct sessions or different channel rules.

• Currency / tax / shipping differences Revenue may be gross in one place and net in another.

• Delayed processing Some platforms backfill conversions after several hours or days.

How to clean it up

1. Pick one source of truth per metric

   • Spend: ad platforms or billing system
   • Sessions/traffic: analytics tool
   • Leads/orders: CRM or backend database
   • Revenue: ecommerce/order system

2. Document the exact definitions

   • What counts as a conversion?
   • Which attribution window?
   • Which date field: click date, conversion date, or impression date?
   • Which timezone?

3. Reconcile at the raw-event level Compare:

   • campaign ID / ad ID
   • timestamp
   • conversion ID / order ID
   • revenue amount
   • source/medium

4. Standardize naming Make sure UTM parameters, campaign names, and IDs match across platforms.

5. Build a reconciliation layer Pull raw data into one warehouse/reporting table and transform everything to shared rules.

Quick diagnostic questions

If you want, I can help you debug it step by step. Tell me:

1. Which tools are involved? (e.g., Google Ads, Meta, GA4, HubSpot, Shopify)
2. Which metric doesn’t match? (spend, leads, purchases, revenue, ROAS)
3. By how much is it off?
4. Are you comparing by conversion date or click date?
5. Do you have UTMs and conversion IDs?

If you share that, I can help you pinpoint the likely cause and suggest a clean reporting setup.