In this tutorial, we will get Google and excel work together. Google allows us to download files from your Analytics account as CSV sheets which you can open in any spreadsheet program like Microsoft Excel. An very useful fonction to keep an offline record or carry trend analysis upon the data. If you do that quite often, there is a way by which you can skip the entire step of logging into your Analytics account from a browser, generating a report and downloading it to your computer. Instead, you can import that data directly into Excel.
- At first,install a free Excel plug-in called Excellent Analytics. You will also need Microsoft Office 2007 or higher and .Net Framework 4.Once you have installed Excellent Analytics, open Microsoft Excel and locate the Excellent Analytics tab on the ribbon. Click on “Account” and enter the Google ID and password you use to login to your Analytics account.
- A Query window will pop open where you will be able to select the data you wish to pull into Excel. We will use Excellent Analytics to retrieve a list of pages.The first thing you need to do is select your website (profile) from the drop-down list on top, in case you have multiple sites tracked by Google Analytics. Also choose the start and end dates from the calendar, or click on Time Span and choose a time period.
- Click on the Dimensions tab, expand the item “Content” and select the box next to “landing page path”
- Move over to the Metrics tab, expand the item “Visitors” and select the box next to “pageviews”
- Choose Maximum results to retrieve. Remember that if you choose a huge number like the default value of 10,000 it can take a long time to download. Choose a more practical figure like 100 or 1000 or 500.
- Click on the Sort by drop-down menu and choose pageviews. Then click the button next to Sort order so that it shows Descending as shown in the screengrab above.Now all you to do is click on Execute, wait a few moments and your report is ready.
- If you want to retrieve a different set of data, say, a list of keywords that visitors used to arrive at your site from search engines, then go to the Dimensions tab, expand the item “Campaign” and select the box next to “keyword”. All options you find on your Google Analytics account from the browser are available from this tool.
If you want to track the ones are coming to your site and the way that used to get there and for what they’re searching, now Google provide an
useful tool Google Analytics to enable you to solve the problem mentioned before. For using it, you need to set up a Google Analytics Account firstly. So this article will guide you to achieve it.
When you work on the computer, have you ever born with you open a lot of windows? My Shortcuts of Google Chrome helps you solve it.
If you're a Chrome user, you can access Google Tasks directly with only one click.
Related Unresolved Questions