Tamamlanmış

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!

Beceriler: Veritabanı Programlama, Excel, Görselleştirme

Daha fazlasını gör: 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

İşveren Hakkında:
( 3 değerlendirme ) Upper Marlboro, United States

Proje NO: #18137379

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 1500%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(115 Değerlendirme)
7.6

Bu iş için 29 freelancer ortalamada $2151 teklif veriyor

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 ( Daha Fazla

$2000 USD in 7 gün içinde
(648 Değerlendirme)
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 Daha Fazla

$3000 USD in 30 gün içinde
(278 Değerlendirme)
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 gün içinde
(274 Değerlendirme)
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 Daha Fazla

$1800 USD in 5 gün içinde
(174 Değerlendirme)
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 in 15 gün içinde
(250 Değerlendirme)
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 Daha Fazla

$1500 USD in 14 gün içinde
(166 Değerlendirme)
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 Daha Fazla

$1500 USD in 15 gün içinde
(77 Değerlendirme)
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. Daha Fazla

$2000 USD in 10 gün içinde
(129 Değerlendirme)
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 Daha Fazla

$1500 USD in 10 gün içinde
(279 Değerlendirme)
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 gün içinde
(74 Değerlendirme)
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 Daha Fazla

$1500 USD in 5 gün içinde
(59 Değerlendirme)
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 Daha Fazla

$7444 USD in 70 gün içinde
(1 Yorum)
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 Daha Fazla

$2500 USD in 30 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$1500 USD in 20 gün içinde
(21 Değerlendirme)
4.9
ilkecokay

.......................................................................................................................................................................................................................... Daha Fazla

$2500 USD in 30 gün içinde
(23 Değerlendirme)
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 Daha Fazla

$1500 USD in 4 gün içinde
(14 Değerlendirme)
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. Daha Fazla

$1500 USD in 30 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$1522 USD in 30 gün içinde
(12 Değerlendirme)
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 Daha Fazla

$1500 USD in 2 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$5000 USD in 30 gün içinde
(2 Değerlendirme)
3.5