Klaviyo Interview Questions

Klaviyo Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(98)
SQL
(74)
Machine Learning
(70)
Probability
(33)
Product Sense & Metrics
(29)

Klaviyo Interview Questions

Practice for the Klaviyo interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

Given three tables, representing customer transactions and customer attributes:

Write a query to get the average order value by gender.

Note: We’re looking at the average order value by users that have ever placed an order. Additionally, please round your answer to two decimal places.

Example:

Input:

transactions table

Column Type
id INTEGER
user_id INTEGER
created_at DATETIME
product_id INTEGER
quantity INTEGER

users table

Column Type
id INTEGER
name VARCHAR
sex VARCHAR

products table

Column Type
id INTEGER
name VARCHAR
price FLOAT

Output:

Column Type
sex VARCHAR
aov FLOAT
Statistics
Easy
Statistics
Medium
Loading pricing options

View all Klaviyo questions

Challenge

Check your skills...
How prepared are you for working at Klaviyo?

Klaviyo Salaries by Position

$190K
$225K
Product Manager
Median: $195K
Mean (Average): $205K
Data points: 5
$120K
$233K
Software Engineer
Median: $160K
Mean (Average): $168K
Data points: 68
$135K
$149K
Marketing Analyst
Median: $135K
Mean (Average): $140K
Data points: 3
$115K
$129K
ML Engineer
Median: $115K
Mean (Average): $120K
Data points: 3
$113K
$126K
Data Scientist
Median: $120K
Mean (Average): $120K
Data points: 6
$111K
$125K
Business Intelligence
Median: $120K
Mean (Average): $118K
Data points: 3

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Product Manager role pays the most with a $204,920 base salary while the Business Intelligence role on average pays the least with a $118,333 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.