# Data Analysis of Starbucks Promotions

## Dataset
Dataset: [Starbucks Customer Data on Kaggle](https://www.kaggle.com/ihormuliar/starbucks-customer-data)

Description: This data was provided by Starbucks to simulate their customers and transactions to see if there are better approaches to sending customers specific promotional deals.

Data files:

- portfolio.csv
- Information about the promotional offers that are possible to receive, and basic information about each one including the promotional type, duration of the promotion, reward, and how the promotion was distributed to customers
- Columns (7):
- index (10)
- reward: value of promotion
- channels: advertising channels
- difficulty: minimum spend to unlock promotion
- duration
- offer_type: type of promotion (e.g.: Buy One Get One (BOGO))
- id: offer id
- profile.csv
- Dimensional data about each person, including their age, salary, and gender. There is one unique customer for each record.
- Columns (6)
- index
- gender
- age
- id: customer id, 17000 unique values
- became_member_on: date that customer became a member
- income: customer's income
- transcript.csv
- Records show the different steps of promotional offers that a customer received. The different values of receiving a promotion are receiving, viewing, and completing.
- You also see the different transactions that a person made in the time since he became a customer. With all records, you see the day that they interacted with Starbucks and the amount that it is worth.
- Columns (5)
- index (307k)
- person: customer id
- event: record description (ie transaction, offer received, offer viewed, etc.)
- value: either an offer id or transaction amount depending on the record
- time: time in hours. The data begins at time t=0

## Ideas

Business Goal: Maximise profit, increase customers.

Business Problem: The current set of promotions may not be the best at maximising profits and increasing/retaining customers.

1. Optimise promotions to maximise profit.
- Find optimal promotion settings to maximise profit
- Find optimal promotion frequency to maximise profit and attract customers.
2. Create targeted promotions based on customer behaviour/profile
- Identify customer segments
- Identify most effective promotion(s) for each customer segment

### Questions

- Are there more unique customers during promotion periods?
- Are there higher profits during promotion periods?
- Do regular customers spend during promotion periods?
- Do promotions achieve the business goal?
- What type of promotions have the most positive impact on business goal?