Get more accurate, detailed insight into your website visitors’ behaviors and motivations.
You will need BigQuery to query raw data, connect with other external data sources, export data for visual reports, and store your raw data. You own all data you export to BigQuery. Ownership lets you manage permissions on its datasets and projects using BigQuery’s table-level access controls.
Set up an account with an analytics service that can extract data from Google Analytics and any systems and interfaces from which you need to pull data.
Good examples are OWOX BI or Electrik.AI’s Google Analytics Hit Data Extractor. If you don’t have a GA 360 account, you need a data extractor to pull the raw data as it moves to GA. You can also use Google Analytics APIs for export data - however, its limitations make it less than ideal for large companies or long-term use by small companies.
Data Studio will allow you to generate, view, and share the reports you pull data from BigQuery. It lets you combine GA data with data from other sources. You can also integrate data from different GA web properties and get unsampled reports.
You can choose to create different types of reports for other pages, or you can collate them into a single page. If there is a template that fits your needs, you can select from a template rather than open a blank document.
Hook into your data source by selecting Create New Data Source on the next screen. Choose BigQuery as your data source.
For the rawest data, choose Master View, which collects all the data without filters.
Follow the prompts on the following pages to build your chart to your preferences and style your graph. When complete, generate your report for analysis.
Last edited by @hesh_fekry 2023-11-14T16:05:14Z