CCLI Usage Report
CCLI Usage Report
If your church holds a CCLI licence, you're expected to report which songs you use. Song7 already knows what you played and when — your sets — so it can hand you a tidy report instead of you piecing it together by hand every six months.
What this is (and isn't)
CCLI doesn't accept a file upload. You report usage by entering it into the CCLI reporting portal (or through a connected integration). So this export is your source of truth for that entry: one clean list of every song use in the period, ready to key in.
Exporting a report
- Go to Sets
- Open the ⋮ menu (top right) and choose CCLI report
- Pick a quick range — This quarter, Last quarter, Last 6 months, or This year — or set a custom From and To date
- Click Export CSV
The file downloads as ccli-usage_<from>_<to>.csv. If no songs were used in that range, Song7
tells you instead of downloading an empty file.
What's in the file
One row per song use — if a song was used in three services, it appears three times, each with its own date. That matches how CCLI counts usage.
| Column | What it is |
|---|---|
| Date Used | The date of the set the song appeared in |
| Song Title | The song's title |
| Author | The song's author |
| CCLI Song Number | The song's CCLI number, if filled in |
| Copyright | The song's copyright line |
| Set | The name of the set it was used in |
Get the most out of it
- Keep CCLI numbers on your songs. The report reads the song's current details, so a number you add today shows up for past uses too. A blank CCLI column just means that field is empty on the song — open the song and add it.
- Report on a regular rhythm. Most churches report every six months; the Last 6 months preset lines up with that.
Related
Less admin, more ministry. Let Song7 keep the record so reporting takes minutes, not an afternoon.