Skip to main content

Custom Service. Build Your Own Analytics.

Build your own Amazon analytics app, on Nova data.

Accurate Nova data refreshed hourly, shipped through Lovable. Built in minutes. Your design, your workflows, your domain.

See Prompt
Nova
+
LovableLovable
=
Build your own app

Your Amazon Workflow

Your Amazon workflows. Your design system. Your domain. Your call.

  • Use cases. Alerting system, Inventory Planner, Internal Agency App.
  • Design system. Type, color, motion, density.
  • Domain. Host on dashboard.yourbrand.com.
  • Components. Charts, tables, alerts, embeds.
See Prompt
dashboard.yourbrand.com
Custom Amazon analytics dashboard with pastel serif design, built in Lovable on Nova data

Built in Lovable on Nova data. One of countless looks.

How it works

From your seller data to a dashboard built around your team.

Hourly Amazon data on one side, your custom analytics app on the other. Here is what happens in between.

01

Connect Amazon APIs to Nova

Give us access to your data in a few clicks.

Seller CentralAdvertising
Nova
Connect API
02

We provision your database

We spin up your dedicated ClickHouse database with host, ID and password, ready to query.

NovaClickHousehost · ID · password
Handled by Nova
03

Plug into Lovable

Drop your credentials into Lovable so it builds with full context of your Nova data.

host · ID · passwordLovableLovable
Open Lovable
04

Prompt your way in

Prompt your way into custom analytics. Dashboards, client portals, internal tools.

LovableLovable
See Prompt

Requires a Lovable account. Free to start, paid plans at lovable.dev.

Hourly refresh. 21 marketplaces.

Starter prompt

Copy this prompt. Paste into Lovable. Ship your dashboard.

It asks for your site URL and app name, walks you through the ClickHouse secrets, then builds a starter dashboard wired to nova_share.product_metrics.

Heads up: to get started, Nova needs to fetch your Amazon data through Amazon's API. Connect your seller account in a few clicks.

Connect Amazon API
starter-prompt.md
Build an Amazon seller analytics app connected to Nova Data Share.

## Step 1 — Ask me these questions before doing anything else

Ask me the following in one message, then wait for my answers:

1. What is your company website URL?
   (I will copy your brand colors, fonts, and logo from it)

2. What should the app be called?

## Step 2 — Secrets setup

Before writing any code, prompt me to fill in the following secrets via the "Update secrets" panel:

- CLICKHOUSE_HOST
- CLICKHOUSE_USER
- CLICKHOUSE_PASSWORD
- CLICKHOUSE_DATABASE

These will be used server-side only. Never expose them in the frontend.

Important: warn the user that CLICKHOUSE_USER must be kept exactly as provided, including the mysql4qjne6q9i1y_ prefix. The connection will fail without it.

## Step 3 — Design

Scrape the website URL I provided and extract the visual identity: colors, fonts, logo, and overall aesthetic. Apply it consistently across the entire app so it feels like my own branded product.

## Step 4 — Starter dashboard

Build a first dashboard as a starting point with:

### KPI cards (top row, last 30 days)
- Total revenue (product_sales)
- Net profit (net_profit)
- Units sold (units)
- TACOS (ppc_spend / product_sales * 100)
- Return rate (returned_units / units * 100)

### Charts
- Daily trend: product_sales + net_profit + ppc_spend (line chart)
- Revenue by marketplace: grouped bar chart (marketplace_name)
- Top 20 ASINs by net_profit: sortable table with columns: child_asin, units, product_sales, ppc_spend, ACOS, margin %

### Filters
- Date range picker (default: last 30 days)
- Marketplace selector (multi-select)
- FBA / FBM / All toggle (is_fbm)

## Database schema reference — consult this before building any feature

Connection:
- Protocol: MySQL wire, port 3306, SSL required
- One table: nova_share.product_metrics
- Grain: one row per seller x marketplace x child ASIN x SKU x day
- Data refreshes every hour from Nova's pipeline
- Always filter on metric_date. Never run unfiltered queries
- Always GROUP BY

Heads up: keep CLICKHOUSE_USER exactly as provided, including the mysql4qjne6q9i1y_ prefix. The connection fails without it.

What you get

Every Amazon metric Nova tracks, in your hands.

Start from 200+ reconciled KPIs across 21 marketplaces, refreshed hourly down to SKU grain. Layer on your design, your workflows, your logic. Ship the surface your team will actually open.

// available data
live · hourly
14data domains
200+KPIs
21marketplaces
1hrefresh cadence
01Net Profit at SKU level· financials
02Orders· growth
03PPC Keywords & Campaigns· ppc
04FBA Inventory· inventory
05Fees· financials
06Search Terms· growth
07Listings· catalog
08Returns· operations
09COGS· financials
10Settlements· financials
11Sessions· traffic
12Buy Box· growth
13BSR· growth
14Subscribe & Save· growth

Three rules

01

We build for the builders.

