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. Then, use the following query to pull event values from the data
column and output the number of times those values have fired. This can be helpful for evaluating event performance and auditing the ability of other systems to accurately track particular events.
Sample output follows:
Value | Count |
---|---|
value1 | 66 |
value2 | 38 |
Get started risk free.
Questions or comments about "I want to see how many times individual event values have fired."
? Leave them below.