8-12

1)SQL

2017-08-04

BI

https://prod-bitool.easybrain.com/cohort_data?report_type=2&period=1&date=04-08-2017+-+05-08-2017&days_limit=10&without_cache=1&application=2#

ADstat

http://adstat.easybrain.com/adjust/index?game=cx6lgh6l80e8&date_from=2017-08-04&date_to=2017-08-05&events%5B%5D=rvhz8m&events%5B%5D=dnmu5y&events%5B%5D=d3iavm&show_type=ARPU&go=1

SQL

SELECT 'u_04',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-08-04 00:00:00' AND sources.application_id = 2 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'u_08',count(DISTINCT device_id) FROM sources WHERE device_id IS NOT NULL AND install_date='2017-08-05 00:00:00' AND sources.application_id = 2 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')

UNION ALL

SELECT 'umpr_20',sum(impressions) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-10-04 00:00:00' AND sources.application_id = 2 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 2 UNION ALL

SELECT 'umpr_21',sum(impressions) FROM daily_stats WHERE device_id IN (SELECT device_id FROM sources WHERE device_id IS NOT NULL AND install_date='2017-10-05 00:00:00' AND sources.application_id = 2 AND device_id IN (SELECT id FROM devices WHERE idfa <> '00000000-0000-0000-0000-000000000000')) AND application_id = 2 

2)

Разница в данных -

BI

https://prod-bitool.easybrain.com/cohort_data?report_type=0&period=1&date=01-08-2017+-+31-08-2017&days_limit=30&application=2&country=235&network=41&advt_revenue_type=1#

ADStat

http://adstat.easybrain.com/adjust/index?game=cx6lgh6l80e8&date_from=2017-08-01&date_to=2017-08-31&country%5B%5D=us&events%5B%5D=rvhz8m&events%5B%5D=dnmu5y&events%5B%5D=d3iavm&source%5B%5D=66ci9e&show_type=ARPU&go=1

ADJUST

https://dash.adjust.com/#/statistics/overview/default/cx6lgh6l80e8/66ci9e?from=2017-07-01&to=2017-08-31&range=custom&sort=name&reverse=false&timezone_id=172&columns=installs&countries=us&attribution_type=click&grouping=dates&conversion_type=all&attribution_source=dynamic&scale=sqrt&gkpi=installs

API

AD

http://adstat.easybrain.com/api/impressions?app=com.easybrain.sudoku&adtype=inter&country=us&network=AdWords+mGDN&date_start=2017-04-01&date_end=2017-11-20&zero_idfa=0

BI

https://prod-bitool.easybrain.com/api/v1.0/get_impressions?app=com.easybrain.sudoku&adtype=inter&country=us&network=AdWords+mGDN&date_start=2017-08-01&date_end=2017-11-20&zero_idfa=0

Excell