No black boxes, no consulting retainers. The pipeline is ours. The app is yours.

“You bring the taste. We bring the truth.”
02

No maintenance.

We handle accuracy and freshness across 21 marketplaces. You focus on what you ship.

03

Endless possibility.

Internal tools, client portals, white-label dashboards. If you can prompt it, you can ship it.

Same hourly data behind every surface. Infinite ways to express it.

Real-life use cases

What teams actually ship.

Five patterns we see every week. Yours can look like anything.

For finance teams

Custom P&L dashboard

Per-marketplace P&L with your COGS model, your overhead allocation, your FX rules. The CFO-friendly view your finance team will actually open every morning.

  • SKU-level margin with custom COGS
  • Overhead allocation rules you control
  • Multi-currency with your FX policy
  • Board-ready monthly exports
Net profit
$184k
Margin
22.4%
ACoS
14.1%

For ops & supply chain

Inventory Planner

Days-of-cover by SKU with your lead times, MOQs, and seasonality. The reorder list your buyer opens every Monday.

  • SKU-level days-of-cover
  • Seasonality-aware reorder dates
  • Slack push when stock-out risk rises
Reorder watchlist23 SKUs at risk
ACM-001
9dReorder
ACM-014
21dReorder
NMB-203
47dOK
HBR-088
112dOverstock

For founders & GMs

Business Targets & Forecast

Set monthly revenue, margin, and ad-spend targets. Track pace versus plan with a forecast you actually trust.

  • Monthly targets per marketplace
  • Pace-to-plan gauges
  • Rolling 12-week forecast
  • Variance alerts when off-pace
78%to plan
Actual vs plan
Actual Plan

For Amazon agencies

White-label client reporting

Ship a branded client portal in days. Your logo, your colors, your domain. Each client sees only their own seller accounts.

  • Your brand, your domain
  • Scoped logins per client
  • Multi-client account switcher
  • Automated weekly summary emails
Your Agency
clients.youragency.com
Acme Brand
$48.2k+12%
Nimbus Goods
$31.7k+8%
Harbor Co.
$22.4k+4%
Kestrel Labs
$18.9k+19%

For everyone on the team

Alerting System

Programmable alerts on any of Nova's 200+ KPIs. Slack, email, or webhook the second something breaks.

  • Threshold or anomaly-based
  • Routing to Slack, email, or webhook
  • Quiet hours and dedup rules
  • Built-in templates for BSR, buy box, ACoS
BSR drop on B07ABCDE
Rank 412 to 1,892
2m ago
ACoS over target on EU
Target 18%, actual 24%
14m ago
Buy box recovered on B08XYZ
Now 96% share
1h ago
Slack delivered#nova-alerts
See Prompt
Live connection, zero sync

How the connection works, and why it's super powerful

Four secrets. One pipe. Your ClickHouse stays where it is, your app stays yours, and the data is live, not synced.

Your warehouse
Your ClickHouse
Self-hosted or ClickHouse Cloud
USUKDEFRJP+16
Add secrets
CLICKHOUSE_HOST
xxxxx.eu-central-1.aws.clickhouse.cloud
CLICKHOUSE_USER
nova_share_user
CLICKHOUSE_PASSWORD
••••••••••••••••
CLICKHOUSE_DB
nova_share
Live in your app
Revenue+18.4%
Your custom app
Charts query ClickHouse in real time
Zero data movement
Your warehouse stays yours. Nova reads, never copies.
Live queries, no cache
Every chart hits ClickHouse in milliseconds.
One source of truth
Same numbers in Nova, your BI tool, and your custom app.
Switch off anytime
Revoke the credential, the connection dies. No vendor lock.

Frequently Asked Questions

Everything teams ask before building on Nova and Lovable

A custom service that pairs Nova Data Warehouses with Lovable. You ship your own Amazon analytics app, with your design, your workflows and your brand, on accurate Nova data refreshed hourly.
Hourly refresh across 200+ KPIs and 21 marketplaces. Same reconciled, SKU-level numbers as your Nova dashboard, with no drift between the two surfaces.
You do. Lovable projects are yours, exportable to GitHub, deployable anywhere. Nova handles the data pipeline. You handle the app surface.
Yes. Lovable lets you publish to a custom domain like dashboard.yourbrand.com on day one. Bring your own SSL, your own DNS, your own brand.
Yes. Use Lovable's built-in auth or your own provider, scope users to specific seller accounts via Nova's row-level filters.
No. Lovable builds React apps from prompts. Our prompt gallery covers the most common Amazon analytics patterns: P&L command center, PPC waste finder, BSR movers, returns root-cause.
Minutes, not weeks. Most prompt-gallery dashboards ship in minutes, and richer multi-page apps in a day.
Nova Data Warehouses pricing scales with marketplaces and refresh cadence. Lovable bills you directly for the app side. Book a demo and we will quote both.

Ready to ship your own Amazon analytics app?

We handle the data. You build. Live on your own domain in minutes.

See Prompt