Song usage and reporting to CCLI

For staffChecked Nov 12, 20264 minutes to read

See which songs your services used, download the report, and work through the list to report to CCLI.

The song usage report shows which songs your services used over a range of dates, with a list that makes reporting to CCLI quick. Open Reports in the menu to find it. Every church plan has it, Free included.

Open in PraisePad to try it

Read the report

  1. Open Reports. It starts on the last 12 months.
  2. To change the range, set From and To and press Show, or choose Last 6 months, Last 12 months, or This year.
  3. The table lists each song with its CCLI number, how many times it was used, when it was last used, and the dates.
  4. Press Download CSV for a spreadsheet with each song's title, CCLI Song #, copyright, times used, Projected (when your church uses Present) and Printed, and dates. Songs only printed or projected in the dates come at the end.

Only published services that have already happened count, and a song counts once per service. A draft service, or one still ahead, isn't in the report yet. The sample services a new church starts with aren't in it either.

The Song usage report: From and To dates, a Download CSV button, and a table of songs with how many times each was used and when

Report to CCLI

CCLI takes reports on its own website, one song at a time, by each song's CCLI Song #. The Report to CCLI list under the table has what you need, most used first.

  1. Press Open CCLI reporting (new tab).
  2. For each song, press Copy to copy its number, then search for it and enter its counts on CCLI's form (see What to enter, below). Open in SongSelect, under the number, opens the song's own SongSelect page in a new tab, to check it's the right song; looking uses none of your SongSelect credits.
  3. Check off each song as you go. The checks stay on this device, so you can finish later.

Songs with no CCLI number are listed first, each with Look up the number: it lists what SongSelect's listings show for that title and writer, up to three, and Use it puts the number in the CCLI Song # field beside the song, where you press Save. Check on SongSelect opens a listing in a new tab to make sure it's the right song, and a listing with a different title is marked "Another title". If the song isn't there, the list ends with Get it from SongSelect, which opens SongSelect's search for that title and writer in a new tab, while PraisePad waits on Import for the file you download there: drop it in and the song gets its chart, CCLI number and copyright from it (see Get it from SongSelect). Or paste the number into the field and press Save: it joins the list for this report and every one after. The song's own page has Get it from SongSelect where its number would show, and Edit details there has the same Look up the number. Songs whose copyright says public domain are listed as nothing to report, and PraisePad doesn't ask for their numbers anywhere.

What to enter

CCLI asks each church to report a six-month period, about every two and a half years, and tells you when. For each song the list shows:

  • Projected: how many times Present put the song on the screens, once a service time. On CCLI's form this goes in the column for words on screens, called Digital. A church that doesn't use Present doesn't see it.
  • Printed: how many times its chart was printed from PraisePad, once a person a day. This goes in the Print column, where CCLI counts "1" each time a copy is made, so if someone printed several copies, or emailed a printed PDF around, add those. PraisePad counts a print when the print dialog closes, so one opened and cancelled counts too.
  • How many services it was sung at, to help you remember.

PraisePad counts only what Present put on the screens and what was printed from PraisePad. Add copies made anywhere else: other projection software, bulletins, the photocopier. A song printed or projected but not on a service in those dates is listed too.

Keep the rotation fresh

  • Used most lists the 10 songs used most in the range.
  • Resting lists library songs not used lately. Choose how many weeks next to Not used in and press Update.
There's a short lesson for this in the Admin courseYour church's details, and its services · 4 min
Did this help?One tap. It tells us what to make clearer.