Categories
ADRFM

Engaging Networks Reporting Suite

Unlock the Power of Data for Your Charity Clients with Our Exclusive Engaging Networks Reporting Suite

Built on the Microsoft Power BI platform, our reporting suite makes it easy to discover impactful insights into your Engaging Networks‘ data.

Are you a design agency partnering with Engaging Networks? Elevate your offerings by introducing your clients to the most comprehensive and easy-to-use reporting suite, exclusively built for Engaging Networks. Join hands with Actually Data Analytics and take your client relationship to the next level.

At Actually Data Analytics we don’t simply take your data and visualise it in charts and graphs. We’ll run some calculations and plug in other reference data to give you even more insight into who your supporters are and how they interact with you.

Users of our ADRFM reporting suite can filter Engaging Networks data on data from their CRM system too, opening up a whole new world of possibilities!

EN Reporting overview

Key features:

  • Regular Data Refreshes: We’ll update the data in the report daily using the Engaging Networks API
  • Geographical Analysis: Know where your supporters are located to tailor your campaigns more effectively.
  • Donation Metrics: Track donations, frequency, and preferences to optimize future fundraising efforts.
  • Action Tracking: Gain insights into the non financial actions taken by supporters on your charity’s behalf and how they convert to financial supporters

Benefits:

  • Ease of Use: No need for data science skills. Simple, straightforward, and ready-to-use reports.
  • Deep Insights: Go beyond superficial data and get to the nitty-gritty of what drives supporter engagement.
  • Compliance Assured: Fully compliant with UK and EU data protection laws and GDPR.

Book a demo

Ready to take the next step? Click book a demo for a no-obligation demo and discover how our reporting suite can add value to your organisation and your supporters.

Categories
ADRFM Guest Post Insight Reporting

A Case Study for ADRFM

RNID, the UK’s leading charity supporting people with hearing loss, has seen significant benefits from using the ADRFM Reporting suite for Actually Data Analytics.

Previously, RNID struggled to gain a comprehensive understanding of its data and make informed decisions based on that data. The organization had a variety of different data sources, including customer relationship management (CRM) systems, fundraising platforms, and marketing tools, but it lacked a centralised system for collecting and analyzing this data.

This changed when RNID implemented the ADRFM Reporting suite. The suite enabled RNID to bring all of its data into a single platform, allowing the organization to gain a much clearer understanding of its data and use it to inform its decisions.

One key benefit of the ADRFM Reporting suite has been the ability to track the effectiveness of RNID’s marketing campaigns. With the suite, RNID can see which campaigns are generating the most leads and donations, and can use this information to optimize its marketing efforts.

This has helped RNID to significantly increase its fundraising efforts and better serve the needs of its donors and supporters.

In addition to its marketing benefits, the ADRFM Reporting suite has also helped RNID to improve its supporter care. The organization can now more easily track supporter interactions and respond to their needs in a timely and effective manner.

Overall, the ADRFM Reporting suite has been a valuable asset for RNID, helping the organization to better understand its data, optimize its marketing efforts, and improve its customer service.

You can read more about their journey here

Categories
ADRFM Insight Reporting

What to count and where the pitfalls are

Depending on their specific goals and objectives, charities can benefit from tracking a variety of key metrics. Some common metrics to consider for charities include:

  1. Donor acquisition and retention: Tracking the number of new donors acquired as well as the percentage of donors who continue to give over time can assist a charity in understanding the health of its donor base and identifying areas for growth.
  2. Measuring the cost of acquiring a new donor or the return on investment of various fundraising efforts can assist a charity in understanding the effectiveness of its fundraising efforts and identifying areas for improvement.
  3. Tracking the number of people served or the outcomes achieved by the charity’s programmes can assist in demonstrating the impact of the organization’s work and identifying areas for growth.
  4. Monitoring financial metrics such as revenue, expenses, and profitability can assist a charity in understanding its financial health and identifying areas for improvement.

When tracking metrics for a charity, there are a few potential pitfalls to be aware of. One common stumbling block is focusing too much on short-term metrics, such as the number of donations received in a given month, rather than taking a long-term perspective. It is critical to consider how various metrics may impact the organisation in the long run, rather than just in the short term.

Another stumbling block is relying on metrics that are simple to track but may not be the most meaningful or relevant to the organisation. Tracking the number of website visitors, for example, may be simple, but it may not provide much insight into the effectiveness of the organization’s efforts.

It is critical to carefully consider which metrics are most important and meaningful to the organisation and to track them consistently over time.

Finally, it is essential to comprehend the limitations of any metrics that are tracked. No single metric can provide an accurate picture of an organization’s performance, so it’s critical to consider how different metrics are related and how they are influenced by external factors.

