Schema
AI AnalyticsAI Layer

AI_CampaignResponder

Computed email engagement profile per customer per organisation. Tier classification plus a 'reads but never clicks' flag.

11 fields1 relationships

Fields

NameTypeReqDescription
scorenumberyesComposite engagement score.
engagement_tierenumyeshighly_engaged | moderately_engaged | passive | disengaged.
campaigns_receivednumberCampaigns sent.
campaigns_openednumberCampaigns opened.
campaigns_clickednumberCampaigns with at least one click.
campaigns_bouncednumberCampaigns bounced.
open_ratenumberOpen rate 0–1.
click_through_ratenumberCTR 0–1.
bounce_ratenumberBounce rate 0–1.
opens_but_never_clicksbooleanOpens but never clicks — reads without acting.
computed_atdatetimeyesLast calculated.

Relationships

Inbound (1)
  • Customer[:CAMPAIGN_RESPONDER]Organizationscore, engagement_tier, campaigns_received, campaigns_opened, campaigns_clicked, campaigns_bounced, open_rate, click_through_rate, bounce_rate, opens_but_never_clicks, computed_at