📖 < 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.

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)

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’

A message will appear when the export is ready.

The spreadsheet will contain a lot more columns of data.