Create a Dataset from Google Analytics

You can create a dataset with data from Google Analytics to report on website usage. For example, you might analyze the number of hits to website landing pages over time.

Creating a dataset based on Google Analytics data enables you to report on website usage over time similar to reporting in Google Analytics.
Before you start, make sure that you have a connection to a Google Analytics data source. See Connect to Google Analytics. By default, connections to Google Analytics expose real time data tables. You can also analyze data in custom tables, for example, to access historical data. See Specifying Google Analytics Custom Tables in a JSON File.
  1. On the Home page, click Create and then click Dataset.
  2. In the Create Dataset dialog, click a connection to the Google Analytics data source.
  3. In the Dataset editor, go to the Connections pane and navigate to Schemas, then GOOGLEANALYTICS4.
  4. Drag and drop one or more custom tables from the GOOGLEANALYTICS4 schema to the Join Diagram, and build your dataset.
    Description of google-analytics-dataset-designer.png follows
    Description of the illustration google-analytics-dataset-designer.png

  5. To analyze historical data, scroll down to locate and add the historical tables.
    Description of google-analytics-custom-tables.png follows
    Description of the illustration google-analytics-custom-tables.png

  6. Click Save Dataset.
  7. Enter a name and click OK.
Create a workbook based on the dataset, and visualize the data.
Description of google-analytics-report.png follows
Description of the illustration google-analytics-report.png