Here's a detailed schema for the Reach & Frequency (R&F) data feed, with field descriptions and sample values.
| R&F Data Feed Column Name | Data Type | Sample Value | Description |
|---|---|---|---|
GroupName |
string | All |
The name associated with this grouping of IDs. |
ReportDate |
string | 2023-05-15 |
Same as the report date for the standard Google Ads report, such as "2021-10-31" |
TimeGranularity |
string | WEEKLY_MONDAY |
Same as in Google Ads report. |
GeoType |
string | REGION |
"COUNTRY", "REGION", or "DMA" |
GeoCriteriaId |
int64 | 21182 |
Criterion ID of the geo location this breakout is for. |
GeoName |
string | Wisconsin |
Name of the geo location this breakout is for. |
Reach |
int64 | 12345678 |
Count of unique users with impressions in the reporting period. |
Impressions |
int64 | 123456 |
Count of total impressions, without deduplication, in the reporting period. |
AverageFrequency |
double | 1.123123 |
Impressions / Reach |
Population |
int64 | 1234567 |
Eligible number of unique users, a theoretical upper bound for Reach based on census data. |
RollingWindowStartDate |
string | 2023-04-24 |
For the cumulative rolling window reach metrics, the start date (inclusive) of the window. |
RollingWindowEndDate |
string | 2023-05-21 |
For the cumulative rolling window reach metrics, the end date (inclusive) of the window. |
RollingWindowCumulativeReach |
int64 | 219024 |
Count of unique users with impressions in the rolling window. |
RollingWindowCumulativeImpressions |
int64 | 397512 |
Count of total impressions, without deduplication, in the rolling window. |
RollingWindowAverageFrequency |
double | 1.123123 |
RollingWindowCumulativeImpressions / RollingWindowCumulativeReach |