---
title: "Reports"
canonical: "https://docs.pbs.org/space/DLM/3577917/Reports"
format: markdown
---
> Macro (toc)

## Tips

- We recommend using filters to reduce the time it takes to return results.
- If no filters are used, all records in the entire PBSLM database are returned.  Depending on the report, this could take a while.
- When several results are returned, pagination can be found at the bottom of the table.
- You have the option to export your results to a CSV file.
- Refer to the [How to format grade range](https://docs.pbs.org/space/DLM/3577917/Reports#How-to-format-Grade-Range-column) for tips on formatting the CSV file.

## Reports overview

| **Type of Report** | **Definition** | **Who can run this report ** |
| --- | --- | --- |
| [Free User Registration Report](https://docs.pbs.org/space/DLM/3577917/Reports#Free-User-Registration-report) | All users who have registered for the free PBS LearningMedia Service and are mapped to a station site by postal code.  Use the available filters to search by a particular role or PBS LearningMedia website. | - PBS Admin
- Service Admin
- Site Admin
- Content Admin
- Site Editor |
| [Custom User Registration Report](https://docs.pbs.org/space/DLM/3577917/Reports#Custom-User-Registration-report) | Detailed information about users who are signed up for the custom service including those created by admins and those who were imported and auto-assigned . | - PBS Admin
- Service Admin
- Site Admin
- Content Admin
- Content Editor
- Site Editor |
| [Custom User Sign-ups Report](https://docs.pbs.org/space/DLM/3577917/Reports#Custom-User-Sign-ups-report) | Users who responded to email invitations to the Custom service. | - PBS Admin
- Service Admin
- Site Admin
- Content Admin
- Content Editor
- Site Editor |
| [Media Objects Report](https://docs.pbs.org/space/DLM/3577917/Reports#Media-Objects-report) | All media objects that have been contributed to the PBS LearningMedia CMS including video, documents, audio, HTML fragments, images, and interactives.  Run this report to find existing media objects in the CMS and the organization to which they belong. Use the filters to target specific content projects or organizations. | - PBS Admin
- Service Admin
- Content Admin
- Content Editor |
| [Asset Report](https://docs.pbs.org/space/DLM/3577917/Reports#Asset-report) | All assets that have been contributed to the PBS LearningMedia CMS.  Filter by Accessibility Indicators or run a report and the applicable Accessibility Indicators will be listed with each asset.  Choosing no filters will return all assets in the CMS. | - PBS Admin
- Service Admin
- Content Admin
- Content Editor |
| [Resource Report](https://docs.pbs.org/space/DLM/3577917/Reports#Resource-report) | All resources that have been contributed to the PBS LearningMedia CMS. | - PBS Admin
- Service Admin
- Content Admin
- Content Editor    
<span style="color: #FFFFFF"> </span> |

## Free User Registration report

|  |  |
| --- | --- |
| **Report interface** | ![image](media://945be543-4d4c-4519-9273-0889fc215d53) |
| **Report filters** | - Start date
- End date
- Preferred subjects
- User role
- Grade level
- Promo code
- LearningMedia website |
| **Fields returned** | - Full name
- Email
- User role
- Preferred subjects
- Postal code
- County name
- Site name
- Site URL
- Date joined
- Grade range
- Promo code
- Organization |

### How to run a Free User report

- On the left side navigation, click** Free User Registration Report** (Figure 1).

Figure 1

![image](media://f7692e3f-db4d-48c4-beea-45028a03eb9a)

- Click the **Export as Csv checkbox** if you want report results emailed to you in one excel file (Figure 2.1).  If you *do not* choose this option, results will surface in the browser window and you must click Previous and Next buttons to scroll through each page of results.  :warning: [**Click here to view important tips on CSV export**](https://docs.pbs.org/space/DLM/3577917/Reports#How-to-format-Grade-Range-column)
- Click the **Start** and **End Date textboxes** to surface a calendar (Figure 2.2).  Once the calendar appears, click the **arrow** to the left of the month and year to scroll to dates in the past or click the **arrow** to the right of the month and year to scroll to dates in the future.  Click the day on the calendar to select a specific date.
- Click the **Preferred subjects** you wish to search on (Figure 2.3).  Multiple subjects can be selected.  If you do not click a Preferred subject, all subjects will be included in the report. All of your selected Preferred subjects appear above the select box with a blue X ( > Macro (inline-media-image)

 ) to the right of each entry.  Click the** X **to delete a selection.  You can add selections at any time.
- Click the **User role dropdown menu** and click the **user role **on which you want to search (Figure 2.4).  Only one User role can be selected.  If you do not select a User role, all roles will be included in the report.
- Click the **Grade level dropdown menu **and click a** grade level range **(Figure 2.5).  Only one grade level range may be selected per report.  If you do not select any, all grade ranges will be returned.
- Click the **Promo code dropdown menu** to search by any promo code that was offered to users (Figure 2.6).  Click the Promo code on which you want to search.  Only one Promo code may be selected per report.  If you do not select a Promo code, all promo codes are returned in your report.
- Click the **LM site dropdown menu** and click the **PBS LearningMedia site** on which you want to search (Figure 2.7).  Only one LM site can be selected per report.  If you do not select an LM site, all sites will be returned in your report results.
- Click **Generate Report** (Figure 2.8).

Figure 2

![image](media://e2f879aa-b8c9-4001-925f-b441f1fae1f1)

## Custom User Registration report

|  |  |
| --- | --- |
| **Report interface** | ![image](media://d932804f-6ae1-44df-a93e-c0755c47649b) |
| **Report filters** | - Organization
- Start date
- End date
- Preferred subject
- User role
- Grade level
- Auth role |
| **Fields returned** | - Full name
- Email
- User role
- Preferred subjects
- Postal code
- County name
- Site name
- Site URL
- Date joined
- Grade range
- Promo code
- Authorization role
- Organization |

### How to run a Custom User report

- On the left side navigation, click** Custom User Report** (Figure 1).

Figure 1

![image](media://fafc21da-1466-4c20-a5a0-56e6d74fd1bc)

- Click the **Export as Csv checkbox** if you want report results emailed to you in one excel file (Figure 2.1).  If you do not choose this option, results will surface in the browser with a total count.  You must click Next or Previous to view results. :warning: [**Click here to view important tips on CSV export**](https://docs.pbs.org/space/DLM/3577917/Reports#How-to-format-Grade-Range-column)
- Click the **custom organization** on which you want to run a report.  Clicking the **plus sign** (> Macro (inline-media-image)

) next to an organization reveals counties and jurisdictions within that particular organization (Figure 2.2).  Multiple organizations can be selected.  If you do not click any organizations, all organizations will be included in the report.  The organizations you have selected appear above the select box.  Click the blue X ( > Macro (inline-media-image)

 ) to the right of each organization to remove an organization from the search criteria.  You can add organizations at any time.
- Click the **Start** and **End Date textboxes** to surface a calendar (Figure 2.3).  Once the calendar appears, click the **arrow** to the left of the month and year to scroll to dates in the past or click the **arrow** to the right of the month and year to scroll to dates in the future.  Click the day on the calendar to select a specific date.
- Click the **Preferred subjects** you wish to search on (Figure 2.4).  Multiple subjects can be selected.  If you do not click a Preferred subject, all subjects will be included in the report. All of your selected Preferred subjects appear above the select box with a blue X ( > Macro (inline-media-image)

 ) to the right of each entry.  Click the** X **to delete a selection.  You can add selections at any time.
- Click the **User role dropdown menu** and click the **user role **on which you want to search (Figure 2.5).  Only one User role can be selected.  If you do not select a User role, all roles will be included in the report.
- Click the **Grade level dropdown menu **and click a** grade level range **(Figure 2.6).  Only one grade level range may be selected per report.  If you do not select any, all grade ranges will be returned.
- Click the **Auth role dropdown menu** to search by a particular Admin role (Figure 2.7).  Only one role may be selected per report.  If you do not select a role, all roles are returned in your report.
- Click **Generate Report** (Figure 2.8).

Figure 2

![image](media://0174d22d-52ac-4e46-af74-01834af357c3)

## Custom User Sign-ups report

|  |  |
| --- | --- |
| **Report interface** | ![image](media://52a9e196-5b1f-4a3c-89a8-cf8784388a38) |
| **Report filters** | - Organization
- Start date
- End date |
| **Fields returned** | - Full name
- Email
- Organization
- Date invited
- Date joined |

### How to run a Custom User Sign-up report

- On the left side navigation, click** Custom User Sign-up Report** (Figure 1).

Figure 1

![image](media://87991fd2-7fbb-4c06-bdad-bd7681895536)

- Click the **Export as Csv checkbox** if you want report results emailed to you in one excel file (Figure 2.1).  If you do not choose this option, results will surface in the browser with a total count.  You must click Next or Previous to view results. :warning: [**Click here to view important tips on CSV export**](https://docs.pbs.org/space/DLM/3577917/Reports#How-to-format-Grade-Range-column)
- Click the **plus sign** (> Macro (inline-media-image)

) next to PBS to expand the list of Organizations (Figure 2.2).  Multiple organizations can be selected.  If you do not click any organizations, all organizations will be included in the report.  The organizations you have selected appear above the select box.  Click the blue X ( > Macro (inline-media-image)

 ) to the right of each organization to remove an organization from the search criteria.  You can add organizations again at any time.
- Click the **Start** and **End Date textboxes** to surface a calendar (Figure 2.3).  Once the calendar appears, click the **arrow** to the left of the month and year to scroll to dates in the past or click the **arrow** to the right of the month and year to scroll to dates in the future.  Click the **day** on the calendar to select a specific date.  The textbox populates with the date you have selected.
- Click **Generate Report** (Figure 2.4).

Figure 2

![image](media://9b33fccd-ef2a-4c96-89e2-be26bf31b1c4)


## Media Objects report

|  |  |
| --- | --- |
| **Report interface** | ![image](media://2fc0e8dd-046a-4eba-a360-584f4e606d0a) |
| **Report filters** | - Organization
- Content project
- Language
- Media type |
| **Fields returned** | - Title
- Media type
- Language
- Content project
- Organization |

### How to run a Media Objects report

- On the left side navigation, click** Media Objects Report** (Figure 1).

Figure 1

![image](media://12282066-1d8c-4ad1-a30e-26a86bad4055)

- Click the **Export as Csv checkbox** if you want report results emailed to you in one excel file (Figure 2.1).  If you do not choose this option, results will surface in the browser with a total count.  You must click Next or Previous to view results. :warning: [**Click here to view important tips on CSV export**](https://docs.pbs.org/space/DLM/3577917/Reports#How-to-format-Grade-Range-column)
- Click the **plus sign** (> Macro (inline-media-image)

) next to PBS to expand the list of Organizations (Figure 2.2).  Multiple organizations can be selected.  If you do not click any organizations, all organizations will be included in the report.  The organizations you have selected appear above the select box.  Click the blue X ( > Macro (inline-media-image)

 ) to the right of each organization to remove an organization from the search criteria.  You can add organizations again at any time.
- Click the **Content project dropdown menu** and click the **Content project** you want to include in your report (Figure 2.3).  Only one Content project can be selected.  If you do not select a Content project, all Content projects will be included in the report.
- Click the **Resource type dropdown menu** (Figure 2.4).  Only one resource type can be selected.  If you do not select a Resource type all resource types will be returned.
- Click the **Language dropdown menu **and click the language in which the resources you are searching were created (Figure 2.5).  Only one language can be selected.  If you do not select a language all languages will be returned.
- Click the **Media type dropdown** menu and click the **type of media** you want to include in your report (Figure 2.5). Only one media type can be selected.   If you do not select a media type, all media types will be returned.
- Click **Generate Report** (Figure 2.6).

Figure 2

![image](media://4e65c91c-dd98-4379-ad9d-f145fd3788da)

## Asset report

|  |  |
| --- | --- |
| **Report interface** | ![image](media://45a5fa57-d073-43eb-bb7c-7c50c70f63eb) |
| **Report filters** | - Organization
- Accessibility Indicators ([see more about Accessibility Indicators](https://pbs-docs.atlassian.net/wiki/spaces/DLM/pages/3578971))
- Media type
- Start date
- End date |
| **Fields returned** | - Title
- Media type
- Date created
- Date modified
- Content project
- Organization
- Accessibility |

### How to run an Asset report

- On the left side navigation, click** Asset Report** (Figure 1).

Figure 1

![image](media://80575ea5-82b7-41d7-a23e-f8444b2bb1e8)

- Click the **Export as Csv checkbox** if you want report results emailed to you in one excel file (Figure 2.1).  If you do not choose this option, results will surface in the browser with a total count.  You must click Next or Previous to view results. :warning: [**Click here to view important tips on CSV export**](https://docs.pbs.org/space/DLM/3577917/Reports#How-to-format-Grade-Range-column)
- Click the **plus sign** (> Macro (inline-media-image)

) next to PBS to expand the list of Organizations (Figure 2.2).  Multiple organizations can be selected.  If you do not click any organizations, all organizations will be included in the report.
- Click the **Content project dropdown menu** and click the **Content project** that holds the assets on which you want to search (Figure 2.3).  Only one Content project can be selected.  If you do not select a Content project, all Content projects will be included in the report.
- Click the **Accessibility Indicators **that apply to the asset you are searching (Figure 2.4).  Click the **plus sign** (> Macro (inline-media-image)

) next to the Accessibility Indicators you wish to expand.  If you do not select any Accessibility Indicators, all will be returned in your search results.
- Click the **Media Type **dropdown menu and click the media types you wish to search (Figure 2.5).  Only one media type can be selected.  If you do not select a media type, all media types will be returned.
- Click each **Date textbox** to surface a calendar (Figure 2.6).  Once the calendar surfaces, click the **arrow** to the left of the month and year to scroll to dates in the past or click the arrow to the right of the month and year to scroll to dates in the future.  Click the **day** on the calendar to select a specific date.
- Click **Generate Report** (Figure 2.7).

Figure 2

![image](media://fa3db535-7e69-4b9e-846f-5af72fe0ff9b)

- When filtering by Organization and Curriculum hierarchy, the options you've chosen appear above each select box with a blue X ( > Macro (inline-external-image)

 ) to the right of each entry.  Click the** X** to delete a selection.  You can add more selections at any time (Figure 3.1).
- Click **Generate Report** (Figure 3.2).

:warning: **Each time you modify your search criteria you must click Generate Report**.

Figure 3

![image](media://5db82bf4-7125-4ece-97ce-fdc488ab6cd6)

## Resource report

|  |  |
| --- | --- |
| **Report interface** | ![image](media://022f50f2-ea60-4675-8cd2-b5b9b911bf02) |
| **Report filters** | - Organization
- Content project
- Resource type (Lesson Plan, One Primary Asset, Media Gallery, Self Paced Lesson)
- Language (Latin, Chinese, German, English, Japanese, French, Spanish, Arabic, Navajo, Italian)
- Curriculum hierarchy
- Grade level (K,1,2,3,4,5,6,7,8,9,10,11,12,13+)
- Start date created
- End date created
- Start date published
- End date published |
| **Fields returned** | - Title
- Media type
- Language (Latin, Chinese, German, English, Japanese, French, Spanish, Arabic, Navajo, Italian)
- Status (published, unpublished, in-progress)
- Grade (K,1,2,3,4,5,6,7,8,9,10,11,12,13+)
- Curriculum hierarchy
- Date created
- Date published
- Content project
- Organization |

### How to run a Resource report

- On the left side navigation, click** Resource Report** (Figure 1).

Figure 1

![image](media://c02f5dfc-5372-45c4-b2f2-2229016536d5)

- Click the **Export as Csv checkbox** if you want report results emailed to you in one excel file (Figure 2.1).  If you do not choose this option, results will surface in the browser with a total count.  You must click Next or Previous to view results. :warning: [**Click here to view important tips on CSV export**](https://docs.pbs.org/space/DLM/3577917/Reports#How-to-format-Grade-Range-column)
- Click the **plus sign** (> Macro (inline-media-image)

) next to PBS to expand the list of Organizations (Figure 2.2).  Multiple organizations can be selected.  If you do not click any organizations, all organizations will be included in the report.
- Click the **Content project dropdown menu** and click the **Content project** you want to include in your report (Figure 2.3).  Only one Content project can be selected.  If you do not select a Content project, all Content projects will be included in the report.
- Click the **Resource type dropdown menu** (Figure 2.4).  Only one resource type can be selected.  If you do not select a Resource type all resource types will be returned.
- Click the **Language dropdown menu **and click the language in which the resources you are searching were created (Figure 2.5).  Only one language can be selected.  If you do not select a language all languages will be returned.
- Click the name of the **Curriculum hierarchy node**. More than one Curriculum hierarchy node can be selected.  If you do not select any all Curriculum hierarchy nodes will be returned.
- Click a **Grade level**.  Hold down your shift key and click to select more than one.  If you do not select any, all Grade levels will be returned.
- Click each **Date textbox** to surface a calendar (Figure 2.8).  Once the calendar surfaces, click the **arrow** to the left of the month and year to scroll to dates in the past or click the **arrow** to the right of the month and year to scroll to dates in the future.  Click a **date** on the calendar to select a specific date.

Figure 2

![image](media://1d54c459-ddd4-4d29-b734-bd00fd904501)

- When filtering by Organization and Curriculum hierarchy, the options you've chosen appear above each select box with a blue X ( > Macro (inline-media-image)

 ) to the right of each entry.  Click the** X** to delete a selection.  You can add more selections at any time (Figure 3.1).
- Click **Generate Report** (Figure 3.2).

> ⚠️ **Each time you modify your search criteria you must click Generate Report**.

Figure 3

![image](media://d1b245af-49c9-4638-96a4-509336571f85)

- Results display below the filters and pagination is available at the bottom of the page (Figure 4).

Figure 4

![image](media://2bebb762-7c6f-4b51-ad9d-f4fedefa2e77)

## How to format Grade Range column

Currently, when exporting results to a CSV file, the Grade Range column contains incorrect formatting.  For the time being, follow the steps below to format the results properly.  This is a temporary workaround and the export functionality is expected to display correctly soon. 

- After you have received the report link in your email, click the **link** to open it (Figure 1).

Figure 1

![image](media://e2e94779-aee6-4bb8-b2af-f5cd7ff59bfa)

- Click **Open** to open the file (Figure 2).

Figure 2

![image](media://30b930e0-1709-4272-bdf6-4eb90b330bb3)

- Click the top of the **Grade range column**.
- Right click

Figure 3

> ✅ Click the play button at the bottom to play the video.  You can pause and back the video up by dragging the circle along the timeline.

> Macro (multimedia)

  

:check_mark: **Results are displayed in a clean, organized format. **

![image](media://09b96f21-7f1e-41e5-860b-63b274b3f54f)