Tuesday, April 15, 2014

Real Estate Client Information

A relative of mine recently started a real estate brokerage in Utah County. As part of the company, he started a website that captures leads and clients. These leads are saved on the website in a format that cannot be used very effectively.


The purpose of my final project is to give useful data to my relative so they can make decisions on which clients they need to be contacting and when. At a high level, this spreadsheet accesses the website and downloads the lead/client information to the spreadsheet. The data is manipulated into a usable pivot table that captures more information about how often the client is visiting the site and what price of houses they are looking at.

No comments:

Post a Comment