Keywords Metrics Data(impressions, click etc) with bid simulator field

[Kuldeep Kumar Patel]

I want to fetch keyword metrics data(impressions, click etc) with its bid simulator fields by date. Can I fetch it through search query ?

 $query = 'SELECT metrics.ctr,metrics.clicks,metrics.impressions, metrics.cost_micros,campaign.id,ad_group.id,ad_group_criterion.criterion_id, ad_group_criterion.status, '

                    . 'ad_group_criterion.keyword.text '

                    . 'FROM keyword_view '

                    . 'WHERE ad_group_criterion.type = KEYWORD AND campaign.status != REMOVED ';

Please Help. I am new to this API.

[Google Ads API Forum Advisor Prod]

Hi Kuldeep,

Thank you for writing to us today. You could use the keyword_view resource to retrieve the keyword metrics data. Please find below the sample report query for reference.
"SELECT ad_group.id, ad_group_criterion.criterion_id, ad_group_criterion.status, ad_group_criterion.keyword.text, metrics.impressions, metrics.cost_micros, campaign.id FROM keyword_view WHERE ad_group_criterion.type = 'KEYWORD' AND segments.date BETWEEN '2019-09-08' AND '2019-09-20' LIMIT 100"
Also, you could use ad_group_criterion_simulation, ad_group_simulation and campaign_criterion_simulation resources to retrieve bid simulator data on the level at which you want to adjust bidding. Please refer to the Interactive Google Ads Query Builder to build the GAQL query for reporting via Google Ads API. Let us know if you have any additional concerns.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHHsC6:ref

[Kuldeep Kumar Patel]

Hi Nikisha,

Thanks for your reply. I am still unable to find the Bid Simulator fields for 'Device' and 'Search keyword'.  please help how to fetch these fields?

Fields : - 

Est. add. clicks/wk (+50% bid)

Est. add. clicks/wk (+300% bid)

Est. add. clicks/wk (-50% bid)

Est. add. clicks/wk (first position bid)

Est. add. clicks/wk (top page bid)

Est. add. cost/wk (+50% bid)

Est. add. cost/wk (+300% bid)

Est. add. cost/wk (-50% bid)

Est. add. cost/wk (first positioin bid)

Est. add. cost/wk (top page bid)

Est. add. cost/wk (Base max. cpc)

[Google Ads API Forum Advisor Prod]

Hi Kuldeep,

It is not possible to get the bid simulator fields for 'Device' and 'Search keyword' via API reports. Let us know if you need any additional information.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHHsC6:ref