Jamboard files in Drive log events

Audit and investigation page: Understand how Jamboard files are used in your domain
The audit log page has been replaced with a new audit and investigation page. For information about this change, go to Improved audit and investigation experience: What's new in Google Workspace

As an administrator, you can use the audit and investigation page to run searches related to Jamboard files in Drive log events. There, you can use Google Drive log events to view how frequently Jams are being created, who is creating or editing them, and more. You can then export your Drive log event data to Google Sheets and analyze it with a Sheets pivot table.

Drive log events are searchable for up to 6 months after the event occurred. Learn more about Data retention and lag times.

For a full list of services and activities that you can investigate, such as Google Drive or user activity, check out the data sources for the audit and investigation page. Learn more About the audit and investigation tool.

Filter and export Drive log event data for Jamboard usage

  1. Sign in to your Google Admin console.

    Sign in using your administrator account (does not end in @gmail.com).

  2. In the Admin console, go to Menuand then Reportingand thenAudit and investigationand thenDrive log events.
  3. Click Add a filterand thenselect Document type
  4. Click Document typeand thenselect Google Jamboardand thenclick Apply.
  5. Click Search.
  6. Click Export all.
  7. Enter a nameand thenclick Export.
    The export displays below the search results table under Export action results.
  8. Click the export name link.
    The log event data opens in Google Sheets.

The export might take time to download depending on the number of users in your domain.

Analyze your data using Google Sheets

After you export the data, you can use Google Sheets to analyze it with a pivot table.

You can see which users in your organization are using Jamboard and how many unique users are taking action on those Jams.

  1. In Sheets, open the spreadsheet that contains the Jamboard data.
  2. Select all of your data, click Insertand thenPivot tableand thenCreate.
  3. On the right, under Pivot table editor:
    • At Rows, click Addand thenOwner.
    • At Values, click Addand thenDocument ID and Addand thenActor.
    • For the Values of Document and Actor, change Summarize by to COUNTUNIQUE.
    • At Rows, change the order to Descending and Sort by to COUNTUNIQUE:
      1. Document ID will show how many unique Jams that owner has had action taken against by themselves or other users.
      2. Actor will show how many unique users have taken action against that owner’s Jams.


Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center