All cookbooks
By company typePostgreSQL or MongoDBExample: ShopNova

E-commerce / D2C retail

Connect retail data, build five dashboards, and ask revenue, marketing, and support questions — modeled on a D2C brand like ShopNova.

Dashboards

5 to build

Output

Dashboard + chat

Teams

Leadership, Marketing

Vizkraft — E-commerce / D2C retail

Shown in preview

Works with

Pick whichever connector your team already uses.

PostgreSQLMongoDBSnowflakeSupabase

What it does

Turns scattered retail data — orders, campaigns, web events, inventory, and support — into executive, marketing, and CX dashboards you can explore in natural language. Built for D2C teams who need revenue, ROAS, and funnel answers without waiting on SQL.

How it works

  1. 1

    Connect your database

    Add a PostgreSQL or MongoDB connector and index the tables that power revenue, campaigns, and customer activity.

  2. 2

    Mark the tables that matter

    Flag orders, campaigns, web events, customers, support tickets, and inventory during indexing so Vizkraft prioritizes the right schema.

  3. 3

    Ask your first question

    Try something like "What is total revenue year to date by region?" and save charts you want to keep.

  4. 4

    Build the five dashboards

    Assemble executive overview, campaign performance, marketing funnel, support & CX, and inventory views from saved charts.

Dashboards to build

Executive overview

Revenue, orders, and conversion KPIs at a glance.

Campaign performance

Spend, ROAS, and channel mix by campaign.

Marketing funnel

Sessions to purchase with drop-off by step.

Support & CX

Ticket volume, CSAT, and resolution trends.

Inventory & fulfillment

Stock health and movement by warehouse.

Questions to try

  • What is total revenue year to date by region?
  • Compare conversion rate by campaign for the last 90 days.
  • Show support ticket volume by priority this month.

Setup

  • Connect PostgreSQL or MongoDB with read access to your retail schema.
  • Index and mark orders, campaigns, web events, customers, support tickets, and inventory.
  • Save charts from chat and add them to dashboards with filters or saved views.

Stop waiting on engineering for reports.

Most of our customers were ops or CS leads who'd been blocked for weeks. They booked a demo, connected their database in 10 minutes, and never looked back.