To query Google Analytics data, you can use the Query Builder as you would with other data sources, or you can use the Database Explorer (Viewer). The Database Explorer allows you to build a multi-dimensional pivot grid to view the data from a selected Account View. You can then save the view as a Query or send it to the Query Builder where you can join it with other Account Views, other Queries, or other data sources.
Saved Queries appear in the Object Explorer when you are connected to the original Google Analytics data source.
To view Google Analytics data (build multi-dimensional grid)
First, select a range from the Date Range list. The default is Last Month.
Note: A Google Analytics query must contain a date range. For a list of special date ranges supported by Toad, see Google Analytics Date Ranges.
To view the data, click Refresh in the wizard bar.
To create and save a Query
In the Create Saved Query dialog, enter a name and a comment (optional), and then click Execute. The saved Query is added to the Queries node in the Object Explorer.
Note: The Query name must be unique. A Query cannot have the same name as an Account View or another Query.
To send to the Query Builder
After building the multi-dimensional view, click Send to Query Builder in the Wizard bar to send the query to the Query Builder.
Note: By default, the date column is excluded from the result set in the Query Builder. To add it, select the Visible checkbox in the date column.
To send a saved Query to the Query Builder
Note: If you use the Editor to write a SQL statement, each Google Analytics Query must have an alias.
To build a Google Analytics query in the Query Builder
If you drag an Account View, a date column is automatically added. To modify the date range, click in the Where field in the date column and specify another date range.