fact_deployment_daily

Pre-aggregated table with delivery counts per campaign and day, broken down by status. Ideal for general metric dashboards without having to aggregate over the detail table.

What questions does it answer?

How many deliveries were made per campaign per day?
What was the delivery and response rate?
How many failures occurred and of what type?
How many users moved on to speak with an agent?

Columns

Column	Type	Description
`company_id`	Int32	Company identifier (filtered automatically)
`day`	Date	Calendar day
`poll_id`	Int32	Campaign identifier
`poll_name`	String	Campaign name
`sent`	UInt32	Total deliveries
`delivered`	UInt32	Delivered to the user
`responded`	UInt32	Responded by the user
`failure`	UInt32	Failed
`in_process`	UInt32	In process
`failure_rate_limit`	UInt32	Failed due to rate limit
`revoked`	UInt32	Revoked
`invalid_phone`	UInt32	Invalid phone
`missing_parameter`	UInt32	Missing parameter
`failure_human_handover`	UInt32	Failed due to active conversation with agent
`deactivated_poll_or_hsm`	UInt32	Deactivated campaign or template
`failure_general`	UInt32	General failure
`failure_unable_to_contact`	UInt32	Unable to contact
`optout`	UInt32	User opted out of receiving messages
`meta_chose_not_deliver`	UInt32	Meta chose not to deliver
`to_agents`	UInt32	Users that moved to agent
`delivered_rate_pct`	Float64	Delivery rate (%)
`response_rate_pct`	Float64	Response rate (%)

Example queries

Summary of the last 2 weeks

SELECT
    poll_name,
    sum(sent) AS sent,
    sum(delivered) AS delivered,
    sum(responded) AS responded,
    sum(to_agents) AS moved_to_agent,
    round(sum(delivered) * 100.0 / nullIf(sum(sent), 0), 1) AS delivery_rate_pct
FROM client_analytics.fact_deployment_daily
WHERE day >= today() - 14
GROUP BY poll_name
ORDER BY sent DESC

Delivery Detail HSM Responses

⌘I

Get Started

Meta

Build with Treble

Main Platform

Agent Platform

Integrations

Data Warehouse

fact_deployment_daily

fact_deployment_daily

What questions does it answer?

Columns

Example queries

Summary of the last 2 weeks

​fact_deployment_daily

​What questions does it answer?

​Columns

​Example queries

​Summary of the last 2 weeks

fact_deployment_daily

What questions does it answer?

Columns

Example queries

Summary of the last 2 weeks