How can I easily combine moz page difficulty, google search volume and SERPS position?

[Zippy-Bungle]

I want to produce an excel spreadsheet that I can use to identify the best use of my content  Writing time.

So Looking at a keyword list I want

• Current SERPS to show me where I am now?
• moz page difficulty score to show how hard I'll have to work
• google traffic estimate so that I can see the potential payoff.

I can can generate all these separately but combining them is a huge time waster as invariably the results don't come back in quiet the same order and a line by line check is required.

Part of the reason for doing this is keyword exploration so that we can find new niches by generating hundreds or thousands of keywords to test.

[JVRudnick]

Egol....your #4 - content that I will enjoy producing is SO very important....I'd a put it up at #1!

[Zippy-Bungle]

Totally agree - if it isn't fun to write it's usually shit to read

For us there are two factors - the product keywords that bring in the leads and new customers. and the interesting articles that keep our existing customer base engaged. I like the Venn diagram approach and can see how it will help with both

[EGOL]

I want to produce an excel spreadsheet that I can use to identify the best use of my content  Writing time.

How to spend your content writing time?

My approach to this is very different.  I use subjective judgements rather than numbers of debatable quality.

My content plan is more of a Venn Diagram that maps the intersection of these things....

1. content that my website needs to be a more complete resource (search volume is important here, but people don't always search for what is important)

2. content that I believe my visitors will consume (visitor behavior is important here but content that will surprise and delight is a fantastic force that stimulates sharing)

3. content that aligns with my subject matter abilities

4. content that I will enjoy producing

Items #1 and #2 cover organic search and social sharing.  They also inform professional development and other investments that facilitate #3.  But, #4 is the most powerful force in getting things done and getting them done well.  If you don't have #4 then you have a race horse in front of a plow.   You ain't the guy or the team for this website.