In Progress

Fundraising Results Tracking & Dashboard

We currently are measuring campaign response and reporting campaign response via a multi-tab Excel spreadsheet that relies on Pivot Tables and Vlookups to take a list of results and measure and track program success. We are seeking to streamline this process and build something that can grow with our project.

We have 15 different clients feeding one reporting spreadsheet.

We receive a daily file of donations, that includes a unique ID number, a response data, an amount, a campaign code, and also flags anyone who has deceased, changed address or asked to no longer be solicited.

We would like to have an interface where we can enter mail date and cost per mailing and campaign name.

As shown in the image below, we use those data elements to do the following:

Track Campaign Cost

Track Cost per piece mailed

Track Number of Donations

Track Gross Income

Track Net Income

Track Cost Per Mailing

Track Donor Response Rate

Track Average Gift

Track Return on Investment

Track Cost Per Dollar Raised

We can provide the calculations for all those fields and/or the Excel sheet we use to help speed the process if you are selected.

We would then want to total all results for the campaign codes within a program as well as totals for the calendar year of all programs within each client.

We want a dashboard that allows us to see these results.

Thank you!

Skills: Database Programming, Excel, Visualization

See more: the nonprofit dashboard: a tool for tracking progress, fundraising dashboards, fundraising metrics dashboard, free nonprofit dashboard template, organizational dashboard example, nonprofit dashboard samples, fundraising dashboard template, board dashboard template, mass mailing campaign, end year donor thank letter, non profit year end donor thank, end year thank donor, year review donor thank, end year thank donor letters, mass mailing cost per mail, mailing campaign php, tracking outsourced adword campaign, tracking results ups, tracking results google maps, postback campaign tracking directtrack

About the Employer:
( 3 reviews ) Upper Marlboro, United States

Project ID: #18137379

Awarded to:

Eagles90

Dear Client, We are interested in your project and ready to go for it. We have read your job description carefully and checked the attached files and understood the project. We have done similar projects so confi More

$1500 USD in 7 days
(114 Reviews)
7.5

29 freelancers are bidding on average $2151 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$2000 USD in 7 days
(634 Reviews)
8.3
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Fundraising Results Tracking & Dashboard. I can assure you the quality job. I have good experience in Database Programming, Excel, Visualizat More

$3000 USD in 30 days
(274 Reviews)
7.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$1500 USD in 10 days
(274 Reviews)
7.2
paris2785

Hello! My name is Paris, and I was glad to see that you're looking for a freelancer proficient in Excel. I'm among the most experienced and skilled Excel developers on this platform. According to your brief, you want More

$1800 USD in 5 days
(166 Reviews)
6.9
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$1500 USD in 15 days
(250 Reviews)
7.0
cugamelover

I read your requirements carefully and I confirm that I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analys More

$1500 USD in 14 days
(166 Reviews)
7.0
ShaunKleinOnline

Hi there, Your fundraising results tracking dashboard project sounds very interesting and I would love to explore this with you further. I think I'd be a great fit - I have over 17 years of corporate experience work More

$1500 USD in 15 days
(77 Reviews)
6.4
best4best

Hi, I am an Excel expert. I have created many easy-to-use templates for performing complex calculations. I am ready to discuss your project requirement in details. Please share the file with me and start discussion. More

$2000 USD in 10 days
(129 Reviews)
6.3
TonmoyRoy111

Dear client I have previously carried out a number of projects in excel using macros and formulas. I would like to help you in this project. I plan to make the interface in excel with data entry points and calculation More

$1500 USD in 10 days
(276 Reviews)
6.6
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.

$2000 USD in 10 days
(69 Reviews)
5.8
aimefx

Hi, I am expert in Excel, VBA, MySQL and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time dynamic dashboards, and Reports. You wil More

$1500 USD in 5 days
(51 Reviews)
5.7
leadconcept

Hi there, I have read everything carefully and checked the attachments too. As per my understanding, a campaign response is to be captured and then based on that the success of the program is to be evaluated. The us More

$7444 USD in 70 days
(1 Review)
5.1
lavizsolutions

Hi, Please share me the excel that you are currently using to understand the input data to system , also 4 hours to discuss the process for campaign and calculation part. Please select me and share me more detail More

$2500 USD in 30 days
(2 Reviews)
5.0
AhmedMarzoq

Hello sir I can help you in your project I make dashboard in some of my projects I can send you some of them and you can see example of dashboard I make it in my profile . appreciate if you contact me to work on you More

$1500 USD in 20 days
(21 Reviews)
4.9
ilkecokay

.......................................................................................................................................................................................................................... More

$2500 USD in 30 days
(19 Reviews)
4.3
afenache

Hi, I can build an excel custom dynamic dashboard (custom charts type, color codes, custom filters) similar with the one from my portfolio. This kind of dashboard is very easy to update with new data and is fully cont More

$1500 USD in 4 days
(14 Reviews)
4.1
C3guru

We are so talented Website design and development team. Please visit our site : [login to view URL] Or you can search "c3guru" on google. We are full stack developers. -Design : Graphic Design, UX/UI design, 3D modeling. More

$1500 USD in 30 days
(2 Reviews)
3.7
luiswilliam

Hello, I read the description of your project thoroughly. I understand your requirements basically, and I have experiences of similar project. I am professional Website builder and Mobile App developer, and talented A More

$1500 USD in 2 days
(2 Reviews)
3.5
donnyforu

Hello, We are an IT company based in India and we work extensively on Bigdata,data visualization,dashboards. We have a team highly skilled in Tableau, powerbi , Qlickview. We have an excellent track record of de More

$5000 USD in 30 days
(2 Reviews)
3.5
akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S More

$1522 USD in 30 days
(9 Reviews)
3.7