ABCDEFGHIJKLMNOPQRSTU
1
2
3
4
SEER SEO Toolbox
5
by: Chris Le (@iamchrisle) and Seer Interactive (@SEERinteractive)
6
Welcome, friends!
7
SEER Interactive created and has been using this toolbox since late 2011. We've made lots of ad-hoc SEO tools, reports, dashboards, and have done a lot of analysis with it.
8
9
It's evolved a lot since it was first created so there's a lot here. Check out www.seerinteractive.com/seo-toolbox to learn more.
10
11
12
How to get started
13
Don't worry. You only have to do this once. After that, you're good to go.
14
15
1. Make your private copy (*VERY* important step!)
16
This is so *ONLY YOU* can have access to your data!
17
18
A) Click on File > Make a copy
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
B) Name your copy, and click OK
35
Make sure there is *NO checkmark* next to "also copy document collaborators"
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
2. Add your own API keys and passwords
57
This tool uses your API keys and passwords.
58
(Um, that's why you made your own private copy. Right??? Hint: Follow step #1)
59
60
A) SEOmoz
61
- Login, then go to https://www.seomoz.org/api/keys
62
- Copy/paste your SEOmoz Access ID into Settings::B11
63
- Copy/paste your SEOmoz Secret Key into Settings::B12
64
65
HELP! My key doesn't work!
66
Did you just make a new key? Wait an hour. Sometimes Roger is busy working.
67
68
HELP! It still doesn't work!
69
Are you sure you typed it in right? Copy and paste it again.
70
71
72
B) Google Analytics
73
- Type in your username into Settings::B1
74
- Type in your password into Settings::B2
75
- Leave Settings::B3 blank
76
77
78
C) Majestic SEO
79
- Login, then go to https://www.majesticseo.com/account/api
80
- Place a checkmark next to "Enable API" on the Majestic SEO API page
81
- Copy/paste your API key into Settings::B7
82
83
84
3. You're ready to go!
85
Dive in! There's some examples on www.seerinteractive.com/seo-toolbox
86
Go to Sheet1, pull some data, and build some links!
87
88
(OK... now the fine print)
89
The MIT License (MIT)
90
Copyright (c) 2011-2013 Seer Interactive
91
92
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
93
94
(In other words.... do whatever you want to this code. It's yours for keeps. Seer Interactive is not responsible and cannot be held liable for any damage you cause yourself or others with it. That also means we can't support you, nor is anyone obligated to. But we put a lot of time into this so it would be really kind if you would follow @SEERinteractive and @iamchrisle and thank them)
95
96
97
98
99
100