eTapestry reports
and dashboards

An eTapestry integration for reporting without re-running queries and exports. Filament syncs gifts, pledges and recurring gifts into board and appeal dashboards.

Your eTapestry data, connected.

Filament turns your eTapestry data into board reports, appeal reports and dashboards that stay current. Gifts, pledges, payments and recurring gift schedules sync through the eTapestry API every 6 hours with their fund, campaign and approach, so nobody has to run a query and export a report to Excel each time the numbers are needed.

Pledged and received amounts can sit side by side, this year next to last year, and each figure shows its working. Ask follow-up questions in plain English, export the dashboard to PDF for the board pack, and connect your email and marketing tools if you want to see what happened before the gift.

Moving off eTapestry? Keep your giving history

If you're switching donor databases, connect eTapestry to Filament before you go. Every account, gift, pledge, payment and recurring gift schedule syncs into your own warehouse with its fund, campaign and approach, and it stays there for as long as the eTapestry connection stays in Filament. Disconnecting an app deletes its copy, so keep the connection after you switch.

Connect your new donor database as well, and next year's appeal results can sit beside the years you kept in eTapestry on the same dashboard. Filament connects to Salesforce, Little Green Light, NationBuilder and other fundraising tools.

Appeal results by campaign and approach

See what each appeal raised, split by campaign and approach.

Income by fund, year on year

Gifts and pledge payments by fund for the period and year to date, next to the same period last year.

Pledged versus received, and arrears

Track how much of each pledge has been paid and what is overdue.

Recurring giving forecast

Count active recurring schedules and the income they are expected to bring in.

Data we sync

AccountsExample fields: Ref, Account number

Donor records with contact information, account number, account role type, personas, and custom defined field values for segmentation.

  • ref
  • account_number
  • name
  • email
  • account_role_type
  • account_defined_values
  • persona_defined_values
GiftsExample fields: Ref, Amount

Outright donations with amount, date, fund, campaign, approach, payment method, and any custom defined field values for fundraising performance analysis.

  • ref
  • amount
  • date
  • fund
  • campaign
  • approach
  • valuable_type
PledgesExample fields: Ref, Amount

Pledged commitments with the original amount, outstanding balance, arrears amount, and next payment date, joined to payments for fulfilment tracking.

  • ref
  • amount
  • outstanding_balance
  • arrears_amount
  • next_payment_date
PaymentsExample fields: Ref, Amount

Payments applied against pledges, inheriting the parent pledge's fund and campaign assignment for revenue reconciliation.

  • ref
  • amount
  • date
  • pledge_ref
  • fund
  • campaign
Recurring Gift SchedulesExample fields: Ref, Frequency

Active recurring giving schedules with frequency, next gift date, next amount, and installment value for retention and forecast analysis.

  • ref
  • frequency
  • next_gift_date
  • next_gift_amount
  • installment_amount
Funds, Campaigns and ApproachesExample fields: Name, Type

The fundraising dimensions every transaction is tagged with. Reference tables joined to gifts, pledges and payments by name (not foreign key).

  • name
  • type
RelationshipsExample fields: Account1 ref, Account2 ref

Explicit links between accounts (household members, employer or employee, matching gift donors). Flags head-of-household and matching gift relationships.

  • account1_ref
  • account2_ref
  • type
  • hoh_account
  • matching_gift_account
Defined FieldsExample fields: Ref, Name

Custom field definitions used across accounts, personas, and journal entries. Values are embedded inside each parent record's defined_values JSON.

  • ref
  • name
  • type
  • category

eTapestry works well with

See the
whole picture.

Filament brings your apps together in a managed warehouse. Build dashboards, share reports and ask questions in plain English.

Explore the demo dashboard
Tidewatch
Beach Clean 2026 Key Metrics
Compared toPrevious year
Funds raised$118,050Goal: $245,000
Sign-ups19482% activation rate
Donations399Median gift: $100
Avg. donation$295.86Across the campaign
Funds raised vs target

$118,050 of $245,000

Sign-ups vs target

194 of 250

Cumulative funds raised 2026 Previous year
JanFebMarAprMay
Powered by Filament

Trusted by the best

“Filament has been a game-changer. Everyone can self-serve and get answers on demand. The integrations are plug-and-play, and we've even cancelled our data warehouse plans — Filly does it all.”
Kevin RassoolTech Lead, High Impact Athletes
“Filament has supercharged our efficiency and levelled up our outputs. Beyond time savings, the mental offload has been priceless, and I can focus on growth, not grind!”
Faith FuhrerMarketing & Communications, Pet Medical Crisis

Your questions, answered.

How should I interpret these reports?
Appeal results by campaign and approach
Group gifts by campaign, then by approach, with the number of gifts, number of donors, total raised and average gift. Payments against pledges carry the pledge's fund and campaign, so add them when you report cash received and leave them out when you report pledged commitments; counting both doubles the total. Funds, campaigns and approaches join to transactions by name, so keep names consistent in eTapestry.
Income by fund, year on year
Add gifts and pledge payments by fund for the reporting period and year to date, alongside the same period last year. Show pledged amounts on a separate line so the board can tell money received from money promised.
Pledged versus received, and arrears
Pledge fulfilment is payments applied to pledges divided by their pledged amount. Use outstanding balance and arrears amount for what is still owed, and next payment date to list pledges with a missed payment.
Recurring giving forecast
Use frequency, next gift date, next gift amount and instalment amount to list active recurring donors and forecast the coming months. The schedules table describes active schedules, so use gift history for trends over time.
How do I connect eTapestry?

