Analytics
2.2K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

Combined report from Search console & Google Adwords keyword Planner

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭
Hi,

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?

 

Thanks,

Ankita

Combined report from Search console & Google Adwords keyword Planner

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

Sorry I don't think Google Analytics have capability to display/retrieve Adwords keyword planner. So at this moment, you need to use 3rd party app to do this

Combined report from Search console & Google Adwords keyword Planner

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Do you recommend any specific 3rd party app for this process?