Donor retention
See which supporters give again and which have lapsed.
Bring your Little Green Light data into Filament. Create dashboards, build reports and explore your questions in plain English.
Little Green Light holds the story of every supporter: who gave, which appeal they answered, which events they came to and the time they volunteered. Seeing the full picture across a year of fundraising still takes a lot of exporting.
Filament brings your constituents, gifts, appeals, events and volunteer time into one place. Ask about retention, appeal results and event attendance in plain English, and set them beside your email and website data.
See which supporters give again and which have lapsed.
Compare what each appeal and campaign raised.
Understand who comes to your events and who gives their time.
People and organisations with their email addresses, phone numbers, addresses, relationships, memberships, groups and class affiliations. The LGL API only returns active constituents, so archived or deleted records drop out.
idsort_nameis_orgcontact_typeinterest_leveldate_addedGifts, pledges, in-kind gifts, soft credits and pledge payments, each linked to its campaign, fund, appeal and event. Amounts are in your account's currency.
constituent_idgift_typegift_categoryreceived_amountreceived_dateparent_gift_idThe campaigns, funds and appeals your gifts are recorded against, plus the appeal requests sent to each constituent.
namecampaign_idfinancial_goalcostask_amountstatusEvents, invitations and guests, with one attendance row for each date a guest attended.
event_iddatersvpattendedis_guestinvitation_idContact reports, notes and volunteer hours recorded against each constituent. Tasks, attachments, mailing history and saved lists are not available through the LGL API.
constituent_idcontact_report_typeteam_membervolunteering_categoryhoursdateYour custom field definitions, category and attribute values, lookups and team members.
owner_typeowner_idfield_namevalueFilament brings your apps together in a managed warehouse. Build dashboards, share reports and ask questions in plain English.
Explore the demo dashboard$118,050 of $245,000
194 of 250
You need access to the LGL API settings in your Little Green Light account.
Changed constituents, gifts, contact reports and volunteer time are fetched every six hours. Every record is re-read once a day, so edits and removals are reflected. Everything else is re-read on every sync.
LGL allows 300 API calls every five minutes. Large accounts pause between batches of calls to stay within that limit.
No. The LGL API only returns active constituents, so archived or deleted records are removed on the next daily re-read. Their gifts remain but are no longer linked to a constituent.
Yes. Choose to encrypt personal information when you connect. Names and contact details are hashed, so you can't group constituents by phone number or address.
Gifts received: the total received amount for gifts and other income, excluding pledges and soft credits. Donor retention: prior-period donors who give again divided by all prior-period donors. Pledge fulfilment: pledge payments received divided by the amount pledged.
No. Filament only reads through the LGL API.