Inconsistent results when filtering Selectors (withCondition) in Adwords Scripts

[jorge.ba...@orbitalads.io]

Hi,

I've found some weird behaviour trying to apply some conditions to an AdGroupSelector.  

I've attached a script to show this weird scenario :-(

Here is the output of the script ( Removing Campaign & Adgroups names for the sake of privacy) , but feel free to execute in your own accounts:

current Campaign: Campaign1

Total adGroups in currentCampaign : 2

0.0 matching adGroups whose Ctr is above 0.14 

2.0 matching adGroups whose Ctr is below 0.14 

The sum of number [2.0] of adGroups below Ctr threshold(0.14) and number of adGroups above [0.0] Ctr threshold has to be equal to the total number of adgroups of the current Campaign [2.0]

current Campaign: Campaign2

Total adGroups in currentCampaign : 3

0.0 matching adGroups whose Ctr is above 0.14 

3.0 matching adGroups whose Ctr is below 0.14 

The sum of number [3.0] of adGroups below Ctr threshold(0.14) and number of adGroups above [0.0] Ctr threshold has to be equal to the total number of adgroups of the current Campaign [3.0]

current Campaign: Campaign3

Total adGroups in currentCampaign : 3

1.0 matching adGroups whose Ctr is above 0.14 

2.0 matching adGroups whose Ctr is below 0.14 

The sum of number [2.0] of adGroups below Ctr threshold(0.14) and number of adGroups above [1.0] Ctr threshold has to be equal to the total number of adgroups of the current Campaign [3.0]

current Campaign: Campaign4

Total adGroups in currentCampaign : 15

1.0 matching adGroups whose Ctr is above 0.14 

5.0 matching adGroups whose Ctr is below 0.14 

The sum of number [5.0] of adGroups below Ctr threshold(0.14) and number of adGroups above [1.0] Ctr threshold has to be equal to the total number of adgroups of the current Campaign [15.0]

current Campaign: Campaign5

Total adGroups in currentCampaign : 27

1.0 matching adGroups whose Ctr is above 0.14 

15.0 matching adGroups whose Ctr is below 0.14 

The sum of number [15.0] of adGroups below Ctr threshold(0.14) and number of adGroups above [1.0] Ctr threshold has to be equal to the total number of adgroups of the current Campaign [27.0]

As you can see results for Campaign4 and Campaign5 are inconsistent . I think the text is self-explanatory , but if you need more details, please let me know.

The point is :

Imaging that a Campaign has 10 Adgroups ( Campaign is enabled and all adGroups of the campaign are enabled too). if we take LAST_7_DAYS as a time window , and we have 3 adGroups out of 10 that has Ctr above .014 , when I filter the selection as .withCondition('Ctr < 0.14) , the Iterator should return 7 entities , but as you see in the example, it doesn't behave properly in any case.

[Vishal Vinayak (Adwords API Team)]

Hi,

I'm trying to look into your issue but I might need additional information from you to be able to further debug. If you have a look at our documentation for the Ctr field available in various reports, only GREATER_THAN X or LESS_THAN X operators can be used with fields of the Double data type i.e. there is no way to filter the scenario when the rows with the value exactly X are also included. There is a slight chance that, in your case, there might be a few records with the Ctr value exactly 0.14. If that's not the case, I would be happy to dig deeper on our side. For that purpose, could you please send me the SOAP XML request and response logs and the downloaded report for a success case and a failure case API call? Please click on Reply privately to author when responding.

Regards,

Vishal, AdWords API Team