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 the number of times an event fired in a particular timeframe. The query supports daily, weekly, monthly, quarterly, and annual reporting periods.
Sample output follows:
event_count | event_date |
---|---|
76 | 2024-09-27 |
46 | 2024-09-26 |
Get started risk free.
Questions or comments about "I want to see how many times an event fired in a particular timeframe."
? Leave them below.