AdWords
3.1K members online now
3.1K 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

Keyword planner report excel trends

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi everyone, this is my first post and I'll go very technical Smiley Very Happy

I was trying to export data from keyword planner but the only thing that can be displayed is the average researches per month.

Is there anyway to export the historical series (monthly researches) for each Adgroup and/or Keyword?

I know I could use many other tools such as Google trends but it hasn't the same level of detail in terms of correlation analysis

 

Thanks in advance to whoever replies

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Massimo C
February 2016

Re: Keyword planner report excel trends

Participant ✭ ✭ ✭
# 2
Participant ✭ ✭ ✭

Hi Massimo,

 

I am not sure what you want to achive, but if it is to see your data segmented by month, then you simply have to tick the first box in the download popup (see below).

Segment by month.PNG

 

That will give you the data segmented by month as opposed to just a monthly average for the time period.

 

Is this what you were looking for?

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Massimo C
February 2016

Re: Keyword planner report excel trends

Participant ✭ ✭ ✭
# 2
Participant ✭ ✭ ✭

Hi Massimo,

 

I am not sure what you want to achive, but if it is to see your data segmented by month, then you simply have to tick the first box in the download popup (see below).

Segment by month.PNG

 

That will give you the data segmented by month as opposed to just a monthly average for the time period.

 

Is this what you were looking for?

Re: Keyword planner report excel trends

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

You are a bloody genius!! Thank you so very much Smiley Very Happy

Re: Keyword planner report excel trends

Participant ✭ ✭ ✭
# 4
Participant ✭ ✭ ✭
Haha,

Glad I could help.

Re: Keyword planner report excel trends

Explorer ✭ ☆ ☆
# 5
Explorer ✭ ☆ ☆

Cut and paste the keywords in your adgroups into the Keyword Planner and you also get what you are looking for.