Provides flow analytics, including aggregated or time-series data for flow performance metrics based on the chosen granularity.

Select

The provider uses the Klaviyo API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.

• ConversionMetricId supports the following operator: =
• Granularity supports the following operator: =. Valid values:
  • hourly
  • daily
  • weekly
  • monthly
  • total (default)
• StartDateTime and EndDateTime support the following operators: =
• FlowId supports the following operators: =, IN
• SendChannel supports the following operators: =, IN
• FlowMessageId supports the following operators: =, IN

You can apply only one filter per column, and filters must be combined using the AND operator. The OR operator is not supported.

Note: Setting Granularity to total returns the same result as omitting the Granularity filter entirely.

You must specify a ConversionMetricId to query this table. If a time window is not explicitly provided using StartDateTime and EndDateTime, the provider automatically applies defaults based on the value of Granularity:

• total or monthly: Last 1 year
• weekly: Last 52 weeks
• daily: Last 60 days
• hourly: Last 7 days

If you provide only one of StartDateTime or EndDateTime, the provider calculates the missing value using the default time span for the selected granularity.

When Granularity is not total, the fields IntervalStartDateTime and IntervalEndDateTime are returned based on the current interval. When Granularity is total, they match the StartDateTime and EndDateTime values.

Note: When using the IN operator, you can provide up to 100 values. Valid values for SendChannel include:

• email
• sms
• push-notification

For example, the following query returns monthly flow stats for a defined time range and multiple flows:

SELECT * FROM FlowStats 
WHERE ConversionMetricId = 'conversion-metric-id' 
  AND Granularity = 'monthly' 
  AND StartDateTime = '2024-07-07' 
  AND EndDateTime = '2024-09-09' 
  AND FlowId IN ('flow-1', 'flow-2', 'flow-3')

You can also run simplified queries depending on your data needs:

SELECT * FROM FlowStats 
WHERE ConversionMetricId = 'conversion-metric-id'

SELECT * FROM FlowStats 
WHERE ConversionMetricId = 'conversion-metric-id' 
  AND StartDateTime = '2024-07-07' 
  AND EndDateTime = '2024-09-09'

SELECT * FROM FlowStats 
WHERE ConversionMetricId = 'conversion-metric-id' 
  AND Granularity = 'monthly' 
  AND StartDateTime = '2024-07-07' 
  AND EndDateTime = '2024-09-09'

Columns