Mapping Analytics session data with Adwords placement (Big Query Export)
I'm requesting your help because after couple of days of back and forth, we are still unable to come to our desired result:
Our purpose is to map the Adwords placement URL with the session data in our Big Query Analytics Export.
We used the gclid and the ClickPerformance report to achieve this, but at the end, it does not work: especially for the automatic placement, we are unable to match the right session using the CriterionID (it works only for managed placements).
I would like to ask you if it's even feasible? At the end I would like to get to :
FullVisitorID / VisitID / Gclid / Placement URL all together.
Thanks a lot for your help!