Getting most recent data for ad_group and ad_group_ads

[Kelly Dougan]

I'd like to pull report data on an hourly cadence, and I'd like to understand how to pull the most recently updated data. If I want to get data updated in a given hour, can I use the segments.date combined with the segments.hour fields to filter on? Namely, if I select some resource fields and metrics filtering on the date and hour, will those metrics change if I pull for the same date and hour at a different point in time? Additionally, can you provide information on which resource fields and metrics can be filtered on segments.date and segments.hour?

Thank you.

Kelly

[Google Ads API Forum Advisor Prod]

Hi Kelly,

Thank you for reaching out. You could refer to this link for the fields/resources that can be selected with segment.date and this link for that of segment.hour. If the field/resource is available in both lists, then you can use both segmentations. As there is a data freshness mechanism for the metrics, once they are available you would be able to fetch the data. Please note that for some metrics they could take longer time to be updated or would be updated a few times so you may see some change on the data as time goes by. Please let me know if you have any further concerns.

Thanks and regards,
Xiaoming, Google Ads API Team

 

 

 

ref:_00D1U1174p._5004Q1zpced:ref

[Kelly Dougan]

Hi Xiaoming,

Thanks for your reply, I’m wondering if the API exposes any immutable event-level fact tables? Aka the facts that are aggregated into the ad_group, and ad_group_ad tables.

Thanks,

Kelly

[Google Ads API Forum Advisor Prod]

Hi Kelly,

Thank you for reaching out. Could you please elaborate your question and provide more information on what specifically you want to achieve?

Thanks and regards,
Xiaoming, Google Ads API Team

 

ref:_00D1U1174p._5004Q1zpced:ref

[Kelly Dougan]

Not sure if this message was sent, re-sending in case:

Basically the raw event data that's aggregated into those ad-level views (ad_group, and ad_group_ad). We would like to have the flexibility to pivot this data however we want going forward and not be restricted by the granularity enforced by these arbitrary aggregations. By "raw event data" we mean clicks, conversions, etc. Basically the atomic events that comprise the most granular datasets in the data warehouse.

Let me know if this makes sense,

-Adam