AdWords Database Structure and Schema

16 views

Skip to first unread message

trabelsi rami

unread,

Apr 13, 2020, 4:57:51 PM4/13/20

to AdWords API and Google Ads API Forum

hello everyone ,

so i'm working with the googleads api and we are using the api for a data visualizations which there is a plenty of data and for having a good infrastructure for our solution i wonder if i can find google adwords database diagram or Database Schema or database structure with it's different entities or it main tables so i don't have to reproduce it from scratch and thanks for responding

Google Ads API Forum Advisor Prod

unread,

Apr 13, 2020, 11:25:55 PM4/13/20

to trabel...@gmail.com, adwor...@googlegroups.com

Hi trabelsi,

Thank you for reaching out to AdWords API and Google Ads API Forum.

We do not provide database diagrams or schemas as what you have in mind. However, we allow developers to query reports via either AdWords API or Google Ads API (Beta).

In AdWords API, you should read the Reports guide and understand the different types of reports.

Reporting Basics: https://developers.google.com/adwords/api/docs/guides/reporting

Types of reports: https://developers.google.com/adwords/api/docs/guides/reporting#choosing_the_right_report

In Google Ads API, you should use the Google Ads Query Language (GAQL) to query different resources:

GAQL: https://developers.google.com/google-ads/api/docs/query/overview

Resources: https://developers.google.com/google-ads/api/fields/latest/overview

Hope that this helps your issue, thank you.