Upgrade to Pro — share decks privately, control downloads, hide ads and more …

FirebaseとBigQueryによるアプリのKPI分析(CMの効果検証編)

shoby
September 17, 2017

 FirebaseとBigQueryによるアプリのKPI分析(CMの効果検証編)

iOSDC 2017での発表資料です。

shoby

September 17, 2017
Tweet

More Decks by shoby

Other Decks in Technology

Transcript

  1. 46 $.ͷඅ༻ରޮՌվળ౎ಓ෎ݝผ౤Լྔͷ࠷దԽ SELECT STRFTIME_UTC_USEC(DATE_ADD(event_dim.timestamp_micros, 9, 'HOUR'), '%Y-%m-%d') AS install_date, user_dim.geo_info.region

    AS region, EXACT_COUNT_DISTINCT(user_dim.device_info.resettable_device_id) as install_count FROM your_table_name WHERE user_dim.geo_info.country = 'Japan' AND event_dim.name = 'first_open' GROUP BY install_date, region ORDER BY install_date ASC, install_count DESC ౎ಓ෎ݝผͷ%BJMZΠϯετʔϧ਺Λऔಘ