Multi-View Queries [Core Add-in]

Some of the connectors support multi-view (Google Analytics Pro) or multi-customer (Google AdWords) queries. To do this, you need the Analytics Edge Core Add-in.

Get a List of Views/Customers

Start by getting a list of view ids or customer ids. For example, to get the view ids available for a specific Google Analytics account, you can use a Google Analytics Pro > Management Lists query.

account-summary-query

Note: you can use the Table > Filter function to remove any entries you do not want.

Alternative: load the list from a worksheet using the File > Read Worksheet function.

account-summary

Note the Column Name

Pay special attention to the name of the column containing the view ids or custom ids. The Core Add-in can use this column name as a source for the query — just enter it with square brackets around it, like [webProperties/profiles/id], instead of a cell reference value.

Continue to build your query. When it is run, The Google Analytics Pro connector will add 2 new columns to the results: the View ID and the View Name.

multi-view-query-results

Save Your Results

Remember to save the result to your workbook using the File – Write Worksheet function, or continue working with the data using the many other Core Add-in capabilities.