Wrong results with ConversionTypeName in AWQL-WhereClause?

[Jonas Schreiber]

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.

[Jaren Callo (AdWords Scripts Team)]

Hi Jonas,

Can you send your CID (reply privately to the author) along with the name of the script so that we can take a look?

Thanks,

Jaren P. Callo

AdWords Scripts Team

[Jaren Callo (AdWords Scripts Team)]

Hi Jonas,

The assumption that the CostPerConversion = Costs / Conversions and ConversionRate = Conversions / Clicks is not applicable when there are multiple ConversionTypeName in the AWQL. This formula is only applicable for single ConversionTypeName. Upon checking the Conversions in your account, it seems the two conversion type falls under the same conversion category. Here is the result when I use the conversion category in AWQL:

 

var report = AdWordsApp.report("SELECT Conversions,CostPerConversion,ConversionRate FROM ACCOUNT_PERFORMANCE_REPORT WHERE ConversionCategoryName IN ['Lead'] DURING 20160509,20160509");

the result is:

 

Conversions	CostPerConversion	ConversionRate
88	23.51	6.07%

What I can suggest, if you still want to use conversion type especially if they don't belong to same category, is to create separate query for each conversion type. This will return a more accurate results.

Below is the data I created using Scripts and using Report tool in the UI:

Report via UI
Conversion Type	Conversions	Cost / conv.	Conv. rate
PSLLER_RatingStep-6_Flat	29	71.33	2.00%
PSLLER_RatingStep-6_House	59	35.06	4.07%
using conversion category (Lead)	88	23.51	6.07%
Report via Scripts
PSLLER_RatingStep-6_Flat	29	71.33	2.00%
PSLLER_RatingStep-6_House	59	35.06	4.07%
using both conversion type	88	47.01	3.03%
using conversion category (Lead)	88	23.51	6.07%

Thanks,

Jaren P. Callo

AdWords Scripts Team