Skip to main content
DataDoe HubHub
(opens in a new tab)
ChatGPT (opens in a new tab)
Claude (opens in a new tab)

Building a Profit Report Website with Codex Sites and DataDoe MCP

Codex Sites (opens in a new tab) is an OpenAI plugin that builds, saves, and deploys hosted websites directly from a prompt — no separate deployment workflow needed. Combined with DataDoe MCP (opens in a new tab), you can generate a live business dashboard powered by real Amazon seller data without writing a single line of code.

This tutorial walks through building a profit report website for a Delto UK seller. You will write one prompt, let Codex generate and deploy the site, and end up with a polished, hosted analytics page that reads live data from DataDoe.

What you will build

By the end of this tutorial, you will have a deployed website that shows:

  • KPI tiles for the last 7 days: profit, total sales, units sold, ACOS, TACOS, and ROI
  • A daily profit and cost breakdown table grouped by SKU and child ASIN
  • A top 5 most profitable products section for the same period

Prerequisites

Step 1: Add the Sites plugin

  1. Open the Codex app (opens in a new tab).
  2. Click Plugins in the sidebar.
  3. Find Sites and click to add it.
  4. Start a new thread — plugins only take effect in threads created after installation.

Step 2: Confirm DataDoe MCP is connected

Before running the Sites prompt, make sure DataDoe MCP is configured for Codex. Your ~/.codex/config.toml (global) or .codex/config.toml (project-scoped) should contain:

toml
1[mcp_servers.datadoe]
2url = "https://mcp.datadoe.com/mcp/v1"
3http_headers = { "datadoe-mcp-key" = "YOUR_API_KEY" }
4startup_timeout_sec = 30

Replace YOUR_API_KEY with your DataDoe MCP key. If you haven't done this yet, follow the Using Codex with DataDoe MCP (opens in a new tab) guide first.

Step 3: Paste the prompt and start the task

In your new Codex thread, paste the prompt below. The @Sites mention at the top activates the Sites plugin so Codex knows to build and host a website.

@Sites

Create a website for Delto UK seller using DataDoe data.

Note:
- Build this as a website, not a single-page application
- Keep the structure simple and easy to maintain for a non-technical business user

Data source:
- Use DataDoe
- Use the table: Profit by SKU & Date
- Seller: Delto UK seller
- Time period: last 7 days

Business goal:
Create a profit report website for Delto UK that helps the user understand daily profitability and cost structure.

What the website should show:
- Daily profit and cost breakdown per SKU and child ASIN
- Base calculations on shipped orders, settlement fees, COGS, and ads spend
- Show data for the last 7 days only
- Show top 5 most profitable products for the same period

KPI section:
- Use aesthetic KPI tiles consistent with the current design system
- KPI tiles should use metrics from Profit by SKU & Date
- Use the relevant columns such as:
  - child_asin
  - sku
  - profit
  - total_cost
  - acos
  - tacos
  - roi
  - total_sales
  - total_units_sold
  - total_items
- Choose a sensible executive KPI set for the top section, focused on profitability and business performance for the 7-day period
- KPI values should be visually prominent and easy to scan
- If comparison logic is useful, keep it subtle and business-friendly

Main report content:
- Show a daily profit and cost breakdown table grouped clearly by day and product identity
- Make SKU and child ASIN easy to find
- Surface profit, sales, units, items, total cost, ACOS, TACOS, and ROI in a way that is easy for a business user to scan
- Keep numeric columns aligned and readable
- Make the report feel operational and decision-oriented, not technical

Top products section:
- Display top 5 products that are most profitable in the last 7 days for Delto UK seller
- Rank them by profit descending
- Make the section easy to compare at a glance

Design rules:
- Calm, light, data-first business dashboard aesthetic
- Clean, restrained, and professional
- Premium through spacing and typography, not decoration
- Bright neutral background
- White cards and white table surfaces
- Soft gray borders and dividers
- Dark navy text for primary content
- Blue-gray text for secondary labels
- One disciplined blue accent for emphasis
- Green only for positive performance states
- Red only for negative performance states
- Minimal shadows
- Rounded corners, but not overly soft
- Strong visual hierarchy for metrics and important numbers
- Tables should feel highly scannable and structured
- Numeric columns should align cleanly
- Hover states should be subtle
- The website should feel like an internal analytics workspace, not a marketing page

What to avoid:
- Flashy gradients
- Glass or frosted effects
- Heavy shadows
- Orange-led interface
- Dark-mode-first styling
- Playful decoration
- Generic dashboard filler
- Unnecessary copy
- Over-complicated interactions

Content scope:
- Keep the website focused only on the profit reporting use case
- Do not add marketing sections, navigation clutter, onboarding text, or generic dashboard filler
- Use clear business language and concise labels

Behavior:
- Use the latest available data for the last 7 days
- If live data is temporarily unavailable, still prepare the website so real DataDoe data can be connected later without redesigning the layout

Output:
- Deliver a complete ready-to-use website page for this profit report
- Keep it polished, practical, and easy for a non-technical user to maintain

Step 4: Review the build

Codex reads the prompt, calls DataDoe MCP to understand the available data, and generates the website code. While it works, you can follow along in the thread.

Once Codex finishes building:

  1. Open the Review pane in Codex to inspect the generated source changes.
  2. Confirm the build succeeded and the layout matches what you expected.
  3. If you want to review before going live, ask Codex to save a version first:
Save a version for review without deploying yet.

Step 5: Deploy the site

When you are happy with the build, tell Codex to deploy it:

Deploy the approved version.

Note: Codex may guide you through the deployment flow automatically after the build is complete — in that case you do not need to paste the command above. Follow the prompts in the thread and confirm when asked.

Codex publishes the saved version and returns a production URL. Every Sites deployment URL is live immediately — share it directly with your team.

Result

The deployed site shows live DataDoe data: KPI tiles at the top, a day-by-day profit and cost breakdown table, and a ranked top 5 products section — all pulled from the Profit by SKU & Date table for the last 7 days.

To adapt this for another seller or time period, open a new Codex thread and adjust the Seller and Time period fields in the prompt. The rest of the design and structure stays the same.

Related resources

DataDoe MCP resources

Check the following resources for more information: