AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Analytics
1.9K members online now
1.9K members online now
Learn how to set up goals and Ecommerce tracking, verify accuracy of attribution traffic sources, and discuss funnel visualization, Multi-Channel Funnels, the Goal Flow Report, and Enhanced Ecommerce
 
Guide Me
star_border
Reply

Identify Missing Transactions

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello friends,

 

please, I would like to ask what is the best way to identify missing transaction in google analytics.

 

Lets say I have 100 transactions in my back end system, but in google analytics are 20 missing.

 

 

The transaction ID in the google analytics is the same with the back end system?

 

So can be the way to analyze it that I export transaction for given period of time a combine it in excel with exported transaction from back end and will use vlookup function?

 

is this a way please?

 

All i need is to identify those missing transaction the best and most possible way

 

thanks a lot

1 Expert replyverified_user

Re: Identify Missing Transactions

Top Contributor
# 2
Top Contributor
Hi MayoRacek,

actually, missing data is quite natural and, basically, you have to accept it. But 20% missing transactions here is quite a lot - you should investigate if there are factors to minimize that percentage [1].

[1] https://brianclifton.com/blog/2016/06/01/how-to-match-transactions-with-reality/