Forum Discussion
Transactions from Google Analytics doesnt fit
Hello all,
I need to replicate Keyword, Clicks, Costs and Transactions from the following Google Analytics site:
Acqusition --> Google Ads --> Keywords
Keywords i take from the folder Traffic Sources. Clicks and Cost I could find in the folder Adwords. Transactions i take from the folder Ecommerce.
All values fit but not the Transactions. My Transactions numbers are a little bit higher than in Google Analytics. Can someone explain this behaviour? Maybe some restrictions in the background?
Example: While in Google Analytics i see for the keyword = dynamic search ads = 0 i see in Power Bi keyword = dynamic search ads =146.
Thanks!
PS: Besides the year (I take 2021) there seams to be a filter Segment = All users. But I am not sure.
4 Replies
- amitchandak
Super User
Pikachu-Power , this needs to compare with what filter and logic applied at google end vs at your end
is there way to check the same on a sample ?
- Pikachu-Power
Impactful Individual
On the Google Analytics site i see no restrictions... just year 2021. But I dont see if there are some restrictions at the background. And I dont know if that is possible to check?
For some keywords in january 2021 my values are less than in Google Analytics. And i use no restrictions. That is strange.
- Pikachu-Power
Impactful Individual
Or maybe it is a API problem. In connection with GA and Power BI i read that numbers often differ 😕