Shopify’s analytics dashboards help you understand customer purchasing patterns and uncover insights that support data-driven marketing. A typical Shopify dashboard tracks business performance across a range of KPIs, including sales, orders, refunds, and more.
At Vidi Corp, we took this a step further by building our own set of custom Shopify KPI dashboards in Power BI. These dashboards reveal unique insights into your customers’ behaviour, such as:
We’re now offering our custom Shopify dashboard template for free to every e-commerce store. In this guide, we’ll walk you through the kinds of decisions you can make using our dashboards and how to get the most value from them. Let’s dive in! make based on our dashboards and how to make the most out of them. Let’s jump straight into it!
When you hear “Shopify analytics dashboard,” what comes to mind? For most people, it’s the default analytics reports available in Shopify’s reporting section.
Here’s a helpful way to frame it: Shopify is constantly capturing signals, traffic patterns, product views, conversion rates, sales by channel, returning-customer share, average order value, and more. Their native dashboards compile these signals and let you break them down by time period, channel, device, or customer behaviour.
While the data in Shopify’s default dashboards is valuable, the way it’s presented is limited and often doesn’t tell the full story. Our Shopify reporting template in Power BI solves this by making it easy to build custom analytics tailored to your business.
To keep expectations grounded, it’s important to clarify what Shopify dashboards don’t include. Shopify focuses on ecommerce activity within your store, not the wider marketing funnel across your ad platforms, awareness channels, or upper-funnel efforts. If you’d like to integrate your marketing data into the Shopify dashboard, our ecommerce analytics consultants can help you do exactly that.
Our Power BI template includes four core Shopify analytics dashboards:
The Shopify Sales Dashboard helps brand owners track sales performance over time and spot key patterns in their store’s activity. It highlights core sales metrics such as Gross Sales, Discounts, Shipping Charges, Sales Tax, AOV, and units sold.
The line chart at the top displays whichever metric you select—by day, week, or month. Users can choose from KPIs like number of customers, gross sales, COGS, gross profit margin, orders, AOV, and units sold. You can also switch between monthly, weekly, and daily views.
The table below breaks down sales by product, including the number of units sold. Users can expand any product to see performance by variant.
The map provides a visual view of gross sales by billing address. Clicking on any state filters all other visuals on the dashboard to that location.
Finally, the table in the bottom right shows the number of orders by discount code, making it easy to analyze the effectiveness of your promotions
The Shopify Order Time Dashboard shows when people buy. It breaks down sales, AOV, and customer counts by weekday and hour, helping you spot clear patterns in shopping behaviour.
A toggle at the top lets you switch the metric displayed across all visuals—AOV, number of customers, or gross sales.
The histogram in the top-right shows the selected metric by weekday. In the example above, Monday and Friday stand out as the strongest days, suggesting customers are more likely to shop at the beginning and end of the workweek. Insights like this can help you plan the timing of marketing emails.
The histogram below displays the metric by hour of the day, revealing when customers tend to shop. This can help you schedule your Facebook Ads to hit during peak activity times.
A heatmap-style table on the right combines both weekday and hour. Each cell shows the value for the selected metric, with darker shades highlighting stronger performance. At a glance, you can identify:
The Shopify Customers Dashboard provides in-depth insights into customer behaviour, showing how often customers return, how much they spend over their lifetime, and how their lifetime value (LTV) grows over time. It’s one of the richest parts of our Shopify analytics template.
The dashboard begins by analyzing the number of new versus returning customers, their associated sales, and AOV.
The line chart below tracks the percentage of returning customers by month, helping you monitor how effectively new customers are being converted into repeat buyers.
It also gives insight into the average number of orders per customer. For example, you on the screenshot above you can see that 47k customers placed only one order, while 13k placed two orders, and so on.
The bar chart on the right shows how many days it takes for customers to make their second, third, and subsequent orders. You can use this analysis to plan your customer reactivation campaigns on social media and email.
The dashboard then focuses on customer lifetime value. A line chart on the right tracks how the average LTV grows over the years. This information is essential for planning your customer acquisition costs and ensuring that LTV exceeds acquisition cost.
At the bottom, a cohort analysis table groups customers by their first order month and tracks how their average LTV grows over time. This helps you understand how long it takes to become profitable for each customer cohort. For example:
Finally, another table shows average customer LTV by state. This lets you identify markets where customers have above-average LTV, enabling you to target these regions and maximize long-term returns on your marketing investment.
The Shopify Product Dashboard lets you analyze the performance of every product in your store. It tracks reorder rates, product profitability, and sales over time, and also shows which products are frequently purchased together.
The table at the top displays how many customers bought each product, the percentage of those customers who reordered it, and the average number of days between orders. This information can help you design new product strategies. For example, if a product is frequently reordered, you could encourage customers to buy multiple items at once, increasing your AOV or offer your customers to buy the same product in your reactivation campaigns.
Clicking on any product in the table filters the line chart below, allowing you to see monthly orders for that specific product. This makes it easy to track trends and seasonal demand.
Finally, the table at the bottom shows product pairs that are often bought together. You can use this insight to plan targeted marketing campaigns, design product bundles, and promote them to website visitors—helping boost average order value and overall sales.
As you can see, our Shopify Analytics Dashboard provides a wealth of valuable insights. However, the numbers alone sometimes lack context. For instance, as a business owner, you need to compare customer lifetime value (LTV) with customer acquisition costs to make informed decisions.
To address this, we highly recommend connecting your marketing data from sources like Facebook Ads, Google Ads, and Google Analytics to our Shopify dashboard template. This integration provides deeper context on your marketing performance and gives you a complete view of your marketing funnel.
Our marketing analytics consultants have extensive experience working with these data sources. We’ve delivered similar analyses for over 600 companies, including Teleperformance and DS Smith. Reach out today to discuss your marketing analytics needs—we’d be excited to bring our expertise to your project.
The template is available to download for free.
To connect your data, you need to start your free trial for the Vidi Corp Shopify Power BI connector. This connector automates the data extraction from Shopify into Power BI and transforms it to an easy format for analysis.
Once connected, all the views graphs above will be populated with your live data.
