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
-
Does intercom support pages and redirect issue can affect the SEO performance of our website?
I noticed that in the redirect issues I have, most of the issues are coming from our Intercom support links. I want to ask, does intercom support pages and redirect issue can affect the SEO performance of our website?
Reporting & Analytics | | Envoke-Marketing0 -
How to analysis Product List position in Analytic for 2nd Page Clicks?
Hi All, While implementing Product list position when user move to 2nd page then position again start from 1st position so how I will know in google analytic that 1st Position clicked from 1st page, 2nd page, 3rd page etc and same way how do i know if page is sorted with highest or lowest price? I am talking about given below position. dataLayer.push({ 'ecommerce':{ 'currencyCode':'EUR', // Local currency is optional. 'impressions':[ { 'name':'Triblend Android T-Shirt', // Name or ID is required. 'id':'12345', 'price':'15.25', 'brand':'Google', 'category':'Apparel', 'variant':'Gray', 'list':'Search Results', 'position':1 }, Regards, Mitesh
Reporting & Analytics | | Arnold30 -
Crawl errors for pages that no longer exist
Hey folks, I've been working on a site recently where I took a bunch of old, outdated pages down. In the Google Search Console "Crawl Errors" section, I've started seeing a bunch of "Not Found" errors for those pages. That makes perfect sense. The thing that I'm confused about is that the "Linked From" list only shows a sitemap that I ALSO took down. Alternatively, some of them list other old, removed pages in the "Linked From" list. Is there a reason that Google is trying to inform me that pages/sitemaps that don't exist are somehow still linking to other pages that don't exist? And is this ultimately something I should be concerned about? Thanks!
Reporting & Analytics | | BrianAlpert780 -
Does Lightbox Gallery Clicks Count Positively Toward Page Rank?
When a user clicks through a lightbox gallery, are these counted as a click through for page rank? I am using WonderPlugin Grid Gallery on multiple pages with multiple galleries. I do not want these clicks to be wasted. Please advise. Regards, Clever Name SEO www.clevernameseo.com
Reporting & Analytics | | cindymariesilva0 -
If I install google Analytics, that can affect my SEO.?
I purchased a site that has a lot of Backlinks and when I started to make changes like installing google analytics! i suspect the performance in search engine was getting worst because of that, so I removed.
Reporting & Analytics | | pparma
Now I'm trying MOZ and needs GA, should I install it again??
Maybe it analyces the backlinks and tells google, I don't know, is that possible?0 -
SEO Moz Errors
We have SEO Moz Errors and warnings showing up, yet we have cleaned them
Reporting & Analytics | | RNK
up. The same errors were showing up in Google's Webmaster tools but after we corrected them they do not show up as crawl errors in Webmaster tools.
Why is SEO Moz different and why does it continue to show corrections already made.0 -
Google Analytics Tracking Code Queries
Hello, I have taken on a new client who has Google Analytics installed. The tracking code is set to 'single domain'. Recently they added a mobile site using a sub-domain (m.website.com) which means that Google Analytics is not picking up this traffic. I want to revise the account so that I have a master account (raw data) and then profiles for the mobile site, main domain (www.website.com) and one other for a sub-domain that they are using. I am aware that there is mobile specific tracking code however I thought it would be easier (re conversions/goals/eCommerce tracking) to not use this and by changing the account to 'multiple domains' we could also get data for another sub-domain that they are using . My questions are: Am I right to want to use individual profiles over web properties. If not please explain why. When installing the tracking code (where the profile number is changing) I believe that I need to add that code with the changing profile number to the sub-domain sections. So my question is a) is that correct, and b) if I use a profile number on a sub-domain section will the master account still gather the data for the main URL as well as all sub-domains. If I change the master account from using 'single domain' tracking code to 'multiple domain' tracking code will this affect historical data? Will I lose the data? When changing from 'single domain' tracking to 'multiple domain' tracking does this affect eCommerce tracking? Or do we only need to be adding the additional lines of tracking code that allow sub-domains to be tracked? The web developers are using asynchronous code however half is in the and the other half is at the bottom of the source code. Given that traffic is being reported in the Google Analytics account should I have any concerns that the code is split? I have done a lot of reading but seem to be going around in circles, so your help is much appreciated! Thanks,
Reporting & Analytics | | Unity
Dinny0 -
What to get from google Webmaster tools?
Hi everyone, I've been doing optimization for our websites and tracking the results regularly but don't really know what the results actually mean. I heard that I need to check the traffic and organic results from Google analytics and Google webmaster tools. Everybody says something and not sure what to do? Is there anyone clarify the SEO process for me - when to do what and why in simplest way? Thanks in advance,
Reporting & Analytics | | WTGEvents0