This is not a new problem - it begain earlier this year. You no longer get display network data in the KeywordPerformance report. You need to pull ManagedPlacement reports for the managed placements, and AutomaticPlacement reports for the automatic placements. This will get you close to the totals you see in the engine UI and in the AccountPerformance reports, but not exact. The difference will be the value of the Other Domains shown in the UI for Automatic Placements. This value cannot be pulled via any report. You can compute it by pulling an AdGroup Performance report with segmentation set to Network1, filtering out all data except Display network data, and then subtracting from that number the totals for each AdGroup for the data already pulled from the above three reports. This will give you the Other Domains number.
Almost. Also take into account the impact of click fraud adjustments. Also take into account the correct timing for pulling these reports. The usual mantra from Google (sorry Eric, Anash) of "4-5 hours after midnight" that is given in reponse to the common question of "when can I pull performance reports" is just plain wrong. It only applies to keyword performance reports and summary data reports (AccountPerformance,...). For managed placement reports, Google's own AdWords docs say to wait until after 3:00pm in the account's timezone (I wait until 5 to be safe); I have accounts that have shown empiracally that their managed placement data never changes after 8:00 am of the following day, but the Google documented rule is 3:00 of the following day. Automatic placement data is far worse. If you log into the UI and try to look at yesterday's data this morning, you will see the usual breakdown at the bottom of the screen showing Search and Display totals, and if you go to the Networks tab you will see the breakdown between Managed Placements and Automatic Placements. But if you try to expand the automatic placements section you will see that there is no data - everything is listed for Other Domains. I've waited all day, and it stays like that. I've ended up waiting until 7:00am of the next day (2 days after the data date) to pull that data. It is still not perfect - I've seen the Automatic Placements data change over the course of 5 days after the event. Not just numbers fluctuating, but new data rows for automatic placement sites showing up. As far as I can tell, Google knows what the total is supposed to be about 4-5 hours after midnight in the account timezone (I pull AccountPerformance reports at that time, and they have the correct totals), but they aren't able to break it down into the detail Automatic Placement performance data for another 36-40 hours, and it doesn't totally settle down for another 5 days. So you need to keep pulling the automatic placement data for the last week or so, checking to see if there is new or changed data, load it or modify your existing data, and the also update whatever value you originally calculated as the Other Domains (since those changes/ additions will have come out of the Other Domains bucket). Now you're almost home. Unless you have remarketing campaigns, especially if you have remarketing campaigns that include placements. Remarketing data only shows up 100% at the detail level in one report - the AdPerformance report. But that report doesn't have keywords in it (since it is an Ad report - makes perfect sense, since not all ads have keywords). So you need a scheme to find the ad data for remarketing campaigns - we decided that all remarketing campaigns would have "remarketing" in their name, and so can locate them that way. So now you get the remarketing data loaded. But if a remarketing campaign includes a managed placement, then its data also shows up in the managed placement performance report - so now you've loaded some of the data twice. Since you cannot tell from the Ad Performance Report itself that the ad is for a Managed Placement, what you end up doing is having the code that loads the Managed Placement Performance Report filter out the data for Remarketing campaigns. Would be nice if the remarketing data was just integrated into the reporting system, but as you can see it's not a clean situation since there can be overlap between the "buckets" of data that remarketing data can be assigned to. Now you're real close. Unless you have video ads with no keywords. They only show up in the AdPerformance Report, so you need to figure out how to filter their data from that report and get it loaded. And don't forget, most of these numbers will be constantly changing over the course of a week or so as click fraud adjustments are made. You can try to determine if adjustments have been made by pulling AccountPerformance data every day for the past xxx days time period, and then comparing that number with what's in your database for each of those days, but to fix your data you need to be constantly repulling the detail level data and seeing what actually changed. And you thought this was going to just be a simple matter of pulling a file and loading its data into a database! -reed -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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
