fact_hsm_responses

Each row is one answer a user gave to a flow step that sent an HSM (WhatsApp template) — typically the buttons or quick replies of a campaign’s opening message. It is a focused subset of fact_treble_session_nodes: only steps with a template that received an answer.

What questions does it answer?

Which button/option do users pick when they answer a template?
Which templates get the most engagement?
What exactly did users reply to each template?

Columns

Column	Type	Description
`interaction_answer_id`	Int64	Unique identifier of the answer — equals `fact_treble_session_nodes.node_record_id` for the same step
`company_id`	Int32	Your company (filtered automatically)
`session_id`	Int64	The conversation flow it belongs to
`hsm_id`	Int32	HSM template (join `dim_hsms`)
`hsm_name`	String	Template name
`answer_text`	String	The user’s reply text
`responded_at`	DateTime64	When the user answered (always set — unanswered templates are not in this table)
`poll_id`	Int32	Flow identifier
`poll_name`	String	Flow name
`cellphone`	String	User’s phone number
`synced_at`	DateTime64	When this row was last written/corrected

Example queries

Answer distribution per template, last 30 days

SELECT hsm_name, answer_text, count() AS answers
FROM fact_hsm_responses
WHERE responded_at >= today() - 30
GROUP BY hsm_name, answer_text
ORDER BY hsm_name, answers DESC

⌘I