adjust-home-task

Usage:

pip install poetry
poetry install
python manage.py migrate
python manage.py import_data dataset.csv
python manage.py runserver

Examples

Show the number of impressions and clicks that occurred before the 1st of June 2017, broken down by channel and country, sorted by clicks in descending order.

Show the number of installs that occurred in May of 2017 on iOS, broken down by date, sorted by date in ascending order.

Show revenue, earned on June 1, 2017 in US, broken down by operating system and sorted by revenue in descending order.

Show CPI and spend for Canada (CA) broken down by channel ordered by CPI in descending order. Please think carefully which is an appropriate aggregate function for CPI.

Farther improvements:

Run in docker for easier deployment
Use gunicorn for more stability under load
Add linters like mypy, black, isort, flake8