Hi,
Is there any issue with this query?
It is giving me all the available results despite passing filters.
1)
SELECT
campaign_criterion.type,
campaign_criterion.criterion_id
FROM
campaign_criterion
WHERE
campaign_criterion.criterion_id IN
(896XXX014,90X367,311871CC0470,31306XX9104,1000,30000,30001,30002,30004,10D7760,100A768,2840,929XX60,47984XX5186)
This is give me 250+ records but ideally it should give filtered results.
Can you please help why it is?
2)
SELECT
ad_group_criterion.type,
ad_group_criterion.criterion_id,
ad_group_criterion.status
FROM
ad_group_criterion
WHERE
ad_group_criterion.criterion_id IN (678X4427,18XXX5610,642XX060,111C651,9814X71,111X551,168X4950)
AND ad_group_criterion.status IN ("ENABLED", "PAUSED", "REMOVED", "UNKNOWN")
This ad_group_criterion result is not giving response for removed criteria.
It should be return which criteria was removed.
Best,