Generated at: 2026-07-01 04:03:21

Data Cleansing, Salesforce Integration, BI Utilization

Accelerating Data-Driven Management with Salesforce × Tableau × uSonar

Eliminating 10,000 Duplicate Records to Maximize the Power of BI Tools

Mitsubishi Real Estate Services Co., Ltd.

Real Estate Industry

INTERVIEWEE

  • Daisuke Uchida, Deputy General Manager, Digital Strategy Department and Manager, CRM Promotion Division

As a member of the Mitsubishi Estate Group, Mitsubishi Real Estate Services Co., Ltd. provides real estate services primarily to corporate clients. The company offers one-stop solutions for all real estate-related corporate needs, focusing on real estate brokerage, office relocation brokerage, planning for rental buildings and housing, and real estate appraisal. The company has been promoting data-driven management, aiming to move away from sales based on intuition, experience, and guts. However, even after implementing Salesforce, issues such as duplicate and incomplete corporate data hindered information utilization, leading to reduced sales efficiency and impacting management decisions. To address this, they chose uSonar, which integrates seamlessly with Salesforce and facilitates the effective use of corporate data. In this article, we spoke with Daisuke Uchida, who also won the Salesforce Japan User Group's 2024 National Utilization Championship, about the reasons for choosing uSonar, the results achieved, and future prospects.

  • Challenges Before Implementation

    • Although we were promoting data-driven management, the utilization of Salesforce was difficult due to data duplication and inaccuracies.
    • Over 10,000 duplicate records were generated, leading to instances where sales representatives made duplicate approaches, resulting in customer complaints.
    • There was a risk of making incorrect management decisions due to the low accuracy of management analysis using Tableau.
  • Reasons for Implementation

    • The ability to normalize data within Salesforce and maintain a duplicate-free environment was the optimal solution.
    • Seamless integration with Salesforce is possible, allowing for the integrated utilization of data necessary for sales activities and management decisions.
    • Compared to other companies, the overwhelming volume of corporate data and the comprehensiveness of information led us to conclude that we could improve the accuracy of our sales targeting.
  • Results Achieved

    • Significantly reduced the time required for list creation and company extraction, leading to a substantial increase in the number of approachable companies.
    • Data accuracy within Salesforce has improved, enhancing the precision of management analysis using Tableau. We also succeeded in reducing the man-hours required for creating meeting materials.
    • By leveraging mSonar, pre-visit information gathering and credit checks are streamlined, leading to improved sales productivity.

Challenges Before Implementation

The Challenge of Data-Driven Management and the Pitfalls of 10,000 Duplicate Records

First, could you please tell us about your responsibilities and mission, Mr. Uchida?

Uchida

Our company aims for data-driven management. As part of this initiative, we use Salesforce to efficiently share customer, property, and sales opportunity information to support our sales activities.

Until now, we have grown the company based on the intuition, experience, and courage of our sales team. However, with the advancement of IT, tools capable of rapidly analyzing vast amounts of data have emerged. Since data is also accumulating in Salesforce, we have been aiming for data-driven management since around 2021, believing that if we leverage this data, we can further increase our sales win rate.

In this context, I am responsible for promoting the utilization of SFA/CRM tools (sales force automation) and BI tools (business intelligence).

You have implemented uSonar to facilitate data utilization. What challenges did you face before its implementation?

Uchida

Before implementing Salesforce, our sales team managed customers using individual notebooks and Excel, which meant that information was siloed, and the sales organization as a whole could not leverage valuable insights. Therefore, we considered a policy to implement an SFA/CRM to utilize information across the entire company.

We initially developed an in-house system to store customer information, but it did not go well. We then implemented Salesforce, but there were many cases where the staff lost sight of the purpose or the data was incomplete.

Another issue was that there were a significant number of duplicate records within Salesforce, reaching approximately 10,000 entries. Because of this data duplication, multiple sales representatives would approach the same company multiple times, which sometimes led to complaints.

Furthermore, we use Tableau for business analysis, but because the data within Salesforce was duplicated, the figures generated in Tableau were not being aggregated correctly. Since Tableau is also used for management meetings, there was a risk of making incorrect management decisions if the results were inaccurate. For that reason, it was essential for us to clean and organize our data.

It is common to hear that even when management calls for the use of SFA/CRM, the field staff does not fully understand it. Were there any points that were particularly difficult?

Uchida

We transitioned from managing sales opportunities in Excel to managing everything in Salesforce, so it was challenging to get the team to understand a mindset completely different from our traditional methods. We involved sales managers and spent six months coordinating with the field teams to define sales phases and probability levels.

mecyes_1.webp

Daisuke Uchida, Deputy General Manager, Digital Strategy Department and Manager, CRM Promotion Division, Mitsubishi Real Estate Services Co., Ltd.

Reasons for Implementation

The Key Was Integration Capabilities and Information Comprehensiveness to Accelerate Data Utilization

You mentioned that you faced various troubles and difficulties with your previous data management. What was the deciding factor in choosing uSonar among the many services available?

Uchida

The ease of integration with SFA/CRM systems was a major factor. To utilize data effectively, it is necessary to aggregate not only information on clients, sales opportunities, and activities but also data from other core systems via API integration. The fact that uSonar facilitates easy integration with various systems was a key point.

