Jump to content

  • Log in with Facebook Log in with Twitter Log In with Google      Sign In   
  • Create Account

Subscribe to HRA Now!

 



Are you a Google Analytics enthusiast?

Share and download Custom Google Analytics Reports, dashboards and advanced segments--for FREE! 

 



 

 www.CustomReportSharing.com 

From the folks who brought you High Rankings!



Photo
- - - - -

"search Volume Trends" In Google Adwords Keyword Tool


  • Please log in to reply
No replies to this topic

#1 BlueHorseradish

BlueHorseradish

    HR 2

  • Members
  • PipPip
  • 31 posts
  • Location:Philadelphia, PA

Posted 25 February 2009 - 01:41 AM

Delving a little deeper into the Google Adwords Keyword Tool (adwords.google.com/select/KeywordToolExternal) and in particular, the green bars in the "Search Volume Trends" display. Trying to understand the data in those green bars - can the historical data be calculated?

If you turn on all the columns in the Choose columns to display, you see:
Keywords
Estimated Ad Position
Estimated Avg. CPC
Advertiser Competition

Then, the keyword info:

Approx Search Volume: January ( <<< note: current month is Feb 2009, so it's giving the previous month's volume)

Approx Avg Search Volume
(from the ? Help icon: This column shows the approximate average monthly number of search queries matching your keywords that were performed on Google and the search network over a recent 12-month period. This number is specific to your targeted country and language as well as your selection from the Match Type drop-down menu. )

Search Volume Trends
( <<< the green bars ) (from the ? Help icon: This column shows a keyword's fluctuation in traffic over a recent 12-month period. Each bar represents a different month, and the month with the highest volume of traffic is listed in the next column. )

Highest Volume Occurred In ( <<< the month is supplied here )

The green bars
When you look at the 12 green bars, you might figure those are the most 12 recent months or the year calendar. But if you rest your cursor on them from left to right (or export to file and check the column headers), you see:
Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct

So, does that first bar mean Nov 2008 or Nov 2007? Is the last one Oct 2008? If it was supposed to be showing the bar for Nov 2008, wouldn't it make sense to have it to the right of Oct, followed by Dec? If it's Nov 2007 and the bars are in proper chronological order, what happened to the data for Nov 2008 and Dec 2008? Remember it's Jan 2009 and they are showing that as the most recent month, so Nov and Dec 2008 must have been available and displayed previously.

If you export the data, say to a CSV file, the bars are represented numerically by either a 1 for the month with the highest search volume, and some number between .01 and .99 for all the other months, based on how it compared to the month with the highest volume. So if May is the highest, it is a 1, and if July has 3/4 of May's search volume, it would be .75 in the file data.

So, if you have the Approx Avg Search Volume and the relative traffic for each month, shouldn't you be able to calculate the search volume in each month? I think it can be done, just not exactly sure how to do that.

Post back if you can figure it out.
Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

SPAM FREE FORUM!
 
If you are just registering to spam,
don't bother. You will be wasting your
time as your spam will never see the
light of day!