Looker Studio Dashboard Starter
Copy the data template, paste your link and create a Looker Studio dashboard connected to your own data in one click.
The link builder runs in your browser. Your sheet stays in your Google Drive and connects straight to Looker Studio.
-
Copy the data template
A Google Sheet laid out the way Looker Studio likes it: one row per day, per channel and campaign. It comes with a month of example data so you can see the dashboard working straight away.
Copy the data templateOpens a copy in your own Google Drive -
Add your data
Replace the example rows on the Data tab with your numbers from GA4 and your ad platforms. Keep the column headers exactly as they are. Hover over a header in the sheet to see what goes in it.
-
Create your report
Paste the link to your copy and Looker Studio will open a new report already connected to it.
Create my Looker Studio reportLooker Studio will ask you to sign in with Google and to allow access to your sheet. Make sure you use the same Google account that owns the copy.
-
Add calculated fields
In Looker Studio, go to Resource › Manage added data sources › Edit › Add a field. Ratios built from totals stay correct when you filter by date or channel.
Field name Formula Type Copy Engagement rate SUM(Engaged sessions) / SUM(Sessions)Percent Key event rate SUM(Key events) / SUM(Sessions)Percent Cost per key event SUM(Cost) / SUM(Key events)Currency ROAS SUM(Revenue) / SUM(Cost)Number CTR SUM(Clicks) / SUM(Impressions)Percent CPC SUM(Cost) / SUM(Clicks)Currency -
Build the layout
The one-page layout I start most client dashboards with:
- Top row: a date range control and a Channel filter
- Scorecards: Sessions, Key events, Key event rate, Revenue, Cost and ROAS, each comparing with the previous period
- A time series of Sessions and Key events by Date
- A table by Channel with Sessions, Key events, Key event rate, Revenue and ROAS
- A table by Campaign with Cost, Clicks, CTR, CPC, Key events and Cost per key event
How to use it
- Copy the data template and replace the example rows with your own numbers.
- Paste the link to your copy above and create your report in one click.
- Add the calculated fields and build the layout. Update the sheet each month and the dashboard updates too.
Want the data to update itself? GA4 and Google Ads have their own Looker Studio connectors. The sheet is the easiest way to bring every platform into one place.
Want help putting this to work? Let's talk.
Book a free 15-minute call and we’ll look at where your marketing can grow fastest.
Book a free strategy call