Products Solutions Templates Pricing Resources

Reconciling analytics data across tools: finding the source of truth

Home / Everything About / Everything About Analytics / Reconciling analytics data across tools: finding the source of truth

Your team argues about which number is right. Google Analytics says 100 conversions. Your CRM says 95. Shopify says 102. No one knows which to trust. Decisions stall while you debate the numbers.

Reconciliation is the process of understanding the gaps between tools and establishing which tool owns each metric. It's not about making numbers match. It's about understanding why they don't and deciding which to trust.

The reconciliation framework

Step 1: Identify what each tool measures

Google Analytics measures tracked events and conversions. Shopify measures completed transactions. Your CRM measures deals entered. Server logs measure requests. Each tool measures something slightly different.

Document exactly what each tool measures: "Google Analytics tracks conversion event fired on checkout confirmation page." "Shopify tracks completed payments." "CRM tracks deals created by sales team."

Step 2: Pull the same data from each tool

For a specific date range, export conversion count from each tool. Use the exact same date range (same time zone) in each tool. If you're comparing monthly, use the same calendar month in all tools.

Example: "January 1-31, 2026 conversions"

Step 3: Calculate the differences

Analytics: 100 conversions. Shopify: 102 conversions. CRM: 95 conversions. Gap between Analytics and Shopify: 2 (2%). Gap between Analytics and CRM: 5 (5%).

Is 2% normal variance? Yes. Is 5% explainable? Maybe. Investigate.

Step 4: Investigate the gaps

Why is CRM lower than Shopify? Possible explanations: offline conversions in Shopify that don't get entered into CRM yet. Refunds in CRM that Shopify still counts. Test transactions in Shopify that don't go to CRM.

For each gap, find the explanation.

Step 5: Document the explanation and accept the difference

"CRM is 3% lower than Shopify because it includes refunds (removed from revenue) and only includes sales entered within 24 hours. Some sales take longer to enter. This gap is expected."

Once you understand it, stop debating the numbers. Use the appropriate source for each decision.

Tools to use for reconciliation

Google Analytics as your traffic source of truth

Google Analytics shows how users behave and convert. It's your best source for understanding traffic patterns and user journeys. Use it for traffic analysis, segment analysis, and attribution questions.

Payment processor as your revenue source of truth

Your payment processor (Stripe, PayPal, Shopify) shows actual money moving. Use this for revenue numbers, refund tracking, and financial analysis. This number gets sent to your accountant, so it's the most official.

CRM as your pipeline source of truth

Your CRM shows deals, opportunities, and sales progress. Use this for sales forecasting, pipeline analysis, and revenue attribution to sales teams.

Server logs as your technical source of truth

Server logs show all traffic at the technical level. Use this for technical diagnostics, bot detection, and understanding traffic the analytics tool might be missing.

Common reconciliation scenarios

Analytics shows fewer conversions than your payment processor

Normal. Likely causes: tracking code failure on some conversions, ad blockers preventing conversion tracking, third-party checkout not tracked.

Fix: calculate the gap percentage monthly. If it's consistent (say, always 5-10% lower), that's expected. If it changes suddenly, something broke.

CRM shows more deals than Analytics shows conversions

Possible causes: sales team creates deals for offline leads, deals created after initial conversion (not tracked at conversion time), test deals in CRM that aren't real.

Fix: decide which conversions go in CRM and which don't. Maybe only first-purchase conversions count for Analytics. Maybe all deals in CRM count, including renewals.

Analytics shows conversion attribution one way, CRM shows it differently

Different tools use different attribution models. Analytics uses last-click by default. CRM might use first-click or custom rules. Of course they disagree.

Fix: pick one source of truth for attribution. If Analytics says Paid Search should get credit, use that number. Don't try to make CRM match Analytics. Use each for what it's good at.

Automate reconciliation checks

Set up monthly reconciliation reports

Create a spreadsheet that pulls key metrics from each tool monthly. Google Analytics conversions. Shopify revenue. CRM deals. Compare them. Calculate variances.

If variance stays within expected range, no action needed. If something changes unexpectedly, investigate immediately.

Set up alerts for unusual discrepancies

If Analytics conversion count drops 50% relative to Shopify, alert your team. Something likely broke. Automatic alerts catch problems faster than manual reviews.

Use data integration platforms

Platforms like Fivetran, Stitch, or native integrations can automatically sync data from multiple sources into a data warehouse. Compare all sources in one place.