下载PDF
Case Study: CARTO for Media & Agencies - Tecnilógica Uses Location Intelligence for A Viral Visualization
技术
- 应用基础设施与中间件 - 数据可视化
适用功能
- 销售与市场营销
服务
- 数据科学服务
挑战
Tecnilógica, a digital agency, wanted to leverage a timely, newsworthy event to generate brand awareness and drive traffic to their platform. The Ashley Madison data leak provided an opportunity to create a data-driven visualization that would attract a global audience. However, the challenge was to clean up the dataset, removing any identifying information to protect users, and then find a way to visualize the data in a compelling and insightful manner.
关于客户
Tecnilógica is a digital agency based in Spain that specializes in the design and development of websites, mobile and web applications. The company helps brands use the internet to engage prospects, customers, leads, and advocates. Tecnilógica's unique blend of strategy, creative, and programming capabilities enables them to provide business-critical technical solutions to their clients. The company sought to leverage a timely, newsworthy event to generate brand awareness and drive traffic to their platform.
解决方案
Tecnilógica chose to use CARTO’s platform to create a data-driven visualization of the Ashley Madison data leak. The team spent about six hours cleaning up the dataset, removing any identifying information like names, email, and home addresses. The remaining data contained only the gender, sign-up data, and city locations of users. They began to experiment with a subset of data, analyzing only three million records out of over 30 million, while setting up a database server to handle the full dataset. The visualization was represented on a map with two layers. The first layer, a heat map, detailed the distribution of users across the world. The second layer visualized the male/female ratio per city.
运营影响
数量效益