Đã hoàn thành

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!

Kĩ năng: Lập trình cơ sở dữ liệu, Excel, Visualization

Xem nhiều hơn: 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

Về Bên Thuê:
( 3 nhận xét ) Upper Marlboro, United States

ID dự án: #18137379

Được trao cho:

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 Thêm

$1500 USD trong 7 ngày
(115 Đánh Giá)
7.6

29 freelancer đang chào giá trung bình $2151 cho công việc này

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 ( Thêm

$2000 USD trong 7 ngày
(648 Nhận xét)
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 Thêm

$3000 USD trong 30 ngày
(278 Nhận xét)
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 trong 10 ngày
(274 Nhận xét)
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 Thêm

$1800 USD trong 5 ngày
(174 Nhận xét)
7.0
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 trong 15 ngày
(250 Nhận xét)
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 Thêm

$1500 USD trong 14 ngày
(166 Nhận xét)
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 Thêm

$1500 USD trong 15 ngày
(77 Nhận xét)
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. Thêm

$2000 USD trong 10 ngày
(129 Nhận xét)
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 Thêm

$1500 USD trong 10 ngày
(279 Nhận xét)
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 trong 10 ngày
(74 Nhận xét)
5.9
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 Thêm

$1500 USD trong 5 ngày
(59 Nhận xét)
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 Thêm

$7444 USD trong 70 ngày
(1 Nhận xét)
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 Thêm

$2500 USD trong 30 ngày
(2 Nhận xét)
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 Thêm

$1500 USD trong 20 ngày
(21 Nhận xét)
4.9
ilkecokay

.......................................................................................................................................................................................................................... Thêm

$2500 USD trong 30 ngày
(23 Nhận xét)
4.4
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 Thêm

$1500 USD trong 4 ngày
(14 Nhận xét)
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. Thêm

$1500 USD trong 30 ngày
(2 Nhận xét)
3.7
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 Thêm

$1522 USD trong 30 ngày
(12 Nhận xét)
3.9
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 Thêm

$1500 USD trong 2 ngày
(2 Nhận xét)
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 Thêm

$5000 USD trong 30 ngày
(2 Nhận xét)
3.5