Drill down functionality in Data Studio is super useful for quickly seeing the keywords URLs rank for! 🔥
Thread 👇
Thread 👇
1/
You can drill down in the @ahrefs top pages report (which is great) but it's nice to be able to brand it in a Data Studio report and manipulate the data as you see fit.
Here's how I done it on a Danish website
You can drill down in the @ahrefs top pages report (which is great) but it's nice to be able to brand it in a Data Studio report and manipulate the data as you see fit.
Here's how I done it on a Danish website
2/
From the organic keywords report, export as much keyword data as your @ahrefs plan allows. You can cleverly use the filters to remove keywords you don't want to be aggregated at page level. 💡
From the organic keywords report, export as much keyword data as your @ahrefs plan allows. You can cleverly use the filters to remove keywords you don't want to be aggregated at page level. 💡
3/
Import the csv into a Google sheet and then add it as a data source in Data Studio. I've excluded some of the columns for the purposes of my report; include as many as you want OR create your own columns (ie. add search intent, categories, keyword clusters etc.)
Import the csv into a Google sheet and then add it as a data source in Data Studio. I've excluded some of the columns for the purposes of my report; include as many as you want OR create your own columns (ie. add search intent, categories, keyword clusters etc.)
4/
Create a table in Data Studio and add URL and Keyword as the dimensions.
Then select 'Drill down' with the default drill down level set as URL.
Add a couple of other cool calculated metrics, if you must 👀
Create a table in Data Studio and add URL and Keyword as the dimensions.
Then select 'Drill down' with the default drill down level set as URL.
Add a couple of other cool calculated metrics, if you must 👀
5/
Voilà ⭐
Check out your competitors top pages in Data Studio and drill down to see the keywords they rank for 💪
Voilà ⭐
Check out your competitors top pages in Data Studio and drill down to see the keywords they rank for 💪
