rpt_funnel_events_performance_hourly - SourceMedium

Hourly funnel event aggregation for volumes and directional event-based ratios.

Grain: One row per (hour x event dimension).
Date field: event_local_datetime.
Filters to start with: event_local_datetime for hourly/daily time windows. Ratios from *_event_count columns are not distinct-session conversion rates. Drill into obt_funnel_event_history by event dimensions and time window.

Query examples

Funnel

Columns

Column	Type	Description
`sm_store_id`	STRING	SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers.
`account_sign_up_event_count`	INT64	Count of account registration events within the hour.
`add_payment_info_event_count`	INT64	Count of payment information submission events within the hour.
`add_shipping_info_event_count`	INT64	Count of shipping information submission events within the hour.
`add_to_cart_event_count`	INT64	Count of add-to-cart events within the hour for funnel analysis.
`begin_checkout_event_count`	INT64	Count of checkout initiation events within the hour for conversion funnel tracking.
`email_sign_up_event_count`	INT64	Count of email subscription and lead generation events (subscribe, generate_lead) within the hour.
`event_is_recurring_subscription_order`	BOOL
`event_local_datetime`	DATETIME	Event timestamp in the reporting time zone (hourly bucket).
`event_order_revenue`	NUMERIC	Total revenue attributed to events within the hour aggregated from event_order_revenue field.
`event_page_path`	STRING	URL path component for page-level aggregation.
`event_page_title`	STRING	Page title where the event occurred for content analysis.
`event_page_url`	STRING	Page URL without query parameters where the event occurred.
`event_utm_campaign`	STRING	UTM campaign parameter for campaign-level attribution.
`event_utm_content`	STRING	UTM content parameter for A/B testing and ad variation tracking.
`event_utm_medium`	STRING	UTM medium parameter for channel grouping (e.g., cpc, social, email).
`event_utm_source`	STRING	UTM source parameter for attribution analysis (e.g., google, facebook, email).
`event_utm_term`	STRING	UTM term parameter for paid search keyword tracking.
`page_view_event_count`	INT64	Count of page view events within the hour for traffic analysis.
`purchase_event_count`	INT64	Count of purchase events within the hour.
`refund_event_count`	INT64	Count of refund events within the hour.
`remove_from_cart_event_count`	INT64	Count of cart removal events within the hour.
`select_item_event_count`	INT64	Count of product selection events within the hour.
`source_system`	STRING	Tracking platform emitting the event (elevar, blotout, snowplow, snowplow_ga4, heap, ga4).
`view_cart_event_count`	INT64	Count of cart page view events within the hour.
`view_item_event_count`	INT64	Count of product detail page view events within the hour.
`view_item_list_event_count`	INT64	Count of product listing page view events within the hour.