Overview

Awe Inspired is a direct-to-consumer fine jewelry brand. Their beloved Goddess Collection has been worn by countless A-list celebrities and tens of thousands of customers.

Celebrating diversity, intersectional feminism, and social justice is at the core of who they are and what they do. 20% of all proceeds benefit their incredible charity partners, each chosen for the direct impact they have on the lives of women overcoming adversity.

Challenges

  • Consolidate various data sources into a single automated report
  • Consolidate all KPIs to have a 360-degree view
  • Calculate metrics like overall marketing spend, overall marketing revenue, overall CTR, overall CPA, etc.
  • Build the Quiz funnel performance and view the performance of each quiz result
  • Blending all marketing channels’ data to calculate global metrics
  • Automate BI dashboards for each company department

Solutions

Data visualization tool used: Google Data Studio

  • SR analytics’ certified Google Analytics experts understood the business model quickly and conducted an audit of their current data sources against the business requirements.
  • SR Analytics built over a dozen customized analytics dashboards in Google Data Studio stitching together data sets across our entire tech stack.
  • This involved stitching together data from various data sources like Google Analytics, Facebook, Pinterest, Shopify, Klaviyo, and Zendesk and building fully customized dashboards in Google Data Studio.
  • Various third-party connectors were used to blend the data like Supermetrics, PowerMyAnalytics, StitchData, etc.
  • Google Big Query data warehouse was used to store data from Klaviyo and Zendesk. 
  • All the complex data modeling and transformations were applied either in Google Data Studio or in Google Big Query.
  • Paid Performance Dashboard

    SR analytics - Luxury jewelry brand from the USA that creates masterpieces
  • Quiz Funnel Dashboard

    SR analytics - Luxury jewelry brand from the USA that creates masterpieces
  • Customer Sales Dashboard

    SR analytics - Luxury jewelry brand from the USA that creates masterpieces
  • Website Performance Dashboard

    SR analytics - Luxury jewelry brand from the USA that creates masterpieces
  • Zendesk Data Dashboard (3rd party software)

    SR analytics - Luxury jewelry brand from the USA that creates masterpieces

Results

  • Access to these dashboards had an immediate and enormously positive impact on the client’s bottom line.
  • The client instituted weekly Business Metrics meetings to analyze the dashboard insights and adjusted their ongoing strategy heading into the holiday season.
  • Made several significant product modifications based on insights from the dashboards.
  • Their overall eCommerce website conversion rate improved by 10% in a span of 4 months.