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 generates a list of email addresses and their first-touch source data. To learn more about the way Confection structures first- and subsequent-touch referrer and campaign data, see this documentation.
Sample output follows:
Get started risk free.
Questions or comments about
"I want to see a list of email addresses and their first-touch source data."? Leave them below.