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

アプリストアからのレポート集計自動化 / App Report Automation

cc4966
November 22, 2019

アプリストアからのレポート集計自動化 / App Report Automation

アプリのダウンロード数や売上集計を自動化するためにやったこと(大変だったこと)
・App Store Connectからのレポート
・Google Play Consoleからのレポート
pixiv App Night - 2019/11/22 https://pixiv.connpass.com/event/153642/

cc4966

November 22, 2019
Tweet

More Decks by cc4966

Other Decks in Programming

Transcript

  1. ΞϓϦετΞ͔ΒͷϨϙʔτूܭࣗಈԽ
    ʙͰ͖ͨΓͰ͖ͳ͔ͬͨΓʙ

    pixiv App Night

    pixiv.inc
    rokuroku (Twitter: @496_)

    View full-size slide

  2. 2
    ࣗݾ঺հ
    ● pixivίϛοΫͷiOSΞϓϦ։ൃ
    ● pixivΞϓϦ (iOS/Android/API)
    ͰখઆपΓͷ։ൃ
    ● झຯͰTATEditorͱ͍͏ॎॻ͖Τ
    σΟλΞϓϦΛ։ൃ͍ͯ͠Δ
    rokuroku
    iOS/AndroidΞϓϦ
    ΤϯδχΞ

    View full-size slide

  3. • Google Play΍App Store͔ΒͷϨϙʔτूܭࣗಈԽ
    • ΍Γ͔ͨͬͨ͜ͱ
    • Google Play Consoleͷ࿩
    • App Store Connectͷ࿩
    • ΍ͬͨ͜ͱ
    • ࢀߟϦϯΫू

    Ξ΢τϥΠϯ

    View full-size slide

  4. • AndroidΞϓϦ΍iOSΞϓϦͷ౷ܭ৘ใ΍ച্ɺܦཧॲཧͷࣗಈԽ
    • ΋ͱ΋ͱ
    • ౷ܭ৘ใ͸खಈͰదٓ
    • ܦཧॲཧ͸ຖ݄ઐ༻؅ཧը໘Ͱूܭ
    • ཧ૝
    • উखʹ਺஋͕஝ੵ͞Ε͍ͯ͘

    ΍Γ͔ͨͬͨ͜ͱ

    View full-size slide

  5. • ࣗಈԽʹखΛ͚ͭΔલʹ஌͍ͬͯͨ৘ใ
    • Google PlayͷϨϙʔτ͸Google Cloud Storageʹશ෦஝ੵ͞ΕΔ
    • App StoreͷϨϙʔτ͸App Store Connect APIͰऔಘͰ͖Δ
    • ͔͜͜ΒόονͰσʔλΛྲྀ͠ࠐΈଓ͚Ε͹Φοέʔ

    ΍Γ͔ͨͬͨ͜ͱ

    View full-size slide

  6. • ͦ΋ͦ΋Ͳ͏͍͏਺஋͕औΕΔΜ͚ͩͬʁ
    • Google Play ConsoleͱϨϙʔτ
    • App Store ConnectͱϨϙʔτ
    • ؒʹ߹Θͳ͔ͬͨͷͰը໘͸શ෦ݸਓϓϩμΫτͷ΋ͷͰ͢

    ຊ୊ʹೖΔલʹ

    View full-size slide

  7. Google Play Console

    View full-size slide

  8. Google Play Console

    View full-size slide

  9. Google Play Console

    View full-size slide

  10. Google Play Console

    View full-size slide

  11. Google Play Console

    View full-size slide

  12. Google Play Console

    View full-size slide


  13. • ϨϏϡʔ
    • ౷ܭ৘ใ
    • Ϣʔβʔ֫ಘ
    • ച্ʢશΞϓϦڞ௨ʣ

    View full-size slide


  14. • ΠϯετʔϧϢʔβʔ਺తͳ਺͸ʮ৽نϢʔβʔ֫ಘ
    ਺ʯͷ૯࿨

    View full-size slide

  15. App Store Connect

    View full-size slide

  16. App Store Connect

    View full-size slide

  17. App Store Connect

    View full-size slide

  18. App Store Connect

    View full-size slide

  19. App Store Connect

    View full-size slide

  20. App Store Connect

    UTCͱPST͕બ΂Δ

    View full-size slide

  21. App Store Connect

    PSTͷΈɻ࠷େ8छྨͷϨϙʔτ͕ݱΕΔ

    View full-size slide

  22. App Store Connect

    ۜߦ΁ͷৼΓࠐΈֹ΍ৼΓࠐΈঢ়گ͕֬ೝͰ͖Δ

    View full-size slide


  23. • AppΞφϦςΟΫε
    • ച্ͱτϨϯυ
    • ࢧ෷ͱࡒ຿ใࠂ

    View full-size slide


  24. • ΠϯετʔϧϢʔβʔ਺తͳ਺͸ʮAppϢχοτ਺ʯ
    ͷ૯࿨

    View full-size slide

  25. • Google Play Console͸ϒϥ΢βͳΒ1࣌ؒ͝ͱͷ਺஋ΛݟΕΔ
    • ϦϐʔλʔͳͲϒϥ΢βͷΈ͔Β͔͠खʹೖΒͳ͍৘ใ΋͋Δ
    • App Store Connect͸UTCͱPST͕͋ΔͷͰ1೔Λ8࣌ؒͱ16࣌ؒʹ෼཭Մೳ
    • AppΞφϦςΟΫε͸ϒϥ΢βͷΈ͔Β͔͠खʹೖΒͳ͍৘ใ͕ͨ͘͞Μ
    • ࣗಈԽՄೳͳൣғͰ͸1೔୯Ґ (PST) ͷ౷ܭ৘ใ͔͠खʹೖΒͳ͍
    • PST: ଠฏ༸ඪ४࣌ -0800

    ൵͍͠ϙΠϯτ

    View full-size slide

  26. Google Play Console

    View full-size slide

  27. • σʔλ͸͢΂ͯBigQueryʹอ؅͢ΔΑ͏ʹόονΛ૊Μͩ
    • ʮGoogle ͕ఏڙ͢ΔαʔόʔϨεͰεέʔϥϏϦςΟʹ༏Εͨاۀ޲͚
    σʔλ΢ΣΞϋ΢εʯ
    • Looker͔ΒݟΕΔΑ͏ʹܨ͗ࠐΜͩ
    • ʮϦΞϧλΠϜͷϏδωε෼ੳΛ؆୯ʹ୳ࡧɺ෼ੳɺڞ༗Ͱ͖ΔϏδωε
    ΠϯςϦδΣϯειϑτ΢ΣΞͰɺσʔλ෼ੳϓϥοτϑΥʔϜʯ
    • iOSͷAppϢχοτ਺ͱAndroidͷ৽نϢʔβʔ֫ಘ਺

    ΍ͬͨ͜ͱ
    • https://inside.pixiv.blog/jaggy/7353
    • https://www.slideshare.net/KOTAROTAKAHASHI1/350-170250961

    View full-size slide

  28. • Google Play ConsoleͷϨϙʔτࣗಈอ؅
    • App Store ConnectͷϨϙʔτࣗಈอ؅

    ΍ͬͨ͜ͱ

    View full-size slide

  29. • Google Play ConsoleͷϨϙʔτ
    • ࣮͸·ͩ΍ͬͯͳ͍ʢ2୒Ͱ·ͩະఆʣ
    • Google Cloud StorageͷCSVΛBigQueryʹΞοϓϩʔυ͢Δ
    • BigQuery Data Transfer Service for Google PlayΛ࢖͏ (25υϧ/ΞϓϦ݄)
    • ݄࣍Ϩϙʔτ͚ͩͲਵ࣌ߋ৽͞ΕΔ
    • ৽نϢʔβʔ֫ಘ਺͸ installs_xxx.yyy.zzzzzz_YYYYMM_overview.csv ͷ
    Daily User Installs ΛΈ͍ͯ·͢

    ΍ͬͨ͜ͱ

    View full-size slide

  30. • Google Play ConsoleͷϨϙʔτ
    • Google Cloud StorageͷϨϙʔτϑΝΠϧ΁ͷΞΫηεݖ
    • Google Play Console > ઃఆ > σϕϩούʔΞΧ΢ϯτ > Ϣʔβʔͱݖݶ
    • ͜͜ͰϑΝΠφϯεݖݶΛ෇༩
    • αʔϏεΞΧ΢ϯτʹ΋෇༩Ͱ͖Δ

    ݖݶ·ΘΓ

    View full-size slide

  31. • Google Cloud StorageͷCSVϑΝΠϧ
    • จࣈίʔυ͕UTF-16ͩͬͨΓ͢ΔͷͰ͚ͦͩ͜஫ҙ

    ΍ͬͨ͜ͱ

    View full-size slide


  32. ͜͜·Ͱ͕៉ྷͳ࿩

    View full-size slide

  33. • App Store ConnectͷϨϙʔτ
    • App Store Connect API͔ΒϨϙʔτΛऔಘͯ͠Ξοϓϩʔυ
    • App Store Connect > ϢʔβͱΞΫηε > ΩʔʢAdminҎ্ͷݖݶʣ
    • ʮΞΫηεΛϦΫΤετʯ͢ΔʢҰ౓͚ͩಉҙ͕ඞཁʣ
    • ʮAPIΩʔΛੜ੒ʯ͢Δ
    • ΞΫηε͸Financeʢࢧ෷৘ใ͕ෆཁͳΒSales͓ΑͼReportsͰྑ͍ʣ

    ΍ͬͨ͜ͱ

    View full-size slide

  34. • ച্ͱτϨϯυϨϙʔτ
    • AppϢχοτ਺ͳͲΛ஌ΔͨΊʹඞཁ
    • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτ
    • ͲͷΞΠςϜͰ೔ຊԁͰ͍͘Βೖۚ͞Ε͔ͨ஌ΔͨΊʹඞཁ
    • ʢࠓճ͸ѻΘͳ͔͕ͬͨϨϏϡʔ͸ެ։RSS͕͋Δʣ
    • ྫ: https://itunes.apple.com/jp/rss/customerreviews/id=1477764116/json

    ΍ͬͨ͜ͱ

    View full-size slide

  35. • ച্ͱτϨϯυϨϙʔτ
    • ೔࣍Ϩϙʔτɺि࣍Ϩϙʔτɺ݄࣍Ϩϙʔτɺ೥࣍Ϩϙʔτ͕͋Δ
    • ϨϙʔτछผʹΑͬͯͲΕ͕͋Δ͔͸ҟͳΔ
    • ೥࣍ϨϙʔτҎ֎͸1೥ͰऔಘෆՄʹͳΔ

    ΍ͬͨ͜ͱ

    View full-size slide


  36. ೥࣍ϨϙʔτҎ֎͸
    1೥ͰऔಘෆՄʹͳΔ

    View full-size slide

  37. • ച্ͱτϨϯυϨϙʔτ
    • ೔࣍Ϩϙʔτɺि࣍Ϩϙʔτɺ݄࣍Ϩϙʔτɺ೥࣍Ϩϙʔτ͕͋Δ
    • ϨϙʔτछผʹΑͬͯͲΕ͕͋Δ͔͸ҟͳΔ
    • ೥࣍ϨϙʔτҎ֎͸1೥ͰऔಘෆՄʹͳΔ
    • ͡Ό͋1೥Ҏ্લͷAppϢχοτ਺͸Ͳ͏͢Δͷʁ

    ΍ͬͨ͜ͱ

    View full-size slide

  38. • App Store Connect > ച্ͱτϨϯυ > Ϣχοτ਺
    • λΠϜκʔϯͰPSTʹͯ͠શظؒΛબ୒
    • ର৅ͷΞϓϦͰϑΟϧλ
    • ϨϙʔτΛμ΢ϯϩʔυ
    • ͜ΕΛ܁Γฦ͢ͱશΞϓϦͷ1೥Ҏ্લͷAppϢχοτ਺΋खʹೖΔ

    1೥Ҏ্લͷAppϢχοτ਺

    View full-size slide

  39. • App Store Connect > ച্ͱτϨϯυ > Ϣχοτ਺
    • λΠϜκʔϯͰPSTʹͯ͠શظؒΛબ୒
    • ର৅ͷΞϓϦͰϑΟϧλ
    • ϨϙʔτΛμ΢ϯϩʔυ
    • ͜ΕΛ܁Γฦ͢ͱશΞϓϦͷ1೥Ҏ্લͷAppϢχοτ਺΋खʹೖΔ
    • Ͱ΋େมͳͷͰͳ͔ͥ௨৴ݟͯͨΒશظؒʹͨ͠ͱ͖ʹඞͣ߱ͬͯ͘Δ
    ͪΐ͏Ͳ1೥ΑΓલͷશΞϓϦͷ೔࣍AppϢχοτ਺Λ࢖͍·ͨ͠

    1೥Ҏ্લͷAppϢχοτ਺

    View full-size slide

  40. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτ
    • ച্ϨϙʔτͱԿ͕ҧ͏ͷʁ
    • ച্ϨϙʔτɿΞΠςϜ͕͍͘ΒͰ͍ͭ͘ങΘΕ͔͕ͨΘ͔Δ

    ΍ͬͨ͜ͱ

    View full-size slide

  41. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτ
    • ച্ϨϙʔτɿΞϓϦ΍ΞΠςϜ͕͍͘ΒͰ͍ͭ͘ങΘΕ͔͕ͨΘ͔Δ
    • ࡒ຿ϨϙʔτɿAppleձܭΧϨϯμʔͰࢦఆ͞ΕΔظؒதʹ༗ྉΞϓϦ΍
    ༗ྉΞΠςϜ͕͍͍ͭ͘͘ΒͰങΘΕͯɺͦͷ͏ͪख਺ྉͳͲΛҾ͘ͱ͍
    ͘ΒʹͳΔͷ͔͕Θ͔Δʢ࣍ͷAppleձܭΧϨϯμʔͷ຤͘Β͍ʣ

    ΍ͬͨ͜ͱ

    View full-size slide


  42. AppleձܭΧϨϯμʔ

    View full-size slide

  43. • App Store Connect > ࢧ෷ͱࡒ຿ใࠂ > ্ͷ೥݄ΛΫϦοΫ > Լ෦ͷձܭΧ
    ϨϯμʔΛදࣔ
    • ௚ۙ3೥͸5ि, 4ि, 4िͷ܁Γฦ͠
    • 2019೥11݄͸2020೥ͷPeriod 2

    AppleձܭΧϨϯμʔ

    View full-size slide

  44. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτ
    • ച্ϨϙʔτɿΞϓϦ΍ΞΠςϜ͕͍͘ΒͰ͍ͭ͘ങΘΕ͔͕ͨΘ͔Δ
    • ࡒ຿ϨϙʔτɿAppleձܭΧϨϯμʔͰࢦఆ͞ΕΔظؒதʹ༗ྉΞϓϦ΍
    ༗ྉΞΠςϜ͕͍͍ͭ͘͘ΒͰങΘΕͯɺͦͷ͏ͪख਺ྉͳͲΛҾ͘ͱ͍
    ͘ΒʹͳΔͷ͔͕Θ͔Δʢ࣍ͷAppleձܭΧϨϯμʔͷ຤͘Β͍ʣ

    ΍ͬͨ͜ͱ

    View full-size slide

  45. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτ
    • ച্ϨϙʔτɿΞϓϦ΍ΞΠςϜ͕͍͘ΒͰ͍ͭ͘ങΘΕ͔͕ͨΘ͔Δ
    • ࡒ຿ϨϙʔτɿAppleձܭΧϨϯμʔͰࢦఆ͞ΕΔظؒதʹ༗ྉΞϓϦ΍
    ༗ྉΞΠςϜ͕͍͍ͭ͘͘ΒͰങΘΕͯɺͦͷ͏ͪख਺ྉͳͲΛҾ͘ͱ͍
    ͘ΒʹͳΔͷ͔͕Θ͔Δʢ࣍ͷAppleձܭΧϨϯμʔ݄ͷ຤·Ͱʣ
    • ࢧ෷Ϩϙʔτɿࡒ຿ϨϙʔτͰใࠂ͞ΕΔͷ͸ݱ஍௨՟ͳͷͰɺͦΕ͕Ͳ
    ͏͍͏ϨʔτͰ೔ຊԁͰ͍͘Βʹೖۚ͞Ε͔͕ͨΘ͔Δʢର৅ͷAppleձ
    ܭΧϨϯμʔ݄຤͔Β45೔Ҏ಺ʣ

    ΍ͬͨ͜ͱ

    View full-size slide

  46. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτͷऔಘํ๏
    • ͲͷΞΠςϜͰ೔ຊԁͰ͍͘Βऩӹ͕͔͋ͬͨ஌ΔͨΊʹ͸2ͭͱ΋ඞཁ
    • ࡒ຿Ϩϙʔτɿ
    • ࢧ෷Ϩϙʔτɿ

    ΍ͬͨ͜ͱ

    View full-size slide

  47. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτͷऔಘํ๏
    • ͲͷΞΠςϜͰ೔ຊԁͰ͍͘Βऩӹ͕͔͋ͬͨ஌ΔͨΊʹ͸2ͭͱ΋ඞཁ
    • ࡒ຿ϨϙʔτɿApp Store Connect APIͰμ΢ϯϩʔυͰ͖Δ
    • ࢧ෷Ϩϙʔτɿ

    ΍ͬͨ͜ͱ

    View full-size slide

  48. • API: https://developer.apple.com/documentation/appstoreconnectapi/
    download_finance_reports

    ࡒ຿Ϩϙʔτ

    View full-size slide

  49. • The date of the report you wish to download based on the Apple Fiscal
    Calendar. The date is specified in the YYYY-MM format.
    • YYYY-MM

    ࡒ຿Ϩϙʔτ

    View full-size slide

  50. • filter[reportDate] [string] (Required) The date of the report you wish to
    download based on the Apple Fiscal Calendar. The date is specified in the
    YYYY-MM format.
    • YYYY-MM
    • AppleձܭΧϨϯμʔͷ೥౓ͱPeriodΛࢦఆ͢Δ
    • 2019೥11݄෼͸2019-11Ͱ͸ͳ͘2020-02ͱͳΔ

    ࡒ຿Ϩϙʔτ

    View full-size slide

  51. • filter[regionCode] [string] (Required) You can download consolidated or
    separate financial reports per territory. For a complete list of possible
    values, see Financial Report Regions and Currencies.

    ࡒ຿Ϩϙʔτ

    View full-size slide

  52. • filter[regionCode] [string] (Required) You can download consolidated or
    separate financial reports per territory. For a complete list of possible
    values, see Financial Report Regions and Currencies.

    ࡒ຿Ϩϙʔτ

    View full-size slide

  53. • filter[regionCode] [string] (Required) You can download consolidated or
    separate 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಺՝ۚϓϩμΫτ͸શੈքʹ഑৴͞ΕΔ
    • ҠಈઌͰ΋ΞϓϦ͸࢖͑ΔͷͰؾΛ෇͚·͠ΐ͏

    ࡒ຿Ϩϙʔτ

    View full-size slide

  54. • filter[regionCode] [string] (Required) You can download consolidated or
    separate financial reports per territory. For a complete list of possible
    values, see Financial Report Regions and Currencies.
    • 46ͷϦʔδϣϯ͕͋ΔͷͰɺ46ճAPIΛୟ͘ඞཁ͕͋Δ
    • ྲྀੴʹେมͩΑͶɺͱ͍͏͜ͱͰZZΛࢦఆ͢ΔͱશϦʔδϣϯΛ·ͱΊͨ
    ΋ͷ͕औಘͰ͖ΔΑ͏ʹͳ͍ͬͯΔ
    • ͨͩ͠2018೥2݄෼͔Β
    • ͦΕҎલ͸46ճୟ͔ͳ͍ͱ͍͚ͳ͍ʢ৔߹ʹΑͬͯ͸खಈָ͕ʣ

    ࡒ຿Ϩϙʔτ

    View full-size slide

  55. • Ϩϙʔτܗࣜ
    • CSVͰ͸ͳ͍
    • ςΩετϑΝΠϧͷதʹCSV΍νΣοΫ༻ͷσʔλ͕ຒΊࠐ·Ε͍ͯΔײ
    ͡ͳͷͰύʔε͠ͳ͍ͱ͍͚ͳ͍

    ࡒ຿Ϩϙʔτ

    View full-size slide

  56. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτͷऔಘํ๏
    • ͲͷΞΠςϜͰ೔ຊԁͰ͍͘Βऩӹ͕͔͋ͬͨ஌ΔͨΊʹ͸2ͭͱ΋ඞཁ
    • ࡒ຿ϨϙʔτɿApp Store Connect APIͰμ΢ϯϩʔυͰ͖Δ
    • ࢧ෷ϨϙʔτɿApp Store Connectͷࢧ෷ͱࡒ຿ใࠂ͔Βۜߦৼࠐޙʹμ
    ΢ϯϩʔυͰ͖ΔΑ͏ʹͳΔ

    ΍ͬͨ͜ͱ

    View full-size slide


  57. खಈμ΢ϯϩʔυʂ

    View full-size slide

  58. • खಈμ΢ϯϩʔυ
    • ݴޠઃఆʹΑͬͯσʔλ͕ϩʔΧϥΠζ͞ΕΔ
    • ࢲ͕஌͍ͬͯΔ͚ͩͰ΋2ճϩʔΧϥΠζ݁Ռ͕มߋ͞Εͨ
    • CSV͕ຒΊࠐ·ΕͨςΩετϑΝΠϧ

    ࢧ෷Ϩϙʔτ

    View full-size slide

  59. • ࡒ຿Ϩϙʔτɺࢧ෷Ϩϙʔτͷऔಘํ๏
    • ͲͷΞΠςϜͰ೔ຊԁͰ͍͘Βऩӹ͕͔͋ͬͨ஌ΔͨΊʹ͸2ͭͱ΋ඞཁ
    • ࡒ຿ϨϙʔτɿApp Store Connect APIͰμ΢ϯϩʔυͰ͖Δ
    • ࢧ෷Ϩϙʔτɿࠓͷച্ܭࢉπʔϧͷϑϩʔʹΞοϓϩʔυΛ௥Ճ

    ΍ͬͨ͜ͱ

    View full-size slide

  60. • ࡒ຿Ϩϙʔτͱࢧ෷ϨϙʔτΛJOIN͢Δ
    • SELECT * FROM ӳޠࡒ຿Ϩϙʔτ JOIN ೔ຊޠࢧ෷Ϩϙʔτ ON ...?
    • App Store Connectͷ೔ຊޠ/ӳޠͷϔϧϓΛۦ࢖͢Δඞཁ͕͋Δ
    • ӳޠࡒ຿Ϩϙʔτʹ͸ࠃ·ͨ͸஍ҬͷISOίʔυɺࢧ෷௨՟͕͋Δ
    • ೔ຊޠࢧ෷Ϩϙʔτʹ͸೔ຊޠͷϦʔδϣϯίʔυɺࢧ෷௨՟
    • ࡒ຿ϨϙʔτʹϦʔδϣϯίʔυೖΕΔͷ͸46ճAPIୟ͚͹Ͱ͖Δ͚Ͳ……

    ࡒ຿Ϩϙʔτͱࢧ෷Ϩϙʔτ

    View full-size slide

  61. Ϧʔδϣϯͱࠃͱ஍Ҭ

    View full-size slide

  62. Ϧʔδϣϯͱࠃͱ஍Ҭʢ೔ຊޠʣ

    View full-size slide


  63. -- աڈλΠ͕WWʹؚ·Ε͍ͯΔ͜ͱ͕͋ͬͨͷͰ௥Ճ
    WITH fixed_financial_report_regions_and_currencies AS (
    SELECT * FROM `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', 'λΠ'
    )

    View full-size slide

  64. ࠃͱ஍ҬͱISOίʔυ

    View full-size slide


  65. WITH fixed_app_store_territories AS (
    -- 2ͭͷදͰදه༳Ε͕͋ΔͷͰͦΕΛٵऩ͢Δ
    SELECT * FROM `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'
    )

    View full-size slide

  66. • ࡒ຿Ϩϙʔτͱࢧ෷ϨϙʔτΛJOIN͢Δ
    • ӳޠࡒ຿Ϩϙʔτʹ͸ࠃ·ͨ͸஍ҬͷISOίʔυɺࢧ෷௨՟͕͋Δ
    • ೔ຊޠࢧ෷Ϩϙʔτʹ͸೔ຊޠͷϦʔδϣϯ໊ɺࢧ෷௨՟
    • ISOίʔυɺࢧ෷௨՟ → Ϧʔδϣϯίʔυɺࢧ෷௨՟
    • Ϧʔδϣϯίʔυɺࢧ෷௨՟ → ೔ຊޠͷϦʔδϣϯ໊ɺࢧ෷௨՟
    • ࢧ෷௨՟͕ඞཁͳͷ͸1ͭͷISOίʔυ͕ෳ਺ͷϦʔδϣϯʹؚ·ΕΔͷͰ

    ࡒ຿Ϩϙʔτͱࢧ෷Ϩϙʔτ

    View full-size slide

  67. • AndroidΞϓϦɺiOSΞϓϦͰ΄΅ಉ౳ͷࢦඪͱͯ͠೔࣍৽نϢʔβʔ֫ಘ
    ਺ (Android) ɺ೔࣍AppϢχοτ਺ (iOS) ͕ࣗಈͰूܭ͞ΕͯΞϓϦ͝ͱʹ
    ֬ೝͰ͖ΔΑ͏ʹͳͬͨʢAndroid͸ͳΔ༧ఆʣ
    • AndroidΞϓϦͰͷΞϓϦɾΞΠςϜผͷച্ɾऩӹܭࢉ͕ࣗಈԽ͢Δ༧ఆ
    • iOSΞϓϦͰͷΞϓϦɾΞΠςϜผͷച্ɾऩӹܭࢉ͕൒ࣗಈԽ͞Εͨ
    • աڈ෼΋ಉ༷ʹ֬ೝͰ͖ΔΑ͏ʹͳͬͨ
    • ৽͍͠؍఺Ͱ਺஋Λݟ͍ͨ৔߹΋ΫΤϦΛॻ͖׵͑Δ͚ͩ

    Ͱ͖ΔΑ͏ʹͳͬͨ͜ͱ

    View full-size slide

  68. • https://support.google.com/googleplay/android-developer/answer/
    6135870
    • https://cloud.google.com/bigquery/docs/play-transfer
    • https://developer.apple.com/jp/app-store-connect/api/
    • https://help.apple.com/app-store-connect/
    • https://help.apple.com/app-store-connect/en.lproj/static.html
    • https://qiita.com/rsahara/items/c9d3743d926dd29a89e8
    • https://blog.japantaxi.co.jp/2018/12/05/2159

    ࢀߟϦϯΫू

    View full-size slide