An eTapestry database administrator must enable API access.

  1. Open Apps in Filament and add eTapestry.
  2. In eTapestry, go to Management → My Organization → Subscriptions and enable the API Subscription.
  3. Copy the API Key and Database ID into Filament.
  4. Add any useful context about your funds, campaigns and custom fields, then complete setup.

If the API Subscription is unavailable, contact your eTapestry account manager.

What does an eTapestry board report look like in Filament?

Here is a typical quarterly board report built from eTapestry tables. Your own funds, campaigns and approaches fill the rows. Income by fund: one row per fund with gifts received, pledge payments received, the quarter's total and the same quarter last year. Appeal results: one row per campaign, split by approach (for example direct mail or email), with number of gifts, number of donors, total raised and average gift. Pledges: total pledged, total paid, fulfilment rate, outstanding balance and arrears, then a list of pledges whose next payment date has passed. Recurring giving: active schedules by frequency and the instalments expected next month. Filament builds this as a dashboard you can export to PDF for the board pack, and each figure shows its working.

How is this different from eTapestry's own reports and queries?

In eTapestry, a query finds the accounts or journal entries and a standard or custom report lays them out, then you export to Excel, CSV or PDF for anything further. Filament keeps a synced copy of the same data, so one dashboard can combine gifts, pledges and payments, compare periods and include your other tools, and it refreshes after each sync without anyone re-running it.

Can I compare this year's eTapestry giving with last year's?

Yes. Gifts and pledge payments carry their date, so any period can sit next to the same period last year, by fund, campaign or approach. Pledged amounts go on their own line, so the comparison keeps money received apart from money promised.

Do I still need to export eTapestry data to Excel?

Not for the data Filament syncs, which is listed above. Each sync picks up new and changed records, so dashboards stay current without a fresh export. If you need something from eTapestry that isn't synced, you can still export it and upload the spreadsheet to Filament.

Which eTapestry campaigns and approaches raise the most?

Every gift carries its fund, campaign and approach, so you can compare total raised, number of gifts, number of donors and average gift for each campaign or approach, and list the donors whose gifts were above a threshold you choose. Campaigns and approaches join to gifts by name, so keep the names consistent in eTapestry.

Can I report on eTapestry donor retention and lapsed donors?

Yes, from gift history. Retention is the donors who gave in the previous period and gave again, divided by all donors from the previous period. The same history lists lapsed donors (gave last year but not this year, often called LYBUNT), time between gifts and how often each donor gives. To split retention by something like region or how a donor was acquired, record it in an eTapestry defined field; defined field values sync with each account and gift.

How does Filament handle eTapestry recurring gifts and pledges?

Recurring gift schedules sync with their frequency, next gift date, next gift amount and instalment amount, so you can list active recurring donors and forecast the coming months. Pledges sync with the pledged amount, outstanding balance, arrears amount and next payment date, and each payment links back to its pledge, so you can work out fulfilment and list pledges with a missed payment. The schedules describe active recurring gifts, so use gift history for trends over time.

Which eTapestry KPIs can I track?

Fundraising income: total recorded gifts by fund, campaign or approach, keeping gifts, pledges and pledge payments distinct. Donor retention: prior-period donors who give again divided by all prior-period donors. Pledge fulfilment: payments applied to pledges divided by their pledged amount.

I'm moving off eTapestry. Can I keep my giving history?

Yes, in your own warehouse. Connect eTapestry to Filament before you switch and the first sync copies every account and journal entry, with no date cap, including fund, campaign and approach. The copy stays as long as the eTapestry connection stays in Filament; disconnecting an app deletes its copy. Connect your new donor database too and both sit side by side, so you can report across the switch.

Is Filament an alternative to eTapestry?

No. Filament is for reporting, not a donor database. You keep recording donors and gifts in eTapestry, and Filament reads that data to build your reports and dashboards. If you move to another donor database later, Filament also connects to Salesforce, Little Green Light and NationBuilder.

Do I need Power BI or Looker Studio for eTapestry dashboards?

No. Filament syncs eTapestry into your own warehouse and builds the dashboards and PDF reports itself, so there is no separate BI tool to connect. You can also ask about your eTapestry data from Claude or ChatGPT through Filament's MCP server.

How far back does Filament sync eTapestry data?

We sync every account and journal entry in your eTapestry database on the initial backfill. After that, syncs run every 6 hours and only pull records changed since the last run using eTapestry's modified or created date watermark. There is no rolling window or hard date cap.

Can I connect multiple eTapestry accounts to Filament?

Yes, you can connect multiple eTapestry accounts to Filament. This is particularly useful for agencies managing multiple nonprofit clients or organisations with separate eTapestry databases for different programs or regional offices.

Last updated