topic Re: Retention rate report in Dashboards & Reporting

Retention rate report

LChandler2 — Wed, 22 May 2024 12:33:51 GMT

We are looking to create a donor retention rate report for our dashboard. Has anyone successfully done this and if so how did you set it up?

Re: Retention rate report

LouiseHare — Wed, 22 May 2024 13:18:48 GMT

Hi @LChandler2,

What do you define as a retention internally? This information will help me to suggest a solution for you.

Thanks,

Louise Hare she/her

Freelance HubSpot Expert

If my reply helped to answer your question please mark it as a solution to make it

easier for others to find!

Re: Retention rate report

LChandler2 — Fri, 24 May 2024 12:41:16 GMT

Hi @LouiseHare Thanks for your help! We define donor retention rate as the percentage of previous period donors who have donated again in the current period.

Re: Retention rate report

LouiseHare — Fri, 24 May 2024 14:12:53 GMT

Hi @LChandler2 ,

I've wracked my brain on this one but have struggled to come with anything that shows what you are looking to see.

The best that I can suggest at the moment is the following:

Create a list of Contacts who are associated to a Deal that has entered the Closed Won stage in the last 30 days (frustratingly, you can't use time period filters such as this quarter in lists)

Create a custom report with Contacts as the primary data source and Deals as the secondary data source. Select the KPI report type and add the following filters-

What the report will show you is the number of Contacts who are associated to a Deal that has been Closed Won more than 30 days ago and less than 60 days ago, and also have another Deal that has Closed Won in the last 30 days - ie. anyone who has made a donation 'last month' and also 'this month'.

Not the ideal solution but hope this is somewhat helpful!

Louise Hare she/her

Freelance HubSpot Expert

If my reply helped to answer your question please mark it as a solution to make it

easier for others to find!