| A | B | C | D | |
|---|---|---|---|---|
1 | Google Analytics for Google Spreadsheets | |||
2 | Template created by Jamie Steven at SEOmoz. Tutorial available at: http://xy.cm/txeXcU | |||
3 | Powered by Google Analytics Data Fetch Functions by Mikael Thuneberg - http://xy.cm/s6j1sL | |||
4 | Settings | |||
5 | ||||
6 | Google Analytics Username | |||
7 | After you've entered your password, you may hide this row to obfuscate your password. | Google Analytics Password | ||
8 | Google Analytics Profile ID | |||
9 | ||||
10 | Auth Code (Do not edit!) Error messages are displayed here. If you see a long token, you have successful entered your credentials. | Loading... | ||
11 | ||||
12 | ||||
13 | Instructions | |||
14 | Detailed information is available at: | http://xy.cm/txeXcU | ||
15 | 1) Once you've first open this document, make sure you're logged into your Google account by checking the top right hand corner of this browser window. | |||
16 | 2) This spreadsheet is uneditable until you make a copy. Choose File... Make a copy... to save this spreadsheet to your own Google account. | |||
17 | 3) Give the browser a few moments to make the duplicate copy. Once the copy is created, enter your Google Analytics username. | |||
18 | 4) Enter your Google Analytics password. Once entered, you may hide that row to obfuscate your password. | |||
19 | 5) Enter your Google Analytics Profile ID. Details on where to find the profile ID in this blog post: http://xy.cm/txeXcU | |||
20 | 6) Once the area below the Profile ID shows an Auth Token (a very long alphanumeric string) you are ready to access your Google Analytics data. Open the "Custom Report" tab at the bottom of the browser to begin. | |||
21 | ||||
22 | ||||
23 | Please Note | If you encounter some issues, ensure you are logged into the same Google Account for which you are trying to access. If you still have issues, such as a CAPCHA warning, wait 30 minutes and try again. | ||