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
-
Non-Interaction Virtual page views
Hello, I would like to know if it is possible in Google Analytics, to generate "non-Interaction" Virtual Page views. In other words, Virtual Page Views, that do not affect the bounce rate (exactly like when we set "non-Interaction": True when we fire an event). I am presently fixing a Google Analytics implementation, where virtual page views were used all over the place instead of events. I am pulling my hairs. Cheers Luca
Reporting & Analytics | | Lvet0 -
Google Search Console All Verfication Methods Failed
Hi Guys, We are trying to get google webmaster tools verified for this site: https://www.nookie.com.au/ We have implemented the recommended: HTML tag from Search Console which is: Which is installed see: http://prntscr.com/g66cle However, verification still failed. We then tried Google Analytics (failed), alternative methods (HTML file upload failed) Google Tag Manager. All failed. I have no idea why this has happened, any ideas? Cheers.
Reporting & Analytics | | jaynamarino0 -
Google Tag Manager Tracking
We have Google Tag Manager set up to track our website https://kontenta.co.uk/ Although we have a blog - https://kontenta.co.uk/designroom/ I'm just wondering if it's better to track the sites separately? If so, how do I add the blog to tag manager? Does it need setting up as a filter to match the regular expression https://kontenta.co.uk/designroom/* We just need to figure out the best way to measure both the website and blog traffic and if users are coming from the blog to the site, and what interactions they are making. Thanks
Reporting & Analytics | | Jseddon920 -
Can not divide in different properties a domain in Search Console (Webmaster Tools)
Dear Moz Community, I hope you can give me a hand with the following questions. Im in charge of SEO of an ecommerce site in LATAM. It´s service is available in several countries, therefore each country has it subdirectory Eg. /ar /pe /co /bo /cl /br,etc... (in the future we will move to differente ccTLDs). I have been recomended to split or create different Search Console or Webmaster Tools properties (one for each subdirectory) but when Im creating a new property with a subdirectory, lets say www.domain.com/ar, Webmaster tools starts creating a property for www.domain.com/ar/ (NOTICE THE LAST SLASH) and it returns since that page doesn´t exist, what do you recomend me to do? Best wishes, Pablo Lòpez C
Reporting & Analytics | | pablo_carrara0 -
Google analytics - landing pages
Hello, I have a website and it contains landing pages. after tracking and analyzing the data in Google Analytics , I found out that the traffic for the whole site is affected by the visits to the landing page. I mean, the bounce rate is less than one minute. this is because users fill their details in the landing pages and leave my website. to improve my website, I need clear data about the traffic, bounce rate etc. in my website. I also need can you help me solve this problem I thought about create another account in Google Analytics and set it to my websites pages (not including the landing pages). and keep the current code for the landing pages. my question is regarding this: Is it legal to use 2 different GA code (each one of them belong to different account) in the same domain ? can you provide me with more information about Multi Account in Google Analytics, and how can I use it to divide the traffic in my website between the traffic and the data for the landing pages and for the website itself ?
Reporting & Analytics | | JonsonSwartz0 -
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 -
Google Analytics All Kinds of Messed Up
Anyone have their google analytics go straight crazy on Thursday, 8/11/2011? 30% increase in visits No increase in visitors Huge drop in pageviews and time site Higher bounce rate More return users
Reporting & Analytics | | ChrisKolmar0 -
How to measure number of visits from Google News coming from Google Universal Search (NOT referral coming directly coming from news.google.com) with google analyitcs
I'm running a news site, and I have a problem of accuratly measuring which traffic is REALLY coming from google news. I analyzed a lot of individual articles and I come to the conclusion, that the visits, that come from the google news section in the universal search results are counted as "normal" search engine traffic in google analytics. So if you do a Google search for a topic that includes links from Google news, you don't get an accurate referral count. As an example, if you do a search for "eBay", incorporated into the page 1 search results you may also see Google news results as well.
Reporting & Analytics | | Mulle
If someone clicks on that Google news link that appears in Google search, it shows up in Google analytics as a referral from Google search, when it was actually from a Google news referral. I was already checking google analytics and google news help forums and searched SEO blogs for this. But I wasn't able to find a working solution. Can anybody help me out with this problem? Thanks so much, Matthias0