I'm having an issue removing specific INT64 id's from consideration while running a p-value script via Spyder while using BigQuery commands.
So when apply the script in this format with the specific advertising_ids removed in this syntax: advertising_id, AND advertising_id NOT in (1163160702660369000, -1925315655674023700) there is no difference in p-value vs when these id's are not removed so there is some issue
When I use AND advertising_id NOT in ('1163160702660369000', '-1925315655674023700') when advertising_id syntax is in 'advertising_id' form, I get the error:
400 Query error: No matching signature for operator IN for argument types INT64 and {STRING} at [24:26]
WITH
prep AS (
SELECT
DISTINCT advertising_id,
group_assignment
FROM
`omitted_for_privacy`
WHERE
day BETWEEN date_audience_start
AND date_audience_end
AND influence is null
AND advertising_id NOT in ('1163160702660369000',
'-1925315655674023700',
'7046321939169906000')
--and sum_cv<=4082.26 and sum_cv>0
-- AND user_subcampaign IS NOT NULL
AND user_subcampaign=subcampaign_name
)
Please help, I can't seem to remove these advertising_id values in the script when considering the calculation of the p-values of the entire dataset.