Setting Up Google Data Studio
Most small business owners I meet in Derbyshire are spending money on marketing without knowing which bits are actually working. They have Google Analytics, maybe a social media account, possibly running Google Ads, but the data lives in five different places and nobody has time to log into all of them. So decisions get made on gut feel rather than evidence.
That is an expensive habit. I have spent 18 years watching small businesses in the East Midlands waste budget on channels that look busy but deliver nothing, while ignoring the ones quietly driving their best customers. The fix is rarely more data. It is getting the right data into one place so you can read it quickly and act on it.
Google Looker Studio (which most people still call Google Data Studio) is a free tool that does exactly that. It pulls in data from Google Analytics, Google Search Console, Google Ads, your spreadsheets and more, and lets you build a single dashboard you can check in five minutes. This post walks you through how to set it up properly, what to put in it, and how to use it to make better marketing decisions without needing a data analyst on staff.
Free tool
Not sure how your marketing measures up right now?
Take the BIG12 Scorecard and get an instant read on the 12 pillars driving growth for small businesses like yours.
Take the free scorecardWhy Google Looker Studio matters for small business marketing
Before we get into the setup, it is worth being clear about what Looker Studio actually is and why it is worth your time. It is a free data visualisation tool from Google. You connect your data sources to it, choose how you want the data displayed, and it builds a live dashboard you can share with your team or come back to each week.
The version most people knew as Google Data Studio was rebranded to Looker Studio in 2022. The free version is still there and still works the same way. You do not need to pay for anything to get real value from it as a small business.
The problem it solves
Without a dashboard, measuring your marketing performance means logging into Google Analytics, then Google Search Console, then your ads platform, then your social media accounts, then trying to hold all those numbers in your head at the same time. Most business owners do not do this, so they never build a clear picture of what is working.
A well-built Looker Studio dashboard changes that. You can see your website traffic, where it came from, how many enquiries it generated, and how that compares to last month, all in one place, updated automatically. For a small business owner in Derbyshire running a lean team, that is genuinely useful.
"Data is not the enemy of small business marketing. The enemy is having your data scattered across a dozen tabs you never actually look at."
Stuart Baddiley, Optimise Your MarketingGetting access to Google Looker Studio
You do not need to create a new account. If you have a Google account (which you will if you use Gmail, Google Analytics or Google Ads), you already have access. Go to lookerstudio.google.com and sign in with those credentials.
Once you are in, you will land on a home screen showing any reports you have already created. If this is your first time, it will be empty. That is fine. Click the blue plus icon or the "Blank Report" button to start.
Connecting your data sources
This is the most important step and the one people most often rush. Your dashboard is only as useful as the data you put into it. Take your time here and connect every source that is relevant to your business.
Google Analytics 4
Click "Add data" when you create a new report and select Google Analytics from the connector list. Authorise it with your Google account and select the correct GA4 property for your website. This gives you traffic data, sessions, users, bounce rate, conversions and more.
Google Search Console
This is the one most Derbyshire SMB owners overlook. Search Console tells you exactly which search queries are bringing people to your website, how many times you appeared in results, and how many people actually clicked. That data is gold for understanding your organic visibility. Connect it the same way you connected GA4, selecting "Search Console" from the connector list.
Google Ads
If you are running paid search campaigns, connect your Google Ads account so you can see spend, clicks, impressions and conversion data alongside your organic numbers. Seeing both in one view makes it much easier to understand the full picture of your lead generation effort.
Google Sheets
This is particularly useful for business owners who track things manually. If you have a spreadsheet where you log monthly enquiries, phone calls or sales figures, you can connect that directly to Looker Studio and include it in your dashboard. This bridges the gap between your digital marketing data and your actual business results.
Practical note
Stick to sources you actually use
Do not connect every source available just because you can. If you are not running Google Ads, do not add it. Start with two or three data sources and build from there. A focused dashboard you look at every week beats a cluttered one you ignore.
Designing your first dashboard
Once your data sources are connected, you can start building. Looker Studio works on a drag-and-drop canvas. You add charts, tables and text boxes, resize and move them, and connect each element to the relevant data source and metric.
Start with your most important metrics
Every business is different, but for most small businesses in the East Midlands doing B2B or local B2C work, I would start with these:
- Total website sessions this month versus the same month last year
- Top traffic sources (organic search, direct, social, paid)
- Top pages by sessions
- Top search queries from Google Search Console
- Goal completions or conversion events (contact form, phone click, booking)
Use date range controls
One of the most useful features in Looker Studio is the ability to add a date range filter. This lets you or anyone you share the report with change the time period being displayed without editing the report itself. Add one at the top of your dashboard so you can quickly switch between last week, last month, last quarter and so on.
Keep the layout simple
Resist the urge to fill every inch of the canvas. A clean dashboard with five or six key metrics is more useful than a dense one with thirty. Use Looker Studio's built-in scorecard components for your top-level numbers, and charts or tables for anything that needs more context. Your website probably has less than ten pages driving 80% of your traffic. Reflect that in your dashboard rather than showing everything equally.
Client result
Visibility into the right numbers changes everything
A Derbyshire professional services firm we work with had no idea that 70% of their enquiry form completions came from a single blog post written three years earlier. Once that was visible in their dashboard, they invested in building ten more like it. Enquiries from organic search doubled within eight months. That kind of decision only gets made when you can see your data clearly. We help businesses across Derbyshire and the East Midlands build that visibility through our Test and Measure service.
See how we approach Test and MeasureSharing your Looker Studio report
A dashboard that lives only on your laptop is limited in value. Looker Studio makes sharing straightforward.
Sharing with your team
Click the Share button in the top right corner and add the email addresses of anyone who needs access. You can give them view-only access (they can see the data but cannot change the report) or edit access. For most small business teams, view-only access for non-marketing people works well.
Scheduling email deliveries
Looker Studio lets you schedule automatic email reports so the dashboard lands in your inbox at a set time each week or month. This is one of the most underused features for small businesses. Set it up once and you get a prompt to look at your data whether you remember to or not. Go to File, then Schedule email delivery, and pick your cadence.
Embedding in your own site
You can also embed a Looker Studio report in a password-protected page on your website, which can be useful for sharing live data with a trusted client or a business partner without giving them access to your Google account.
What to do with the data once you have it
This is where most dashboard projects stall. The setup gets done, the dashboard looks good, and then nobody acts on it. After 18 years of working with small businesses, I can tell you that the businesses who grow are the ones who build a regular habit around their data, not the ones who build the most impressive dashboard.
Set a weekly review habit
Block 20 minutes on your calendar each Monday morning to look at your dashboard. Ask three questions: What went up? What went down? What am I going to do about it? Keep it that simple. You are not looking for perfect answers, you are looking for signals.
Connect data to decisions
If your Search Console data shows a particular page dropping in clicks, that is a signal to update it. If your top traffic source is suddenly referring fewer sessions, that is a signal to investigate. If your contact form completions spike after you publish a piece of content, that is a signal to publish more like it. The dashboard does not make decisions. It just gives you better information to make them with.
Track changes when you make them
Whenever you make a significant change to your marketing, whether that is launching a new campaign, updating your Google Business Profile, redesigning a page or running a promotion, note the date and then watch your dashboard in the weeks that follow. Over time this builds a clear picture of what actually moves the needle in your business.
"The businesses I see grow consistently are not the ones with the most marketing activity. They are the ones who know which activity is working and do more of it."
Stuart Baddiley, Optimise Your MarketingHow this fits into the BIG12 framework
At Optimise Your Marketing, we use the BIG12 framework to help small businesses across Derbyshire and the East Midlands build marketing that is consistent, measurable and sustainable. One of the twelve pillars is Test and Measure, and Looker Studio is one of the core tools within that pillar.
Without measurement, the other eleven pillars are working blind. You might be producing great social media content, running Google Ads, investing in SEO and building your brand, but if you cannot see which of those activities is actually generating enquiries and customers, you cannot allocate your budget intelligently. That is how small businesses end up spinning their wheels.
Looker Studio is the reporting layer that sits across your entire marketing operation. Set it up properly and it becomes the tool your whole team comes back to when they need to understand what is happening and why.
Free tool
Not sure how your marketing measures up right now?
Take the BIG12 Scorecard and see how your business scores across all twelve marketing pillars, including Test and Measure.
Take the free scorecardThe challenge is never learning. It is doing.
Setting up a Looker Studio dashboard takes less than an afternoon. The harder part is building the habit of using it, acting on what it tells you, and keeping it updated as your business and marketing evolve. That implementation gap is where most small business marketing improvement efforts stop.
At Optimise Your Marketing, we help businesses in Derbyshire and across the UK close that gap. We can set up your Looker Studio dashboard, connect the right data sources, build a reporting process that fits how your team actually works, and then sit alongside you month by month to interpret the data and turn it into decisions. That is what 18 years of working with real businesses teaches you: good data without someone to help you read it is still just noise.
If you want clearer visibility into your marketing performance and a practical plan to act on it, start with a free 90-minute audit below.
Book a free audit
Book a free 90-minute audit with Stuart
We will look at your current marketing, benchmark it against the BIG12, and give you a practical set of actions to take. No sales pitch. No fluff. Just 18 years of honest advice applied to your business.
Book your free auditGoogle Data Studio is a powerful tool for creating interactive and visually appealing reports and dashboards, allowing you to analyse and share insights from your marketing data effectively. By setting up Google Data Studio, you can transform raw data into actionable insights, enhancing your decision-making and optimising your marketing strategies. Here’s how to set up Google Data Studio: -
Understanding the Benefits of Google Data Studio
Google Data Studio enables you to consolidate data from multiple sources into a single, easy-to-understand report. This helps you track key performance metrics, identify trends, and make informed decisions to improve your marketing efforts.
Steps to Set Up Google Data Studio
Access Google Data Studio
Create an Account: If you don’t already have a Google account, create one to access Google Data Studio. You can sign in using your existing Google credentials.
Navigate to Data Studio: Visit the Google Data Studio website and sign in with your Google account to access the platform.
Connect Your Data Sources
Add Data Sources: Click on the “Create” button and select “Data Source” to add your data sources. Google Data Studio supports a wide range of data connectors, including Google Analytics, Google Ads, Google Sheets, and more.
Authorise Access: Authorise Google Data Studio to access your data by following the prompts. This ensures that your data is securely connected and available for reporting.
Designing Your Dashboard
Create a New Report
Start a New Report: Click on “Blank Report” to start creating a new report. You can also choose from a variety of templates if you prefer a pre-designed layout.
Add Data to Report: Use the “Add Data” button to select the data sources you want to include in your report. You can add multiple data sources to create a comprehensive dashboard.
Customise Your Visualisations
Choose Visualisation Types: Google Data Studio offers various visualisation options, including tables, charts, and graphs. Choose the types that best represent your data and insights.
Customise Design: Use the editing tools to customise the design of your report, including colours, fonts, and layout. This ensures your report is visually appealing and aligns with your brand identity.
Sharing and Collaboration
Share Your Report
Set Permissions: Click on the “Share” button to set permissions for your report. You can control who can view or edit your report, ensuring it’s accessible to the right audience.
Embed and Export: Google Data Studio allows you to embed your report on websites or export it as a PDF for easy sharing with stakeholders.
Leverage Optimise Your Marketing Expertise
Expert Guidance: Work with Optimise Your Marketing to access expert insights and tools that enhance your Google Data Studio setup and overall marketing strategy.
Continuous Improvement: Regularly update your reports with new data and insights to ensure they remain relevant and informative.
Monitoring and Optimising Performance
Track Key Metrics
Performance Dashboards: Use your Google Data Studio dashboards to monitor key performance metrics, such as website traffic, conversion rates, and campaign effectiveness.
Identify Trends: Analyse the data to identify trends and patterns that can inform your marketing strategies and optimise performance.
Conclusion
Setting up Google Data Studio is a strategic approach to enhancing your online marketing analytics and decision-making. By connecting your data sources, designing customised dashboards, and sharing insights, you can transform data into actionable information that drives business growth. With the guidance and resources from Optimise Your Marketing, you can effectively implement Google Data Studio to support your brand’s objectives and ensure long-term success in the competitive digital landscape.
