12-12

BI

https://prod-bitool.easybrain.com/cohort_data?report_type=2&period=1&date=04-08-2017+-+20-11-2017&days_limit=29&application=2&country=235&network=42&advt_type=2#

AdS

http://adstat.easybrain.com/adjust/impressions?game=cx6lgh6l80e8&date_from=2017-08-04&date_to=2017-11-20&country%5B%5D=us&events%5B%5D=rvhz8m&source%5B%5D=ftyerj&show_type=SUMM_IMPRESSIONS_PER_USER&go=1

Adjust

https://dash.adjust.com/#/statistics/overview/default/cx6lgh6l80e8/ftyerj?from=2017-08-01&to=2017-11-20&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

SQL

SELECT count(DISTINCT device_id ) FROM daily_stats 

WHERE DATE BETWEEN '2017-08-01' AND '2017-11-20'

AND advt_type_id = 2

AND device_id IN 

  (SELECT device_id FROM sources 

    WHERE country_id=235 

    AND application_id=2 

    AND network_id = 42

    AND install_date = '2017-08-07' )

TEST 2

BI

https://prod-bitool.easybrain.com/cohort_data?report_type=2&period=1&date=01-08-2017+-+20-11-2017&days_limit=29&application=2&country=235&network=30&advt_type=2#

SELECT count(DISTINCT device_id ) FROM daily_stats 

WHERE DATE BETWEEN '2017-08-01' AND '2017-11-20'

AND advt_type_id = 2

AND device_id IN 

  (SELECT device_id FROM sources 

    WHERE country_id=235 

    AND application_id=2 

    AND network_id = 30

    AND install_date = '2017-08-02' )