To get started with the Google Analytics connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Google Analytics button (Free or Pro) and select the Accounts menu item.
ADD AN ACCOUNT
Enter a Reference Name for the account and click the Add Account button. You will step through a Google Analytics login sequence to authorize Analytics Edge to access your account. *
* A note about security: an account access token is encrypted and stored in a file on your computer using the reference name you entered. Your workbook queries use the reference name, and during refresh, the connector looks up your access token and sends it direct to Google’s API server with your queries. Your access tokens are not stored in your workbooks, so you can freely share the workbooks.
MAKE A QUERY
In Excel, on the Analytics Edge ribbon bar, click the Google Analytics button (Free or Pro) and select the Analytics Reporting menu item. You can get a quick start by selecting from one of the preset reports, or step through the tabs to select the Views, Segments, Fields, Filters, Dates, Sorting and Options for your query. Click Finish when you are ready to make the query.