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
-
Keyword Research and Planning Flow
Hello, First post here. I am a IT infrastructure engineer that does application and deployment work mostly, but new to SEO. That being said, I am a firm believer in demming wheel and defined process/flow charts. I have a website up, built as best practice, its a Magento CE open source Ecommerce store. After some initial research, it seems I really need to define my keywords before I start branding my landing pages and such. So i am going to have to go back and implement the keywords and evaluate. But as I am reading it seems most SEO people try their keywords in google ad words first? Then implement? I am hoping to find some flow or process sheets on how successful Keyword research is done via step by step process and evaluation. And explanations of each. How many keywords to start with per landing page, how many to try and get in the H1 headers, paragraphs, URL. How long to leave keywords in to test? Also, I am a start up company that is competing with the big boys in my market space. I know I cant compete for the big keywords in my market? What is my best strategy for getting any kind of ranking as a small business in a global market? SEO is a mysterious, intriguing thing to me! Very much reminding me of one of my favorite whimsical quotes I will leave you will now, and thanks for reading. -Alex "Invention, my dear friends, is 93% perspiration, 6% electricity, 4% evaporation, and 2% butterscotch ripple." - Willy Wonka
Moz Pro | | iamgreenminded0 -
Tools for Monitoring Hundreds to Thousands of Keywords and Rankings
Hi All, I am in process of doing and SEO overhaul for our five global sites in: US, UK, Canada, Sweden, France I'd like to track hundreds of keywords and rankings per site - I'm talking at least 300-400 keywords each site. Each site has its own country domain with both www and www2 domains. So, I need a keyword tool that will let me track massive amounts of keywords. I know that the Moz Pro tool helps, but we only have 350 keywords on this account. I think on this. Any suggestions on something reliable that will provide good data? I'm sure I can get some budget to purchase something, but I also can't spend too too much money. I'm not looking for a massive analytics package. Right now, I'm concerned mainly with our keyword rankings Thanks in advance!
Moz Pro | | CSawatzky0 -
Is the keyword ranking number used for MOZ Pro an average position taken across the time period?
Hi there I am just trying to confirm how the ranking given in the 'rankings' report is calculated (an average etc). Thanks Sarah
Moz Pro | | Laurie-Tomahawk0 -
Accurate Google Keyword Ranking for a domain
Hi Folks, SEO N00b here, in a new job so please go easy on me if i ask stupid questions. I'm looking for some clarification on Google Keyword rankings. I am looking for accurate Google Keywords rankings as when I log into Google Webmaster Tools I am given values like (6-10) for a ranking? When I used SEOMoz (Research Tools -> Keyword & Ranking -> Rank Tracker) it gives me an even less accurate range by simply saying >#50?Why is SEOMoz giving a completely useless metric? Why is its actual rank not shown? I know rankings are becoming less useful as a metric with Google moving toward personalized search but I still have reports to deliver to clients so the conversation of what metrics are going in the report is to be had another day. Right now I just want to get accurate rankings, from what I've found online Google Webmaster tools is recommended as the de-facto ranking tool but it doesn't provide accurate results so how can that be (yes I know it averages out the ranking but 6-10 is a range of values not a single value that represents an average) Dave
Moz Pro | | icanseeu0 -
Branded keywords
I'm trying to understand this concept a little further. Say if I create a branded keyword, "dc widgets" I then start to add keywords such as "maker" "toy" and apply the branded keyword to it. Does this mean that they then become "maker dc widgets" and "toy dc widgets" ? What purpose does branded keywords offer?
Moz Pro | | priceseo0 -
Keywords rankings compared competitors not working
Hello, My keywords rankings compared competitors is not working : http://screencast.com/t/x88Z6tXB2r For months I've never have any stats in the competitors columns, why ? Thank you
Moz Pro | | JeanlouisSEO0 -
Keyword tool results - broad match or exact?
Do the SEOmoz keyword rankings display results for exact match or broad match?
Moz Pro | | ClaytonKendall0 -
What SeoMoz tools should I use to track the sucess of my SEO efforts and find possible linking partners?
HI All, I am a new user to SEO moz pro and I have a few questions I hope you can help me with. We are adding a new product category to an existing site and I am wondering what tools to use to track our SEO efforts to build ranking for these new products. I have already started a campaign that tracks the ranking of our primary keywords but I am wondering if there are other tools I should be using as well. Currently our SEO strategy is centered around link building. I have been approaching sites that have content related to our products and offering to write articles, guest blogs, and create educational resources that benefit the sites users and have specific anchor text linking back to our site. Since we are trying to build rank for a new category of products should I be linking to the general product category page or should I try to link to sub categories or individual products? Also I have used the juicy link finder to help me identify related sites that I can approach but I haven't received very many good leads. Is there a more specific way to use the tool or another tool that I should try? If you have any suggestions about other SEO strategies/activities that we should be pursuing please share your ideas! Thanks!
Moz Pro | | AndrewY0