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
-
In google analytic for google /cpc it is showing url with 404 which even not exists in my database
Hello All, In google analytic for google /cpc it is showing url with 404 which even not exists in my database that also more than 300 per day. How can it is possible? it is showing /black-friday-offers but I don't have such page. Thanks!
Reporting & Analytics | | pragnesh96390 -
Delays in Search Console Data
We are seeing big delays in search console data this month. In the past we have seen delays of a few days, but I have never noticed it being this long before. At the moment we have no data since 23rd February. Have I just never noticed this before or is this particularly long? Is anyone else seeing the same thing?
Reporting & Analytics | | Wagada0 -
Moz analytics showing joomla tag feature as duplicate page content
Moz Analytics is showing Joomla 3 tag pages as Duplicate Page Content because many articles are tagged with multiple words and therefore show up on the same tag-pages. example URL: www.domain.com/tag/tagID-tagname I already added "tag" as a URL parameter with Crawl=No URLs. Is there anything else I should do?
Reporting & Analytics | | modernmagic0 -
Exact match domains DOMINTATING the serps
For longer tail keywords with typical local monthly search volume of 50 or so, there are exact match domains that are just killing it. Take for instance "alabama registered agent", I'm showing www.alabamaregisteredagent.com in the first spot ahead of the state department, etc. This site has zero links in OSE (DA and PA 1) and is a very small site in general. Can anyone explain why this domain is doing so well?
Reporting & Analytics | | Harbor_Compliance0 -
How to hook up a ppc campaign to a google + Page
Greetings,
Reporting & Analytics | | Nightwing
Sometimes you just want to give Google a big slap for making straight forward requests damn impossible. So all i ma trying to ad is point a ppc ad at this Google + account <a>https://plus.google.com/118393512656496298734#118393512656496298734/posts</a> But i get a warning sign saying:
"The URL must be for a Google+ page, not a personal profile" I then spend half an hour tring to find a Google + page but get no where fast 😞 Warning message illustrated here:
http://i216.photobucket.com/albums/cc53/zymurgy_bucket/google-page-plus_zps46ff995a.jpg So my question is please how to a get the Google + page for this account:
<a>https://plus.google.com/118393512656496298734#118393512656496298734/posts</a> Any insights welcome!
David0 -
It appears there's a problem with our connection to your Google Analytics account. Please go to your Settings page to update your connection.
I keep getting this error though I have confirmed I have the correct information. Any recommendations?
Reporting & Analytics | | x3oadmin0 -
Google Analytics and backlinking
Let say I have my main site and my secondary site that is optimized for a slightly different set of keywords (nonetheless still relevant to my main site). I have several links from a secondary site to my main site. Secondary site is on a different C-block. Do you ladies and gentlemen think that if I put both websites under the same google analytics account, Google is going to penalize me or remove some of the juice that is flowing from secondary site to the main site because it would detect through GA that both sites belong to the same entity?
Reporting & Analytics | | SirMax0 -
How do shortened links show up in Google Analytics?
Hey, How do shortened links show up in GA? So if I tweet about something and use bitly, does twitter get the referral? I am thinking not. I have never seen bitly show up as a referrer, but we gets lots of clicks from those links. Hmmmm. Anyone? E
Reporting & Analytics | | ErinTM0