AdWords
5K members online now
5K members online now
Use AdWords conversion tracking and reporting to measure your results. Have a question about Google Analytics? Post it here, on the Google Analytics Community!
Guide Me
star_border
Reply

Combined report from Search console & Google Adwords keyword Planner

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

Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

You may want to re-post this in the Google Analytics group instead of AdWords. 

 

https://www.en.advertisercommunity.com/t5/Google-Analytics-Reports/bd-p/Reports_and_Reporting_Relate...

 

Combined report from Search console & Google Adwords keyword Planner

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