Today we’re creating a keyword table that shows:
– Initial Ranks at Campaign Kickoff
– Ranks as of Today
Steps:
- We’re using SE Ranking and Google Sheets for this. Make a Google Sheets table of the iniitial keyword data – this will be static forever
- Connect SERanking + Google Sheets to Data Studio
- Make sure the Google sheets table has the same dimension/metrics names as the SE Ranking table in Data Studio
- Blend Data -> Note you can change the metrics/numerics in the settings here. I got gged since I didn’t do this and spent like 10 mintues looking for it






YAMM – yet another mail merge