GLCC offers advanced analytics reports powered by Looker in the Admin interface. These reports are in addition to the Metrics dashboards for Email, Candidate Activity, Job Posting Activity, Employment Reporting, Advising/ Coaching and Employer Engagement. These reports can be filtered and sent out on demand or as scheduled.
Permissions: Any Admin User with the Looker Reports permission will have access to this menu.
Standard Reports tab
How to Access and Filter Looker Reports
All are accessible through Reports > Metrics Dashboard.
The Standard Reports are accessed through Reports > Metrics Dashboard > Looker Reports.
NOTE: Standard Reports will vary by school type.
To access, click on the report name, ex. Advising Monthly Fill Rates - Year over Year
The report pulls your school's data which can be filtered to meet your specific requirements.
To filter data, change parameters and click on Run.
A report reflecting new data filters is generated.
How to Download, Send or Schedule a Report
Click on the Gear in the top right.
Download as PDF or CSV - click here to export the data.
How to send the report in an email
Click Send to have the report sent to specific email addresses.
Select a Title for the email. It will default to the name of the report but can be changed.
Who should it be emailed to? - enter email address of recipients and click Add after each.
To include a custom message in the body of the email, click on Include a Custom Message... and enter text.
Select a format - options include PDF, Visualization (graphical result) or CSV ZIP file.
Select Filters (see image below).
Select Advanced options:
- Email Options - include links will insert a link to Looker to view the report. Only users with a Looker license would be able to see the report in Looker.
- Format Options - select Use single column layout to send an image of the full report within the email body.
Click Send.
Email Format settings and Email Message Results
CSV Options
Settings
Message format
PDF Options
Settings
Message format
Visualization Options
Settings
Message Format
How to Schedule the Report to be Sent Later
This option is similar to Send (see Above) but includes fields to schedule the emails to be sent on a recurring basis.
In the left pane, a list appears with all of the Schedules created for this report. Click on New after setting your parameters to create a new schedule.
Use Deliver this Schedule to select the frequency of the emails. Below that, select the day and time to send it. At the bottom of the screen is a Send Test button. This will send a test message to the designated email address and keep the window open. After verifying the test, the report schedule can be saved or cancelled.
How to add a report to the Metrics menu or to a student dashboard
Click on the arrow in the Action column next to the report to be added.
Select Audience
- Admin - adds the report to the Metrics menu.
- Click Admin.
- Click Save.
- Select Permission Group. Admins within this group (ex. Looker Reports) will be given access. Click Save.
- Report then appears as a separate menu item in the Metrics dropdown.
- Students - adds a widget displaying the report to the student dashboard
- Note: Only students with the Data Analytics permission in their permission group can view the widget.
- Click on Students.
- Click Save.
- Select Programs. Save.
- Select Permission Groups. Save.
- If you log in as student in this program and permission group, the report is available as a menu item in the Data Analytics Menu
Custom Reports tab
Displays any custom Looker reports that have been designated to appear here. This can be done by any school with a Looker license. Custom reports can also be built by GradLeaders per school specifications for an additional fee. Talk to anyone on the GradLeaders team or email support, support@gradleaders.com, to learn more.
Favorites tab
Displays any Looker reports that have been starred, or designated as Favorites.