Sales reconciliation
Online orders, store sales and returns compared across systems before any report.
/INDUSTRIES / RETAIL / INSIGHTS
Retail Marketing Insights
Practical notes on measuring retail marketing when customers browse online, buy in store, return a week later and use a loyalty card in between.
Retail buyers blend online research with in-store buying. Winning brands stay visible across both, with seasonal precision.
/01
THE SITUATION
Retail customers rarely follow a straight line. They see a product on social media, check the price on the website, buy it in a store and return it online. Each system records one step: the ad platform sees the click, the store system sees the sale, the loyalty program sees the customer.
/02
WHY IT MATTERS
If each team reports from its own system, the same sale is counted twice or not at all. Online marketing gets credit only for online orders, store campaigns look free, and nobody can say what a new customer costs across channels.
/03
HOW WE APPROACH IT
We start from the sale and work backward: which systems record it, which identifier links them, and where consent allows a connection. Then we set up tracking that respects consent, link loyalty and store data where possible, and report one set of numbers for online and stores together.
/NOTES FROM THE WORK
What we often find when we audit retail measurement.
- Online purchase tracking that does not match the orders in the store system
- Returns that are never deducted from the revenue reported to ad platforms
- Loyalty data that could link online and store purchases but stays in a separate tool
- Promotions measured on revenue, without the margin they gave away
/WHAT THE WORK COVERS
Store and loyalty data
Offline sales and loyalty purchases linked to campaigns where consent allows it.
Promotion analysis
Each promotion measured on extra sales and margin, not only on revenue.
Tracking setup
GA4, Google Tag Manager, consent mode, and server-side tagging where the ad spend justifies it.
Dashboards
Looker Studio reports built around the decisions you make each month, not around every available metric.
/WHAT WE MEASURE
- /01
Revenue after returns
The revenue figure that ads should be judged on.
- /02
New customer cost
What it costs to win a customer, across online and stores.
- /03
Repeat purchase rate
Whether the customers you pay for come back.
- /04
Store visits from ads
Estimated store traffic from campaigns, reported next to online sales.
/HOW LONG IT TAKES
/01
Tracking audit
We list every tag, event and conversion, and check each one against what really happened on the site.
/02
Rebuild and validate
Broken or missing tracking is rebuilt and tested against orders, calls or CRM records.
/03
Reporting and review
A monthly review of the numbers that matter, with the decisions they support written down.
/FAQ
Not directly. Store sales can be imported into GA4 and into the ad platforms when they carry an identifier, such as a loyalty card linked to an online account, and when the customer gave consent.
With one definition of a sale and of a customer, agreed by both teams. The tracking and the dashboard follow from that; without it, any new tool repeats the same disagreement.
Tracking follows the consent the customer gave, with consent mode in place for visitors who refuse. Personal data from loyalty programs is matched only in hashed form and only where the program terms allow it.
Access to analytics and the platform, one person who can approve changes, and an honest picture of what has been tried. Two hours in week one, then a weekly checkpoint.
Not always. It pays off when ad spend is significant or when browser tracking loses a large share of conversions. The tracking audit tells you which case you are in.
FIND OUT WHAT YOUR RETAIL DATA IS MISSING
We start by comparing what your analytics reports with what your stores and online shop actually sold last month.
REQUEST A TRACKING AUDIT
Or explore other Retail services · Find my industry