How to show custom parameters in the report

[Rintaro Maruyama]

Currently, the following tracking template is set up for each ad, with custom parameters to set the value of each item.

utm_source={_source}&utm_medium={_medium}&utm_campaign={_campaign}&utm_content={_content}


I am trying to use a script to generate a report in a spreadsheet that contains the column "ad_group_ad.ad.url_custom_parameters",
but in any of the rows, only the campaign parameter is displayed as shown below; source, medium, and content are not displayed.

{value=xxx, key=campaign}

The content of "xxx" is displayed correctly in each line


I am using the following query in my script.
If I modify something, will the values of source, medium, and content also come up?

SELECT campaign.name, ad_group.name, ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.url_custom_parameters, ad_group_ad.ad.final_ urls as follows
FROM ad_group_ad

[Google Ads Scripts Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/sloCRuFZEis) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads Scripts Team

[Google Ads Scripts Forum]

Hi,

Thanks for reaching out to the Google Ads Scripts Team. We appreciate you for providing a brief summary of your concern. Please do excuse us for only getting back now as your message failed to be routed to our support queue.

Could you please confirm if you're still in need of assistance with regard to this? If yes, would you be so kind as to provide the following information so we're able to further investigate and guide you accordingly?:

• Google Ads account ID or CID
• Name of the script
• Complete and uncropped screenshots of the entity you'd like to retrieve from the Google Ads UI

You may send these privately via the Reply to author option. Note that you may need to join the Google Group for you to use this option. If this option is not available on your end still, you may send it through our email (googleadsscr...@google.com) instead.

Best regards,

Google Ads Scripts Team