0405123696 petra@web-data-analytics.com

 429 total views,  3 views today

This week I came across a really unusual situation where the ecommerce transactions being stored in Google Analytics were very different from the real transaction data from the back-end of the (Magento) store.

While it’s very common to see problems with ecommerce transactions coming through to in Google Analytics, it is not common to see problems to this degree.

  • We had transactions in Google Analytics that were not on Magento.
  • We had transactions in Magento that were not in Google Analytics.
  • We had transactions on both Magento and Google Analytics but with different prices listed in each.
  • And, we had some that matched perfectly.

All up, 50% of revenue was missing from Google Analytics, even though some was “extra”.

It all seems very random and since in this instance I am not personally setting up this data I have had to refer it to the client’s developer for further investigation. The website code is sending the ecommerce transactions directly to Google Analytics rather than Google Tag Manager so I’m yet to learn exactly the cause.

The biggest issue here is the fact that it is really impossible to optimise advertising or CRO attempts if your transactions are not being correctly recorded. If you’re doing it right, Digital Advertising will always become optimised for what is leading to transactions, so if you are not recording transactions correctly you’ll get some really weird results.

If you’re running an ecommerce business or one in which the sales are taking place on your website, I recommend you periodically check your Google Analytics ecommerce results against your real ecommerce results (from your back end).

With this client, the issue had been occurring for years and no-one had picked it up until I discovered the issue in an audit.

To compare the two, take one full month of back-end transaction data and compare it to the same full month of date range in Google Analytics. Ideally, the two revenue numbers will match within 5%. If the two don’t match, the first thing to check is the tax. Google Analytics data is usually shown tax-excluded, especially if you sell across multiple tax jurisdictions. If your numbers are still not adding up you can go through line by line across a date range and see where the problems are occurring.

I hope this isn’t a problem you are running into, but if you ever experience issues like this one, please reach out as you may need some more specialised help to get to the bottom of it.

david clayton myomasters

Your attention to detail is beyond what I had expected. The detail of the data is incredible. The best part though was to learn the profile demographic - which is very different to whom I think I've been trying to target through social.

David Clayton Director, Myomasters Massage Health Clinic Google Ads April 23, 2020

charles marois olsa tools

Working with Petra was a great experience, communication was easy and she is very organized. She also provided detailed reports of the work she had done and the results generated. We would definitely recommend her services.

Charles Marois CEO, Olsa Tools Ecommerce Google Ads April 23, 2020

Ian Gale - Sleepwise Clinic

Petra was instrumental in pulling all our clinic's web analytics into one easy to read, dynamic report that's accessible to me at any time, and works with our EXACT booking system.

This has allowed me to see, at a glance, what marketing initiatives are working, need tweaking, or changing altogether, saving me both time and money. I can't recommend her or her analytic services enough.

Ian Gale SleepWise Clinic Analytics Dashboard August 1, 2018

Nadia Rossi

It has been an absolute pleasure working with Petra over the last year and a half. 1834 Hotels centralises marketing for over 20 hotels around Australia, all with different branding and websites. On an analytics level Petra’s skills have allowed us to monitor and track our marketing efforts in the digital space. Bringing Petra onboard to manage our Google Ads was one of the best marketing decisions we have made. Her thoroughness and attention to detail is incredible, her insights have helped develop better marketing strategies and demonstrate to shareholders return on investment. I would highly recommend working with Petra.

Nadia Rossi Digital Marketing at 1834 Hotels Ecommerce / Hotel Google Ads April 23, 2020

Michelle Bridger

Petra's detailed reports and her personal assistance has been helping us to know where to concentrate our efforts and even showed us technical issues we needed to fix. Our Audience Engagement Report identified several key interests of our buying audience. We tried targeting one of those interests and it brought in two sales almost immediately! I highly recommend working with Petra and accessing her brilliance to scale your business.

Michelle Bridger Michelle Bridger, Facebook Advertising Specialist Ecommerce Google Tag Manager, Google Analytics & Google Data Studio Configuration April 23, 2020