Hi guys,
I need to populate these info: *utm_term*, *utm_campaign*, *utm_source* and
*utm_medium* based on GCLID. Where can I find them using GAQL?
So far I can only find them on campaign.trackingUrlTemplate using this
query:
*SELECT campaign.tracking_url_template, click_view.gclid FROM click_view
WHERE segments.date='{YYYY-MM-HH}' and click_view.gclid = '{*
*ZZZZZZZRRREEWWSSSSSSSSSSSSSSSSS**}' *
This is the result:
[ { "campaign": { "resourceName":
"customers/XXXXXXXXXX/campaigns/YYYYYYYYYYY", "*trackingUrlTemplate*":
"{lpurl}?*utm_term*={keyword}&*utm_campaign*=ABCD&*utm_source*=adwords&
*utm_medium*=ppc&hsa_acc=ZZZZZZZZZZ&hsa_cam=QQQQQQQQQQQ&hsa_grp={adgroupid}&hsa_ad={creative}&hsa_src={network}&hsa_tgt={targetid}&hsa_kw={keyword}&hsa_mt={matchtype}&hsa_net=adwords&hsa_ver=3"
}, "clickView": { "resourceName":
"customers/XXXXXXXXXX/clickViews/2025-10-10~ZZZZZZZRRREEWWSSSSSSSSSSSSSSSSS",
"gclid": "ZZZZZZZRRREEWWSSSSSSSSSSSSSSSSS" } } ], "fieldMask":
"campaign.trackingUrlTemplate,clickView.gclid", "requestId":
"qhkn8cNtnvVnFskgztX1iQ", "queryResourceConsumption": "340" } ]
Another questions are:
- Why any GCLID that doesn't have *trackingUrlTemplate *information in
result
- Any other table/field that contain these 4 information?
Thanks in advance.
Regards,
Wawan K.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/adwords-api/147c4613-2fac-4e3d-a82c-442e19a3b64cn%40googlegroups.com.
