This repository contains projects that have been done for Practicum Yandex100 training program.
The visits table (server logs with data on website visits):
Uid — user’s unique identifier
Device — user’s device
Start Ts — session start date and time
End Ts — session end date and time
Source Id — identifier of the ad source the user came from
All dates in this table are in YYYY-MM-DD format.
The orders table (data on orders):
Uid — unique identifier of the user making an order
Buy Ts — order date and time
Revenue — Yandex.Afisha’s revenue from the order
The costs table (data on marketing expenses):
source_id — ad source identifier
dt — date
costs — expenses on this ad source on this day
__
In the course of the project we are going to analize and optimize marketing expenses of Yandex.Afisha. We are going to look into data related to site visits, orders and costs from June 2017 through May 2018.
__