I have been trying to fetch the data for UAC campaigns while fetching that I'm unable to get the target_cpa.
Whereas, I can see the value of target_cpa in the UI.
I tried with adding the target_cpa in the query but didn't work.
query = ("""SELECT
ad_group.target_cpa_micros
,ad_group.cpm_bid_micros
,ad_group.cpc_bid_micros
,ad_group.id
,ad_group.name
,campaign.advertising_channel_sub_type
,campaign.id
,campaign.name
,customer.descriptive_name
,customer.currency_code
,customer.id
,customer.time_zone
,metrics.clicks
,metrics.conversions
,metrics.all_conversions
,metrics.conversions_value
,metrics.cost_micros
,metrics.impressions
,metrics.view_through_conversions
,segments.ad_network_type
,segments.date
FROM ad_group
WHERE segments.date > '{}' AND segments.date < '{}'
AND campaign.advertising_channel_sub_type = 'APP_CAMPAIGN'""".format(
start_range, end_range))
header_list = ['ad_group.target_cpa_micros', 'ad_group.cpm_bid_micros', 'ad_group.cpc_bid_micros',
'ad_group.id', 'ad_group.name', 'campaign.advertising_channel_sub_type',
'campaign.id',
'campaign.name', 'customer.descriptive_name', 'customer.currency_code', 'customer.id',
'customer.time_zone', 'metrics.clicks', 'metrics.conversions',
'metrics.all_conversions', 'metrics.conversions_value', 'metrics.cost_micros',
'metrics.impressions', 'metrics.view_through_conversions', 'segments.ad_network_type',
'segments.date']