"I want to see detailed information about an event."

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.

Use the following query to answer questions like, "On which page did an event fire," "How many times did it fire," "What values are available," and "Where did the user who triggered the event come from?" You can return results for custom event names or you can use default Confection events like loadtime, pageviewBatch, and purchasedEvent.

Enrichment Add-On

To generate city, region, country, and lat/long information, you'll need to activate Confection's enrichment add on. To do so, schedule a call with our team. To learn more about the add-on, see this blog post.

Sample output follows:

event event_value domain URL referrer campaign content id medium term city region country loc count
eventName eventValue xyz.com xyz.com/landing-page google.com PPC AdTextHere 123456 paid keyword San Francisco California US 42.361145,-71.057083 12

"Why do I see direct referrer values and campaign information?"

referrer information and UTM-style campaign data run in parallel lines. referrer is a server-side value, and UTM-style campaign values are URL-parameter-based, front-end values.

Browsers that use privacy settings or extensions generally hide referrer information. Links with rel="noreferrer" attributes will also omit referrer information. As such, when you see a direct referrer value and campaign information, treat the campaign information as authoritative.

We considered overwriting referrer data when campaign source information is available. However, there are ethical and practical arguments to be made for preserving the actual referrer information. Confection's mission involves presenting information as accurately as possible. A customer may want to calculate the number of privacy-focused users visiting his/her site. A customer might also want to audit a particular campaign.

For these and other mission-focused, usage-based reasons, we present referrer values exactly as we detect them.

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 see detailed information about an event."? Leave them below.

Get Started. Risk Free.

  • Hidden