Thank you for reply. Let me implement this method and update you. On Wednesday, March 13, 2019 at 12:51:46 AM UTC+5, googleadsapi-forumadvisor wrote: > > Hello Qaiser, > > Assuming that you are using the Google Ads API > <https://developers.google.com/google-ads/api/docs/release-notes>. If > yes, you can order the result in the descending order for the impressions > and put a limit of 10 on the query so that it will only return the top 10 > keywords with highest impressions. Below is the query share for your > reference. > > Query for Google Ads API below: > > "SELECT campaign.id, " > + "campaign.name, " > + "ad_group.id, " > + "ad_group.name, " > + "ad_group_criterion.criterion_id, " > + "ad_group_criterion.keyword.text, " > + "ad_group_criterion.keyword.match_type, " > + "metrics.impressions, " > + "metrics.clicks, " > + "metrics.cost_micros " > + "FROM keyword_view " > // Limits to the 10 keywords with the most impressions in > the date range. > + "ORDER BY metrics.impressions DESC " > + "LIMIT 10"; > > If you are facing any issues please share the query you are performing so > that I can take a look. > > If you are using the AdWords API and facing this error, it is not possible > to order by impressions in the AdWords API, you can try to apply more > filters in the where clause to narrow down your results. If the issue > persists please share the entire error log and the report definition you > are trying along with the CID. You could use reply privately to the author > option while sharing the information requested. > > Regards, > Sai Teja, AdWords API Team > > > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > Also find us on our blog and discussion group: > http://googleadsdeveloper.blogspot.com/search/label/adwords_api > https://developers.google.com/adwords/api/community/ > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > > Was your question answered? Please rate your experience with us by taking > a short survey. > If not -- reply to this email and tell us what else we can do to help. > > Take Survey > <https://support.google.com/google-ads/contact/survey_transactional?caseid=5-4883000025571&hl=en&ctx=1> > > Also find us on our blog and discussion group: > http://googleadsdeveloper.blogspot.com/search/label/adwords_api > https://developers.google.com/adwords/api/community/ >
-- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/1db200cf-34cc-4258-9801-9de74e6fa61f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
