fact_ad_sessions

Each row is one conversation that started when a user clicked a Click-to-WhatsApp ad (Facebook/Instagram), together with the creative that brought them: headline, body, media, and the ad’s source id. Join with fact_treble_sessions through session_id for outcome analysis. This dataset was not available in the previous warehouse.

What questions does it answer?

Which ads generate the most WhatsApp conversations?
Which creatives (headline/body/media) convert best once the conversation starts?
What is the funnel from ad click to goal (join with fact_target_events)?

Columns

Column	Type	Description
`session_id`	Int64	The conversation the ad started (join `fact_treble_sessions`)
`company_id`	Int32	Your company (filtered automatically)
`created_at`	DateTime64	When the conversation started
`headline`	String	Ad headline
`body`	String	Ad body text
`source_type`	String	`ad` or `post`; occasionally empty when Meta doesn’t send the field
`source_id`	String	Meta’s id of the ad/post — key for joining with your Meta Ads reporting
`source_url`	String	URL of the ad/post
`media_type`	String	`image` or `video`; occasionally empty
`image_url`	String	Creative image URL, when media is an image
`video_url`	String	Creative video URL, when media is a video
`thumbnail_url`	String	Video thumbnail URL
`treble_image`	String	Copy of the creative stored by Treble
`synced_at`	DateTime64	When this row was last written/corrected

Example queries

Conversations per ad, last 30 days

SELECT source_id, any(headline) AS headline, count() AS conversations
FROM fact_ad_sessions
WHERE created_at >= today() - 30
GROUP BY source_id
ORDER BY conversations DESC

From ad to conversion

SELECT
    a.source_id,
    any(a.headline)                 AS headline,
    uniqExact(a.session_id)         AS conversations,
    uniqExact(t.session_id)         AS converted
FROM fact_ad_sessions AS a
LEFT JOIN fact_target_events AS t
    ON t.company_id = a.company_id AND t.session_id = a.session_id
WHERE a.created_at >= today() - 30
GROUP BY a.source_id
ORDER BY conversations DESC

⌘I

Get Started

Meta

Build with Treble

Main Platform

Agent Platform

Integrations

Analytics Warehouse

Data Warehouse (Legacy)

fact_ad_sessions

fact_ad_sessions

What questions does it answer?

Columns

Example queries

Conversations per ad, last 30 days

From ad to conversion

​fact_ad_sessions

​What questions does it answer?

​Columns

​Example queries

​Conversations per ad, last 30 days

​From ad to conversion

fact_ad_sessions

What questions does it answer?

Columns

Example queries

Conversations per ad, last 30 days

From ad to conversion