Hello! Welcome back to our module on Marketing Dashboards & Reporting.
In our last lesson, we explored the crucial concept of attribution models. You learned how different models—from Last-Click to Data-Driven—assign value to the various marketing touchpoints in a guest's journey. This gave us the "why" behind performance measurement. Now, it's time to build the "how."
Today's lesson addresses the learning outcome: Connect GA4 and Google Ads as data sources to Looker Studio (formerly Data Studio). We're moving from theory to the first practical step in building a professional marketing dashboard. By the end of this lesson, you will know how to pipe the data from your key analytics and advertising platforms into a single, powerful reporting tool.
1. What is Looker Studio and Why Use It?
Before we start connecting things, let's clarify what Looker Studio is. In short, it's a free tool from Google that allows you to turn your raw marketing data into informative, easy-to-read, and shareable dashboards.
For your hotel, this is incredibly powerful. Instead of jumping between the Google Analytics interface to check website traffic and the Google Ads manager to check campaign costs, you can bring all that essential data into one place. You can build a single dashboard that answers questions like:
- "How much did we spend on Google Ads last month, and how many bookings did it generate?"
- "Which campaigns are driving the highest Return on Ad Spend (ROAS)?"
- "What is the booking conversion rate for traffic coming from our paid ads versus organic search?"
To get a quick sense of why marketers are increasingly using Looker Studio alongside GA4, watch the first couple of minutes of the following video.
Looker Studio tutorial for Google Analytics 4 | GA4 + Google Data Studio
This video from Analytics Mania introduces Looker Studio and explains why its visualization capabilities are much more flexible and powerful than the standard reports inside GA4.
Watch the first two minutes of the video (from 00:00 to 02:05). The speaker discusses the limitations of GA4's native reporting and the benefits of using Looker Studio for more customized and shareable dashboards.
As the video highlights, Looker Studio allows you to create reports tailored to your specific needs and the needs of your stakeholders (like hotel management), which is a significant step up from the default reports in your marketing platforms.
2. Connecting Your First Data Source: Google Analytics 4 (GA4)
The foundation of our marketing dashboard will be data from Google Analytics 4. It holds the key information about what users do on your hotel's website—how many sessions you get, which pages they view (e.g., specific room types), and most importantly, the conversion events you've set up, like begin_checkout and successful bookings.
Connecting GA4 to Looker Studio is a straightforward process. You'll create a new report and use a built-in "connector" to link your GA4 property.
The following video provides a clear, step-by-step demonstration of this exact process.
Looker Studio Tutorial (2025) Build Dashboards & Reports Step-by-Step
This tutorial from Loves Data demonstrates how to start a new report and connect a data source. It uses the GA4 connector as its primary example.
Watch the clip from 01:15 to 03:33. Follow along as the presenter creates a new report and connects the Google Analytics data source. Notice the list of other available connectors.
To reinforce those steps, here is the official Google documentation. It serves as a great checklist for when you do this yourself.
This official documentation from Google provides a step-by-step guide to connecting Google Analytics to Looker Studio. It's a useful reference to have on hand.
Read the section 'How to connect to Google Analytics 4'. It breaks down the process into seven clear steps, from creating a data source to selecting your account and property.
Once connected, Looker Studio can pull in any dimension (e.g., 'City', 'Traffic Source') or metric (e.g., 'Sessions', 'Conversions') available in your GA4 property.
A Note on Data Credentials
The documentation also mentions "Data Credentials." This is a key concept for sharing your reports.
- Owner's Credentials: Anyone viewing the report sees the data using your access permissions. This is perfect for sharing a performance dashboard with hotel management or other staff who don't have (and don't need) their own login for Google Analytics.
- Viewer's Credentials: Each person viewing the report must have their own access to the underlying GA4 property. This is more restrictive and typically used when sharing reports with other marketing team members.
For most of your reporting needs within the hotel, Owner's Credentials will be the most practical choice.
3. Connecting Your Second Data Source: Google Ads
While GA4 tells us what happened on the website, Google Ads tells us about the advertising activity that drove that traffic. It contains crucial metrics like ad spend, clicks, impressions, and Cost Per Click (CPC). To get a full picture of your ROAS, you need both data sources.
The process for connecting Google Ads is nearly identical to connecting GA4. You'll add a new data source to your report, but this time you'll select the Google Ads connector.
The official documentation provides a clear walkthrough.
This guide details the steps to connect your Google Ads account to Looker Studio. Pay attention to the option for selecting manager accounts, which could be relevant if your hotel works with an agency or has multiple ad accounts.
Read the section 'Select an individual account'. This walks you through the 8-step process, which is very similar to connecting GA4.
By connecting both GA4 and Google Ads, you establish the two pillars of your marketing dashboard. You'll have website behavior data and advertising cost data available in the same report, ready to be combined and visualized.
Test your understanding!
You're building a dashboard for your hotel manager. They want to see two things on one page:
- The total number of bookings made on the website last month.
- The total amount of money spent on Google Ads in the same period.
Which data sources must you connect to your Looker Studio report to get this information?
Show answer
You would need to connect two data sources:
- Google Analytics (GA4): To get the "total number of bookings" from your conversion tracking.
- Google Ads: To get the "total amount of money spent" (the 'Cost' metric).
Conclusion
Congratulations! You've completed the foundational step of building a marketing dashboard. While we didn't build any charts today, understanding how to properly connect your data sources is the most critical part of the process. Bad data in means bad data out, so ensuring a solid connection is paramount.
Key Takeaways:
- Looker Studio is for visualization: It's a free tool designed to turn data from sources like GA4 and Google Ads into clear, interactive reports.
- Connectors are the key: You use specific "connectors" to link each data source to your Looker Studio report.
- GA4 provides user behavior data: It tells you what happens on your website, including key conversion actions like bookings.
- Google Ads provides performance data: It tells you about your advertising metrics, including clicks, cost, and impressions.
- Connecting both is essential: To create a comprehensive performance dashboard that calculates metrics like ROAS, you need to connect both GA4 and Google Ads.
What's Next?
With our data sources connected, we're now ready to bring the data to life. In the next lesson, we will build a marketing KPI dashboard in Looker Studio showing performance over time. You'll create your first "scorecards" to display top-line metrics and a time-series chart to track performance trends, turning all this setup into a tangible and valuable report.