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
-
Conflicting average position data from Google Search Console?
I'm looking at Google Search Console data in Google Analytics, specifically Average Position as given in the Landing Page report, and the same metric broken out by mobile and desktop in the Devices report. In the Landing Page report, I see an aggregated average position that's much higher/worse than an actual average of what is reported for mobile, desktop and tablet traffic under the Device reporting. For example: Mobile: 5 Desktop: 5 Tablet: 5 So the average still should be roughly 5, right? Why would the Landing Page then show an aggregate Average Position of 8? I wouldn't expect to see a precisely same average given that different device types have different proportions that could render differently when the buckets are combined, but this is a huge swing. In fact, the aggregate Average Position as given in the top level Devices report is closer to 5 than to the 8 shown in the Landing Pages report. (These aren't actual numbers, but are illustrative of what I'm seeing, by the way.) Unless I'm missing some vital difference in the way that Average Position is reporting for the Landing Page report versus the Device reports, it doesn't seem like this should be possible. What am I missing?
Reporting & Analytics | | BradsDeals0 -
Direct traffic spam on Google Analytics: how can you identify and filter it?
One of my smaller clients noticed a huge jump in direct traffic visits last month. The bounce rate was around 97% so I'm pretty certain that most of the traffic was illegitimate. I know how to filter out spam referrals and organic keywords in Google Analytics. However I'm not sure what to do about direct traffic spam. Are there recommendations for filtering this out? Can I identify spam IP addresses?
Reporting & Analytics | | RosemaryB0 -
Why is Google Analytics showing index.php after every page URL?
Hi, My client's site has GA tracking code gathering correct data on the site, but the pages are listed in GA as having /index.php at the end of every URL, although this does not appear when you visit the site pages. Even if there is a redirect happening for site visitors, shouldn't GA be showing the pages as their redirect destination, i.e. the URL that visitors actually see? Could this discrepancy be adversely affecting my search performance? Example page: http://freshstarttax.com/innocent-spouse/ shows up in GA as http://freshstarttax.com/innocent-spouse/index.php thanks
Reporting & Analytics | | JMagary0 -
Google Analytics traffic hijacking?
Ran into something interesting a week ago - the same Google Analytics code was installed on two different sites by accident. The account was reporting traffic from both domains. Haven't found a definitive answer on how to stop this yet if it were to be used maliciously?
Reporting & Analytics | | khemistry0 -
Re-branding with Google Analytics
GM Mozzers, I apologize in advance if my description of this issue is confusing, but I'm doing my best here. Anyway, due to legal reasons, one of the publications I manage was forced to change their name. We set-up a 301 redirect from the previous domain and have also set-up an analytics profile for the new domain, however, as it stands, visits to the old domain outnumber those to the new domain 12:1. Is there anyway to set-up my analytics profile to the new URL so that this traffic is being attributed to the new domain and the new site, since, after all, it is a redirect. I hope that I explained this sufficiently. Any and all insight will be very much appreciated. Thank you in advance.
Reporting & Analytics | | NiallSmith0 -
Setting up Google Analytics default URL
If someone has set: the default url in Google Analytics to a non-www address (http://mysite.com) then placed the UA tracking script from that GA account within the CMS framework of the website... ... and then set the permanent 301 redirect in the htaccess file to redirect to the www address (http://www.mysite.com). How less accurrate will my GA analytics measurements be considering the default url within GA is non-www and the permanent 301 redirect in htacess is to the www-address? Anyone know how reliable GA reports are until the default url in GA analytics is changed to match what is the redirected url in htaccess file? _Cindy
Reporting & Analytics | | CeCeBar0 -
Search for signed in users
"As search becomes an increasingly customized experience, particularly for signed in users" What does this imply ? Does it mean that search is more customized for signed in users than those for non signed in users ?
Reporting & Analytics | | seoug_20052 -
Google +1 and ranking effect .
Anyone have any experience as to what effect google +1 has on ranking? Trying to figure out what impact it might have. Ecommerce site in norway selling childrens clothing. Atm we are ranking 25th for main targetted word childrens clothing (barneklær in norwegian). on google.no this has a difficulty of 34. None of main competitors have any amount of google +1's on their site. Lets say if I in some way could manage to get 100 ppl to push +1 button. Would this affect our ranking at all ? Might be impossible to answer but if anyone has thoughts about it I am interested. Thanks
Reporting & Analytics | | danlae0