Practice Interview Questions
| Question | Status |
|---|---|
The marketing team has recently conducted an ad promo and wants to evaluate its effectiveness. They need to understand the total units sold for each product following the promotion using these benchmarks:
Your results should include the product ID and its corresponding ad performance category.
marketing_campaign table:
| Column Name | Description |
|---|---|
| user_id | Identifier for the buyer of that product |
| created_at | Time when the transaction was recorded |
| product_id | Identifier of the product |
| quantity | Number of units of the product sold |
| price | Price of the product |
| product_id | ad_performance |
|---|---|
| 101 | Poor |
| 116 | Outstanding |
The marketing team has recently conducted an ad promo and wants to evaluate its effectiveness. They need to understand the total units sold for each product following the promotion using these benchmarks:
Your results should include the product ID and its corresponding ad performance category.
marketing_campaign table:
| Column Name | Description |
|---|---|
| user_id | Identifier for the buyer of that product |
| created_at | Time when the transaction was recorded |
| product_id | Identifier of the product |
| quantity | Number of units of the product sold |
| price | Price of the product |
| product_id | ad_performance |
|---|---|
| 101 | Poor |
| 116 | Outstanding |