Skip to main content

Google Analytics 4

Connect Google Analytics to Qluent using a connection. Upon saving each new report, Qluent fetches 14 months of historical data and on subsequent days it will extract the previous 7 days.

Currently only daily reports/daily aggregation is supported and every report requires at least the "date" dimension.

For a more powerful experience consider setting up BigQuery Links. Doing so will allow you to connect Qluent to BigQuery and in turn allow asking questions about raw events captured by Google Analytics. You cannot export historical data with BigQuery Links therefore it's best to setup as soon as possible to begin gathering data.

Give access​

Give Qluent permission to access your analytics data by adding the Qluent user to your account.

  1. Go to Google Analytics
  2. Go to "Admin" > "Property settings" > "Property" > "Property access management"
  3. Click the "+" icon (in the top right) > "Create users"
  4. Add email "qluent-ga4@ageless-sol-373219.iam.gserviceaccount.com"
  5. Choose "Viewer" as the role
  6. To save click "Add" (in the top right)

Get your property identifier​

  1. Go to Google Analytics
  2. Go to "Admin" > "Property settings" > "Property" > "Property settings"
  3. Take not of the "PROPERTY ID" value e.g. 174562018 for the next step

Create a report​

Repeat the following steps to create one or more reports.

  1. Go to app.qluent.com, go to "Settings" > "Connections" > "Google Analytics 4"
  2. Paste in your "Property ID" value
  3. Click the "+" icon to create an empty report
  4. Click "untitled_" to setup the report
  5. Choose a name for your report e.g. "daily_performance", "active_users_by_country"
  6. Choose up to 9 dimensions
  7. Choose up to 10 metrics

Update a report​

  1. Go to app.qluent.com, go to "Settings" > "Connections" > "Google Analytics 4"
  2. Expand the report you want to update and specify the new details
  3. Changing a report will recreate all report data

Remove a report​

  1. Go to app.qluent.com, go to "Settings" > "Connections" > "Google Analytics 4"
  2. Click the "bin" icon beside the report title
  3. Removing a report will automatically mark data for removal

Recommendations

  • Not all dimensions and metrics are compatible
  • Use the Google Analytics Query Explorer to test your dimensions and metrics before creating a report.
  • Whilst it's possible to use all 9 dimensions and 10 metrics it can lead to unexpected report numbers due to metrics data being split into too many dimensions (aka buckets)
  • Utilising many dimensions and metrics will yield a large dataset and take much longer too extract
  • Use smaller more focused reports comprising of fewer dimensions and metrics when possible

Discrepancies

  • Due to the way data is approximated in Google Analytics, expect differences between it and reports in Qluent that use the Google Analytics Report API behind the scenes
  • Selecting too many dimensions and metrics can lead to metrics data being split or duplicated
  • It can take time before data is gathered by Google Analytics therefore each day, the previous 7 days of data are extracted and replaced in Qluent

How it works

Qluent will fetch all data from Google Analytics for the last 14 months. On subsequent days, Qluent will fetch the previous 7 days of data to factor in any changes to the data.

Still stuck? Contact info@qluent.com to get help.