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

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

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

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

Wayfair Salaries by Position