How to Reconcile Ad Platform Data with Actual Revenue
by Nirjar Sanghavi
|
13 min read
Jul 10, 2026
To reconcile ad platform data with actual revenue, you need one authoritative revenue number from your storefront, a defined attribution model applied consistently across every ad channel, and a process for explaining the gap between what platforms report and what actually sold. The gap will always exist. Every ad platform over-reports its contribution by design: Meta and Google each claim credit for the same customer journey, attribution windows capture organic conversions, and post-iOS modeling adds estimated conversions alongside real ones. Reconciliation does not mean making the numbers match. It means understanding exactly why they differ, so you can make budget decisions on accurate economics rather than whichever dashboard happened to show the highest number.
DEFINITION: Reconciling Ad Platform Data with Actual Revenue Reconciling ad platform data with actual revenue is the process of comparing what each ad platform claims it drove (conversions, revenue, ROAS) against what your storefront actually recorded as completed orders, then documenting the specific reasons for the gap. The goal is not to find a single "correct" ROAS number. It is to understand which portion of each platform's reported revenue is real, which is double-counted, and which is modeled, so that budget decisions are made on actual business performance rather than inflated platform metrics.
Why Do Ad Platforms Always Report More Revenue Than You Actually Made?
The gap between ad platform revenue and actual storefront revenue is not a glitch. It is the inevitable result of how attribution works, compounded by three structural factors.
Factor 1: Every platform uses a different attribution model and window. Meta's default attribution counts conversions within a 7-day click or 1-day view window. Google Ads uses a 30-day click window by default. If a customer sees a Meta ad, clicks a Google retargeting ad three days later, and purchases, both platforms claim 100% of the revenue. Your Shopify order report counts the same purchase once. The sum of platform-reported revenue is always higher than actual revenue when you are running ads on more than one channel simultaneously.
Factor 2: Attribution windows capture organic behavior. A customer who has been on your email list for eight months, sees a Meta ad on a Tuesday, ignores it, then buys via a Klaviyo email on Friday still appears in Meta's 7-day click attribution as a Meta-driven conversion if they clicked the ad at any point in the prior week. Meta counts it. Klaviyo counts it. Your Shopify revenue report counts it once. The combined platform-reported total is at least two times the actual transaction.
Factor 3: Post-iOS 14 modeling adds estimated conversions. Since iOS 14.5 reduced pixel tracking accuracy for iOS devices, Meta models an estimated portion of conversions it cannot directly measure. These modeled conversions appear in the same dashboard view as directly measured ones, without a distinct label in standard reporting. The modeled conversions are statistically derived estimates, not records of actual purchases. At scale, this means a meaningful portion of Meta's reported revenue has never been verified against an actual order in your storefront.
The combined effect of these three factors: brands running Meta and Google simultaneously will typically see their combined platform-reported revenue exceed actual storefront revenue by 30-80%. The exact gap varies by channel mix, attribution window settings, and how much iOS traffic the brand has.
What Is the Right Process for Reconciling Ad Platform Data with Revenue?
Reconciliation is a five-step process. It is not a one-time exercise; it is a weekly practice that gets faster once the comparison structure is built.
Step 1: Establish Your Revenue Ground Truth
Your ground truth is the number from your storefront that records completed, paid orders. For Shopify brands, that is the Shopify Orders report filtered to paid and fulfilled, in your base currency, for the reconciliation period.
Important: decide upfront whether your ground truth includes or excludes:
Refunds and returns (generally, exclude them from the reconciliation period to avoid timing mismatches)
Marketplace revenue (Amazon, eBay) if it flows through a separate storefront
Wholesale or offline orders
Write this definition down. The reconciliation only works if you use the same ground truth definition every time.
Step 2: Pull Platform-Reported Revenue with Consistent Settings
From each ad platform, pull the revenue attributed to the same time period you used for your ground truth. Before pulling, align these settings across every platform:
Attribution window: Set each platform to the same click window (7-day or 30-day) and disable view-through attribution for the reconciliation comparison. View-through attribution in particular inflates reported numbers significantly.
Conversion event: Confirm that each platform is counting "purchase" events only, not add-to-cart or checkout initiation.
Currency: Pull all figures in the same base currency.
Record the attributed revenue from Meta, Google, TikTok, and any other active paid channels.
Step 3: Calculate the Declared Gap
Declared gap = Sum of all platform-reported revenues minus storefront ground truth revenue.
On most multi-channel brands, this gap is large and immediately visible. A brand doing $500,000 in Shopify revenue for a given month might see $650,000 in combined platform-reported attribution. The $150,000 gap is not money the brand failed to make. It is the overlap, double-counting, and modeling that platform attribution produces when left unexamined.
Step 4: Attribute the Gap to Specific Causes
This is where reconciliation turns from accounting into insight. Document which portion of the gap comes from each of the following sources:
Attribution overlap: Customers attributed to two or more platforms for the same purchase. Estimate this by looking at the percent of conversions on each platform that fall within windows where the customer was also active on another channel.
Organic and email capture: Conversions where the customer was in an active email or SMS flow at the time of the ad attribution. Check your Klaviyo or email platform for sends and clicks within the attribution window.
Modeled conversions: Meta reports an "estimated" or "modeled" conversion count in advanced analytics. The difference between modeled and measured conversions is a portion of the gap.
Return and refund timing: Platforms do not automatically reduce their reported revenue when a purchase is returned. If the reconciliation period includes recent purchases that were later returned, this creates a discrepancy.
Not every brand will be able to fully quantify all four causes, but documenting even two or three gives you enough clarity to make better decisions than treating platform numbers as accurate.
Step 5: Calculate Blended MER as Your Operating Metric
After completing the reconciliation, calculate blended MER: total storefront revenue divided by total ad spend across all channels. This is your operating metric for weekly budget decisions.
MER sidesteps the attribution debate entirely. It does not require you to know which platform drove which sale. It answers one question: for every dollar we spent on paid marketing, how much revenue did the business generate? That number, tracked weekly against a four-week rolling average, is the most reliable indicator of whether your total paid investment is working.
BI Reportingthat connects your Shopify or Amazon revenue data to your ad spend across every channel provides this blended MER view automatically. Rather than exporting and calculating manually each week, the number updates continuously from connected native API sources, which means the reconciliation infrastructure is maintained rather than rebuilt each time.
What Tools Do You Need to Reconcile Ad Data with Revenue Accurately?
At minimum, you need three things connected to each other.
An authoritative storefront data source. Shopify, Amazon Seller Central, WooCommerce, or whatever platform records completed orders. This is the ground truth. TheShopify integrationin a properly configured analytics platform pulls order-level data including customer, product, and refund information, which gives you the most precise ground truth available.
Normalized ad platform data. Each ad platform connected via native API with consistent attribution settings. Not CSV exports, which introduce lag and configuration errors. Not platform native dashboards, which each use their own attribution logic. A unified layer that applies the same attribution definition to every platform's data, as described in thedata integration documentationfor a properly built system.
A calculation layer that produces the MER comparison. Something that puts storefront revenue and total ad spend side by side in one view, updated automatically.Custom dashboardsbuilt on a unified data layer eliminate the weekly manual export-and-calculate process that most brands rely on for this comparison.
What Should You Do Differently Once You Have Reconciled Data?
Reconciliation changes three things about how you manage paid spend.
Use MER, Not ROAS, for Weekly Budget Decisions
ROAS is a platform metric. It is useful for campaign-level optimization within a platform. It is not useful for deciding whether to increase total spend on Meta versus Google, because each platform's ROAS is calculated differently and over-reports the channel's contribution.
Blended MER is the cross-channel metric. When MER is improving week over week, total paid investment is becoming more efficient. When MER is declining, something in the total paid mix is underperforming, and reconciliation data helps identify which channel is creating the drag.
Treat Platform ROAS as a Signal, Not a Decision Metric
Platform ROAS is still useful for identifying which campaigns within a channel are performing better or worse relative to each other. A campaign running 3x ROAS on Meta compared to a baseline of 2x ROAS is worth investigating, not because 3x is meaningful in absolute terms, but because the relative performance suggests a better creative or audience. The platform number is useful for relative comparisons within a channel. It is not reliable for cross-channel budget allocation.
Set a Maximum Acceptable Attribution Gap
Once you have completed two or three reconciliation cycles, you will have a baseline for the normal gap between platform-reported revenue and actual storefront revenue. Declare a maximum acceptable gap percentage (typically 40-60% for brands running Meta and Google simultaneously). When the gap exceeds that threshold, it is a signal that attribution settings may have drifted, a new channel was added without consistent configuration, or a modeling change at the platform level has inflated reported numbers.
AI Agentsthat monitor your unified metrics automatically can flag when the MER-to-ROAS ratio moves outside normal range, which is a proxy indicator for attribution gap expansion, without requiring you to run a manual reconciliation to notice it.
The Revenue Reality Check
THE REVENUE REALITY CHECK: A three-number comparison that gives ecommerce brands a fast, weekly view of whether their ad platform data is consistent with actual business performance.
Here is how it works. Once per week, produce three numbers side by side:
Number 1: Storefront revenue. Total completed orders from your primary storefront(s), in your base currency, for the prior 7 days. This is ground truth.
Number 2: Combined platform-reported revenue. The sum of attributed revenue from every active paid channel for the same 7-day period, using consistent attribution settings across all platforms.
Number 3: Blended MER. Storefront revenue divided by total ad spend for the same period.
The ratio of Number 2 to Number 1 is your attribution gap factor for the week. A stable gap factor (e.g., combined platform revenue is consistently 1.4x to 1.6x actual storefront revenue) is a healthy signal: the over-reporting is consistent and understood. A gap factor that spikes above the normal range signals that something in the attribution environment changed and warrants investigation.
The Revenue Reality Check, developed from patterns observed consistently across ecommerce operators managing multi-channel ad spend, replaces the complex full reconciliation with a fast weekly proxy that catches meaningful changes without requiring a detailed attribution analysis every seven days. The full reconciliation (Step 1-5 above) is then reserved for the monthly or quarterly deep dive.
Conclusion and CTA
Reconciling ad platform data with actual revenue is not optional once you are running more than one paid channel. The gap between platform-reported attribution and storefront-verified revenue is real, it is large, and it grows with every channel you add. Ignoring it means making budget allocation decisions on numbers that are structurally inflated.
The five-step reconciliation process in this post is the manual version. The Revenue Reality Check is the weekly proxy that keeps you calibrated between full reconciliations. Blended MER is the operating metric that sidesteps the attribution debate for weekly decisions while keeping you honest about total paid investment efficiency.
The brands that do this consistently make better budget decisions, catch attribution drift before it compounds, and stop the Monday morning argument about which dashboard is right.
Q1: Why is my ad platform revenue always higher than my actual Shopify revenue?
Because every ad platform claims credit for conversions within its attribution window, including purchases that were also attributed to other channels and purchases that would have happened through organic or email traffic regardless. When you run Meta and Google simultaneously, both platforms count the same conversions using different logic. The sum of their reported revenue is almost always higher than your actual Shopify revenue, typically by 30-80% for multi-channel brands.
Q2: What is the correct way to reconcile Meta Ads revenue with Shopify orders?
Pull completed Shopify orders for a defined period in your base currency. Pull Meta's attributed revenue for the same period using 7-day click attribution only (disable view-through for the comparison). The gap between the two numbers is attributable to: organic conversions Meta captured in its window, conversions attributed to other channels as well, and modeled conversions that Meta estimated rather than directly measured. Document the gap percentage rather than trying to make the numbers match.
Q3: What is blended MER and how does it help with ad reconciliation?
Blended MER (Marketing Efficiency Ratio) is total storefront revenue divided by total ad spend across all channels. It bypasses the attribution debate by measuring business-level performance rather than platform-level attribution. For budget decisions, MER is more reliable than any single platform's ROAS because it is calculated from your actual storefront revenue rather than each channel's self-reported conversion count. Track MER weekly against a four-week rolling average for your most reliable paid performance indicator.
Q4: How much should my ad platform revenue differ from my actual revenue?
A gap of 30-60% between combined platform-reported revenue and actual storefront revenue is typical for brands running Meta and Google simultaneously. Brands also running TikTok or Pinterest may see gaps of 50-80% due to additional double-counting. The specific percentage matters less than its consistency: a stable gap indicates understood, structural over-reporting. A gap that spikes suddenly indicates a change in attribution settings, a new channel added without consistent configuration, or a platform modeling change.
Q5: Should I change my attribution window to fix the reconciliation gap?
Changing attribution windows reduces the gap for comparison purposes but does not change the underlying reality of which purchases each channel actually drove. The more useful approach is to standardize your attribution window setting across all platforms for the purpose of internal comparison (7-day click is a practical standard), and then use blended MER as your actual decision metric rather than ROAS from any platform. Trivas.ai applies a consistent attribution framework across all connected ad channels, which makes the comparison meaningful rather than comparing apples to different-sized oranges.
Q6: How do I know if my reconciliation gap is normal or a sign of a problem?
Run the reconciliation for three consecutive months to establish your baseline gap percentage. If the gap is consistent (within 5-10 percentage points month to month), it is structural over-reporting that you can account for in your decision-making. If the gap changes significantly (increases by more than 15 percentage points in a single period), investigate: a new channel was likely added without consistent attribution settings, a platform changed its default modeling approach, or a pixel or tracking configuration changed.
Q7: Can an analytics platform automate the reconciliation process?
Yes. Platforms that connect your storefront data and ad platform data via native API can calculate the gap between platform-reported revenue and actual storefront revenue automatically and display it in a unified view. Trivas.ai connects Shopify, Amazon, Meta Ads, Google Ads, TikTok, and 40+ other platforms in one place, providing both the blended MER view and the underlying data needed to investigate attribution discrepancies without manual exports or spreadsheet assembly.
Q8: What is the single most important metric to track after reconciling ad and revenue data?
Blended MER: total storefront revenue divided by total marketing spend across all channels for the same period. It is the one number that reflects actual business performance rather than platform attribution, sidesteps the multi-channel double-counting problem entirely, and tracks week over week without requiring a detailed reconciliation every time. When MER is improving, your total paid investment is becoming more efficient. When MER is declining, something in the channel mix is underperforming, and the reconciliation process identifies where.
Visionary leader with 20+ years of deep expertise in eCommerce analytics and business intelligence at companies like Samsung, Groupon, eBay, PayPal, and Chase. Nirjar founded Trivas with the mission to democratize data-driven decision making for online merchants.
Continue Reading
explore more insights
Ecommerce Analytics to Measure Brand vs Performance Spend
3 min read
Common Challenges and Solutions: Measuring Attribution Success
3 min read
Ecommerce Analytics ROI vs Triple Whale: A Real Comparison
.d53b12e5.png&w=3840&q=75 "Trivas.ai")
by Nirjar Sanghavi
