アプリのダウンロード数や売上集計を自動化するためにやったこと(大変だったこと)
・App Store Connectからのレポート
・Google Play Consoleからのレポート
pixiv App Night - 2019/11/22 https://pixiv.connpass.com/event/153642/
• BigQuery Data Transfer Service for Google PlayΛ͏ (25υϧ/ΞϓϦ݄) • ݄࣍Ϩϙʔτ͚ͩͲਵ࣌ߋ৽͞ΕΔ • ৽نϢʔβʔ֫ಘ installs_xxx.yyy.zzzzzz_YYYYMM_overview.csv ͷ Daily User Installs ΛΈ͍ͯ·͢ ͬͨ͜ͱ
wish to download based on the Apple Fiscal Calendar. The date is specified in the YYYY-MM format. • YYYY-MM • AppleձܭΧϨϯμʔͷͱPeriodΛࢦఆ͢Δ • 201911݄2019-11Ͱͳ͘2020-02ͱͳΔ ࡒϨϙʔτ
financial reports per territory. For a complete list of possible values, see Financial Report Regions and Currencies. • 46ͷϦʔδϣϯ͕͋ΔͷͰɺ46ճAPIΛୟ͘ඞཁ͕͋Δ • https://help.apple.com/app-store-connect/#/dev360aba524 • App՝ۚϓϩμΫτશੈքʹ৴͞ΕΔ • ҠಈઌͰΞϓϦ͑ΔͷͰؾΛ͚·͠ΐ͏ ࡒϨϙʔτ
financial reports per territory. For a complete list of possible values, see Financial Report Regions and Currencies. • 46ͷϦʔδϣϯ͕͋ΔͷͰɺ46ճAPIΛୟ͘ඞཁ͕͋Δ • ྲྀੴʹେมͩΑͶɺͱ͍͏͜ͱͰZZΛࢦఆ͢ΔͱશϦʔδϣϯΛ·ͱΊͨ ͷ͕औಘͰ͖ΔΑ͏ʹͳ͍ͬͯΔ • ͨͩ͠20182݄͔Β • ͦΕҎલ46ճୟ͔ͳ͍ͱ͍͚ͳ͍ʢ߹ʹΑͬͯखಈָ͕ʣ ࡒϨϙʔτ
`financial_report_regions_and_currencies` UNION ALL SELECT 'Rest of World', 'USD', 'WW', 'Thailand' ), fixed_financial_report_regions_and_currencies_in_japanese AS ( SELECT * FROM `financial_report_regions_and_currencies_in_japanese` UNION ALL SELECT 'ͦͷଞͷҬ', 'USD', 'WW', 'λΠ' )
`app_store_territories` UNION ALL SELECT 'CO', 'Columbia' UNION ALL SELECT 'KR', 'Korea' UNION ALL SELECT 'TZ', 'United Republic of Tanzania' UNION ALL SELECT 'LC', 'Saint Lucia' UNION ALL SELECT 'BN', 'Brunei Darussalam' UNION ALL SELECT 'KR', 'Republic of Korea' UNION ALL SELECT 'LA', 'People’s Democratic Republic of Lao' UNION ALL SELECT 'MK', 'The Former Yugoslav Republic of Macedonia' )