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

Expedia Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Expedia Interview Guides

<p>Let’s say that you work for a software as a subscription (SAAS) company that has existed for just over a year. The chief revenue officer wants to know the average lifetime value.</p>

<p>We know that the product costs $100 dollars per month, averages 10% in monthly churn, and the average customer sticks around for around 3.5 months.</p>

<p>Calculate the formula for the average lifetime value.</p>


<p>If a software-as-a-subscription company has a monthly churn rate of 20% for a product that costs $100, what would be the average lifetime value of a single customer?</p>


If a software-as-a-subscription company has a monthly churn rate of 20% for a product that costs $100, what would be the average lifetime value of a single customer?

Average Lifetime Value

Revenue Retention

<p>Let’s say you work for a search engine company. The company has increased the number of ads shown after a subset of searches. </p>

<p>After analyzing the data, we see that total amount of revenue is up but the total number of user searches is down. Is this good or bad?</p>


Determine whether the increase in total revenue is indeed beneficial for a search engine company.

Increase Search Ads

<p>Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.</p>

<p>Write a query to randomly sample a row from this table.</p>

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

<p><code>big_table</code> table</p>

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

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


Write a query to randomly sample a row from a big table.

Expedia Interview Questions

Expedia Interview Guides

Expedia Interview Questions

Expedia Salaries by Position