Hello, there is something weird when filtering reports with ConversionCategoryName segment field. I cant filter the using the 'Others' value.
The following works:SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName = 'Download'
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName = 'Lead'
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName In ['Lead', 'Download']
But when picking only Others, it doesn't work. It returns nothing...
The following doesnt work:
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName = '
Other'
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName In ['Other']
I even tried ths but it's just doesnt work.
SELECT CampaignId, ConversionCategoryName, Conversions FROM CAMPAIGN_PERFORMANCE_REPORT Where ConversionCategoryName In ['Other', 'other', 'Others', 'others']
I want to know why is that.