Changing our database structure isn't an option right now. We really need a single report comparable to the v13 Keyword Performance Report. Was anyone able to merge the 3 reports together in .NET?
On Jul 29, 4:35 am, TJ <[email protected]> wrote: > We don't merge them. Instead, use each to write to the different > tables in your db. We use thekeywordperformancetable to populate > thekeyworddata. Adperformancereportto populate the ad data & a > cost & conversionperformancetable. When querying to make areportor > 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 placementreport. What > do you do here? Do you put the placement in the same column as thekeywordand > have a flag in the table to indicate that the entity is a > placement rather than akeyword? > > On Jul 28, 7:08 pm, bgraves <[email protected]> wrote: > > > > > I'm sure lots of people have had issues with theKeywordPerformance > >Reportmissing 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.- Hide quoted text - > > - Show quoted text - -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
