Create a report with keyword, label, difficulty, global search volume, and ranking?

[promfgsystems]

Is it possible to create a report with containing keyword, label, difficulty, global search volume, and ranking?  Currently in order to get the data, it seems like I need to manage two lists, the keyword list we are tracking and the keyword list in the Difficulty tool then somehow manually combine the data.  Is there an easier way?

[Ray-pp]

Hi promfgsystems,

A report like that is not available within the Moz tools with all the information in one place. However, is you're familiar with Excel then combining a few reports together to create that dashboard is not very difficult with the help of Vlookups.

• Download the Tracked Keywords report - This will give you...

• Keywords

• Labels

• Ranks

• Download the Keyword Difficulty and SERP Analysis report - This will give you...

• Keyword difficulty

• Bring all your keywords to the Google Keyword Planner Tool - This will give you...

• Global search volume (Moz cannot shot Google search volume)

Then you would put all of these reports into a single Excel workbook and use a Vlookup to put the information into 1, simple report.

[promfgsystems]

Thanks for the reply.  I'm using the Bing Global Search Volume in Moz.  I found that the Google Keyword Planner tool is not accurate as the data is based on the particular adwords account.  I'll look into the excel vlookup feature.  What about the best way to make sure the keywords in the Moz Keyword difficulty list are the same ones being tracked in the tracked keyword report?

[Ray-pp]

The keywords would need to match exactly to make sure the Vlookup works properly. If you're tracking keywords that are not in the difficulty list / vice versa then the Vlookup would pull a N/A value, which would let you know the keyword is not on the list.

[promfgsystems]

Thank you.  I did get vlookup working with the two data sets and I do have some N/A values.  It's going to take some work to get all my tracked keywords into the difficulty list.  I wish there was a way to auto check the difficulty and bing volume for my tracked keywords and generate a report.  Your info helped a lot though.  Thanks

[Ray-pp]

Glad to see you got most of the reporting needed.

You may also want to submit a feature request over here and see if the community and Moz team can plan to implement your feature.