Supermetrics Support Forum

Join CPC of Keyword Planner With Search Console Queries

Hi There,


In Google Data Studio I want to create a connection between the Search Console and Google Ads Keyword datas. 


I started to use Supermetrics in the hope it can give me CPCs of the queries that Search Console shows me rankings for.


I tried to do a Join Key with "Queries" from Search Console and "Keyword Text" from Google Ads (Supermetrics), then I have tried every CPC-Variable which was available but I just got always "null" . 


Our goal is basically that we want to say our clients "Look if you would have paid for this amount of clicks on Google Ads then you would have paid X-amount".


Is this a good approach or do you have a better idea for doing it? 


I already have an manual solution with putting the CPC from Keywordplanner in a Google Sheet in connection with a Search Console Query export but I actually want to get it automatically, and Supermetrics is my last hope. 


Thank you!

Cheers,

Florian

Login to post a comment