In a nutshell: Account - has many - Campaigns - has many - AdGroups - has many - Keywords/Sitelinks - has many - Impressions, Clicks, Conversions, etc
Then, you have a decision to make: how often do you fetch Impressions, Clicks, Conversions, etc and attach them to Keywords/Sitelinks? Hourly? Daily? Also, if you like: AdGroups - has many - Ads HTH. On Tuesday, August 1, 2017 at 6:36:05 AM UTC-4, [email protected] wrote: > > Our Real Estate Company would like to incorporate our AdWords accounts > within our company Data (MS-SQL) Server. We would like to use the AdWords > API in order to synchronize and maintain (add/update/delete/etc) our > AdWords data such as Campaigns, AdGroups, Keywords, Bids, Site-links, > Rules, as well as Impressions, Clicks, Conversions, etc. We are planing to > accomplish this through our Company Admin Dashboard and using the amazing > AdWords-API. > > We are planing to add design the necessary database from scratch and > mainly following the AdWordsApi.cs, however there are like 488 C# partial > classes to study. Since we only need to re-create the main AdWords Tables > on our SQL Database that is why having a previous database diagram/schema > will HELP a LOT in order to decide what to add/include in our current > database and so our question: > > *Is there any Google AdWords Database Diagram (at least at Tables-Names > level)?* > We don't need to reproduce the whole AdWords DB schema, we only need the > MAIN tables (and main foreign-tables) related. > > Thanks.cs > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/4a139af6-854f-4d4c-b03f-89c8ee7f3b9f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
