"I want to see how many times an event fired in a particular timeframe."

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

Search the Cookbook

See Confection in Action

Get started risk free.

  • Hidden

Next Steps

"I'm ready to try it."

Get Started (Risk Free)

"I want to see a demo."

Let’s Go

"I have some questions."

Contact Us

"I want to see this."

Share It

"How much does this cost?"

View Pricing Guide

Discussion

Questions or comments about "I want to see how many times an event fired in a particular timeframe."? Leave them below.

Get Started. Risk Free.
IB QUIMBY MELTON

  • Hidden