This question is to either Google or people who've developed tools to store AdWords performance data. My team is successfully making reports from keyword level data and we want to next store placement & content data. Placements formerly were retrieved in the same report as keywords, but placements/content has since been separated into separate reports from keyword. Regarding storing data in a database, is best practice to:
1) Store individual placements and the "content keyword" in the KEYWORDS table and add a new "datatype" field in the table with available values "placement", "content", "keyword". Any roll up of stats to the ad group will include both placements and keywords if we don't filter with the datatype field. -or- 2) Create a copy of the KEYWORDS table and call it PLACEMENTS with the same performance fields such as clicks, impressions, cost, etc. And everytime we roll up total stats, we will need to add values from the PLACEMENTS table plus KEYWORDS table to get ad group level stats? Gut tells me #1 will be easier for us to implement; however #2 may be best practice because Google separated the data into separate reports implying that the keyword and placement/content data should NOT be stored together. How do you other developers store placements & what would you recommend if starting from scratch? -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords 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
