How do I look up unused PDTs in system activity?

[LookerExperts]

Knowledge Drop

Last tested: Sep 8, 2020

This link will help navigate you to the pdt_event_log explore (Be sure to replace with hostname with your own):

https://xxxxx.cloud.looker.com/explore/system__activity/pdt_event_log?fields=pdt_builds.view_name&f[pdt_builds.start_date]=2+months&sorts=pdt_builds.view_name&limit=500&query_timezone=America%2FLos_Angeles&vis={}&filter_config={"pdt_builds.start_date"%3A[{"type"%3A"past"%2C"values"%3A[{"constant"%3A"2"%2C"unit"%3A"mo"}%2C{}]%2C"id"%3A0%2C"error"%3Afalse}]}&origin=share-expanded

You’ll then get a list of views in the result set. If you look up these views in the Field Usage explore you’ll be able to see which ones have been used and which ones haven’t.