Hi, I'm making AWQL-Requests with AdWords Scripts and we only want to consider specific conversion types, so I tried to filter the data like so:
SELECT Conversions,CostPerConversion,ConversionRate FROM ACCOUNT_PERFORMANCE_REPORT WHERE ConversionTypeName IN [ '<CONVERSION_TYPE_NAME_1>', '<CONVERSION_TYPE_NAME_2>'] DURING 20160509, 20160509 This works well for the Conversions column - the CostPerConversion and ConversionRate however don't match my expectations. I would expect to get CostPerConversion = Costs / Conversions and ConversionRate = Conversions / Clicks (where the Conversions are only those from the AWQL-Select above). And when there's only one conversion type in the where clause my expectations are met. But when I have two ConversionTypeNames the CostPerConversion value seems doubled and the ConversionRate seems halved. When I have 3 ConversionTypes the value is 3 times higher resp. 1/3 of the expected value and so on. The same applies to ConversionCategoryName here: SELECT Conversions,CostPerConversion,ConversionRate FROM ACCOUNT_PERFORMANCE_REPORT WHERE ConversionCategoryName IN ['Lead','Signup'] DURING 20160509,20160509 This seems like a bug to me, but maybe I'm just missing something here. Thanks in advance for any help. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/b0f1c2e9-80a2-4345-846b-f464670cbee0%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.