Google Analytics

Infoveave seamlessly integrates with various cloud-based servers, allowing you to effortlessly access, analyze, and derive insights from your cloud-hosted data. Infoveave supports Datasource creation from databases like Amazon Athena, Amazon Redshift, Data World, and Google Analytics in Infoveave.

Steps to Create Datasource from Google Analytics

Access Datasources

Note

The initial step involves crafting a foundational structure for your Datasource. This framework outlines the essential columns required for your Datasource. After finalizing this structure, you can proceed with the upload of the actual Datasource file.

• To access Infoveave Datasource types, navigate to Studio Datasource.All types of Datasources, created by you or shared with you will be displayed under My Datasources and Shared Datasources.
• To create a new Datasource, click on New Datasource.

Note

The configuration settings may change based on the file type you choose.

Connect with Google Analytics

Connect with Google Analytics to import the data table stored in Google Analytics Server for analysis, visualization, and reporting in Infoveave.

1. Choose Google Analytics under Cloud Services as the Datasource type.
2. A new window will open for the Datasource creation process.
3. In this window, you will all previously connected Google Analytics accounts (if any).
4. To start use an existing account, click on Use this property across the established connection.
5. If the token for the connection has expired, you can re-authorize it by clicking Re-authorize.
6. To add a new Google Analytics account, click on Connect new account.
7. A popup modal will appear, asking you to enter your Google Analytics credentials.
8. This will establish the connection between Infoveave and your Google Analytics account.
9. Once the connection is established, the dataset from Google Analytics will be imported to the Infoveave platform.You can view the Google Analytics dataset table with the following fields, Datasource Name, Type, Source Query, Display Name, and Import.
10. Name the Datasource, choose a name that reflects the data source for easy identification.
11. Under Type, you’ll find pre-defined measures, dimensions, and date dimensions from Google Analytics.
12. Customize the display names for any fields to make them more user-friendly under Display Name.
13. To select which data fields to import from the Google Analytics account. Use checkboxes to choose the data fields you need under Import.
14. Once you’ve configured all the required fields, click Save to create and save the Google Analytics Datasource in Infoveave.

Note

A Google Analytics account must be preconfigured to establish the connection.

Define Measures and Dimensions

Note

All the Measures and Dimensions for Datasource from Google Analytics are predefined within Infoveave.

Configure columns as measures and dimensions for effective data analysis and visualization. Add Hierarchies to group data in a structured way, allowing for drill-down capabilities and detailed analysis. Establishing relationships between tables is crucial for combining data from different sources and performing comprehensive analyses, and create calculated columns and measures to detailed analysis.

To define measures, dimensions, calculated columns, calculated measures and define relationships follow the below steps

1. Identify the specific data table and column for which you intend to create a measure.
2. Locate the designated column within the required table and proceed to click on the Add Measure icon associated with that column.
3. Upon clicking the Add Dimension icon, an Add Dimension modal window will open, allowing you to configure the properties of the dimension.
4. To start defining a relationship, identify the table that you want to establish a relationship between from the list of all available tables.
5. Drag and drop the two tables to the designer canvas.
6. Identify the column that is common between the two tables (key column). This is the column, based on which you will establish the relationship.
7. Define the key column on the newly added table as a dimension.
8. Start defining the hierarchy, along with defining the dimension.
9. To add calculated column, click on the Add Calculated Column option at the top of the data table.
10. Click on the icon or the Add Calculated Measure option to initiate the process of adding a calculated measure.

Caution

Datasource must have at least one measure and one dimension to enable the Save.