Google Ads Data Dictionary
- 14 Apr 2022
- 1 Minute to read
- Print
- DarkLight
- PDF
Google Ads Data Dictionary
- Updated on 14 Apr 2022
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Panoply supports the selection from over 100 different resources from the Google Ads API. For each resource there are multiple different combinations of fields, segments and metrics. These include also attributed resources and segmenting resources.
It is up to the user to select which resource, fields, segments and metrics they wish to collect using Panoply.
The full list of available resources is available here
Every selected field, segment and metric will be saved in Panoply with a prefix to identify its origin. Metrics and segments will be saved with the metrics_ and segments_ respectively and fields will have the relevant resource's name as a prefix (For example, ad_group_).
Note:
Cost fields are returned in micro currency units (micros). For example, $1.23 will be seen as 1230000. Divide the micro currency units by 1000000 to get the actual cost.
When filtering on cost fields, provide the value in micros. For example, to return rows where metrics_average_cost is greater than $1, use WHERE metrics_average_cost > 1000000 or divide the field by 1000000: WHERE metrics_average_cost/1000000.00 > 1.
::
Was this article helpful?
.png)