I am expecting hour wise ad cost for items. Is there any way to achieve this ?
Let say for item "X", I want to see hourly ad spend ! I can see day wise ad cost for items but I want more detail break down of the ad cost On Monday, July 17, 2023 at 7:01:35 PM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi Vipul, > > Thank you for reaching out to us. > > Upon checking, I could confirm that 'segments.hour' is not a valid field > in the WHERE clause when 'shopping_performance_view' is the resource in the > FROM clause. To prevent this kind of error, You can use the exact > *shopping_performance_view > builder > (**https://developers.google.com/google-ads/api/fields/v14/shopping_performance_view_query_builder?hl=en > > <https://developers.google.com/google-ads/api/fields/v14/shopping_performance_view_query_builder?hl=en>* > *)* to see its selectable and filterable fields. Also, I would recommend > that you use the *Google Ads Query Builder* > (*https://developers.google.com/google-ads/api/fields/v14/overview_query_builder?hl=en > > <https://developers.google.com/google-ads/api/fields/v14/overview_query_builder?hl=en>*) > > and *Query Validator* > (*https://developers.google.com/google-ads/api/fields/v14/query_validator?hl=en > > <https://developers.google.com/google-ads/api/fields/v14/query_validator?hl=en>*) > > tools for constructing queries. > > On the other hand, for our team to further check and provide you with > appropriate recommendations, could you please provide us with the entire UI > screenshot without cropping, including its customer ID, where you can see > the data you want to retrieve in the API? > > You may then send the requested information via the Reply privately to > author option. If this option is not available, you may send the details > directly to our [email protected] alias instead. > > This message is in relation to case "ref:_00D1U1174p._5004Q2n8PjQ:ref" > > Thanks, > > [image: Google Logo] Google Ads API Team > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/becebed3-dbfa-48f4-9681-efd571a58c88n%40googlegroups.com.
