When enabled, Confection's BigQuery integration creates a dataset with two columns:
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 queries to output values from a particular form field. For example, you might want to see what terms people use to search your site. You might want to isolate a list of phone numbers for your sales team.
The query accepts any form field name (eg.,
<input type="search" id="site-search" name="query" />).
Sample output follows:
Get started risk free.
Questions or comments about
"I want to output certain form field values."? Leave them below.