{"id":31059,"date":"2026-11-16T19:00:00","date_gmt":"2026-11-16T18:00:00","guid":{"rendered":"https:\/\/www.web-systems.pl\/store-sales-dashboard-data-metrics-tools\/"},"modified":"2026-11-16T23:35:31","modified_gmt":"2026-11-16T22:35:31","slug":"store-sales-dashboard-data-metrics-tools","status":"publish","type":"post","link":"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/","title":{"rendered":"Store Sales Dashboard: Data, Metrics and Tools"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A store sales dashboard is a handful of agreed numbers from a single source of truth: net sales, number of orders, average order value, returns and traffic sources. The order of work is definitions first, then data, and the tool last. If every Monday you stitch together numbers from your store panel, marketplaces and ads in Excel, and before the holiday season you want to see sales daily in one place, below you will find these three steps in order.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#What_should_a_store_sales_dashboard_show\" >What should a store sales dashboard show?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Definitions_first_what_%E2%80%9Csales%E2%80%9D_means_in_your_company\" >Definitions first: what &#8220;sales&#8221; means in your company<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#What_data_should_an_online_store_sales_report_combine\" >What data should an online store sales report combine?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Three_dashboard_levels_from_the_WooCommerce_panel_to_a_custom_app\" >Three dashboard levels: from the WooCommerce panel to a custom app<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Level_1_the_WooCommerce_Analytics_panel\" >Level 1: the WooCommerce Analytics panel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Level_2_a_Data_Studio_store_dashboard\" >Level 2: a Data Studio store dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Level_3_a_report_in_your_own_system\" >Level 3: a report in your own system<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Comparison_which_level_to_choose\" >Comparison: which level to choose<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Why_do_the_numbers_in_a_dashboard_not_match\" >Why do the numbers in a dashboard not match?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Sales_dashboard_before_the_holiday_season\" >Sales dashboard before the holiday season<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Frequently_asked_questions\" >Frequently asked questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Is_a_sales_dashboard_in_Excel_enough\" >Is a sales dashboard in Excel enough?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#Why_do_sales_in_WooCommerce_differ_from_GA4\" >Why do sales in WooCommerce differ from GA4?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.web-systems.pl\/en\/store-sales-dashboard-data-metrics-tools\/#How_many_metrics_should_go_on_the_first_screen_of_a_business_dashboard\" >How many metrics should go on the first screen of a business dashboard?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_should_a_store_sales_dashboard_show\"><\/span>What should a store sales dashboard show?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The first screen only needs a few metrics, and the rest can go lower down as details. This set works well to start with:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>net sales<\/strong>, meaning revenue after returns and coupons are deducted,<\/li>\n<li>number of orders,<\/li>\n<li><strong>average order value<\/strong>,<\/li>\n<li>returns,<\/li>\n<li>traffic sources and conversions,<\/li>\n<li>ad spend.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">It is best to base your definitions on the <a href=\"https:\/\/woocommerce.com\/document\/woocommerce-analytics\/\" rel=\"nofollow noopener\" target=\"_blank\">WooCommerce Analytics reports documentation<\/a>. Gross Sales is the selling price times quantity, excluding returns, coupons, taxes and shipping. Net Sales is Gross Sales minus returns and coupons. Total Sales goes one step further and adds taxes and shipping. Average Order Value is Net Sales divided by the number of orders. One important detail: a return shows up as a negative value on the day of the return, not on the day the order was placed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Definitions_first_what_%E2%80%9Csales%E2%80%9D_means_in_your_company\"><\/span>Definitions first: what &#8220;sales&#8221; means in your company<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before you build a sales dashboard, settle three things. Do you count net, or with shipping? By order date or by payment date? And what do you do with returns? The store panel, GA4 and accounting will show different numbers. That is normal, since each of them measures something else. The trouble starts when nobody knows which version ended up in the report. So write a short definitions cheat sheet once and pin it to the dashboard. Then everyone reads the numbers the same way.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_data_should_an_online_store_sales_report_combine\"><\/span>What data should an online store sales report combine?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A complete online store sales report pulls data from the store, marketplaces, invoices, traffic and ad costs. In practice, that means five sources:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>orders from WooCommerce,<\/li>\n<li>marketplace orders gathered in one place, for example because a <a href=\"https:\/\/www.web-systems.pl\/en\/woocommerce-baselinker-integration\/\">WooCommerce and BaseLinker integration<\/a> merges them with the store,<\/li>\n<li>invoices from the ERP system,<\/li>\n<li>traffic and conversions from GA4, provided that <a href=\"https:\/\/www.web-systems.pl\/en\/ga4-setup-after-universal-analytics-what-to-check\/\">GA4 setup in your store<\/a> counts purchases correctly,<\/li>\n<li>ad campaign costs.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">They are tied together by a shared key: order number, date and sales channel. Every number needs one source of truth, otherwise you will count the same order twice: once from BaseLinker and once from the store.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Three_dashboard_levels_from_the_WooCommerce_panel_to_a_custom_app\"><\/span>Three dashboard levels: from the WooCommerce panel to a custom app<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You choose the level based on the number of sales channels and how fresh you need the numbers to be.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Level_1_the_WooCommerce_Analytics_panel\"><\/span>Level 1: the WooCommerce Analytics panel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you sell mainly through your own store, the built-in panel is usually enough. It has filters, segmentation, CSV export and a dashboard you can set up around your key metrics.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Level_2_a_Data_Studio_store_dashboard\"><\/span>Level 2: a Data Studio store dashboard<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">With several channels, Data Studio fed by exports or a spreadsheet works well. According to the <a href=\"https:\/\/docs.cloud.google.com\/data-studio\/welcome\" rel=\"nofollow noopener\" target=\"_blank\">Google Data Studio documentation<\/a>, in April 2026 Looker Studio went back to this name, the old address redirects to the new domain, and existing reports do not need to be touched. The tool is free. You bring data in via an export, a spreadsheet, a database or a connector.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Level_3_a_report_in_your_own_system\"><\/span>Level 3: a report in your own system<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When the numbers need to refresh on their own and connect with stock levels, the report moves into a custom application, and data flows into it through <a href=\"https:\/\/www.web-systems.pl\/en\/api-system-integration-store-crm-erp-warehouse\/\">system integration via API<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A sales dashboard in Excel is a good interim stage where it is easy to agree on definitions. With daily refreshes, though, it takes a lot of manual work.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Comparison_which_level_to_choose\"><\/span>Comparison: which level to choose<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The simplest way to choose is by data sources and the time you can realistically spend on maintenance.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr><th><\/th><th>WooCommerce panel<\/th><th>Data Studio<\/th><th>Custom application<\/th><\/tr>\n<\/thead>\n<tbody>\n<tr><td>Data sources<\/td><td>store only<\/td><td>exports, spreadsheets, databases, connectors<\/td><td>all systems via API<\/td><\/tr>\n<tr><td>Refresh<\/td><td>live in the store<\/td><td>depends on how data is fed in<\/td><td>automatic<\/td><\/tr>\n<tr><td>Maintenance work<\/td><td>minimal<\/td><td>regular data updates<\/td><td>maintaining integrations<\/td><\/tr>\n<tr><td>Best for<\/td><td>sales mainly in the store<\/td><td>several channels<\/td><td>many channels and a warehouse<\/td><\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_do_the_numbers_in_a_dashboard_not_match\"><\/span>Why do the numbers in a dashboard not match?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Different definitions, dates and sources are usually to blame. The most common mismatches:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>order date instead of payment date,<\/li>\n<li>returns booked on a different day than the order,<\/li>\n<li>tax and shipping included in Total Sales,<\/li>\n<li>cancelled and unpaid orders,<\/li>\n<li>attribution in GA4 different from the store panel,<\/li>\n<li>different time zones across systems.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Next to every number on the dashboard, note where it comes from and how you calculate it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sales_dashboard_before_the_holiday_season\"><\/span>Sales dashboard before the holiday season<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before the peak, switch to a daily view and a comparison with the same period a year earlier. Already in November, set the date range to the whole season, the interval to daily and the metrics broken down by sales channel. Organic traffic is well complemented by <a href=\"https:\/\/www.web-systems.pl\/en\/google-search-console-reports-to-check-monthly\/\">monthly Search Console reports<\/a>, because they show whether the visibility of seasonal categories is growing.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Start by writing down the definitions, then connect the sources, and only then choose the tool level. A well-built sales dashboard ends the Monday ritual of stitching panels together: one place and the same numbers for everyone, calculated by the same rules.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_asked_questions\"><\/span>Frequently asked questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1794867389102-0\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><span class=\"ez-toc-section\" id=\"Is_a_sales_dashboard_in_Excel_enough\"><\/span>Is a sales dashboard in Excel enough?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>To start with, yes, especially for agreeing on definitions and the layout of metrics. With several channels and a daily view, however, manual copying takes a lot of time and mistakes come easily. At that point Data Studio or a report fed via API works better.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1794867389102-1\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><span class=\"ez-toc-section\" id=\"Why_do_sales_in_WooCommerce_differ_from_GA4\"><\/span>Why do sales in WooCommerce differ from GA4?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Because the two systems count different things at different moments. The store saves orders in its database. GA4 counts events in the browser and assigns them to channels according to its own attribution rules. On top of that come returns, cancellations and blocked tracking scripts.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1794867389102-2\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><span class=\"ez-toc-section\" id=\"How_many_metrics_should_go_on_the_first_screen_of_a_business_dashboard\"><\/span>How many metrics should go on the first screen of a business dashboard?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>A few metrics that answer one question are enough: how are sales going? Put breakdowns by product, category and campaign lower down, so the sales dashboard stays easy to read.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>A store sales dashboard is a handful of agreed numbers from a single source of truth: net sales, number of orders, average order value, returns and traffic sources. The order of work is definitions first, then data, and the tool last. If every Monday you stitch together numbers from your store panel, marketplaces and ads [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":31050,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[812],"tags":[106,2556,948,2559,1637,1190],"class_list":["post-31059","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-e-commerce-en","tag-analytics","tag-dashboard-x2","tag-e-commerce-en","tag-kpi-x2","tag-sales","tag-woocommerce-en"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/posts\/31059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/comments?post=31059"}],"version-history":[{"count":1,"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/posts\/31059\/revisions"}],"predecessor-version":[{"id":31061,"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/posts\/31059\/revisions\/31061"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/media\/31050"}],"wp:attachment":[{"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/media?parent=31059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/categories?post=31059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.web-systems.pl\/en\/wp-json\/wp\/v2\/tags?post=31059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}