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
Function Wizards (filter at right)
1 Add a Google Analytics Account
Once you have installed and activated the trial for the Google Analytics connector, you need to log in to your Google Analytics account. More
2 Your First Google Analytics Query
Make your first Google Analytics query (be sure to create an Account entry first). More
Accounts – Google Analytics
Use this wizard to log in to your Google Analytics account and authorize Analytics Edge to access your data. More
Analytics Reporting – Dates
Use this Analytics Edge wizard to establish the date range for the report. More
Analytics Reporting – Dynamic Segments
Analytics Edge makes it possible to create dynamic segments using a a wizard interface similar to that in the web version of Google Analytics. More
Analytics Reporting – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More
Analytics Reporting – Filters
Use this Analytics Edge wizard to define filters to use with the query. More
Analytics Reporting – Options
The Options tab provides access to several options that affect how the Google Analytics data is presented in Excel. More
Analytics Reporting – Output
The Output tab (available only in the Google Analytics Pro Connector) offers the ability to download direct to a CSV (comma-separated) file instead of returning the results to Excel. More
Analytics Reporting – Reports
The Reports tab lets you quickly select common dimension and metric combinations that you can use as-is or use a starting point for a custom report. More
Analytics Reporting – Segments
This Analytics Edge wizard is used to select a predefined Google Analytics segment from your account, or to define a dynamic one to be used solely for this query. More
Analytics Reporting – Sort
Use this Analytics Edge wizard to select the sort order to use for the query. Additionally, you can restrict the query to download a limited number of rows i.e. the top 10. More
Analytics Reporting – Views
Use this Analytics Edge wizard to select the Login account and the reporting View to use for the query. More
Bulk Queries – Dates
[Pro connector] Use this Analytics Edge wizard to establish the date range for the report. More
Bulk Queries – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query. More
Bulk Queries – Filters
Use this Analytics Edge wizard to define filters to use with the query. More
Bulk Queries – Options
The Options tab provides access to several options that affect how the Google Analytics data is presented in Excel. More
Bulk Queries – Queries
Use this Analytics Edge wizard to select the Query Configuration Worksheet for Bulk (multiple) Google Analytics queries. More
Bulk Queries – Segments
This Analytics Edge wizard is used to select a predefined Google Analytics segment from your account, or to define a dynamic one to be used solely for this query. More
Bulk Queries – Sort
Use this Analytics Edge wizard to select the sort order to use for the query. More
Bulk Queries – Views
Use this Analytics Edge wizard to select the Login account to use for the query, plus the Account, Property, and View. More
Convert Excellent Analytics
[Only available in the Free Google Analytics connector] Use this wizard to convert existing queries built with Excellent Analytics into Analytics Edge queries. Select the cell below the Excellent Analytics query cell and open the wizard. More
Enter Data Source Schema
Entering the Google Analytics data source schema into Analytics Edge makes it easier to upload data by automatically populating the target column names to match the schema. More
Management Lists
The Management Lists wizard allows you to download information about your account(s), web properties and views. Select the Login to use for the query, then pick the Account, More
MCF Reporting – Accounts
Use this Analytics Edge wizard to select the Login you want to use for the query, plus the Account, Property and View.
MCF Reporting – Dates
Use this Analytics Edge wizard to establish the date range for the report. More
MCF Reporting – Fields
Use this Analytics Edge wizard to select the dimensions and metrics to be retrieved in the query.
MCF Reporting – Filters
Use this Analytics Edge wizard to define filters to use with the query.
MCF Reporting – Sort
Use this Analytics Edge wizard to select the sort order to use for the query. Additionally, you can restrict the query to download a limited number of rows i.e. the top 10.
Save Filter
[Pro connector] Use this Analytics Edge wizard to save one or more view filters to one or more Google Analytics views. More
Upload Data into Google Analytics
To upload data into Google Analytics, select the Property and Custom Data Source (see Google Analytics help for details about custom data sources and uploading data). More