"I want to output information about companies who are visiting my site."

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 output information about companies visiting your site.

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:

Company Name Company Domain Visitor City Visitor Region Visitor Country Visitor Lat/Long Page Visited Timestamp
XYZ Corporation xyz.com San Francisco California US 42.361145,-71.057083 domain.com/landing-page 2023-09-07

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 output information about companies who are visiting my site."? Leave them below.

Get Started. Risk Free.

  • Hidden