Reports: Build, customize, and schedule reports
In this article:
- What’s in a report?
- Important note about customization
- Working with reports and exports
- Scheduled reports
- Archived reports
- Archiving exports
Wouldn’t it be nice if you could build a report once and be able to re-run it with a couple clicks whenever you want an update of the data? Or even better, have LGL run it for you on a schedule and email you the results (daily, weekly, or monthly)?
You can do just that with LGL's reporting feature, accessible from the Reports page or from any search results page in LGL. Almost immediately, you'll get access to either a PDF or CSV report you can use to see what's happening with your data or share with others.
What’s in a report?
Each report in LGL has two main ingredients:
- The search that defines the records to export
- The template that defines the report's format (or the fields you will see when you look at the report)
Building a brand-new report is a four-step process, which LGL's report builder walks you through:
- Define your search criteria (which records will go into your report)
- Customize your report output (which bits of data you will get for each record)
- Preview the report
- Save and/or export the results
1. Define your search criteria
Search for records to pull into your report using the standard Advanced Search functionality from either the Constituents or the Fundraising tab, or you can start from the Reports page using one of the canned reports automatically available in your account (see the "Working with reports and exports" section later in this article).
2. Customize your report output
This is where you can tell LGL what fields, or data points, to put in your report. You can choose one of the CSV report templates from the Report Template drop-down menu and either use it as is or update it based on your preferences.
You can also choose a PDF report template from the Report Template drop-down menu (note that PDF reports are not customizable).
Or you can start fresh from the Customize screen of the report builder, make your selection of fields, and customize them to your needs. CSV reports are fully customizable—you can add fields, remove fields, rearrange the order of fields, customize field labels, specify a primary or secondary address, choose gift type, and numerous other options.
If you click on the Customize link next to a field, such as Total Giving, for example, this is where you further refine what type of information will be presented in the Total Giving column in your report.
Important note about customization
There is no relationship between your search query from Step 1 above and the fields you choose from the Customize screen of the report builder in Step 2. What this means is that once you’ve created your overall search query, you also need to make sure your customizable fields are set to pull the data you want in your report.
For example, when you want a giving report for a specific date range, you include the date range in your search query, and you also add it during the customization step:
The example below shows how you can add columns for individual gifts into a constituent report, choosing which gift fields you want (i.e., date, amount, etc.) and how many gifts to include. Remember to increase the gift count if you want to see more than one gift per constituent:
3. Preview the report
For CSV exports (PDF reports are not previewable), you can preview the first 100 rows of the results either via the Quick Preview button (useful for seeing a snapshot of what your report will look like if you are in the midst of customization) or in the Preview step of the report builder:
4. Save and/or export the results
When you are happy with the report, you can save it as a new canned or reusable report or you can export the results (right away, or on a schedule).
Working with reports and exports
Most of your report management takes place on the Reports tab, where you can review and manage reports and exports for Constituent, Gift & Pledge, Goal, Contact Report, Task, Volunteering, and Note information.
All of your canned or saved reports for a given type of record are listed on the Reports tab. To generate an export from one of these, click on the Export button, then on Save Export, and a new export will be generated using that report. You can also edit reports, copy them and make changes, and/or archive reports you don’t intend to keep using. By default, we have included several canned reports for each record type, which correspond to all of the export types that were previously available in LGL:
To schedule your report, choose the frequency with which you want it to be created and emailed to you by selecting one of the available options from the Export Generation Schedule dropdown as you're creating the report, as shown here:
Any reports you have saved as scheduled for automatic generation and email delivery will then be listed in the Scheduled reports tab.
Scheduled reports can also be set to create a "permanent link," which generates a data file at a fixed URL location.
The permanent link provides a fixed URL where the data from this report will be stored as a data file. When your report updates every weekday, week, or month, you can pull in that new data very easily, and the location of the data (the permanent link URL) will stay the same.
Removing email notifications from a scheduled report
If a scheduled report is sending notifications that you no longer want, it's possible to remove them by editing the scheduled report:
Now check the Disable email notifications box:
Uncheck the names of those team members who no longer want or need to receive notifications when this report is automatically generated:
You can archive reports that you don’t think you’ll use on a regular basis. This is a good way to get them out of the way but also keep them around in case you ever want to refer to them. For instance, if you don’t need or use some of the default LGL reports, you can archive them to get them off your main list of reports:
All of your exports (including those from before this release) are available for review and download. You can also take any previously run export and either re-run it or convert it into either a scheduled report or a saved, canned report.
If a report exists in your Exports list that is no longer needed, you can move it into the Archived exports tab by setting it to "Archived":
You have the option to delete the archived export by going into the Archived exports tab and clicking the Delete button next to the export:
It's also possible to automatically delete archived versions of scheduled exports that you no longer need. For example, if your account runs a daily scheduled report, after a year you'd have 365 reports. You can set this option as you're saving the scheduled report. If you want to keep only the most recent copies, any number from 2 to 30, you can set that option as shown: