Hello,
This is a query Im trying to do in my request trough Google Ads API (V8). Everything is going ok, but the field "bidding_strategy.type" is not coming in the response attributes. I also tried to access "
bidding_strategy.id" and "
bidding_strategy.name", but the result is the same, nothing.
query = """
SELECT
campaign.id,
ad_group.id,
ad_group_criterion.criterion_id,
metrics.conversions,
metrics.value_per_conversion,
metrics.conversions_value,
metrics.cost_micros,
metrics.clicks,
ad_group_criterion.keyword.text,
ad_group_criterion.cpc_bid_micros,
ad_group_criterion.keyword.match_type,
bidding_strategy.type,
bidding_strategy. id,
bidding_strategy.name,
ad_group_criterion.position_estimates.first_page_cpc_micros
FROM keyword_view WHERE campaign.advertising_channel_type = 'SEARCH'
AND ad_group.status = 'ENABLED'
AND metrics.conversions > 0
AND ad_group_criterion.status = 'ENABLED'
AND ad_group_criterion.negative = 'false'
AND campaign.status = 'ENABLED'
AND ad_group_criterion.system_serving_status = 'ELIGIBLE'
AND
campaign.name NOT LIKE 'brand'
AND
campaign.name NOT LIKE 'BRAND'
AND
campaign.name NOT LIKE 'marca'
AND
campaign.name NOT LIKE 'MARCA'
AND segments.date BETWEEN '{start_date}' AND '{end_date}'""".format(
start_date=from_date,
end_date=end_date)
Here is an example of the results in this query:
campaign {
resource_name: "customers/7910637076/campaigns/100925979"
id: 100925979
}
ad_group {
resource_name: "customers/7910637076/adGroups/
4243192059"
id:
4243192059 }
metrics {
clicks: 2253
value_per_conversion: 78.24969001993682
conversions_value: 31843.68693971
conversions: 406.949688
cost_micros: 22610000
}
ad_group_criterion {
resource_name: "customers/7910637076/adGroupCriteria/4243192059~36756703161"
position_estimates {
first_page_cpc_micros: 10000
}
keyword {
match_type: EXACT
text: "bodeboca"
}
criterion_id: 36756703161
cpc_bid_micros: 10000
}
keyword_view {
resource_name: "customers/7910637076/keywordViews/4243192059~36756703161"
}
}