That works! :) Thanks. On Monday, November 21, 2016 at 12:46:49 PM UTC-8, Vikram Tiwari wrote: > > I am trying to replicate how reports are shown/generated from the UI via > Python SDK. > > In the UI if I take Conversion Action Name (ConversionTypeName) I get the > ability to add it as a row or as a column (Attached Screenshot). > > *First Format*: If I add it as a row all the different conversion types > go under one column and the values in that column are string values. To get > actual counts, I have to add Conversions and the count is populated into > another column. > > *Second Format*: But if I add it as a column, different conversion types > become different columns and the numeric values end up forming rows. This > is the structure that I am trying to replicate via API. > > While using *Python SDK and AWQL* I only get the ability to pass it in > fields. That ends up downloading the report in the first format. How do I > tweak my query to get it in flat format? > > Details: > SDK version: v201609 > Query: "SELECT Date, AdGroupId, AdGroupName, ConversionTypeName, > ConversionTrackerId, Conversions FROM ADGROUP_PERFORMANCE_REPORT DURING > LAST_7_DAYS" > > > >
-- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 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 --- 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 adwords-api+unsubscr...@googlegroups.com. 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/e8d4c290-f37a-415e-a211-75773bca3ec6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.