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 |
Get started risk free.
Questions or comments about "I want to output information about companies who are visiting my site."
? Leave them below.