Google Ads Tracking

select
	a.subscription_created_at::date,
	b.cleaned_source,
	b.utm_campaign,
	count(distinct b.browser_hash) as n_visits,
	count(distinct case when w.first_user_created_event_at is not null then b.user_id else null end) as accounts_created,
	count(distinct a.user_id) as credit_cards_added
from analytics.browser_hash_hits b
join analytics.acquisition_waterfall_by_browser_hash w
on w.browser_hash = b.browser_hash
left join analytics.acquisition_credit_card_source_tracking a
on a.user_id = b.user_id
and	a.summarized_reporting_cleaned_source ilike '%google%'
where 
	 b.cleaned_source ilike '%google%'
group by 1,2,3