📖 < 1 min read

We can measure user engagement over the last 90 days (by counting Google Docs created in that time frame).

In Drive audit, click on the ‘Apply custom filter’ button.

GAT+: Measuring User Engagement Over the Last 90 Days 1

In the Drive Files filters popup, perform the following actions, click on ‘Add group’, in this group select the following search parameters.

  • Type equal Document
  • Type equal Word

Note: This group is OR’d.

Outside of the group add an additional rule.

  • Created After or equal dd/mm/yyyy (look back 3 months)

GAT+: Measuring User Engagement Over the Last 90 Days 2

And then apply the filter.

When the results appear in the Drive result table, click on the ‘Export data’ button and select ‘Export to Google Sheet’

GAT+: Measuring User Engagement Over the Last 90 Days 3

A message will appear when the export is ready.

The spreadsheet will contain a lot more columns of data.
GAT+: Measuring User Engagement Over the Last 90 Days 4

 

Thanks for sharing and spreading the word!