Categories
ADRFM Insight Reporting

An Intro to ADRFM

Are you tired of manually analyzing data for your business reports?

Look no further than ADRFM Reporting Suite!

Our powerful software automates the analysis process and visualising your data, allowing you to focus on making informed decisions for your business.

But don’t just take our word for it, check out our video demonstration of ADRFM Reporting Suite in action.

See how easy it is to view your data and gain valuable insights into your business operations. Don’t waste any more time on reporting. Upgrade to ADRFM Reporting Suite today and streamline your reporting process. For more information, please Get in touch.

We’ve also just released a new module for Engaging Networks Reporting. If you’re an Engaging Networks customer, you can find out more here

Categories
ADRFM Beginner Insight Reporting

12 Days of Christmas

As some fun and to get you into the spirit of Christmas, we’ve decided to publish a page of a Power BI report each day to show you what can be done with data and what types of visualisations might be useful for your organisation.

This is an interactive reporting suite, feel free to have a play and see what little nuggets of insight you can gain. This is demo data so please bear this in mind when looking at the numbers.

Day 1 – We start off with maps – everyone gets excited to see their supporters on a map, but it can be really useful when thinking about new products or events that you may want to hold outside of London.

Day 2 – KPIs – They’re important so you know what’s working and what isn’t. If it isn’t working, you know you can change something. It’s also a really nice way to make this data presentable rather than a flat table of numbers, which I have presented to leadership teams before and couldn’t understand why it wasn’t engaging for them!

Day 3 – RFM – So here’s where we get to the more exciting segmentation models that some charities we’ve worked with have used in the past. Recency, Frequency and Monetary (or sometimes its called Value RFV). It’s a simple model of creating segments based on giving history and if you haven’t started segmenting your supporters this is a great way to get started.

Day 4 – Performance – This is one of the most powerful reports and really simple to visualise your teams activities. One of the things that this shows you is that you can filter other visuals based on a selection that you make. To see this in action click on Public Fundraising in green and watch the table change to only activities that were carried out by the Public Fundraising team. When looking at a visual, there is a menu on the right hand side that allows you to focus on a specific tile and there’s also an export data option for the summaries if you need to do more analysis under the three dots.

Day 5 – Demographics – Here we show how we blend data with open data sets to add value and help you to identify other key identifiers that your supporters may have. You can see a breakdown of Acorn classifications for the supporters. There are 8 high level classifcations that are then broken down to 2 further levels.

And as a bonus for me releasing Day 5 late, I’ve released Day 6 a few hours early.

Day 6 – Regular Giving – As well as keeping an eye on the number of active regular givers you have, it’s also a good idea to keep an eye on the number of cancellations. To help with forecasting and planning we’ve extracted the average annual value of the regular givers.

Day 7 – High Value Fundraising – This report shows people at the different stages of solicitation. It also identifies the different types of restrictions that may apply to those special gifts

Day 8 – Forecasting – As we come to the end of the year, we all have the challenge of working out how we’re going to forecast for the coming year. Here we demonstrate using the past number of years income to forecast what may be expected in the future. It’s by no means perfect, but it’s a starting place.

Day 9 – Gift Aid – As we all know, gift aid is the extra money that you can get for nearly free! You need a declaration and your system will probably work out based on rules of what you can claim and what you can’t. Here you can see who you may want to send a communication to. These people are people who have given a gift that potentially is giftaidable but you can’t or haven’t claimed gift aid on the income. So as Tesco says, Every little helps especially with the current economic climate. Don’t forget to run your own gift aid mailing, maybe as a thank you mailing to all your supporters who have given in the last 12 months and try and entice them where it’s appropriate to give a declaration. Remember you can take a declaration over the phone if you have a supporter care team who are speaking to supporters you just need to confirm the verbal declaration in a letter and then so long as they don’t come back you’d be good to claim from those declarations as well.

Day 10 – Events – So as we move to a new year and start looking at calendars, here’s an overview of what has happened with events in the last financial year. It’s useful to see what platforms your supporters are using. We also look at the user stories for participants and its always interesting to see the keywords that different demographic of supporters use. Have a click around and let us know what you think.

Day 11 – Contactability – Every data persons favourite subject, GDPR and data protection. Here we demonstrate how to show the number of records that you can contact by the various channels used within the sector. We show the split between genders and age bands of opted in supporters broken down by the likely different communication purposes you’re want to use.

Day 12 – Communications – We all know that fundraising is built on relationships and a key to understanding relationships is language. Communications shows the different ways we interact with our supporters and how they speak to us and how we speak to them.

