Em Andamento

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!

Habilidades: Programação de Banco de Dados, Excel, Visualization

Veja mais: 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

Acerca do Empregador:
( 3 comentários ) Upper Marlboro, United States

ID do Projeto: #18137379

Concedido a:

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 Mais

$1500 USD em 7 dias
(114 Comentários)
7.5

29 freelancers estão ofertando em média $2151 para esse trabalho

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 ( Mais

$2000 USD in 7 dias
(634 Comentários)
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 Mais

$3000 USD in 30 dias
(274 Comentários)
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 dias
(274 Comentários)
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 Mais

$1800 USD in 5 dias
(166 Comentários)
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 dias
(250 Comentários)
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 Mais

$1500 USD in 14 dias
(166 Comentários)
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 Mais

$1500 USD in 15 dias
(77 Comentários)
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. Mais

$2000 USD in 10 dias
(129 Comentários)
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 Mais

$1500 USD in 10 dias
(276 Comentários)
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 dias
(69 Comentários)
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 Mais

$1500 USD in 5 dias
(51 Comentários)
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 Mais

$7444 USD in 70 dias
(1 Comentário)
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 Mais

$2500 USD in 30 dias
(2 Comentários)
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 Mais

$1500 USD in 20 dias
(21 Comentários)
4.9
ilkecokay

.......................................................................................................................................................................................................................... Mais

$2500 USD in 30 dias
(19 Comentários)
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 Mais

$1500 USD in 4 dias
(14 Comentários)
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. Mais

$1500 USD in 30 dias
(2 Comentários)
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 Mais

$1500 USD in 2 dias
(2 Comentários)
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 Mais

$5000 USD in 30 dias
(2 Comentários)
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 Mais

$1522 USD in 30 dias
(9 Comentários)
3.7