Tracking Keyword Positions
-
Hello!
I've been working with the various Google Docs Spreadsheets out there taking advantage of web scraping using xml and the seomoz api.
I want to be able to track keyword rank by week, I've been playing around but can't seem to get it nailed on, I'm looking to put keyword in column 1, domain in col 2 and keyword rank on google uk in col 3.
Anybody done/seen anything like this in a G spreadsheet?
Cheers
Jamie
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
-
What's the best way to search keywords for Youtube using Moz Keyword explorer?
I want to optimize my youtube channel using identified keywords, but I'm concerned that the keywords I'm identifying work well for SERP's but might not be how people search in Youtube. How do a distinguish my keywords to be targeted for Youtube?
Moz Pro | | Dustless0 -
Can appropriate alt text be considered keyword stuffing?
Hi all, I just used the Moz page grader on this page: http://giavan.com/collections/earrings/pearl for the keyword "pearl earrings". It's grading it a "B" and the most important issue is "Avoid Keyword Stuffing in Document". The keyword appears once in the title, once in the H1 tag, twice in the body and 31 times in alt image text. We've recently been taking the time to add alt text to all product images by simply copying the product name. So if the product name is "Pearl & Crystal Beaded Drop Earrings", that text is copied and pasted as the product image's alt text. This seemed like the best way because it's highly descriptive and obviously, quick to implement. But if search engines see this as keyword stuffing, I guess we should rethink it. I don't know why Google would have a problem with this - it doesn't negatively affect the user experience and clearly those alt tag are serving a specific purpose. Still, the Moz grader doesn't seem to like it so if anyone knows the best way to handle this (or ignore it?) I'd really appreciate your help. Thanks!
Moz Pro | | RichAlbanese0 -
My Keyword Stats are Lagging?
In several of my PRO campaigns, I'm noticing that my keyword traffic stats are several weeks behind. Any idea what is causing this? Here's today's report from a campaign: Any help or explanation is great. Thanks!
Moz Pro | | jeffpic0 -
Can you export a keyword rankings report with the keywords listed in order of ranking ?
My keyword ranking report shows the results all jumbled. I can put them in order when viewing the report online, but when I export it , the results go back to all jumbled rankings.
Moz Pro | | jlane90 -
Is it possible to track and rank internal links?
Trying to create my cornerstone pages and I'd like to see which pages have the most internal links already to get started. Is there a tool for this?
Moz Pro | | hyperthalamus0 -
SEO process suggestions / keyword analysis
hi all, we've done a bit of SEO over the years for our site, and are looking to pick things up this year and spend more time on SEO. first off, we are working on revising our keyword list & would like to view what keywords specific competitors are ranking for and try to target those keywords as well. is this possible via SEOmoz (similar to spyfu)? please let me know if you feel this is a good first step in picking up our SEO efforts for the new year. i've been looking at the research tools & is seems the Keyword Difficulty Tool hasn't been fully functional for the past week or so ("Our Keyword Difficulty Tool is having issues displaying AdWords API data. We are working with the AdWords API folks to get a fix soon!"). also, i noticed i can enter competitor sites in open site explorer & compare link metrics, but i don't see anywhere to compare keyword metrics. is there something i'm missing? thanks again everyone!
Moz Pro | | lsat0 -
How do we use SEOmoz to track Local Searches? Is there a way to set the location from which the campaign tracker is "searching"?
It seems that there is no way to set a parameter for location. In Places, I'm able to define my targeted region. How does SEOmoz mimic that localization? Thank for any help! -- Chris
Moz Pro | | ChrisPalle1 -
Keyword Update More Frequent?
I think it's extremely important to be aware of any change in ranking ASAP is there any way to have SEOMOZ Pro update more often than once a week?
Moz Pro | | montage0