Undrgoods – Looker Dashboard


An e-commerce brand from middle east



Undrgoods is a Middle Eastern e-commerce brand specializing in premium undergarments sold through WooCommerce. Leveraging Facebook, Google, Snapchat, and TikTok, they reach diverse audiences across social media platforms, aiming to become a leader in the regional market.

Looker Dashboard


To create a comprehensive Looker dashboard integrating data from Facebook Ads, Google Ads, Snapchat Ads, TikTok Ads, and WooCommerce. This dashboard will provide detailed insights into campaign performance, order attribution to marketing channels, customer segmentation (new vs. returning), cohort analysis, sales trends, ad spend across platforms and campaigns, clicks, impressions, and funnel analysis. The dashboard will also include interactive filters for campaigns, order dates, marketing channels, and other relevant attributes, empowering the client to make informed decisions and optimize their marketing strategies effectively.


Tools & Technologies:

Data Sources :  

  1. Marketing Data Sources : Facebook Ads, Google Ads, Snapchat Ads, TikTok Ads
  2. Operations Data Sources : Woo Commerce, Google Sheets
  3. Other Data Sources : Google Analytics

Data Connector : 

  1. Fivetran

Data Transformation : 

  1. DBT (Data Build Tool)
  2. SQL  and YAML

Data Visualization :

  1. Looker Studio

Database :

  1. Google BigQuery


  1. Data Pipeline Setup:

    • Utilized Fivetran to extract data from Facebook Ads, Google Ads, Snapchat Ads, TikTok Ads, and WooCommerce, transferring it seamlessly to Google BigQuery.
  2. DBT Implementation:

    • Connected DBT to BigQuery and GitHub, creating SQL-based data models for analytics-ready datasets.
    • Automated model updates through scheduled tasks, ensuring data freshness for insights.
  3. Data Modeling:

    • Designed models for campaign attribution, customer segmentation, cohort analysis, ad spend analysis, clicks, impressions, and funnel analysis.
  4. Integration with Looker Studio:

    • Connected final data models to Looker Studio for intuitive data visualization and exploration.
    • Developed interactive dashboards for marketing performance analysis.
  5. Testing and Documentation:

    • Conducted rigorous testing to ensure data accuracy and consistency.
    • Documented the entire process for knowledge sharing and training.



we will assist you in any issue and conflict

Lorem ipsum dolor sit amet, conetur adiping elit Lorem ipsum dolor sit amet, consectetur adipiscing elit.
  1. Looker Dashboard

Data Visuals:

Looker Dashboard
Looker Dashboard
Looker Dashboard

Have a project in mind? Let’s talk.