* Google Analytics Help

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.

More videos:
Basic Add-in  Standard Add-in  Core Add-in

ADD AN ACCOUNT

google-analytics-pro-menuWhen the Accounts wizard opens, click the Add Account button. You will step through a Google Analytics login sequence to authorize Analytics Edge to access your account. If a browser window does not open within a few seconds, copy the URL provided and paste it into your browser to perform the Google Analytics login and grant access to the connector.

 

* A note about security: an account access token is encrypted and stored in a file on your computer using the reference name you enter. 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.