How to combine Search Console and Analytics in Google Data Studio

Hello, friend! How is everything? Good? I hope so! Are you surprised to see me here so soon after posting yesterday? Well, I’m super excited because the launch of my course to analyze and understand data with Google Data Studio is working very well (snif, snif, ainnnsss how excited). And there are still two days left to be able to make the purchase enjoying the bonuses (ahem! ahem! self-promotion. Okay… I’ll stop hehe). Well, as happy as I am, I wanted to share with you one of the things that I think are most powerful about the Data Studio tool . And it is the ability to combine multiple data sources into a single chart . That is, obtaining a single data source by combining two data sources.

Steps to combine Search Console and Analytics data in Data Studio

Create a custom field in the Google Analytics feed to include the domain, since in Search Console URLs go with a domain industry email list and in Analytics they go without a domain. With which we unify the format. Eye! Use the “Landing Page” field from Google Analytics and not the “Page” field since if we want to combine data from Search Console, we will have to use the destination page and not all the content of the website. Even doing a pre-filter of only organic traffic would be cool… I’ll leave it there… 🙂

Step 2: Create the combined data source

Create a combined data source where we will say that the combining fields are date Forex Email List and URL in Search Console, and date and combined URL in Google Analytics so that they make the match and combine. Step3: Choose the metrics Choose what metrics we want in our new data source. In the case of the example we take impressions, clicks and CTR from Search Console and sessions from Google Analytics. Step 4: Save the font Save the data source.

Leave a Reply

Your email address will not be published. Required fields are marked *