IB QUIMBY MELTON <GO>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 |
Get started risk free.
Questions or comments about "I want to output location information about visitors to my site."? Leave them below.
IB QUIMBY MELTON