I don't want to reply privately as many other programmers are trying to make this work and can find this useful. It's also good to keep a public record of how bad things have become.
Your query 'SELECT extension_feed_item.resource_name, extension_feed_item.extension_type, campaign.resource_name, campaign.id, campaign.name from extension_feed_item order by campaign.id limit 100' does not work. It returns no results. Not only is this API tremendously bad, but your random solutions don't work. Do you want to play one more time or do you want me to give you the answer again ? On Thursday, May 23, 2019 at 6:39:57 AM UTC+2, adsapiforumadvisor wrote: > > Hello All, > > I've found the source of the inconsistency, so we can work on finding a > resolution. Just so everyone has a summary of the current state, here is > it: > > - You can have segments.month, segments.quarter in the SELECT clause > with segments.date in the WHERE clause. The result is that you'll get > metrics for your date range and the metrics will be empty for anything > outside your date range. The only one that does not work like this is > segments.week, so that's where we'll focus on getting that in line with > the > others. > - If you select segments.month with segments.month in the WHERE or or > segments.week with segments.week in the WHERE clause or segments.quarter > with segments.quarter in the WHERE clause, then you'll only get back > metrics for that time. Keep in mind that if you picked month that if your > date spans the 1st of over 2 months, you'll get back 2 results, one for > each month you've spanned. > > I've run all the variations and we're working on getting that sorted out. > > Now, let's see about that second question on extension settings and feeds. > This spanned multiple objects in AdWords API. So, let's take this one > offline so we don't clutter this forum thread with a separate topic. It's > easier for people searching later if there's one topic per thread. Just > click *Reply privately to author* on the forum with what exactly you did > in the AdWords API to get that exact result, and I can get you what you're > looking for in the Google Ads API. Just as a starter query, I've found > 'SELECT extension_feed_item.resource_name, > extension_feed_item.extension_type, campaign.resource_name, campaign.id, > campaign.name from extension_feed_item order by campaign.id limit 100' > works, and I expand from there for specific types of extension feed items. > > As for the performance, I totally agree with you that there's a slowdown > in certain places depending on the report, but we are very aware of it and > we're working on it. My teammate Ben posted > <https://groups.google.com/d/msg/adwords-api/6tE3d16pj3U/79hX0vhyAwAJ> > something > on it if you're interested in the specifics. > > If you want to chat further on your query, feel free to click *Reply > privately to author*. If you have a new question or topic, then please > start a new thread to make it easier for your fellow readers. > > Thanks, > Nadine, Google Ads API Team > > ref:_00D1U1174p._5001UAqFgy:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. 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/e56364aa-bbfd-4e24-9fe3-3e26828658b1%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.