Weekly Sales Report Template

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

Current State:

Each week every sales person fills in the attached report. They collate this information from Salesforce CRM as well as write down other non data type items like key achievements etc. Once they have the report filled in they email it to me as the Sales Manager.

Objective:

I would like to make this report more modern and visual, when they insert the number of appointments for example it shows on a dashboard type interface whether they are above or below target.

The target for each person is different so i would like to make it easy to adjust the target when required.

I want to keep it on one page.

I would also like some suggestions as to whether it can calculate an overall percentage or grade as to how they performed that week. For example Project specific meetings earn more points than say Initial discovery meetings with builders and contractors etc.

I am happy for whatever platform you design it in either Word or excel.

To be successful for this job please offer a lump sum price as well as some similar examples you have completed previously.

CRM Excel Salesforce.com Word

Project ID: #18721998

About the project

24 proposals Remote project Active 5 years ago

Awarded to:

aimefx

Hi, I am an expert in Excel, VBA, Power bi and MySQL. I can create a dashboard for you in Excel or Power bi whatever you like. The dashboard will be automatic, there will be a source folder when you get a new email, More

$150 AUD in 3 days
(82 Reviews)
6.1

24 freelancers are bidding on average $183 for this job

singhalp

Hi There, How are you? I am a Senior Salesforce Consultant, Solution Architect, and Developer with 7+ years of experience in Salesforce. I am highly trained Salesforce® certified with a strong knowledge of Salesforce A More

$222 AUD in 3 days
(36 Reviews)
7.2
ShreyShrma

Hello, Hope you are doing well :) I would love to have the opportunity to discuss your project with you. May I ask about your Salesforce edition? We have worked on environments of companies like “Deloitte” More

$250 AUD in 3 days
(25 Reviews)
6.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. I would appreciate a example report from you, which I can give life to More

$250 AUD in 5 days
(115 Reviews)
6.4
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

$200 AUD in 2 days
(33 Reviews)
5.7
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

$150 AUD in 3 days
(68 Reviews)
5.7
AhmedMarzoq

Hello I have previous experience in making and build dashboard by using excel and learn you how can deal with it and easy update by your self appreciate if you take quick look to my profile reviews

$250 AUD in 5 days
(23 Reviews)
4.9
braincenter

I DO NOT OUTSOURCE I have been a freelancer for the past 8 years, I believe that my experience and skill in this background will prove to be of great help to you. Contact me to discuss more on the details

$200 AUD in 3 days
(2 Reviews)
3.7
writingorders365

Hey, It seems to be that you are looking for writing a sales report. I can help you with this task. Please fell free to knock me. Thank you.

$50 AUD in 3 days
(1 Review)
2.0
liejuni

hi, we checked the "word" file and we suggest using "Excel" as your platform and for your dashboard. there will be 1 "Main Sheet" for you as the manager the other sheets are the sheet for the Sales Person (you ca More

$222 AUD in 3 days
(1 Review)
0.8
yoocef

Dynamique et motivé, j’ai acquis au cours de mes premières expériences les qualités d’écoute et de compréhension nécessaire à ce poste en me familiarisant avec les outils techniques à votre disposition. Espérant que m More

$133 AUD in 10 days
(0 Reviews)
0.0
amirthaa04

Dear client I have been working in accounting field for years. I was also responsible for preparing weekly MIS statements. I can assure you that work will be done on time and meet your expectations as I have good exp More

$111 AUD in 3 days
(0 Reviews)
0.0
NausalTec

Greetings, Its Wali Caan Business development officer from Nausal Technologies. I have gone through your description and I was interested in your project. I am a bidder and I submit my daily and weekly reports to m More

$277 AUD in 1 day
(0 Reviews)
0.0
kevinmbutt

Good Day, I would suggest an Excel file with worksheets containing raw data for each aspect of the report, for example Salesforce data on one worksheet and data to be keyed manually on another worksheet(s). A main More

$250 AUD in 3 days
(0 Reviews)
0.0
SteveHeu

Hey mate Steve from Melbourne here Seems like a pretty straightforward project So, at present, you define the values in the Target column and the team member fills in the rest? I think this would be better More

$200 AUD in 2 days
(0 Reviews)
0.0
khamis853

Hello There, As an accomplished consultant with a background in environmental sciences, I have been using MS Excel to make my life easier for the past 10 years! As a power excel user, dashboards, data visualization More

$277 AUD in 5 days
(0 Reviews)
0.0
jeanifernavarro

With prior experience in Sales and Marketing budget and profitability setting, I can make you a template wherein specific sales person can input their data on the designated sheet, a summary sheet will show how does th More

$166 AUD in 3 days
(0 Reviews)
0.0
prasoonuit

Hello, My name is Prasoon and I have been working for the private sector for the past 2 years as Key Account Manager and Sales & Marketing representative heading several regions in my country. I feel I'm best suited More

$88 AUD in 4 days
(0 Reviews)
0.0
amicomic

Full salesforce development team. Certified admin / developer. Multiple apps on appexchange. Please let me know if you would like to discuss details. This is pretty straight forward work for us and happy to assist.

$30 AUD in 10 days
(0 Reviews)
0.0
beautyhealthin

Hello Friend. I am confident that i can do this. Let's discuss more on chat about the full requirements.

$222 AUD in 3 days
(0 Reviews)
0.0