Performance Max from Google Ads connector

[AndreasGu]

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)'
);

[juraj_misina · Accepted solution]

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

[AndreasGu]

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-%''' );