DATA_SOURCE: duckdb - Ecommerce platform — customers, orders, products, inventory, and marketing. DuckDB backend. Run `python seed.py` to initialise.
CONTEXT: marketing - Campaign performance, spend tracking, and customer acquisition. Covers email and social campaigns with full attribution data. (v1.0)
DATASET: main - Primary ecommerce schema
TABLES:
main.campaigns|Marketing campaigns. channel is 'email' or 'social'. budget is the planned spend; spend is the actual spend to date. active=FALSE means the campaign has ended.|id:I[PK]|name:S|channel:S|budget:N|spend:N|start_date:D|end_date:D|active:B
main.campaign_conversions|One row per customer conversion attributed to a campaign. revenue is the order value attributed to this conversion. FK: campaign_id → campaigns.id, customer_id → customers.id.|id:I[PK]|campaign_id:I|customer_id:I|converted_at:TS|revenue:N
main.customers|Customer data used for acquisition analysis. Join on customer_id to get signup_date, city, and lifetime_value.|id:I[PK]|name:S|email:S|phone:S|city:S|country:S|signup_date:D|active:B|lifetime_value:N