Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications

    Equity Taps CRM for Tracking Condo Sales

    By
    Joseph C. Panettieri
    -
    April 12, 2004
    Share
    Facebook
    Twitter
    Linkedin

      Equity Residential doesnt own boardwalk or Park Place, but if it were playing Monopoly, the Chicago-based company would manage much of the surrounding prime real estate.

      So when the company, which manages more than 1,000 prime properties across 35 states, decided last year to convert several of its apartment buildings into condominiums, it made sense, especially considering the real estate boom at the time.

      But Equity Residential realized fairly quickly that the condo sales strategy wouldnt pass “Go” without a new IT system in place.

      The company had used Microsoft Corp.s Excel to track condo sales, pricing and reporting and Microsoft Word as the foundation for documents, but there was no central means for culling and analyzing cumulative sales data.

      What the $1.8 billion property management company needed was a new CRM (customer relationship management) system that could handle functions such as tracking condo sales leads and identifying which marketing tactics were generating the best leads; monitoring the entire sales cycle for each condo unit; streamlining the documentation and paperwork required for sales closings; and tracking the inventory status of each condo unit (sold, pending and so on).

      Equity Residential reached out to local solutions providers, seeking an IT partner that could design such a system using Microsoft CRM, the software companys fledgling package for midsize businesses. However, two solutions providers tried—and failed.

      Then came Sonoma Partners LLC, a Chicago-based solutions provider that designs IT systems for small and midsize customers, typically those with 25 to 500 employees. In addition to serving the real estate sector, Sonomas vertical-market focus includes manufacturing, health and personal care, and professional sports.

      “We found Sonoma by doing a Web search,” said Anne Baker, a product manager at Equity Residential. “We were looking for information about a specific CRM function. Sonomas Web site had the best explanation, and we signed up for their CRM newsletter.”

      Impressed, Equity Residential asked in June if Sonoma could get the companys CRM project back on track. Very familiar with Microsoft CRM, Sonoma agreed to tackle the project and designed a fully functional system in seven weeks.

      Most solutions providers are only now kicking Microsoft CRMs tires, but Sonoma has been a driving force behind the product since its beta tests in 2002.

      “We have extensive experience designing proprietary Web-based customer management software using Microsoft .Net,” said Mike Snyder, principal of Sonoma. “Microsoft CRM allows us to give our customers the core functionality they require, and we can extend the solution with open-software APIs and our own development experience.”

      Thats exactly what Equity Residential needed. Although Microsoft CRM has extensive out-of-the-box functionality, it also required custom extensions from Sonoma. On the upside, Microsoft CRM has built-in Lead, Contact and Opportunity features. When a prospective buyer expresses interest in a condo, an Equity Residential salesperson enters the information into the CRM system as a Lead. If the Lead decides to purchase a condo, the CRM system converts him or her into a Contact with an associated Opportunity record—which tracks the buyers name, unit number, closing date, down payment and so on.

      Still, Microsoft CRM could not remove a product (in this case, a condo) from inventory once it was sold. “Tracking the inventory of each condo was critical,” said Snyder. “Equitys salespeople had to know which units were available, pending and sold in real time.”

      Moreover, the CRM system had to account for specific differences among the condos. Buyers had 25 to 30 “upgrade” options for each condo, such as tile, plumbing and kitchen countertops. Further complicating matters, upgrade prices varied from condo to condo. For instance, a tile upgrade in a one-bedroom unit may differ in price from a tile upgrade in a two-bedroom unit.

      Sonoma therefore created a separate SQL Server database, which tracks and manages the nuances of each condo sale. Equity Residential users view information from Microsoft CRM and SQL Server as if it were culled from a single database.

      Next Page: Many solutions providers are tying Microsoft CRM to other Microsoft server apps.

      Pursuing Integration

      Sonomas strategy isnt unique. Predictably, many solutions providers are tying Microsoft CRM to other Microsoft server applications. “One of Microsoft CRMs great strengths is its ability to leverage classic technology such as SQL Server, Exchange Server and BizTalk Server,” said Eileen Stribula, a Microsoft CRM consultant at Tectura Corp., a solutions provider in Tempe, Ariz. “Its attractive to companies that seek integrated functionality.”

      Although Microsoft CRM has received mixed reviews from the media, sales appear to be picking up. “Microsoft expects to double last years [CRM] customer number by June of this year,” said Stribula. “We expect our customer base to follow that trend.”

      Microsoft CRM is particularly attractive to businesses that are seeking rapid application deployments. Sonoma, for instance, completed the initial rollout for Equity Residential in a scant seven weeks. Active since August, the first rollout spans roughly 20 desktops and manages one property involving 700 condo units.

      Through additional enhancements, Sonoma empowered Equity Residentials sales agents to quickly generate purchasing agreements, closing worksheets, tax letters, warrantee deeds, paid assessment letters, bills of sale and titles. Software from ActivePDF Inc., of Mission Viejo, Calif., works hand in hand with Microsoft CRM and manages the document generation. “The instant creation of these documents eliminates errors and saves hours of time for each condo unit sold,” said Snyder.

      Satisfied with the current rollout, Equity Residential has big CRM plans for the future. By next year, the CRM system will manage more than 10,000 condo units across 50 property locations, according to Baker.

      Rather than depending on Sonoma for the large-scale rollout, the solutions provider trained Equity Residentials internal development staff to manage the system.

      Sonoma makes Microsoft CRM sound like an easy sale. Yet two other solutions providers tried—and failed—to deploy such a system for the real estate company. “Sonoma Partners displayed a solid understanding of the product and were quick to comprehend our business needs,” said Baker. “We talked to other integration firms, but Sonoma had the best solution for the functionality we needed. We consider them a trusted adviser.”

      Sounds like Equity Residential is ready to pass “Go.”

      Joseph C. Panettieri (joe_pan5@yahoo.com) is editorial director at New York Institute of Technology (www.nyit.edu). He has covered Silicon Valley since 1992.

      /zimages/3/28571.gifCheck out eWEEK.coms Enterprise Applications Center at http://enterpriseapps.eweek.com for the latest news, reviews, analysis and opinion about productivity and business solutions. Be sure to add our eWEEK.com enterprise applications news feed to your RSS newsreader or My Yahoo page: /zimages/3/19420.gif http://us.i1.yimg.com/us.yimg.com/i/us/my/addtomyyahoo2.gif

      Joseph C. Panettieri
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×