Share this
How we helped our client identify 6 million users
by Veronika Schipper on Jan 4, 2019 3:47:38 PM
Personalisation matters
Segmentation and personalisation are becoming widely used terms in e-tail nowadays. Consumers want to see offers that are relevant to them when they are searching for a certain product or service and companies want to be able to provide that message to them. Sounds like an easy formula, doesn't it? So how come many businesses are not yet able to achieve it?
The answer is simple. The whole process is technically challenging and, depending on the amount of data, also costly. That is why many organizations choose to go the other, easy way and create mass offers for their audience or, in better cases, segments, and hope it will generate enough revenue to reach their targets. Luckily for us and for the consumers, there are organisations that want to innovate, invest and improve their communication with their customers.
Merging existing users with web data in real-time
One of those innovative companies is a travel operator and a well-trusted Crystalloids' client that asked us to help them identify user information from their web data.
"Being in the cloud, the client already had lots of structured customer data. In total, their database contained 1 million customers that registered themselves either via their booking system, requested a brochure or had a subscription," says Will Rulof, the product owner from Crystalloids.
"Next to that, the (client's) website generates lots of traffic which might or might not come from the same registered customer. To be able to identify the users joining from the web, we had to merge all the data using cookie and email as the key identification." he continues.
Here is a graphic representation of the pipeline/process
Beata Blaszkowska, our software developer, explains: "This project took us two months to complete. The biggest challenge was to merge all the data in real time taking into account all the existing data the client had."
"After completing the project, we could identify 6 million new users in the database, which is a fantastic result," summarises Wil. The client is now able to see all the users in Google BigQuery and Data Store for further segmentation and analysis purposes.
Curious how we can help you innovate, grow and become a more customer-centric organisation using Google Cloud?
ABOUT CRYSTALLOIDS
Crystalloids helps companies improve their customer experiences and build marketing technology. Founded in 2006 in the Netherlands, Crystalloids builds crystal-clear solutions that turn customer data into information and knowledge into wisdom. As a leading Google Cloud Partner, Crystalloids combines experience in software development, data science and marketing making them one of a kind IT company. Using the Agile approach Crystalloids ensures that use cases show immediate value to their clients and make their job focus more on decision making and less on programming.
For more information, please visit www.crystalloids.com or follow us on LinkedIN
Share this
- October 2024 (2)
- September 2024 (1)
- August 2024 (1)
- July 2024 (4)
- June 2024 (2)
- May 2024 (1)
- April 2024 (4)
- March 2024 (2)
- February 2024 (2)
- January 2024 (4)
- December 2023 (1)
- November 2023 (4)
- October 2023 (4)
- September 2023 (4)
- June 2023 (2)
- May 2023 (2)
- April 2023 (1)
- March 2023 (1)
- January 2023 (4)
- December 2022 (3)
- November 2022 (5)
- October 2022 (3)
- July 2022 (1)
- May 2022 (2)
- April 2022 (2)
- March 2022 (5)
- February 2022 (3)
- January 2022 (5)
- December 2021 (5)
- November 2021 (4)
- October 2021 (2)
- September 2021 (2)
- August 2021 (3)
- July 2021 (4)
- May 2021 (2)
- April 2021 (2)
- March 2021 (1)
- February 2021 (2)
- January 2021 (1)
- December 2020 (1)
- October 2020 (2)
- September 2020 (1)
- August 2020 (2)
- July 2020 (2)
- June 2020 (1)
- March 2020 (2)
- February 2020 (1)
- January 2020 (1)
- December 2019 (1)
- November 2019 (3)
- October 2019 (2)
- September 2019 (3)
- August 2019 (2)
- July 2019 (3)
- June 2019 (5)
- May 2019 (2)
- April 2019 (4)
- March 2019 (2)
- February 2019 (2)
- January 2019 (4)
- December 2018 (2)
- November 2018 (2)
- October 2018 (1)
- September 2018 (2)
- August 2018 (3)
- July 2018 (3)
- May 2018 (2)
- April 2018 (5)
- March 2018 (5)
- February 2018 (2)
- January 2018 (4)
- November 2017 (2)
- October 2017 (2)