How to Get More SEO Insights from Google Data Studio with SEMrush

Looking for complicated tactics to work with your advertising knowledge, higher provide insights, and enhance reporting throughout your SEO actions?

On December 2, I moderated a Search Engine Journal webinar sponsored by SEMrush and introduced by Nick Wilsdon, Partner, Torque Partnership.

He mentioned how an information integration for Google Data Studio can make stronger your SEO actions and shared some complicated use-cases with the SEMrush Data Studio Connector.

Here’s a recap of the presentation.

Google Data Studio (GDS) is a loose but tough software that permits entrepreneurs to make visible dashboards and reviews that mix quite a lot of knowledge resources, together with Google Analytics, BigQuery, Google Sheets, YouTube, and extra.

Connecting Google Analytics or Search Console to GDS lets in you to create extra versatile and custom designed reviews in your web site’s peak acting seek phrases and pages

But if you happen to’re having a look to take your reporting to the following point, integrating Google Data Studio with SEO platforms corresponding to SEMrush is a should.

When you combine SEMrush with Google Data Studio, there are three separate connection points:

  • Position monitoring means that you can seek statistics on any area within the SEMrush database.
  • Domain analytics means that you can observe ratings for a customized set of goal key phrases.
  • Site audit means that you can audit any area on the internet and obtain a record at the web site’s major technical mistakes that harm its well being and visibility.

Here are many ways to take advantage of out of this knowledge integration.

Focus on Domain Overview Metrics

The SEMrush Domain Overview record allows you to analysis or tracking by yourself domain names or competition.

SEMrush Domain Overview

What Can You Do With This Data?

Pulling this knowledge to GDS will let you create a record that incorporates:

  • SEMrush Rank.
  • Top natural and paid key phrases (Google Ads).
  • Backlinks.
  • Estimates of natural and paid site visitors.
  • Traffic price.

The knowledge additionally covers 121 Google ccTLDs and 18 cellular Google ccTLDs.

It is excellent for top-level reviews throughout more than one domain names the use of more than one knowledge issues (with out hitting your undertaking prohibit inside SEMrush).

Improve dashboard performance

Use Case: ccTLD Migration to COM

The screenshot underneath represents a migration that Wilsdon and his staff performed the place they moved the whole lot from the ccTLDs and aggregated them right into a .com construction.

ccTLD to dot Com

On the left, as they migrated away from the ccTLD, the typical natural key phrases and reasonable site visitors are declining.

And as they’d hope, the typical natural key phrases and reasonable natural site visitors are expanding at the .com.

More key phrases additionally ranked in Position 1-3 once they switched to .com.

What they sought after to see finally is a better consequence for migrating that content material.

How to Pull This Report

To pull this knowledge:

  • Use the SEMrush Domain Analytics connector.
  • Choose Domain History because the record kind.
  • Under Parameters, input your area title. (Note that recently most effective ready to alter root area, now not actual URL, subdomain, or subfolder.)
  • Still underneath Parameters, test the bins for permitting databases/ to be changed and reviews.

SEMrush - GDS 1

Tip: If you ever get caught, put your knowledge right into a desk.

GDS - 1

This signifies the answer is to use other date layout however take into account fifteenth <month> for later.

You can use the next knowledge choices:

  • Select absolute date layout (Year Month).
  • Choose natural key phrases and site visitors metrics.
  • Date (varies by knowledge set).
  • We can make a selection parameters for every chart.

And some taste choices:

  • Set axis for left / proper.
  • Optional: reference strains the use of averages

Upgrade with Blended Charts

By mixing charts, you’ll be able to create extra tough dashboards that permit you to view quite a lot of knowledge issues.

Blended charts

You too can mix knowledge and use distinctive names for shared dimensions (i.e., “Organic Keywords” or “Organic Traffic”).

Blend data

Wilsdon stocks that it’s more straightforward to upload/arrange metrics within the Data Resources > Edit Connection display.

Manage metrics GDS

This is a fundamental calculated box to come up with 51-100 positions in a single block (simplify visualizations).

Tip: You can manually replace Field IDs to attach graphs in combination.

GDS - Edit field IDs

Improve Dashboard Performance

By the use of the SEMrush Data Studio Connector in conjunction with the GDS Extract Data characteristic, you’ll be able to enhance the efficiency of your reviews.

GDS Extract Data

Data extract means that you can discover a subset of your knowledge.

It too can:

  • Store up to 100MB of information.
  • Enable flexibility with aggregated knowledge.
  • Be used for knowledge with per thirty days updates.
  • Allow you to optimize your API utilization and costs.

How to Use Extract Data

Improve dashboard performance

  • Set naming conference.
  • Pull in all dimensions, metrics, and so on. required.
  • Set auto-update dates and be aware final up to date timestamp. (Tip: Save and extract when making any adjustments.)

[Slides] How to Get More from Google Data Studio with SEMrush

Check out the SlideShare underneath.

Source link

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: