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
-
Unsolved How to find keywords your competitors rank for but you don't?
Hi, I'm just digging through Moz pro at the moment, and really like the true competitor feature, but would like to be able to see the keywords our competitors rank for and we don't, rather than just the overlapping ones. Is this possible at all? Thanks
Moz Pro | | pm-mbc
Paul0 -
What is considered a keyword score that is too competitive?
I'm researching my keywords trying to strategise content around keywords I can optimise. Most of the high search volume (1000 + searches per month) keywords I want to optimise are in and around 0.5-0.6, is this good? Is this score range considered highly competitive...?
Moz Pro | | JordanStodart10 -
How can I limit the impact of Google's mobile friendly updates on keyword rankings?
Hi everyone, I have a client on a monthly SEO package that is taking a hard hit in the rankings as their website is not mobile friendly. We are currently building a new website for them that will be fully responsive, but face the predicament of how to keep the current site performing relatively well in the rankings in the meantime. The site is generally well optimised and we always follow SEO best practices, so we've hit a bit of a stumbling block as to how to limit any negative impact the mobile friendly updates have on the site. Does anyone have any suggestions for damage limitation? Any help will be greatly appreciated. Thanks.
Moz Pro | | keyzo0 -
Is there a tool that tracks and records your links to your site
What I mean by this is we have a linkbuilder working for us and I'm looking for to record there progress with link building I've seen somthing in Majestic but is there one in SEOMOZ All teh best Steve
Moz Pro | | ibexinternet0 -
Keyword tool: SEOMOZ spacific month ? vs adword tool 12 month average but same data ???
Running a keyword analysis in SEOMOZ it shows my the folowing information "Local Search Volume (Dec)". I compared the data for the specific country , language and keyword with the adwords keyword tool and it exactly showed me the same numbers. The adwords keyword tool shows: "Local Monthly Searches: This column shows the approximate 12-month average number of search terms matching each keyword" http://support.google.com/adwords/bin/answer.py?hl=en&answer=25148 So if the numbers are the same in google keword tool and SEOMOZ why is SEOMOZ saying that for a specif month? If the data is the same one of both can not be right or probaly I didn't get the point. See screenshot: http://screencast.com/t/GyaaW7EkwV Thanks for help
Moz Pro | | n-media0 -
Why Do Domain Link Metrics Differ in Keyword Difficulty Report vs OpenSiteExplorer
If anyone could shed some light on this that would be great. It seems as if the two tools are using different versions of the database?
Moz Pro | | belasco0 -
How can I change (specifically, decrease) the reporting/crawling frequency of the keyword ranking?
It always seem to compare the standings based on the week before, which confuses the issue when I'm only reporting monthly or quarterly. Is there currently (or might there be in the future) a way to set this so that the comparison is based on a time period that I specify?
Moz Pro | | MackenzieFogelson0 -
Where do I find "URLs Receiving Entrances Via Search" and "Non-Paid Keywords Sending Search Visits" in Google Analytics?
These are two metrics highlighted in the "Organic Traffic Data" report in the PRO campaigns. Since this report is composed of data linked from Google Analytics, I bet there's a way to find this same information in GA. So...anyone know how to do that in Google Analytics? I want this information for some long-tail productivity/potential research.
Moz Pro | | jcolman0