7 Free Small Business Dashboard Templates (Data Studio, Google Sheets)

What is a small business dashboard?

A small business dashboard shows what you sold, what you spent, and where your customers came from. It brings together store sales, accounting data, and customer activity from Google Business Profile. Measuring your Google Business Profile activity can be difficult: in the example below, GA4 can’t identify the source of two-thirds of Windsor.ai’s sign-ups.

Build your dashboard in Data Studio or Google Sheets. Windsor.ai connects data from WooCommerce, QuickBooks, Google Business Profile, and other sources, so you don’t need manual CSV exports. Owners can check performance each week, while bookkeepers and agencies can use the same data to report to them.

Which small business dashboard template to pick

The table lists all 7 free templates in this gallery. Some template titles still mention Looker Studio, Data Studio’s previous name.

Small business dashboard example: which channels bring active users

This example uses Windsor.ai’s own GA4 property for Q3 2026 (1 July to 30 September). It shows where customers come from, for two steps: signing up and adding a first data source, Windsor.ai’s equivalent of a first order or booking.

Step 1: Connect GA4. Sign in at onboard.windsor.ai, choose the GA4 connector, and authorize your property.

Step 2: Pull the channel fields. In the data preview, set the date range to the quarter and select the fields in the table.

Step 3: Compare the shares. Divide each channel’s sessions and key events by the totals. In Windsor.ai, the conversions field holds GA4’s key events. Engagement rate is engaged sessions divided by sessions.

GA4 couldn’t assign a channel to 66.4% of sign-ups, so it grouped them under Unassigned. All of these sign-ups were recorded on onboard.windsor.ai, the sign-up subdomain. Unassigned sessions had a 4.7% engagement rate, much lower than any other channel. A separate sign-up or checkout domain can disrupt attribution, as can events sent directly from a server, so both are worth checking.

The first data source is a clearer indicator of which channels bring users who take action: Only 5.3% are classified as Unassigned. Direct drove 50.3% of first data sources from 37.0% of sessions, making it a stronger source of active users than its session share suggests. AI Assistant showed a similar pattern, accounting for 15.8% of first data sources from 8.6% of sessions. Organic search showed the opposite pattern, contributing 10.6% of first data sources from 21.0% of sessions.

Before comparing channels in your dashboard, check how many of each key event GA4 classifies as Unassigned. If you run an online store, use the WooCommerce template’s Orders Via chart to break down orders by channel and cross-check the results against GA4.

What KPIs does a small business dashboard track?

Choose the KPIs that match how you sell. Windsor.ai pulls the fields for each one from your store, payment, accounting, or Business Profile account.

• Revenue: the total of all sales in the period, from your store, your card reader, or QuickBooks.
• Profit margin: profit divided by revenue.
• Average order value: revenue divided by the number of orders.
• Conversion rate: orders divided by sessions in GA4, or by product views on BigCommerce.
• Returning customer share: revenue from returning customers divided by all revenue.
• Refund rate: refunds divided by total sales.
• Transaction decline rate: declined card transactions divided by all attempted transactions.
• Profile action rate: calls, direction requests, and website clicks divided by Business Profile views.

What to include in a small business report

Find out what sold, what it cost, and which channels brought in customers. Compare the results with last month to spot changes.

Split the data by six fields:

• product or category
• sales channel (online store, card reader, marketplace)
• traffic channel, from GA4 or WooCommerce order records
• customer type (new or returning)
• expense category
• location, for businesses with more than one shop or office

A shop owner’s monthly report brings key business metrics together in one place. Start with revenue, profit margin, and average order value compared with last month. Follow with sales by product and channel. Finish with QuickBooks expenses by category and Google Business Profile data on calls and direction requests for each location.

Browse the full template gallery for dashboards by platform and destination, or see the WooCommerce templates for more store reports. How to use Windsor.ai for e-commerce shows how to ask an AI assistant which products and channels bring sales.