How to Create Custom Charts and Reports in BigCommerce with ChartsyAI
ChartsyAI lets BigCommerce store owners ask questions in plain English - such as sales trends, customer behavior, or product performance - and instantly turn their BigCommerce data into charts, tables, and dashboards without SQL or manual reports.
Get the Most Out of Your AI-Powered Dashboard Builder
ChartsyAI for BigCommerce helps you analyze store performance faster by turning natural-language questions into visual insights. Instead of building reports manually in BigCommerce or exporting data to spreadsheets, you can simply ask ChartsyAI what you want to know.
In seconds, ChartsyAI visualizes:
- Sales and revenue trends
- Customer behavior
- Product performance
- Discounts and promotions
- Order and fulfillment insights
1. What Are Prompts in ChartsyAI?
Prompts are short, natural-language questions or instructions you give to ChartsyAI to analyze your BigCommerce data.
You don't need technical skills - just ask questions the same way you'd ask a data analyst.
Example Prompts for BigCommerce
- "Show me total sales by month for the current year."
- "Who are my top 10 customers by revenue in the last 90 days?"
- "Display my best-selling products this month."
- "What is my average order value by month?"
- "Show orders by status for last quarter."
ChartsyAI understands your intent and generates an interactive chart instantly.
2. Start by Typing Your Prompt
In the input field labeled: "Ask me anything about your data...", type your question.
You can also start with ready-to-use prompts, such as:
- Show me sales by month for the current year
- Show me my best-selling products this month
- Who are my top 10 customers by revenue?
- What are the best performing discount codes?
- Show orders by status for last 30 days
These templates help you learn how to structure effective prompts.
3. Good Prompt Formula (BigCommerce-Friendly)
A clear prompt helps ChartsyAI return accurate results.
Prompt Formula
Show [metric] [time period] [specifics]
Example
Show me my top 10 customers by revenue last quarter as a bar chart
More BigCommerce Examples
- Show average order value by month this year
- Show revenue by product category last 30 days
- Show number of orders by country this month
- Show returning vs new customers by month
4. Click "Visualize"
Once your prompt is ready, click Visualize.
ChartsyAI will:
- Analyze your BigCommerce data
- Apply the right filters and metrics
- Generate a chart or table automatically
This replaces manual reporting and repetitive dashboard setup.
5. Explore Suggested Visualizations
After your chart is generated, ChartsyAI automatically suggests the best visualization types for your data, such as:
- Line charts (trends over time)
- Bar charts (comparisons)
- Tables (detailed breakdowns)
- Pie charts (distribution)
- KPI cards (key metrics)
- Treemaps and bubble charts (advanced insights)
You can switch between visualization types instantly to find what works best.
6. Use "Try Next" Suggestions
When you’re not sure what to analyze next, Chartsy shows a Try next panel with smart suggestions based on your recent BigCommerce data.
Examples of Try next suggestions you might see:
- Analyze repeat customers vs one-time buyers for the last 90 days
- Compare revenue from your top 5 product categories this month
- Find products with rising refund rates in the last 60 days
- Look at customers with declining order frequency compared to last quarter
Clicking a suggestion will pre-fill a prompt and run the analysis for you. You can then refine it with follow-up questions, just like any other ChartsyAI query.
Try next turns analytics into a guided workflow, so you’re never stuck wondering what to look at next in your BigCommerce data.
6. Save Charts to Your Dashboard
When you're happy with the result, click Save.
Your chart will:
- Appear on your dashboard
- Update automatically as new BigCommerce data syncs
- Be available anytime for tracking and reporting
This allows you to build custom BigCommerce dashboards without predefined limits.
7. What If No Data Appears?
Sometimes ChartsyAI may return No Data Found. This doesn't mean something is broken - usually the query needs adjustment.
| Issue | Example | Fix | Explanation |
|---|---|---|---|
| Time period too narrow | Show revenue for January 2025 | Show revenue for Q4 2024 | Data may not exist yet |
| Too many filters | Show Enterprise customers over $10k in December | Show customers from Q4 | Query is too restrictive |
| Unclear metric | Show customer churn | Show cancellations by month | Use clearer BigCommerce terms |
8. "Fuzzy Prompt" Message Explained
If your question is too vague, ChartsyAI may display:
"This prompt's a bit fuzzy - try these quick improvements."
Use the tips below to refine your prompt.
| Improve | Before | After | Examples |
|---|---|---|---|
| Add dates | Show revenue | Show revenue last month | last 30 days, Q1 2024 |
| Be specific | Show customers | Show top 10 customers | top, new, returning |
| Use metrics | Show orders | Show orders by revenue | by revenue, by count |
| Specify charts | Show sales last quarter | Show sales last quarter as a bar chart | bar, line, pie |
9. Popular BigCommerce Questions You Can Ask ChartsyAI
These are high-intent queries BigCommerce users commonly ask:
- How much revenue did my store generate last month?
- What are my best-selling products by revenue?
- Which customers have the highest lifetime value?
- What discount codes generate the most sales?
- How many orders were refunded last quarter?
- What is my average order value over time?
- Which products have declining sales?
- How do new vs returning customers compare?
Why Use ChartsyAI for BigCommerce Analytics?
- No predefined dashboards
- No SQL or manual exports
- Ask new questions anytime
- Visualize BigCommerce data instantly
- Build dashboards that evolve with your business
ChartsyAI gives you the flexibility to communicate directly with your data, not just look at static reports.
What's Next?
Now that you know how to use ChartsyAI with your BigCommerce store, you can:
- Explore your store's performance metrics
- Identify trends and opportunities
- Make data-driven decisions for your business
- Share insights with your team
For more help, check out our Getting Started with Chartsy on BigCommerce guide or visit the Help Center.
