Google Data Studio – Blending Data

Today we’re creating a keyword table that shows:
– Initial Ranks at Campaign Kickoff
– Ranks as of Today

Steps:

  1. 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
  2. Connect SERanking + Google Sheets to Data Studio
  3. Make sure the Google sheets table has the same dimension/metrics names as the SE Ranking table in Data Studio
  4. 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