top of page

Case Study on Diversity. pk

Introduction


Diversity.pk is an E-Commerce based venture which aims to sell quality products. They offer a diverse range of products that cover several categories such as Health, Fashion, Technology, and home items. Being an online retailer, their revenue is generated via organic search, influencer marketing, and paid advertisements on social media sites including Facebook, Instagram, Snapchat, and TikTok.

Diversity Logo
Diversity Logo

Problem

As an Ecommerce Store, they spent heavily on a marketing budget but lacked a comprehensive dashboard to track their advertising spend and sales performance to analyze how much revenue is generated by spending on social media platforms. Different key metrics involve attributes/variables from sales and marketing data such as Cost per Conversion, Conversion Rate, and Cost per Order. They have not consolidated their different data sources in one place to generate insights and make data-driven decisions in real time.


They used a prebuilt Analytics Page on Shopify and social media platform sales. Then, we spent lots of time wrangling with data and consolidating them on spreadsheets. Still, the problem is to bring real-time data and then analyze critical metrics which used to vary on a daily basis.


Objective

The company wanted to have all its data sources in one place and analyze their costs and returns by spending on different ad campaigns. They have a specific list of key metrics requiring combining data from the Shopify Store and Social Media Ads.


Solution

Datum Labs extracts its data from Shopify, Facebook, Instagram, and Google Ads in AirByte, which allows over 100 connectors, and then stores that data in a warehouse such as Big Query. Data modeling is done to create relational databases and then create custom metrics. After performing multiple business queries on the integrated sales and marketing data, we evaluated the required metrics and KPIs for their business growth.


After data collection, we visualize these attributes with proper dimensions and graphs and create a custom dashboard on Metabase by connecting Big Query for the required business queries to make data-driven decisions.


Data Integrations


Data Integrations
Data Integrations

Tools

Tools

Result

Centralized Dashboard has been created by visualizing all the key metrics that have been described above.

The project results in automated data exporting, cleaning, and loading as required.


How Datum Labs helps the company?

Integrating all these data sources in one place helps the company to assess its key metrics and analyze the success of its goals.

Datum Labs helps in saving a lot of time in Diversity reporting and key metrics analysis. Datum Labs enables the company by giving an overview of its sales and marketing stats and adjusting its marketing actions in real time.

Comentarios


bottom of page