Talk about your next project
Firebolt case study

The lesson

Show the alternatives the customer tried and why each one failed, so the final choice reads as an engineering decision rather than a pitch.

The move

Under a "CUSTOMERS / SIMILARWEB" breadcrumb, the headline sits over an "ABSTRACT" and "ABOUT SIMILARWEB", followed by screenshots of Similarweb's own product, such as a godaddy.com overview and a godaddy.com versus wix.com comparison. "SIMILARWEB'S DATA ARCHITECTURE" describes the AWS data lake and a Spark and Airflow pipeline ingesting 5TB of data daily. "THE CHALLENGE OF THE 'SEGMENT ANALYSIS' USE CASE" uses a FootLocker.com versus Amazon.com example, then lists the hurdles of Data Scale, Dynamic User Input and Query Performance. "SOLUTIONS CONSIDERED" rules out Presto, NoSQL Key-Value Databases and Auto-Scaled Serverless Compute one by one, and "THE FINAL EVALUATION" narrows the choice to BigQuery and Firebolt with a benchmark chart and reasons such as Superior Performance and Workload Isolation. An "ON THIS PAGE" sidebar lists every section.

Why it works

  • Our readThe rejected options each come with a specific reason, like Presto missing sub-second latency or the serverless route needing a duplicate of the 1PB dataset, which shows an engineer the constraints that ruled them out.
  • Our readThe FootLocker versus Amazon example turns an abstract segmentation problem into a query any reader can picture before the technical hurdles are listed.
  • Our readShowing the customer's own product screens first explains what the end user needs from the data before the database is ever mentioned.

What not to copy

Don't copy Firebolt's AWS partner language, the MongoDB announcement banner or Similarweb's clickstream specifics. Keep the order of customer product, data architecture, one concrete use case, a named list of rejected alternatives with reasons, and a final head-to-head evaluation, with a section sidebar for navigation.

More from Firebolt

More case studies

Steal it for your brand.

Tell us what you want to make. We’ll talk through how to put these ideas to work for your brand.