We don't merge them. Instead, use each to write to the different tables in your db. We use the keyword performance table to populate the keyword data. Ad performance report to populate the ad data & a cost & conversion performance table. When querying to make a report or a table, we use the unique identifiers to display in the same way you see data in the adwords ui.
And we're stuck on how to integrate the managed placement report. What do you do here? Do you put the placement in the same column as the keyword and have a flag in the table to indicate that the entity is a placement rather than a keyword? On Jul 28, 7:08 pm, bgraves <[email protected]> wrote: > I'm sure lots of people have had issues with the Keyword Performance > Report missing information (like managed placement used, creative > used, etc.) It seems that the only solution that I've read on this > forum is that it is necessary to merge all 3 reports together...but > how? Just wanted some feedback to see what other .NET developer are > doing to acheive this: are you using a DataTable, XMLDocument, or > some other method to merge all the reports together (I'm assuming the > keywordId is being used to link everything up). I've coded a nice > solution to pull all 3 reports...just wanted some advice on how to > link them up so I can write the full set of data to SQL. -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [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
