Hi, Kindly note that we cannot retrieve the data based on the last timestamp. Could you please confirm whether you want to retrieve the data based on the timestamps rather than dates ? -> I mean dates only. For example I am in timezone where today date is 19 and according to API doc I can fetch data based on dates in this case I pass 19 as a date I might have lesser data as 19 date was running, so I might miss data for date 19. In my current system I was trying to update data only after day is over and 6 hours buffer in case any in valid clicks can be adjusted.
Now I need to see data near about it was seen in UI. So in my case If I am selecting date as 19 I can see data upto last hour as in UI. In your query I am adding another segments which will add more additional rows to response and makes no addition to response. Thanks On Monday, 18 November 2024 at 18:59:42 UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for reaching out to the Google Ads API support team. > > Kindly note that we cannot retrieve the data based on the last timestamp. > Could you please confirm whether you want to retrieve the data based on the > timestamps rather than dates ? > > You can retrieve the data from the segments.hour, I would recommend you to > check this documentation > <https://developers.google.com/google-ads/api/fields/v18/segments#segments.hour> > for > more information. You can try the following query: > > > SELECT segments.hour, campaign.name, campaign.id, metrics.clicks FROM > campaign WHERE segments.hour = 1 > > You can try making a request using the Search > <https://developers.google.com/google-ads/api/rest/reference/rest/v17/customers.googleAds/search> > or SearchStream > <https://developers.google.com/google-ads/api/rest/reference/rest/v17/customers.googleAds/searchStream> > by > passing the customer Id. Also, you can use Query Builder > <https://developers.google.com/google-ads/api/fields/v14/customer_search_term_insight_query_builder> > to > create your query and Query Validator > <https://developers.google.com/google-ads/api/fields/v14/query_validator> to > validate your query. > > If this is not what you are looking for, kindly provide us the uncropped > UI screenshot of the Google Ads account and also highlight the fields based > on hour segmentation that you require to retrieve via the API. > > You can send the details via *Reply privately to the author option*, or > *direct > private reply* to this email. > This message is in relation to case > "ref:!00D1U01174p.!5004Q02vGkOQ:ref" (ADR-00275906) > > Thanks, > > [image: Google Logo] Google Ads API Team > Feedback > How was our support today? > > [image: rating1] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=5004Q00002vGkOQ> > > [image: rating2] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=5004Q00002vGkOQ> > > [image: rating3] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=5004Q00002vGkOQ> > > [image: rating4] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=4&entry.295079254=5004Q00002vGkOQ> > > [image: rating5] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=5&entry.295079254=5004Q00002vGkOQ> > > > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/4f0e9789-261f-44a7-9c3d-d05afdc97964n%40googlegroups.com.
