Of course, it could be that a connection/integration or a data model has a fundamental issue that needs debugging especially when discrepancies are significant. If so, then let us know!
But, most of the times smaller discrepancies come down to how the data is modeled or interpreted. Therefore, datapoints can show mismatches between platforms but still be accurate.
Common Questions
My revenue is wrong or off - different revenue in shopify or an ad platform compared to adtribute
Too many or little orders - there is a different order count in my shopsystem compared to adtribute
Too many or little leads - there is different number of leads in my CRM or ad platform compared to adtribute
My ad spend is wrong or off - there is a different amount of ad spend in the ad platform compared to adtribute
Reasons for data mismatches
One of the following reasons might be cause for data mismatches. While data is not the same, this does not mean that it is wrong. But rather, that the data is modeled and interpreted in different way between the adtribute and other platforms or systems and usually more accurate in adtribute.
Attribution
This results in revenue mismatches.
First of, it is important to understand that our revenue for channels will not be the same as you see in your respective platforms - and it shouldn't, as this is what we solve: Better data through better attribution.
We attribute conversion value e.g. revenue to channels, campaigns and ads based on different attribution models more accurately than the platforms. Therefore, you will always see different numbers as in your ad platforms when it comes to revenue.
For information read Understand Attribution Models.
Refund logic
This results in revenue mismatches.
When a refund occurs, we subtract the refund amount on the day the original order was placed, while Shopify (and other shop systems) subtract it on the day the refund was processed.
For example, if an order was placed on February 12th and refunded on the 25th of March, the refund would be:
adtribute: subtracted from February 12th's revenue
Shopify: subtracted from March 25th's revenue
This approach was chosen because from a marketing perspective, attributing refunds to the original order date provides cleaner data for analysis.
This difference in refund handling can lead to slight variances between adtribute and Shopify revenue for specific timeframes, though the overall data picture remains accurate.
Timezone differences
This results in revenue, order, spend, lead mismatches.
Timezone differences can cause discrepancies in several ways. For example, an order placed at 23:06 CEST might be recorded on a different day in EET (Eastern European Time) since it would be after midnight there.
This can result in:
Orders (or Leads for that matter) appearing on different days between systems
Different daily revenue totals for days
The same goes for spend that was around midnight.
This is why you might see slight discrepancies in daily numbers between different systems and timeframes, though the data is accurate.
Therefore, the total data picture shows no or only very little mismatches across longer time periods.
Note: We can adjust the timezone for adtribute. If you want to change it, just let us know
Currency exchange
This results in mismatches for revenues that are not your default currency.
We utilize exchangeratesapi.io for daily exchange rates. When calculating revenue, we use the specific exchange rate for each day within the selected timeframe.
If you calculate total revenue for a bigger timeframe based on the exchange rate of the day you are reviewing the revenue, discrepancies may arise compared to our data as exchange fluctuate on daily.
Lead deletion & duplication
This results in mismatches for lead count.
When you delete a lead in your CRM this will not reflect in adtribute as leads remain in adtribute.
For some CRMs, when an already signed up lead signs up again, this is counted as a new lead.
If you need changes in lead handling, let us know!