Hi - I'm not sure when this was made available, but it seems like it would help:
https://developers.google.com/adwords/api/docs/appendix/reports/all-reports.csv For each report, you will see a list of field names, information about data types, enum values, etc. You may also find the report diagram on this page useful in determining which reports to pull: https://developers.google.com/adwords/api/docs/guides/reporting#choosing_the_right_report For those out there considering maintaining their own code for small projects like this, I would strongly encourage you to look for existing software that will do this for you. Given the number of changes to the AdWords API (including breaking changes) and the relatively short sun-set periods <https://developers.google.com/adwords/api/docs/sunset-dates>, you will spend a lot of time building and maintaining your codebase. For as little as $50/mo, third-party software companies will stay on top of these changes for you, and in some cases, even insulate you from breaking changes so that your reporting and automated refreshes can continue without interruption. -Ameet On Wednesday, August 2, 2017 at 1:18:16 AM UTC-4, lead...@gmail.com wrote: > > Thanks *John* and *Sreelakshmi*: > > It's a sad day for me.. lol > I was hoping that I will get something from the forum to avoid doing the > reverse engineer into the entire API classes hierarchy. > > I am not worry so much about the Stats but as to keep the main CONTENT > synchronized in both servers (Google and Ours). We would like to develop a > way to AUTOMATE much of the process within our end and not accessing Google > AdWords Dashboard while doing some advanced marketing topics/ideas. We have > an Admin-Dashboard where we would like to program some Advanced weekly > ideas and make it happen within clicks through the AdWords API. Using the > API will be good to also have a way to get the latest available information > in our campaigns on our end (host servers) synchronized at the most > accurate/time-frame level as provided by Google. > > We had already code in C# (Web) and JAVA (Android) some of the Google APIs > like Google Maps, Firebase Cloud Messaging, Firebase Realtime-Database, > etc. We feel ready to go for Google AdWords in order to minimize > exponential time while doing our marketing ideas through Google AdWords. > > Now that you guys confirmed the none DB-Schema existing, we do not have > any other choice but to reverse-engineer the entire AdWords API Classes, we > have considerable studied the API already and thanks to the *BaseFields* > (base) class as well as each Field, SelectableFields, FilterableFields > inside every API Class will reduce our time a lot in our first goal to > reproduce a minimal database to hold our AdWords account data in our > servers. > > Thanks once again for the information and confirmation. > > Will get back soon! > > On Tuesday, August 1, 2017 at 2:52:48 PM UTC-4, Sreelakshmi Sasidharan > (AdWords API Team) wrote: >> >> 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: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. 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/bc6443d5-eb54-416e-a3e7-d6467f190c62%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.