Marketing CRMMarketing
EmailCampaign
Email campaign — manual or workflow-triggered. Tracks send/open/click/bounce funnel per customer.
15 fields8 relationships
Fields
| Name | Type | Req | Description |
|---|---|---|---|
| id | uuid | yes | Campaign UUID. |
| name | string | yes | Internal campaign name. |
| subject | string | no | Email subject. |
| status | enum | no | draft | scheduled | sending | sent | cancelled. |
| type | enum | no | manual | automated. |
| is_automated | boolean | no | Workflow-triggered. |
| sent_at | datetime | no | Dispatched. |
| created_at | datetime | yes | Created. |
| org_id | uuid | yes | Owning organisation. |
| send_count | number | no | Total recipients. |
| open_count | number | no | Total opens. |
| click_count | number | no | Total clicks. |
| bounce_count | number | no | Total bounces. |
| open_rate | number | no | Open rate 0–1. |
| click_rate | number | no | Click rate 0–1. |
Relationships
Outbound (6)
- EmailCampaign[:BELONGS_TO]→Organization
- EmailCampaign[:TARGETS_SEGMENT]→Segment
- EmailCampaign[:DROVE_REVENUE]→Venueattributed_bookings, attributed_covers, attributed_revenue_pennies, conversion_rate, computed_at — AI computed
- EmailCampaign[:CAMPAIGN_DROVE_WIFI]→Venuerecipients_who_visited, wifi_sessions_generated, foot_traffic_rate, computed_at — AI computed
- EmailCampaign[:MARKETING_REACTIVATION]→Organizationreactivated_customers, reactivation_sessions, reactivation_rate, computed_at — AI computed
- EmailCampaign[:CAMPAIGN_REVIEW_IMPACT]→Organizationreviews_generated, unique_reviewers, avg_rating, avg_sentiment, review_rate, computed_at — AI computed
Related entities
OrganizationGraph AI Engine
Top-level organisation node. Supports franchise and group hierarchies via :PARENT_OF. Every piece of data in the platform is scoped to an organisation.SegmentMarketing CRM
Audience segment for targeting campaigns. Dynamic (graph-driven) or static (fixed list).WorkflowMarketing CRM
Automated marketing journey triggered by behaviour events. Sends email or SMS at intervals/conditions.BookingBookings
A table reservation or walk-in visit. Central hub connecting customers to venues, orders, threads, upgrades, and events.VenueGraph AI Engine
A physical location operated by an organisation. Every activity node — bookings, Wi-Fi sessions, orders, reviews — links back to a venue via the :AT_VENUE relationship.