It’s been a blast putting this together, if you’ve not noticed it there’s an i at the top of each page which will give you more information about our reporting tools so come on dive in. We have a special offer that we will release next week if you’d like to get started on your reporting journey.


In terms of navigation, if you click on the “of” from 1 of 2 at the bottom of the report screen, you’ll be able to quickly navigate to the page you want to see.

As always, if you’re interested in finding out how ADRFM and our reporting solutions could help your organisation, feel free to get in touch.

Categories
ADRFM Beginner Guest Post Insight Strategy

The Devil’s in the Data : 4 Tips to Help Develop a Data Led Fundraising Culture

This blog post was very kindly written by Paul Hayward, Director of Fundraising, RNID. 

If you work in fundraising, or alongside fundraisers, you’ll know how important data is to everything we do. You use it to track progress, assess programs, and make decisions about where to allocate precious resources. But what about using data to inform and guide your fundraising team? Building a data led approach to fundraising can help you raise more money and do so more efficiently. At RNID this approach has driven our fundraising strategy, our ways of working and the way we make day-to-day decisions, with a transformative effect.

Here are four tips to get you started:

1. Use data to set goals.

Too often, fundraising teams operate without clear goals. This can lead to wasted time and resources chasing after unimportant metrics. Instead, use data to set attainable goals for your team. What amount of money do you realistically want to raise? What kind of growth do you want to see? What’s the long-term value of the work you’re delivering? Answering these questions will help you focus your team’s efforts and better utilize your resources.

2. Use data to inform strategy.

Once you have set some goals, it’s time to start thinking about how you’re going to achieve them. This is where data comes in. Look at your programme and try to identify trends. Who are your most generous donors? What kinds of appeals work best with different segments of your audience? What products attract and retain people most effectively? Answering these questions will help you develop targeted strategies for reaching your goals.

3. Use data to track progress.

As you implement your fundraising plans, be sure to track progress along the way. This will help you course correct if necessary and adjust your strategy as needed. It will also help you see what’s working so that you can replicate those successes in the future. Set some relevant KPI’s before you act and keep checking back in to see your progress against them; not only will it help you hold your work to account, but it will help develop a sense of momentum as you succeed!

4. Use data to assess results.

Once you’ve reached the end of a campaign, it’s time to take a step back and assess the results of your efforts. Which strategies were most successful? Which ones fell short? What can you learn from your experience that will help you be even more successful next time around? Answering these questions will help you fine-tune your approach, develop future strategies and make sure that you’re constantly learning and improving.

Developing a data led fundraising team doesn’t have to be complicated or time-consuming. By following these four simple tips, you can start making data-informed decisions that will help you raise more money and do so more efficiently. So what are you waiting for? Get started today!

Categories
ADRFM Insight Reporting Strategy

Board Report – What should you tell them?

Reporting and Insight should always be led or driven by the strategic direction of the organisation, whether that be an organisational strategy or fundraising strategy. It’s only knowing where you are now that can help you work out where you’re going and how well your doing against those objectives or targets. So I would always make sure that these strategic documents include ways in which you are planning on measuring success.

The next thing that I would say is break up the kpis into when they make sense to the audience that want or need them. There’s no point giving an appeal and segment breakdown to board members as they won’t be into the detail, they’ll just want to know if you asked us for investment did it work and how much did it return? I recently finished a book by Elizabeth Clarke which talked about understanding your audiences for reporting which was really helpful to me. You can find a link to that book here.

So you should have now an idea of where you’re going and a way in which you’d like to measure the success of those initiatives. The next thing is the data. You can only count what you can record so this should help inform what you want to do with coding structures across your CRM system. Whether its the number of new regular givers or the number of campaigners or the number of facebook fundraisers, all of these things should be recorded in your database somewhere.

So now you have data and targets the next thing to do is work out your baseline, where are you right now. this gives you a starting point to compare yourself to. A key thing here is that you are comparing your organisation to your organisation, not anyone else or any other organisation or any other sector benchmarks to start off with.

And if you don’t have targets, that’s ok, compare yourself to the same period last year (for those of you using power bi, that’s a formula you can use – sameperiodlastyear() ). If you don’t have the data then that’s ok too everyone starts somewhere.

Here are some top line kpis that we record as part of our reporting suite:

  1. Total Income
  2. Total Number of Contacts
  3. Total Number of Donors
  4. Total Number of Active Regular Givers
  5. Total Number of supporters that we can email
Here’s an example of our ADRFM reporting suite showing the top line details for a board report.

Using these 5 key indicators should be enough to work out how the organisation is performing, especially when you compare it to a previous period and start to identify trends.

