Don't be afraid of inconsistencies in the visitor list!
Transforming marketing operations with generative AI

You want to compare the attendee list collected at an event or seminar with your customer management master data, but you can't combine the data due to variations in notation... This is a problem faced by many companies, and cannot be solved with Excel alone, resulting in huge amounts of time being wasted on manual corrections.

In this article, we will introduce a method to solve this "wording variation problem" all at once by utilizing generative AI and data integration platform.

"Notation variations" problems lurking in Excel work

In marketing and sales support departments, it is essential to check the attendee lists collected at events and seminars against customer management master data.
However, many sites face the challenge of not being able to properly combine data due to variations in notation.

For example, consider the following case:

• There are typos and omissions (e.g. "Toyota Motors" is written as "Toyota Automatic Doors")
• Abbreviations are used (e.g., "NTT Data" becomes "N Data")
• The legal entity status is different (e.g., "Sample Co., Ltd." and "Sample Co., Ltd.")
• Inconsistent corporate abbreviations (e.g., "Saison Technology (same company)" for a company called "Kabushiki Kaisha").

While it is possible to replace or delete spaces in Excel, these complex variations in notation ultimately require manual work, which can be extremely time-consuming when dealing with data on the scale of thousands to tens of thousands of items.

Generative AI excels at "handling ambiguity"

Generative AI can fundamentally solve this problem.

Generative AI can not only match simple strings of characters, but also understand the context and meaning to estimate the optimal corrections, allowing it to automatically perform tasks that were previously only possible for humans, such as correcting typos and standardizing spelling.

For example, a generative AI can determine:

• "Toyota Automatic Door" was understood to be a misspelling of "Toyota Motors" and was corrected.
• Variations such as "NTT Data," "NTT Data," and "NTTD" are recognized as the same company
• Corrected to the correct corporate name

In other words, rather than simply mechanically replacing the name, AI can automatically make corrections at a level that allows a person to read it and understand that it is the same company.

Incorporating generative AI into your business with HULFT Square

Of course, a generative AI on its own needs a mechanism for "how to load data" and "how to manage modified data."

That's where HULFT Square comes in.

HULFT Square is data integration platform that seamlessly connects with various systems and services.

You can use the GUI to create workflows that trigger processes when an Excel file is uploaded, pass data to AI for cleansing, and automatically reflect the results in your customer management system.

What's important here is that HULFT Square acts as a bridge to incorporate generative AI into on-site operations.

By incorporating AI's strength in resolving ambiguous notation into the business flow, the traditional manual Excel work can be reduced to a simple process of "uploading."

Effect: 90% reduction in labor hours and acceleration of data utilization

By using generative AI to automatically correct spelling variations, the amount of time spent correcting text manually can be significantly reduced.

In a real-world scenario, this could reduce man-hours by as much as 90% annually. For example, a company that handles visitor data for 20,000 people annually could reduce work by approximately 80 hours.

Furthermore, increased data accuracy will improve the accuracy of use in CRM and MA (marketing automation), which is expected to improve the quality of lead management and sales activities.

summary

Dealing with variations in spelling has been considered a job that only humans can do.

However, by utilizing generative AI, it is possible to automatically achieve data uniformity to a level that humans intuitively recognize as "the same."

And when combined with a collaboration platform like HULFT Square, you can incorporate this power into your daily work and dramatically increase on-site productivity.

"I want to be free from editing work in Excel."

If that sounds like you, we encourage you to try combining generative AI with HULFT Square.

Reference) We also accept consultations regarding the introduction of generative AI

Saison Technology provides support for implementing generative AI for business use, as well as infrastructure development, including data preprocessing.

Please feel free to contact us with any inquiries, including "I want to utilize the information we have in our company with AI" or "I want to start a PoC but I don't know where to start."