"I want to output location information about visitors to 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 location information for site visitors.

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:

URL Visited Visitor City VisitorState/Region VisitorCountry VisitorLat/Long Referrer Campaign Content ID Medium Term Timestamp
xyz.com/landing-page Boston Massachusetts US 42.361145,-71.057083 google.com PPC Lorem ABC123 Paid My-Keyword 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 location information about visitors to my site."? Leave them below.

Get Started. Risk Free.

  • Hidden