Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
4 years ago

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

  • 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's avatar
      Pikachu-Power
      Icon for Impactful Individual rankImpactful 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's avatar
        Pikachu-Power
        Icon for Impactful Individual rankImpactful Individual

        Or maybe it is a API problem. In connection with GA and Power BI i read that numbers often differ ğŸ˜•