With the wide variety of clients out there, you’re bound to run into the occasional DIY marketer. These marketers prefer that you teach them how to be self-sufficient rather than rely on you for every little question.
These clients can be a blessing but can also be dangerous. The challenging aspect of client management is finding the balance between empowering them to get the data they want without feeling like they don’t need you.
That’s where Google Data Studio tools come into play.
Data Studio is typically used for general reporting. The real beauty of Data Studio is that it can be used for so much more.
By creating tools for clients, you enable them to do the actual research it takes to accomplish SEO while still providing that much-needed maintenance and guidance that comes with experience.
This article illustrates free dashboard templates you can use with your clients.
How to change the branding
Before we dive into the specifics, you may want to update the branding and logo of your dashboard. This process could not be easier.
Right-click on your logo, and you will see a menu appear. Near the bottom, select “Extract theme from image.” You will then be presented with three different color scheme options. Select whichever one you feel best represents your brand.
This will automatically change most of the colors and get you most of the way to the finish line of designing in your Data Studio tool. However, there may still be a few charts or texts you’ll need to update.
1. Technical SEO auditing
Tracking technical SEO efforts can be difficult to visualize. Sure, you can track it in a spreadsheet, but that isn’t client-friendly.
For years, SEOs have attempted to make dashboard trackers to help show improvements in site health over time.
Luckily, our friends at Screaming Frog have finally cracked the case of the perfect technical SEO dashboard. The best part? The template is free. You can see it here.
How to copy the dashboard
To copy the dashboard:
- Click on the three dots in the top right
- Select make a copy
- Select your data source (don’t worry, you can update later)
How to set up the technical SEO tracker tool
Screaming Frog has published a helpful guide on setting up this Data Studio tool. What they will walk you through includes:
- Setting up a scheduled crawl
- Configuring the export to a Google Sheet
- Connecting that Google Sheet to the Data Studio dashboard
You can find the full tutorial here.
Get the daily newsletter search marketers rely on.
2. Keyword research
The presentation of keyword research takes many forms. Most recognizable is the simple spreadsheet. Some people create keyword maps for each page or topic, while others with smaller clients have a short list of keywords.
However, Data Studio can be a powerful analysis tool for larger sites with tens of thousands or millions of keywords.
If you are working with millions of keywords, do not use Google Sheets