Your data is scattered: GA4 on one side, Facebook on another, sales in an Excel file, WhatsApp requests in a notebook. Every Monday you lose an hour gathering numbers instead of deciding. Looker Studio, Google free tool, solves this. It brings all your sources into a single visual dashboard, updated automatically, that the whole team can consult.
This guide shows how to build a useful dashboard for a Senegalese SME: connect the right sources, choose relevant KPIs, share the dashboard and above all set up a review ritual that turns numbers into decisions.
Why Looker Studio rather than Excel
Excel is excellent for calculating, but poor for tracking living indicators. Looker Studio connects directly to your data sources and updates itself. You open the dashboard and the numbers are current, with no copy paste.
The concrete advantages
Looker Studio is free, with no limit on dashboards. It connects natively to GA4, Google Sheets, Google Ads and Search Console. It produces clear charts even a non technical director understands. And it is shared by a simple link, like a Google document. For an SME, it is the ideal management tool with no investment.
Step 1: define the questions before building
The classic mistake is to dive into the tool and stack up charts. Start with the questions your dashboard must answer. How many prospects this month? Where do they come from? Which channel costs least per contact? What is the three month trend?
A good dashboard answers five or six essential questions, no more. Everything else is noise that diverts attention.
Step 2: connect your data sources
Connect GA4
In Looker Studio, add a data source and choose the Google Analytics connector. Select your GA4 property. All your metrics become available: users, conversions, traffic sources. This is the backbone of your dashboard.
Connect Google Sheets
Your sales, your WhatsApp orders or your ad spend often live in a file. Put them in a clean Google Sheet, with one row per event and clear columns (date, amount in FCFA, channel). Connect this Sheet to Looker Studio. Now, when you update the Sheet, the dashboard follows.
Connect Search Console and Google Ads
For an SEO view, add Search Console to see your keywords and organic clicks. If you advertise, connect Google Ads to track cost and return. Looker Studio brings everything to one place.
Step 3: visualize the right KPIs
A KPI is a key performance indicator. Choose them carefully.
The useful KPIs for an SME
The number of conversions over the period, for example quote requests or WhatsApp clicks. The source generating the most conversions. The cost per conversion if you advertise. The month over month trend to see if you are progressing. And, for e-commerce, revenue and average basket in FCFA.
The right chart types
Use a big number, called a scorecard, for important totals: 47 requests this month. Use a line chart for trends over time. Use a table or pie chart to compare sources. Avoid complicated three dimensional charts that impress but do not help you decide.
Step 4: share and organize
Looker Studio is shared like a Google document. Give read access to your sales team, your accountant, your partner. Everyone sees the same numbers, ending debates about the data.
Organize into pages
If your dashboard grows, split it into pages: a Summary page for management, a detailed Marketing page, a Sales page. The first page should fit on one screen and answer the question "how is the business doing this month".
Step 5: the review ritual, the most important part
A dashboard nobody looks at is useless. The real lever is the ritual.
Set up a weekly review
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Block thirty minutes every Monday morning. Open the dashboard, look at the key KPIs, compare to the previous week. Ask three questions: what worked, what dropped, what do we change this week. Note one concrete action at the end.
The deeper monthly review
Once a month, take an hour to analyze long trends. Which channel is rising, which is fading. This is the moment to reallocate the marketing budget based on facts, not impressions.
Mini case: Bambi Academy language school in Dakar
Bambi Academy, a Dakar language school, received enrollments via its website, its Facebook page and WhatsApp. The director never knew which channel actually filled the classes. Every new term was a stress.
We built a Looker Studio dashboard combining GA4 for site traffic, a Google Sheet for real enrollments and Facebook for spend. The first page displayed four numbers: visitors, information requests, confirmed enrollments and cost per enrollment.
The weekly ritual changed everything. Within two months, the director saw that enrollments came mostly from referrals and WhatsApp, while Facebook advertising cost 12,000 FCFA per enrollment for little result. She cut part of the ads and launched a referral program. Acquisition cost dropped by half. The dashboard did not create these customers, but it showed where money was being wasted.
Mistakes to avoid
The gas factory dashboard
Too many charts kill the dashboard. If the first page does not fit on one screen, you have overloaded it. Cut everything that leads to no decision.
Forgetting maintenance
A source that disconnects, a renamed Google Sheet, and the dashboard breaks. Check it regularly and name your sources clearly to avoid surprises.
Building without a ritual
The most beautiful dashboard is useless without regular review. If you remember only one thing, it is this: the ritual matters more than the tool.
FAQ
Is Looker Studio really free?
Yes, Looker Studio is free, with no limit on the number of dashboards or users. Only certain paid third party connectors have a cost, but Google connectors are free.
Do I need to code to create a dashboard?
No. Looker Studio works by drag and drop. You choose a source, a chart type, and place elements visually. No line of code is required.
How long to build a first dashboard?
A simple dashboard connected to GA4 takes half a day. Most of the time goes to thinking about the right KPIs, not the technical build.
Can I put my offline sales in Looker Studio?
Yes, via Google Sheets. Record your store sales or WhatsApp orders in a structured Sheet, connect it, and they appear in the dashboard alongside site data.
Does the dashboard update itself?
Yes for connected sources like GA4 or a Google Sheet. When the source changes, the dashboard reflects the new data on opening, with no manual handling.
Can I share the dashboard with a client or partner?
Yes, by a simple read only link, like a Google document. You control who can view or edit, and you can revoke access at any time.
Let's talk about your project. Kolonell builds your Looker Studio dashboard, connects your sources and sets up your review ritual. Message us on WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
