Updated on December 5, 2019
We asked Rob Sattler, a commercial real estate broker & Advisor at Cresa New York to share his story of data migration from Excel to AscendixRE Foundations for Salesforce. But before that, we asked him a few questions to get to know more about his background in commercial real estate.
Q: Tell us a little about your current focus and background.
Rob: I am a Tenant Rep Advisor in New York and assist occupiers of space primarily in Manhattan with their office requirements. I’ve been with Cresa for 2.5 years and was with a large global firm prior to moving to my current position. I moved to Cresa because of the focused niche as I was confident that their platform would help me better serve my current and future clients.
Q: How do you perceive the landscape of #CRETech today?
Rob: #CRETech today is seeing significant growth. What will change the landscape of #CRETech are the individuals involved in commercial real estate. As more and more millennials come into the business they will become quick adapters of the new technologies created to make their lives easier.
The baby boomers are at a point in their career where they are involved in transactions for a high-level relationship; they aren’t necessarily involved in the day to day creation of the reports and heavy paperwork that these new technologies help with. Their lack of adoption creates inefficiencies with their team below them.
As the landscape changes adoption will happen quicker than its happening today, but I’m sure the next generation coming into the CRE world will feel we’re not adapting fast enough.
Q: What is one of the ways Ascendix impressed you?
Rob: In one of our early conversations, we discussed that the world is becoming a “big data world” and those who do the best job of collecting, organizing, and utilizing data will achieve the highest levels of success.
Ascendix made it clear that with their solution I could build a database that would help advance my career and give me a competitive advantage.
Q: Before we get to your review of xRE Foundations, we want our readers to get to know you better. What is your favorite place to take a client to dinner or to celebrate in New York?
Rob: Harry’s on Stone Street.
Q: Are you a fan of the Yankees or Mets?
Q: Who makes the best hot dogs in New York City?
Rob: Please Don’t Tell (PDT) in the East Village.
Q: Can you give your review of our xRE Foundations solution built on Salesforce.com?
Rob: I was reviewing your competitors’ solutions, but what I like most about Ascendix was the relational aspect of the data and the high touch of their team throughout the process. It is easy to use and getting the information in was made easy by your team. I liked that you were upfront about the data migration process. Ascendix told me that they would help me through the process, but if I put in a little work on my side making sure the data was clean and complete I would benefit even more, and I have.
Data Importation Process: From 75% to 95% of Data Accuracy
Rob: Regarding the data importation process, my working assumption going in was that I would only be able to get an accuracy rate of around 75-80%. On one of our first calls, Wes Snow stated that we should shoot for a much higher rate than that if we follow a methodical process, perhaps approaching 100% accuracy.
My first thought based on previous experience was this not going to happen. Then Wes said, “we can definitely do better than 75%.” In the end, we achieved much closer to 95% data accuracy.
Ascendix set clear expectations for the capabilities of xRE Foundations the on-boarding process and it was extraordinary from the beginning. They carried me through all the way to the back-end. They have a process that made it pretty easy.
During the process, I thought I can’t believe I’m going back to review excel sheets again, but at the end of the day, it wasn’t that difficult as they did a great job of communicating the benefit to be gained in the end which served as ample motivation. And even better, xRE Foundations was exactly what I wanted it to look like and everything was where it was supposed to be.
I can’t stress enough the importance of taking time to prepare the data to assure usability of the tool for you and your future team. This investment of time was key if I wanted to build the best database in my market. I truly believe a database that is highly organized with my market intelligence will lead to more deals.
If you want to have a quality dataset that is better than the competition it is something that you have to spend your personal time on upfront, then your data will be streamlined in the future.
A quick tip to expedite the process; create a master spreadsheet to organize all of your data into one source file giving you the ability to not only identify duplicates faster but to establish links between record types such as companies and leases.
To give you some insight on what we imported, I imported every property in my market over 100,000 square feet, over 2,500 lease comps, another 1,000 accounts & associated contacts. Overall it was about 8,000 records.
The support team was great from start to finish. For example, I had a few basic questions one evening and I called the Ascendix client success team. I didn’t even leave a voicemail because I thought it could wait till the next day.
The rep I had been working with saw that she missed my call and immediately called back and said, “I’m in the car and I’m on my way home, but I saw I just missed your call and wanted to see how I could help.” On that call, she was able to quickly walk me though a few minor details. It was nice that she was so attentive to something that could have waited till the next day.
The whole team has gone above and beyond to make sure the system is working for me. Especially during the first 2 weeks in making sure that everything looked the way I wanted and, more importantly, functioned the way I wanted.
3 Hours a Week are Saved
In the short time of me using xRE Foundations it has been a big time saver. It’s also easy to run reports and especially to pull my comps. I’m quickly learning that in the click of a few buttons I can get everything I need for a meeting, then get it over to my team to prep for the presentation.
I can now focus on preparing for the deal instead of wasting time combining excel sheets and creating reports from scratch. In addition to making more informed decisions with the organization of the data, I would guess I’m saving about 3 hours a week and a lot can get done in 3 hours!