Hi, Unfortunately, we do not have a database diagram available that can be shared. Like John mentioned, the best approach to create this structure would be by referring to the object hierarchy <https://developers.google.com/adwords/api/docs/guides/objects-methods#object_hierarchy_and_scope> in AdWords along with the campaign data broken down as entities in this <https://developers.google.com/adwords/api/docs/guides/objects-methods#campaign_data> table. This should help you come up with the main tables and their relationships. To get the stats against each entity, you could run the report <https://developers.google.com/adwords/api/docs/appendix/reports/all-reports> at each level. Eg, run campaign performance report to gather stats at the campaign level and ad group performance report to gather stat at the ad group level etc. You may have to keep in mind that not all performance stats are available immediately. You could check this <https://support.google.com/adwords/answer/2544985?hl=en> document for better understanding of data freshness in reports.
Thanks, Sreelakshmi, AdWords API Team -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] 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 "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/9952dcb7-3e12-4cd6-88bb-b5b6a6d3c648%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
