KPI Dashboards/Scorecard and reporting in excel
Budget: £10 – £15 GBP
This is for a Real Estate business.
We need a KPI Dashboard with graphics to show how we are spending and understand our cost per lead.
We have a real estate and finance broker business.
We need to track the number of leads , cost, and estimated gross profit and net profit out to the gross .
For example:
For out real-estate we need to input the following fields
name of client, property, ARV( After Repair Value), Repairs, appraisal , inspection, Closing Cost, Agent commission, Fixed Monthly Operations cost, Support Team Commission, Total Cost, Net profit
Then Track the Campaign that generated this lead:
Campaign Name, Cost of Campaign, Number of Emails sent, Post Cards Sent, voice mails sent, response rate, number of leads generated, Number of Contracts, cost per lead generated, date of lead( very important to track for the month), # of accepted deals, Cost per accepted deals.
Need to be able to see graphs that indicated leads for the month, deals accepted for the month.
We prefer English speaking
Must provide a excel prototype that matches what we are looking for, we need to make sure that what you designed will work.
Must have experience in the real estate space for providing KPIs for business
We need a KPI Dashboard with graphics to show how we are spending and understand our cost per lead.
We have a real estate and finance broker business.
We need to track the number of leads , cost, and estimated gross profit and net profit out to the gross .
For example:
For out real-estate we need to input the following fields
name of client, property, ARV( After Repair Value), Repairs, appraisal , inspection, Closing Cost, Agent commission, Fixed Monthly Operations cost, Support Team Commission, Total Cost, Net profit
Then Track the Campaign that generated this lead:
Campaign Name, Cost of Campaign, Number of Emails sent, Post Cards Sent, voice mails sent, response rate, number of leads generated, Number of Contracts, cost per lead generated, date of lead( very important to track for the month), # of accepted deals, Cost per accepted deals.
Need to be able to see graphs that indicated leads for the month, deals accepted for the month.
We prefer English speaking
Must provide a excel prototype that matches what we are looking for, we need to make sure that what you designed will work.
Must have experience in the real estate space for providing KPIs for business