For a board report, that should be enough to get started around income, expenditure would be helpful as well but not many organisations record this in their CRM. I’m a fan of recording some high level numbers for expenditure in your CRM just so that you can begin to work out ROI (Return on Investment) for all the activities that you do. Remeber everything has a cost, so free activities still have costs associated with them, whether it be staff time or freebies that are offered for support.

The other thing with these kpis is they should be relatively easy to pull out of your CRM systems. I appreciate that any kpis that require a snapshot of your data can be a challenge but power bi does make some of that easier with the use of DAX formulas.

Other things that Boards would normally want to know about are forecasted income Whether that be from High Value teams like Major Donors and Trusts or whether that be from things like Regular Giving and Lifetime value.

The key with all of the reporting data, start small and then grow. Once you have a handful of indicators and I would suggest no more than 6 indicators to start off with give it at least 6 months to show trends and then put some narrative around what the numbers say. A thirst for knowledge or curiosity, both of which are really useful may lead you to other things that you might want to look at, like 2nd gift rates, retention, conversion but think very carefully about whether these secondary indicators need to be reported to the board or if it will overwhelm them with numbers – nobody wants a wall of data

If you’d like to learn more about how we can help you get started on your reporting journey please get in touch.

Categories
ADRFM

The journey so far….

So I’ve been a fan of the power platform for a long time now. I’ve done presentations about the use of power query in excel to replace the need of even more complicated excel macros to do data trnasformation for those regular tasks of recoding and transforming data in the sector. I started with Access Databases and I’m aware that there are a number of charities who still use Microsoft Access to transform their weekly data feeds for importing into their CRM system.

So ADRFM, our name for our reporting platform, where did it start? One of my first jobs in the sector as database manager was looking at monthly reporting and looking at volunteering numbers and identifying the number of people who dropped out of the recruitment process. I found it fascinating, now I look back and think that if only Power BI existed then (we’re talking about 2006) then fundraisers would have understood what I was trying to explain with a wall of data. Yes I fell into the trap of presenting tables of data and just expecting people to get it. I’ve found out that they don’t!

For years I’ve worked with clients who have needed insight into their fundraising activities. Some have just wanted high level numbers and then some people wanted to drill down into the data, so we’ve taken these lists of requirements that we’ve seen over the years and turned it into a vast array of visualisations that make sense to anyone working within the charity space. So how did we get here.

We looked at the various different areas of CRM systems that we’ve worked with and came up with a data model that provided us with what we needed for reporting.

Then I needed to review what others were putting out there in terms of visualisation styles. Doing an image search on google revealed lots of different styles of reporting and insight see here but what I wanted was something that meant that users didn’t need to ask for a “could I just” once I’d created it. These range from could I see this by a different field instead or now that we have this could I see this as well please. One of the things that frustrates database people is their lack of time for things that are outside of the standard day job, business as usual (BAU) stuff. Reporting and Insight falls into this category normally, but a larger number of job opportunities for reporting and insight opportunities seem to be offered by the larger organisations which is great.

So now I have a model and I have an idea of what’s possible with Power BI so it was now a question of learning Power BI. Enter a pandemic and most of the consulting work I was working on was put on hold whilst Charities tried to deal with BAU, so I decided to learn Power BI. I started with a quick youtube search, I wanted something I could just dip my toe into enter the series of videos by “Guy in a cube” without a shadow of a doubt these guys are probably my favourite bite sized learning duo friends. If you’ve not watched a couple of their videos do it, you won’t regret it.

Then I needed something to help me with the transfer of my skills. Writing DAX is like writing excel formula, most of us only scratch the surface of what’s possible there’s a couple of great resources if you’re starting on your DAX journey, the ones I’ve used the most are: Enterprise DNA and Home – SQLBI. The SQL BI one was really useful for me as it compared SQL code to how you’d tackle that in dax. With Enterprise DNA, the deep dives that Sam and his team have done (again which can be found on youtube) are really excellent. As always I’ve got a couple of reference books that I regularly have by my side but more and more I find using videos better as things change so quickly these days that books seem out of date by the time they are written (apologies to any authors out there reading this!) The one thing that I tried to stay away from was the microsoft documentation. I’ve never got on with Microsoft’s documentation, I’m just not wired that way. If you get Microsoft’s documentation great, crack on, there’s loads of stuff on Power BI it just doesn’t work for me.

So now I have a model, an idea of what page layouts I wanted and a map of how to create the “measures” of the things that I want to count, the next bit was understanding the different options for “cards” the actual thins that you can put on a page. On the SQL BI website there’s this really cool reference tool that helps you understand what visuals you should use and when, you can check it out here: Power BI Visuals Reference – SQLBI

