topic Re: Performance Max from Google Ads connector in Integration, Extension & APIs

Performance Max from Google Ads connector

AndreasGu — Thu, 10 Nov 2022 08:37:33 GMT

We are using the Google Ads connector in Qlik Sense Cloud.

For some reason the Performance Max campaigns are not being collected. Does anyone know if this should be dealt with in the connector or how to sort this?

Sample code:

SELECT campaign_resourceName, campaign_name, adGroup_resourceName, adGroup_name, metrics_clicks, metrics_conversionsFromInteractionsRate, metrics_conversions, metrics_costMicros, metrics_costPerConversion, metrics_ctr, metrics_averageCpc, metrics_impressions, adGroupAd_resourceName, adGroupAd_ad_resourceName, segments_date FROM Reports WITH PROPERTIES ( CustomerId='customers/XXXXXXXXX', customerClientId='customers/XXXXXXXXX', gaqlQuery='SELECT metrics.cost_micros, ad_group_ad.ad.text_ad.headline, campaign.name, metrics.clicks, metrics.ctr, metrics.impressions, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.average_cpc, ad_group.name, metrics.cost_per_conversion, segments.date FROM ad_group_ad WHERE segments.date BETWEEN $(vStartDate) AND $(vEndDate)' );

Re: Performance Max from Google Ads connector

juraj_misina — Tue, 11 Apr 2023 08:44:12 GMT

Hi,

If this is still valid, you will not get performance max campaigns from ad_group_ad endpoint. I managed to solve it by this

SELECT segments_device,campaign_id,campaign_name,campaign_status,segments_adNetworkType,segments_date, metrics_impressions,metrics_clicks,metrics_costMicros FROM Reports WITH PROPERTIES ( CustomerId='customers/XXXXXXXXXX', customerClientId='customers/$(vCustomerID)', gaqlQuery= 'SELECT segments.device,campaign.id,campaign.name,campaign.status,segments.ad_network_type,segments.date, metrics.impressions,metrics.clicks,metrics.cost_micros FROM campaign WHERE segments.date >= $(vFromDateAW) AND segments.date <= $(vToDateAW) AND campaign.advertising_channel_type = PERFORMANCE_MAX');

Hope this helps
Juraj

Re: Performance Max from Google Ads connector

AndreasGu — Thu, 13 Apr 2023 11:44:24 GMT

Thank you.

We were able to sort it in a different way since all our Performance Max campaigns did include the word "pmax"

SELECT campaign_resourceName, campaign_name, metrics_clicks, metrics_conversionsFromInteractionsRate, metrics_conversions, metrics_costMicros, metrics_costPerConversion, metrics_ctr, metrics_averageCpc, metrics_impressions, segments_date FROM Reports WITH PROPERTIES ( CustomerId='customers/xxxxxxxxx', customerClientId='customers/xxxxxxxxx', gaqlQuery='SELECT metrics.cost_micros, campaign.name, metrics.clicks, metrics.ctr, metrics.impressions, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.average_cpc, metrics.cost_per_conversion, segments.date FROM campaign WHERE segments.date BETWEEN $(vStartDate) AND $(vEndDate) AND campaign.name LIKE ''%-pmax-%''' );