You’re sure to meet DIY marketers with the many clients you have. They prefer to learn how to do it themselves, rather than depend on you.
This can both be a blessing and a curse. It is difficult to find the right balance in client management.
This is where Google’s tools are useful.
Looker Studio can be used to do general reporting. Looker Studio’s real appeal is its versatility.
You can create tools that clients use to conduct the research necessary to achieve SEO, while also providing them with that needed guidance and maintenance.
Here are some free templates that you can share with clients.
Change your branding
Before getting into details, it is a good idea to change the logo and branding of your dashboard. It is simple and straightforward.
Click on the logo to open a menu. Select “Extract the theme from this image” at the bottom. You’ll then see three color schemes. Choose the one that best describes your brand.
You can then change the majority of your colors automatically and you will be able to finish designing with the Looker Studio tool. You may need to make some minor adjustments or charts.
1. Auditing technical SEO
It can be hard to track technical SEO efforts. It’s possible to track this in a spreadsheet but it isn’t user-friendly.
Since years SEOs have tried to create dashboard trackers that show changes in site health over time.
Our friends from Screaming Frog finally solved the problem of the ideal technical SEO dashboard. What’s the best thing? It’s free! It can be viewed .
How do I copy the dashboard
Copy the dashboard
- To the right, click on the three dots
- Make a copy
- Choose your data source (don’t be afraid, you can always update later).
How to setup the technical SEO tracker instrument
Screaming Frog published an informative guide for setting up the Looker Studio tool. They will guide you through the following:
- Scheduled crawls
- Configuring the export to Google Sheet
- The Google Sheet can be connected to the Looker Studio dashboard
Find the Daily Newsletter Search Marketers Rely on.
2. Keyword research
There are many ways to present keyword research. The most common form of keyword research presentation is the spreadsheet. While some people make keyword maps for every page, or topic of interest, others have smaller lists.
Looker Studio is a great tool to analyze larger websites with thousands, if not millions, of keywords.
Google Sheets is not recommended for millions of keywords. BigQuery is a better way to manage your keywords.
Step 1: Setting up source data
First, import your keyword research to a Google Sheet. You will need the following metrics and dimensions to use my free Google Sheet template:
- Previous position
- Search Volume
- Keyword Difficulty
- Keyword Intents
This is the original data source that was used in the dashboard. Semrush provides all data.
Step 2: Copy the dashboard
You’ll need to copy the dashboard as we saw in the last dashboard. Then connect any data source you like BigQuery or Google Sheets.
This tool from Looker Studio has important features
The tool offers many features to aid in your SEO efforts. These features can be tailored to show different data types and categories depending on the strategy.
This tool’s three buttons are built on custom boolean functions, which means they can be used to make true/false statements. Let’s look at just one.
This function will only display long-tail questions that begin with the question word from the above formula. Regex is used in this formula, which uses two important symbols.
- The circumflex () is a regex that basically means “if the keyword begins with this.”
- ) symbol is another regex function that means “or.”
This formula can be used to create many different types of checkboxes. ) to help display keywords in those categories for the SEO and PPC checkboxes.
Custom search box
This tool has a powerful, yet simple feature called the custom search box. It can help you quickly narrow your search in order to find keyword possibilities. Additionally, it can use regex to personalize your search.
You can filter the keywords by intent using the keyword intent dropdown. It’s really that simple.
This filter is easily interchangeable by any dimension within Looker Studio. This filter can also be used to replace it for keywords from other categories.
The funnel allows you to visualize your search funnel according to intent. The funnel and metrics will automatically adjust to the intents when you apply other filters.
One of the most difficult topics for SEOs to discuss with clients is link building. Link building is difficult to achieve and can be very challenging to manage.
Transparency is the best way to build trust with clients, stakeholders and other parties. Don’t hide the link-building data. Instead, give the keys to the stakeholders and allow them to explore it.
This tool is the simplest in Looker Studio. To illustrate your point, you can combine any number of metrics and dimensions.
A simple SEMrush backlinks report is the supporting Google Sheet that I am using. You can also feed this report with your link-building tracker. Make sure to include the acquisition date in the date range.
The Google Sheet which feeds the tool .
Looker Studio has some very robust features and is fast. It’s free, making it an attractive platform.
This begs the question: Why go to all this trouble for clients or other stakeholders?
This tool can improve trust by creating a greater sense of transparency. This creates a stronger partnership between you, your stakeholders.
The most difficult part of SEO is not the actual work but communicating value. You should think up creative ways that you can demonstrate your value to clients from now on. Even if this is just a tool in Looker Studio.
These opinions are not necessarily those of Search Engine Land, but they do reflect the views of the guest author. Here are the names of staff authors.
Search Engine Land: New!
- How to survive a Google core update and come out on top - March 28, 2023
- Core Web Vitals report within Google Search Console updated - March 28, 2023
- Google Ads Editor version 2.3 is out with 12 new features - March 27, 2023