Furthermore, by using uSonar for data cleansing, we were able to eliminate duplicate data and establish a foundation for leveraging data within Salesforce.

Of course, the fact that it possesses a volume of corporate data unmatched by other companies, as well as the breadth of information that is comprehensively collected and easy to use, were also deciding factors.

mjres_fig.webp

Integration Image for Mitsubishi Real Estate Services Co., Ltd.

You are also using mSonar; did you compare it with other business card management applications?

Uchida

We compared three to four different companies, but we chose mSonar because of its ease of integration with Salesforce and its convenience for sales representatives in the field. We believe that field-level usability is particularly important, and after seeing the demonstrations, many of our team members agreed that mSonar was the most practical solution. Compared to other business card management applications, mSonar offers an overwhelming amount of information, and the ability to freely search not only for business card details but also for corporate information while on the go is a significant advantage for our field staff.

Results Achieved

Streamlining Both Sales and Management! Changing Conventional Wisdom with Salesforce × Tableau × uSonar

You mentioned that by utilizing uSonar, you successfully resolved approximately 10,000 duplicate data entries and established a data utilization foundation. What specific benefits have you realized as a result?

Uchida

The reduction in time spent on list creation and company extraction, as well as the cost savings, have been significant. It is particularly useful to be able to create lists based on company characteristics using "Stories" (qualitative corporate attributes uniquely labeled by uSonar). For example, stories such as "companies likely to relocate their offices," "companies that own corporate housing," and "companies promoting work-style reform" align well with our real estate business, allowing us to create targeted lists that lead to successful outcomes.

The "Good Industry" classifications (industry categories uniquely defined by uSonar) are also highly regarded by our sales team. Even when companies fall under different attributes in the Ministry of Internal Affairs and Communications' industry classifications, the "Good Industry" categories often align with our own internal definitions, making it easier to segment our analysis results.

Furthermore, before implementing uSonar, our only option was to purchase corporate data from other providers on an ad-hoc basis. While the data accuracy was high, the time and cost required to utilize it were significant drawbacks. In contrast, uSonar allows us to use 12.5 million corporate data records whenever and as much as we need, which has drastically reduced our costs related to corporate data and significantly increased the number of companies we can approach.

The reduction in corporate data purchases has also resolved the issue of data duplication. When we were purchasing corporate data, we had to cross-reference it with our existing internal data to check for duplicates. By implementing uSonar, we have been able to eliminate the man-hours previously required for that task.

How are you utilizing mSonar, which was implemented with field convenience in mind?

Uchida

It is very convenient to be able to view credit information by scanning a business card, search for corporate information, make calls directly from the app, and view the location of a headquarters on a map. It has become a habit among our sales members to check mSonar before visiting clients to stay updated on industry news.

You mentioned that your company is promoting data-driven management. From the perspective of data analysis, have you noticed any changes since the implementation of uSonar?

Uchida

The man-hours required for creating materials for meetings have been significantly reduced. Previously, we had to submit materials several days before a meeting, which meant struggling to aggregate figures in Excel and create graphs for every single meeting. Now, we utilize Tableau for our operations, and no advance preparation is required.

This is only possible because of the culture where data normalized by uSonar is entered into Salesforce. Our president and executives have even explicitly stated that they only look at Salesforce for meeting materials. In other words, a lack of data entry implies a lack of results, so the culture of data entry has become deeply rooted.

That said, data entry is time-consuming, so I do not think every member is fully convinced. Therefore, our president and executives periodically speak about why data entry is necessary to continue our awareness-raising efforts.

mecyes_2.webp

Daisuke Uchida, Deputy General Manager, Digital Strategy Department and Manager, CRM Promotion Division, Mitsubishi Real Estate Services Co., Ltd.

Future Outlook

The Scenario for Improving Sales Win Rates Envisioned Through Salesforce and uSonar

Finally, could you share your outlook on how you would like to utilize uSonar in the future?

Uchida

We intend to utilize uSonar even further to increase our sales win rates.

By seamlessly integrating and utilizing information such as uSonar's corporate data, news, and Live Access with the customer information registered in our Salesforce, we are considering building a system that allows us to precisely capture customer needs and approach customers who require our services early and accurately.

Furthermore, if we can capture the interests of potential customers in real-time through data-driven initiatives and visualize priorities to approach them effectively, we can accelerate the process from lead acquisition to nurturing and closing. I am optimistic that we can improve our win rate from our previous 7-5 record to 8-4 or 9-3.

DSC_1771.webp

Daisuke Uchida, Deputy General Manager, Digital Strategy Department and Manager, CRM Promotion Division, Mitsubishi Real Estate Services Co., Ltd.

* Note: Service and feature names mentioned are current as of the time of the interview.

Consult with uSonar

You may stop receiving information regarding services and events at any time. Please review our Privacy Statement for details on our company policies.

Other Case Studies

For Urgent Inquiries, Please Call03-5388-7000Business Hours: 10:00 AM – 5:00 PM (Closed on Weekends and Holidays)

The Definitive Solution for Sales DX Through Data Utilization

Service Brochure

uSonar in 5 Minutes

Understand uSonar in 5 Minutes

Download Brochure