1WITH
2  t1 AS(
3    SELECT *
4    FROM `tc-da-1.turing_data_analytics.adsense_monthly`
5    WHERE (campaign LIKE 'NewYear%' OR campaign LIKE 'BlackFriday%')
6    AND (month = 202101 OR month = 202011)),
7  t2 AS(
8    SELECT LEFT(event_date, 6) month, campaign, COUNT(DISTINCT user_pseudo_id) clicks
9    FROM `tc-da-1.turing_data_analytics.raw_events`
10    WHERE (campaign LIKE 'NewYear%' AND event_date LIKE '202101%' AND event_name = 'page_view')
11    OR (campaign LIKE 'BlackFriday%' AND event_date LIKE '202011%' AND event_name = 'page_view')
12    GROUP BY LEFT(event_date, 6), campaign)
13
14SELECT DISTINCT t1.month, t1.campaign, t1.impressions, t2.clicks
15  FROM t1
16  INNER JOIN t2
17  ON t1.campaign = t2.campaign
18  ORDER BY t1.month