How can I easily combine moz page difficulty, google search volume and SERPS position?
-
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.
-
Egol....your #4 - content that I will enjoy producing is SO very important....I'd a put it up at #1!
-
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
-
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....
-
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)
-
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)
-
content that aligns with my subject matter abilities
-
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.
-
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Search my keyword on google
When I search my keyword on google I can see my website, but when I connect to a VPN and again search it, I'm not in the search result, what happens on my website?
Reporting & Analytics | | Pintapin0 -
Search console Search Analytics devices not showing mobile and tablet data since July 29th, have anyone noticed that too?
If you filter for devices in the search analytics at search console you get that from July 29th all the data is tagged as desktop and mobile and tablet have no data from that date. I see that for all my websites I have search console for, any input on that?
Reporting & Analytics | | amirbt0 -
Find Pages with 0 traffic
Hi, We are trying to consolidate the amount of landing pages on our site, is there any way to find landing pages with a particular URL substring which have had 0 traffic? The minimum which appears in google analytics is 1 visit.
Reporting & Analytics | | driveawayholidays0 -
Major practices which helps to index pages by google.
Actually, We have submitted more than 100 pages in to google through xml sitemap. But, we see in that 75% of the pages where indexed by google. Note : Excluding the duplicate pages
Reporting & Analytics | | Webworld_Norway0 -
Moz Rank & Trust | Page vs Sub vs Root
Hey guys, Just need some help deciphering my OSE link metrics for my site theskimonster.com . Page MozRank: 5.51 (highest among my competitors) Page MozTrust: 5.74 (#2 among my competitors) Subdomain MozRank: 4.19 (#4 among my competitors) Subdomain MozTrust: 4.63 (#2 among my competitors) Root Domain MozRank: 3.89 (#5 or last place among competitors) Root Domain MozRank: 4.1 (#5 or last place among competitors) What does this mean? What am I doing right, what do I need to do?
Reporting & Analytics | | Theskimonster1 -
How can i see queries what my visitors are searching for, in my website?
Google analytics installed, but they are not showing. What additional things should i add there? I need to see most popular search queries and add more content to these pages for panda.
Reporting & Analytics | | bele0 -
Number of Visitor Entries to page via search engine
Hi, I wanted to figure out the most optimal way to track the number of visitors that comes to a specific page on my blog via search engine only. I know Google Analytics has a "top landing page" filter, but that includes all visitors that comes in directly or other channels. Is there a way to figure out how many visitors a certain page received that was generated through only search engine? Does SEOmoz have this capability?
Reporting & Analytics | | kevinyu10290 -
Can you get local search numbers/traffic out of Google Analytics?
With Google's new local search I am more curious as to market penetration on keywords that are now localized to my different US cities. I understand that you can separate out Google traffic based on regional Google domains, but I am curious if there is an effective way to separate out searches and keywords based on a my local US Metros? If google cannot do this, any recommendations on products that can? Thanks.
Reporting & Analytics | | Thos0031