Prepare for and practice interview questions from Wayfair across topics like Product Metrics, SQL, Analytics and more.

Wayfair Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Wayfair Interview Guides

<p>Let’s say that you’re a data scientist working on the marketing team of a B2B SAAS business.</p>

<p>We’re nearing the end of the quarter and are missing revenue expectations by 10%. An executive asks the email marketing person to send out a huge email blast to your entire customer list asking them to buy more products.</p>

<p>Is this a good idea? Why or why not?</p>


<p>Let’s say you work at a B2B (Business-to-Business) SaaS (software as a subscription) company.</p>

<p>If you are going to send out an “email blast” advertising new promotions, which of the following should you do beforehand?</p>


Let's say you work at a B2B (Business-to-Business) SaaS (software as a subscription) company.

If you are going to send out an "email blast" advertising new promotions, which of the following should you do beforehand?

Negative Email Blast

We’re nearing the end of the quarter and are missing revenue expectations by 10%. An executive asks the email marketing person to send out a huge email blast to your entire customer list asking them to buy more products.  Is this a good idea? Why or why not?

Email Blast

<p>Let’s say you have a table called <code>events</code> that keeps track of every user’s actions. A small example of the <code>events</code> table would look like this:</p>

<table>
<thead>
<tr>
<th>user_id</th>
<th>created_at</th>
<th>action</th>
<th>platform</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>2021-01-01 12:00:00</td>
<td>email_opened</td>
<td>Android</td>
</tr>

<tr>
<td>2</td>
<td>2021-01-01 12:05:00</td>
<td>like</td>
<td>Outlook</td>
</tr>

<tr>
<td>3</td>
<td>2021-01-01 12:10:00</td>
<td>post_enter</td>
<td>Gmail</td>
</tr>

<tr>
<td>4</td>
<td>2021-01-01 12:15:00</td>
<td>post_cancel</td>
<td>Outlook</td>
</tr>

<tr>
<td>5</td>
<td>2021-01-01 12:20:00</td>
<td>like</td>
<td>Gmail</td>
</tr>
</tbody>
</table>
<p>Using this information, you wish to find out how many users have opened an email.</p>

<p>What query would you use to find out?</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>events</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>created_at</td>
<td>DATETIME</td>
</tr>

<tr>
<td>action</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>platform</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>num_users_open_email</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Emails Opened

<p>Let’s say you’re tasked with building the YouTube video recommendation algorithm.</p>

<p>How would you design the recommendation system?</p>

<p>What are important factors to keep in mind when building the recommendation algorithm?</p>


Wayfair Interview Questions

Wayfair Interview Guides

Wayfair Interview Questions

Wayfair Salaries by Position