May 19, 2020

Cleansing the complex

Oleg Rogynskyy
4 min
Cleansing the complex

Cleansing CRM data doesn’t have to be an overwhelming task - it can be an easy, manageable and efficient process, as Oleg Rogynskyy, CEO of explains.

The origin of Customer Relationship Management (CRM) can be traced back to the 1990s, when companies such as Siebel helped gradually drive the evolution of contact management software towards CRM systems. Previously, CRMs were built on hierarchical databases, but these have since been wiped out by SQL (Structured Query Language) CRMs. Since then, the likes of SalesForce have moved SQL CRM into the cloud, but the problems that inhibited the platforms 20 years ago, such as inaccurate, incomplete and untrustworthy data, still exist today. 

This is a problem that limits the true potential of CRM software. The technology was built for static data while today’s business data is, in fact, very dynamic. Information is constantly developing and so can quickly become outdated. The current use of CRM is like using flipbooks to try to watch a movie: the method has become obsolete and overtaken by newer, more efficient forms of technology. 

The main issue is that modern CRM platforms, despite their sophistication, focus primarily on processing and consuming data instead of collecting and keeping it accurate. According to Ben Horowitz, we have witnessed the demise of systems of record from the rise of AI. CRMs were built in the point-in-time sales world, meaning that they were built in the days of one-time sales, where activity data and the dynamic nature of contacts didn’t matter. Since then the world has transitioned into a continuous sales world, leading companies like Zuora and Gainsight to try to fix the point-in-time nature of CRM and successfully address data inaccuracy and duplication. 

Specialised tools

A ‘CRM Scan’ can quickly identify data quality metrics and incorporate them into an overall metric called the ‘CRM Health Score’, revealing where efforts need to be focused. This assessment sheds light on CRM fitness and, when combined with a strong understanding of how sales and marketing teams are using the activity data, elevates confidence in prioritising efforts to improve the CRM system. 

Within this process, it is paramount to focus on three primary dimensions of CRM data quality to establish the baseline: 

  1. Is the activity data complete?

  2. Is there a single representation of the activity data?

  3. Does the activity data correctly represent the real world?

Although it is possible to create the metrics internally, this would take several weeks. Not only does this discourage teams who are investing significant time in this work, but it also paralyses them as they often don’t know where to start or whether their efforts are making a difference. 

Important first steps

Identifying data duplication is another hurdle that can undermine productivity. Duplication is typically due to a lack of standard and unique identifiers for companies and the people that work for them. Despite the use of common proxies, including web domain and email addresses, these are often not unique, as the names of companies and people can change or have variations. To tackle duplicates, businesses need to: 

  1. Define duplicates 

The first step is to define what is considered a duplicate. For instance, in contacts and leads this can be email address matches, identical name matches and account associations. 

  1. Set up preventative dedupe rules in the CRM

Businesses should then use features established by Salesforce to block and prevent the creation of duplicate records. 

  1. Identify and clean existing data duplicates

The ‘CRM Scan’ can be used to identify duplicates and clean them up. This requires some planning based on the CRM system in use. There are specialised tools that make this process easier, but in some cases it can be a good step to reinforce the process by taking it offline to use spreadsheet analysis. 

  1. Implement ongoing monitoring for new duplicates

Once data duplicates have been identified and cleaned, it is important to set up preventative de-duplication rules in the CRM platform to monitor and repair duplicates. 

Quick, visible results 

Specialised scan tools, custom reports and dashboards are used to identify, clean and enrich data. This focuses on finding invalid data, such as digits or special characters in contact names, email addresses, web domains and incomplete mailing addresses. This can be done by combining spreadsheets and simple scripts to build update files for a CRM loader, as well as using a database built for this purpose. 

The timescale of this process varies depending on data quantities, the number of duplicates and the amount of data that needs cleansing. With the right tools, reliable measurement and on-going commitment, results can be visible almost immediately. 

In order to achieve this, organisations need to set targets that are tied to business priorities. This will enable businesses to communicate results, rebuild trust in the data and celebrate milestones to keep the momentum going. Benefiting from CRM data doesn’t have to be overwhelming, impossible or disheartening. It can be relatively easy, straightforward and more than satisfying. 

Share article

Jun 18, 2021

Intelliwave SiteSense boosts APTIM material tracking

3 min
Intelliwave Technologies outlines how it provides data and visibility benefits for APTIM

“We’ve been engaged with the APTIM team since early 2019 providing SiteSense, our mobile construction SaaS solution, for their maintenance and construction projects, allowing them to track materials and equipment, and manage inventory.

We have been working with the APTIM team to standardize material tracking processes and procedures, ultimately with the goal of reducing the amount of time  spent looking for materials. Industry studies show that better management of materials can lead to a 16% increase in craft labour productivity.

Everyone knows construction is one of the oldest industries but it’s one of the least tech driven comparatively. About 95% of Engineering and Construction data captured goes unused, 13% of working hours are spent looking for data and around 30% of companies have applications that don’t integrate. 

With APTIM, we’re looking at early risk detection, through predictive analysis and forecasting of material constraints, integrating with the ecosystem of software platforms and reporting on real-time data with a ‘field-first’ focus – through initiatives like the Digital Foreman. The APTIM team has seen great wins in the field, utilising bar-code technology, to check in thousands of material items quickly compared to manual methods.

There are three key areas when it comes to successful Materials Management in the software sector – culture, technology, and vendor engagement.

Given the state of world affairs, access to data needs to be off site via the cloud to support remote working conditions, providing a ‘single source of truth’ accessed by many parties; the tech sector is always growing, so companies need faster and more reliable access to this cloud data; digital supply chain initiatives engage vendors a lot earlier in the process to drive collaboration and to engage with their clients, which gives more assurance as there is more emphasis on automating data capture. 

It’s been a challenging period with the pandemic, particularly for the supply chain. Look what happened in the Suez Canal – things can suddenly impact material costs and availability, and you really have to be more efficient to survive and succeed. Virtual system access can solve some issues and you need to look at data access in a wider net.

Solving problems comes down to better visibility, and proactively solving issues with vendors and enabling construction teams to execute their work. The biggest cause of delays is not being able to provide teams with what they need.

On average 2% of materials are lost or re-ordered, which only factors in the material cost, what is not captured is the duplicated effort of procurement, vendor and shipping costs, all of which have an environmental impact.

As things start to stabilise, APTIM continues to utilize SiteSense to boost efficiencies and solve productivity issues proactively. Integrating with 3D/4D modelling is just the precipice of what we can do. Access to data can help you firm up bids to win work, to make better cost estimates, and AI and ML are the next phase, providing an eco-system of tools.

A key focus for Intelliwave and APTIM is to increase the availability of data, whether it’s creating a data warehouse for visualisations or increasing integrations to provide additional value. We want to move to a more of an enterprise usage phase – up to now it’s been project based – so more people can access data in real time.


Share article