— A simple example of joining web behavior with CRM leads
SELECT
ga.user_pseudo_id,
ga.event_name,
crm.lead_status,
crm.opportunity_value
FROM
your-project.analytics_123456.events_* AS ga
JOIN
your-project.crm_data.leads AS crm
ON
ga.user_email_hash = crm.email_hash
WHERE
crm.lead_status = 'Qualified'
AND ga.event_name = 'first_visit'