Modern BI & Analytics solutions for startups

Klardata is a full-service, business intelligence and analytics solutions agency for medium sized businesses and startups. Klardata uses cutting edge technologies and tools to make both your project and systems run as efficiently as possible. We work with the market leading database and BI technologies in the market Klardata provides a quick-to-market, low cost solution with start of the art visuals to present a clear story of your data.

 
$1,000+
 
$100 - $149 / hr
 
Freelancer
 Founded
2017
Show all +
San Francisco, CA
headquarters
  • San Francisco, CA 94121
    United States

Portfolio

Key clients: 

Qubole, NEXT Trucking, W4, Webcor Builders, ISOFLEX USA, FireStats

Reviews

Sort by

Reporting & Analytics for Skin Care Company

“His responsiveness and productivity in troubleshooting issues when they arose really made him stand out.”

Quality: 
4.0
Schedule: 
5.0
Cost: 
4.0
Willing to refer: 
4.5
The Project
 
$50,000 to $199,999
 
June 2017 - June 2019
Project summary: 

Klardata conducted routine analytics and reporting services to track a skincare company’s e-commerce site and paid advertisements. They deployed Google Sheets, an AWS database, and Shopify data.

The Reviewer
 
11-50 Employees
 
Berkeley, California
Director of Marketing, Skin Care Company
 
Verified
The Review
Feedback summary: 

Klardata effectively captured leads and provided actionable insights that informed key business decisions. Incredibly responsive, engaging, and easy to work with, the one-person team managed ad-hoc requests with ease and integrated seamlessly with the internal team.

A Clutch analyst personally interviewed this client over the phone. Below is an edited transcript.

BACKGROUND

Introduce your business and what you do there.

I’m the director of marketing at an organic and wildcrafted skincare company.

OPPORTUNITY / CHALLENGE

What challenge were you trying to address with Klardata?

My company didn’t have an analytics team, so we hired Klardata to help us with reporting and analytics. We were looking to create a database and extrapolate reports from that database that linked our Shopify data. We wanted to find long-term value for customers coming in through Facebook ads.

SOLUTION

What was the scope of their involvement?

Justin (Owner, Klardata) used AWS for our database. He pulled different reports on a weekly, monthly, quarterly, and annual basis. We didn’t have a BI tool, so Justin pulled these reports on Google Sheets.

The reports tracked the performance of our e-commerce website and paid advertisements. Justin looked at how different cohorts were doing over time, and what their long-term value was. He did reverse projections and engineering to determine how many new customers we would need year-over-year to attain our revenue goals, just based on the average lifetime value. He analyzed new versus existing customers and tracked Zephyr connections on a skin quiz that we use as a lead generation apparatus.

Justin also monitored our marketing dashboard, which acts as our business compass, and updated it on a weekly basis, so that we could see how things were performing and where our ROI was. Finally, he regulated a reporting directory that I set up, which he notated when he was updating reports.

What is the team composition?

Justin was our only point of contact.

How did you come to work with Klardata?

We found Klardata through Upwork.

How much have you invested with them?

We spent between $50,000–$100,000 over two years. Justin worked 20–30 hours each week.

What is the status of this engagement?

Our partnership with Klardata spanned 2017–June 2019. We ended the engagement because we wanted to go in a different direction, either by hiring someone internally or hiring a team with multiple resources.  

RESULTS & FEEDBACK

What evidence can you share that demonstrates the impact of the engagement?

Justin gave us a clear picture of our business. The reverse projections that he did were really helpful, as they enabled us to see how many new people we needed to bring in the pipeline through various advertising channels. By making sure the Zephyr connections for the skin quiz were happening, Justin effectively captured emails into our email database.  

How did Klardata perform from a project management standpoint?

One of the things I liked most about Justin was how responsive he was. He proved capable of handling a lot of ad hoc requests. We used Trello and communicated via Slack and email. We had weekly calls and check-ins. Justin was very easy to work with.

What did you find most impressive about them?

Justin felt like a part of our team. He was very integrated; he reported directly to me, but he worked cross-functionally with other team members. His responsiveness and productivity in troubleshooting issues when they arose really made him stand out.

Are there any areas they could improve?

I think that not having a BI tool in place while running so many queries with data from Google Sheets hindered Justin. Data cleanliness was a bit back and forth. However, Justin was always prepared to jump in and help troubleshoot. If he presented numbers that I thought seemed off, I’d ask him to go back in to make sure they were correct, and he was very open to doing so.

Any advice for potential customers?

For large data, I’d recommend investing in a BI tool upfront. If you’re using Google Sheets, cross-check the data. We established a good cadence by being clear about responsibilities and setting up weekly calls and a project management tool. Also, having a reporting directory in place helped organize everything.

4.0
Overall Score
  • 5.0 Scheduling
    ON TIME / DEADLINES
  • 4.0 Cost
    Value / within estimates
  • 4.0 Quality
    Service & deliverables
  • 4.5 NPS
    Willing to refer