When enabled, Confection's BigQuery integration creates a dataset with two columns:
data column includes JSON-formatted data associated with a UUID's site activity. To connect BigQuery to your Confection account, see this quick-start guide.
The following query pulls emails from the
data column and links them with pageview information. This can help you plan and build retargeting campaigns.
To learn more about the ways Confection can help you build retargeting lists and capture leads that otherwise go missing, see this blog post.
Sample output follows:
Get started risk free.
Questions or comments about
"I want to generate a list of emails, the URLs the users visited, and the number of times the users visited those URLs."? Leave them below.