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

Wayfair Interview Questions

Python

Machine Learning

Product Metrics

A/B Testing

Analytics

Statistics

Probability

Algorithms

Wayfair Interview Guides

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

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?

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?

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

Email Blast

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:

<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>
Using this information, you wish to find out how many users have opened an email.

What query would you use to find out?

Example:

Input:

<code>events</code> table

<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>
Output:

<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

Given a dictionary with keys of letters and values of a list of letters, write a function <code>closest_key</code> to find the key with the input value closest to the beginning of the list.

Example:

Input:

<pre tabindex="0" class="chroma"><code>dictionary = {
 &#39;a&#39; : [&#39;b&#39;,&#39;c&#39;,&#39;e&#39;],
 &#39;m&#39; : [&#39;c&#39;,&#39;e&#39;],
}
input = &#39;c&#39;
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>closest_key(dictionary, input) -&gt; &#39;m&#39;
</code></pre>

\(c\) is at distance 1 from \(a\) and 0 from \(m\). Hence closest key for \(c\) is \(m\).

Wayfair Interview Questions

Wayfair Interview Guides

Wayfair Interview Questions

This feature requires a user account

Wayfair Salaries by Position