Join CPC of Keyword Planner With Search Console Queries
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.