<p>An online marketplace company has introduced a new feature that allows potential buyers and sellers to conduct audio chats with each other prior to transacting.</p>

<p>Let’s say we have two tables that represent this data.</p>

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

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

<p><code>chats</code> table</p>

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

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

<tr>
<td><code>buyer_user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>seller_user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>call_length</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>call_connected</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>marketplace_purchases</code> table</p>

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

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

<tr>
<td><code>buyer_user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>seller_user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>item_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>purchase_amount</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

<ol>
<li>How would you measure the success of this new feature?</li>
<li>Write a query that can represent if the feature is successful or not.</li>
</ol>


How would you measure the success of an online marketplace introducing an audio chat feature given a dataset of their usage?

Audio Chat Success

Comments