Combined report from Search console & Google Adwords keyword Planner[ Edited ]
May - last edited May
Currently I am manually exporting all the organic keywords from Search Console>Search Analytics and the uploading all these keywords into Google Keyword Planner to know the Suggested Bid (CPC) of these keywords by exporting this data. So now I have 2 file from Search Console & Keyword Planner. Now I do "index match" from w.r.t keywords in the files. So that finally I get one file with all keywords and there CPC, Impression & Clicks so I can calculate Total Value=CPC*Clicks. It give the dollar value that SEO is worth.
So my question is, is there any way I can do all this in Google Analytics without having to do lot of manual excel work?