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 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., query
in <input type="search" id="site-search" name="query" />
).
Sample output follows:
value1 | value2 |
---|---|
lorem | 1234567890 |
ipsum | 0987654321 |
Get started risk free.
Questions or comments about "I want to output certain form field values."
? Leave them below.