"I want to isolate a list of emails."

When enabled, Confection's BigQuery integration creates a dataset with two columns: UUID and data. The 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 isolates emails from the data column. It can help you build mailing lists, organize retargeting campaigns, and find leads and emails that may be missing from your CRM or other endpoints as a result of bounces, form abandonments, or application script malfunctions.

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:

[email protected]
[email protected]

Search the Cookbook

See Confection in Action

Get started risk free.

  • Hidden

Next Steps

"I'm ready to try it."

Get Started (Risk Free)

"I want to see a demo."

Let’s Go

"I have some questions."

Contact Us

"I want to see this."

Share It

"How much does this cost?"

View Pricing Guide


Questions or comments about "I want to isolate a list of emails."? Leave them below.

Get Started. Risk Free.

  • Hidden