'How to calculate Clicks in GA report with BigQuery table
I am trying to create and match a report in Google Analytics through data in BigQuery table, but I couldn't find any way to get the same figures for "Clicks".
The definition of "Clicks" in GA is The number of times users click on your ad.
So I have tried COUNT or COUNT DISTINCT gclId column under adwordsClickInfo and all other methods, but still cannot replicate the number.
How do I correctly count the Clicks with my ga_session_* table?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|