KNOWLEDGE BASE

Aggregating Unique Users by Time Period Other Than Day in Google Analytics


Published: 05 May 2014
Last Modified Date: 31 Jul 2017

Question

How to return the number of unique visitors per year, month, week, etc. in Google Analytics.

Environment

  • Tableau Desktop
  • Google Analytics

Answer

  1. In Google Analytics Connection Dialogue, select desired date range for data import.
  2. In the Dimensions pane, hover over Date until a red x appears.
  3. Click the red x to remove Date from the Dimensions pane.
  4. Select Add Dimension > Time > Year (or other time period for aggregation level).
  5. Select Add Measure > Users > Users.
  6. Select OK.
  7. Drag Year to the Rows shelf.
  8. Right-click the Year field and select Discrete.
  9. Drag Unique Visitors to the Text shelf on the Marks card.

Additional Information

By default Google Analytics includes a Date field in the set of dimensions to import, which causes the data to be aggregated at the level of day. Removing this field and replacing with the desired level of time aggregation, such as year, resolves the issue.
Did this article resolve the issue?