Then it was a case of building it. Blood sweat and tears, lots of sleepless nights, lots of rabbit holes of “how cool is this” and “wouldn’t it be great if..” and then iterating with customers to see what works for the users.

I’m proud to say that during our first year we were shortlisted for a DMA award with the initial work we did with RNID, now into our 2nd year and we’ve split it out to a new company, let me introduce you to Actually Data Analytics, which has three main products a lite version for people just starting out on their reporting journey, a pro version which is everything you could ever want and more (I hope). I promise to talk about this more or check out the website and a medium version for those organisations where only specific areas are ready to tackle reporting.

So I hope that these resources are helpful, there are other tools that I’ve used as well including DAX studio, Power BI helper which have pointed me in the right directions. I talk about these in a different post where I talk about the pitfalls of Power BI for consultants.

If you’d like to find out more then please get in touch or if you’d like to connect about reporting and insight let me know.

Categories
ADRFM

Welcome to a world of….

Over the years, I’ve really enjoyed working in the sector, there’s great people and causes but one thing that I’ve always struggled with is the lack of data understanding.

I remember, whilst typing this, of a conversation I had on a train early in my role at VSO with the head of Individual Giving and another fundraiser where I was waxing lyrical about data and its usage and how animated I got and was told to calm down and you’ll go far but also remember thinking to myself I need to bridge the gap between the database and the fundraising team. I thought that this was my job as Database Manager.

15 years later and I’m now at a stage where I’m still trying to bring fundraisers closer to their data. Over the years I’ve understood that fundraisers are people who like colours rather than a wall of numbers – I’ve tried to do both, they like simplicity rather than having to write queries and are mainly comfortable in excel. Some of the new fundraisers though and the ones that I think that will excel (see what I did there!) over the coming years are the ones that are curious about their supporters and want to get closer to their data.

Enter ADRFM

ADRFM is a suite of reports that cover the key reports and metrics that fundraisers have asked me for over the years. Actually Data’s Really Fantastic Metrics (ADRFM) was born.

One of the things I’ve always enjoyed is delivering training sessions. When a user gets what you’re trying to show them, as an example, queries in Raiser’s Edge. There’s no better feeling that you’ve just made someone self sufficient. I’ve worked with organisations who have asked me for reports from CRM systems and I’ve also worked with organisations who’ve had no reporting in place or not had any ideas of how well they have been performing other than what’s in the management accounts. The level of detail that is available or should be available in your CRM system should mean that you have answers to questions like: Who are my best supporters, where do they live, what products do they buy, when do they buy them, what will they buy next. None of this is going to come from your management accounts.

Having worked with a number of organisations where there were monthly reports required and doing mailing selections for clients. I’ve spent a lot of time thinking about what has been common across these organisations, large and small. Simple things like RFV (Recency, Frequency, Value) to single givers and multi givers were always things that seemed to be high up on a fundraisers mind. Then there were things around average gift amounts and the number of communications that a supporter has received. We have over 20 metrics that we can calculate on your data that you can select supporters on or review what they have done some of which might be things that you’d like to test at some point in the future in a mailing or supporter journey.

Having a suite of reports that covers all aspects of fundraising that is simple to use and explore your data I hope brings fundraisers closer to their supporters and helps them understand what they do and when they do it. It’s colourful so hopefully more engaging than a crystal report and gives organisations who haven’t reviewed their reporting needs a starting point. One of the clients used it in that way, they needed reporting but wasn’t sure what they wanted so have started with ADRFM and found that it meets most of their requirements

ADRFM is a system agnostic, subscription product. so we don’t mind if you’re using thankQ, Raiser’s Edge, D365, Salesforce or any other of the number of CRM systems that are in the sector, our system will work with it. We have customers who combine data from multiple systems to use together instead of going through a full data warehouse solution.

As with most things that I’ve worked on, I believe that reporting is a journey, if you’re just starting out on your journey we have a reporting suite that will get you and your organisation started. This is ADRFM lite, it covers reporting and KPIs.

If however, you’re a larger organisation embracing data already and looking to take the next step with your reporting we have the Pro version which has the reporting, KPI’s, metrics and our very own segmentation tool. This allows fundraisers (or anyone?) to create their own segments to do analysis with.

We’ve also done bespoke reports using the same technology and based on our data model using data from Google Analytics and Email Marketing Platforms like Dot Digital.

So if you’d like to find out more about ADRFM or talk about your specific reporting needs and how it might help your organisation get in touch and we can have a virtual coffee and talk about it in more detail, you may need to tell me to “calm down” though ;). Contact Us