Mobile App Report » History » Version 5
Soh Keong, 08/30/2022 02:32 PM
| 1 | 1 | Soh Keong | h1. Mobile App Report |
|---|---|---|---|
| 2 | |||
| 3 | h2. Steps |
||
| 4 | |||
| 5 | h3. Get data from Google |
||
| 6 | |||
| 7 | 3 | Soh Keong | 1. Visit "Google Play Console":https://play.google.com/console/u/0/developers/6818755711564860776/app/4973104729191098085/statistics?metrics=INSTALL_EVENTS-ALL-EVENTS-PER_INTERVAL-DAY&dimension=APP_VERSION&dimensionValues=OVERALL&dateRange=2021_10_11-2022_1_20&growthRateDimensionValue=OVERALL&tab=APP_STATISTICS&ctpMetric=DAU_MAU-ACQUISITION_UNSPECIFIED-COUNT_UNSPECIFIED-CALCULATION_UNSPECIFIED-DAY&ctpDateRange=2021_12_22-2022_1_20&ctpDimension=COUNTRY&ctpDimensionValue=OVERALL&ctpPeersetKey=3%3Af5848f1964a2a47f |
| 8 | 1 | Soh Keong | |
| 9 | 2 | Soh Keong | 2. Update the "Install events" to *Monthly* |
| 10 | 3. Update the period to *Last Month* |
||
| 11 | 4. Copy the Total downloaded value from the chart. |
||
| 12 | |||
| 13 | 5 | Soh Keong | |
| 14 | 1 | Soh Keong | !mApp_1.png! |
| 15 | |||
| 16 | 5 | Soh Keong | |
| 17 | 2 | Soh Keong | h3. Get data from Apple |
| 18 | 1 | Soh Keong | |
| 19 | 3 | Soh Keong | 5. Visit "Apple Store":https://appstoreconnect.apple.com/login?targetUrl=%2Fanalytics%2Fapp%2Fd30%2F1570365048%2Fmetrics%3FannotationsVisible%3Dtrue%26chartType%3Dsingleaxis%26measureKey%3DtotalDownloads%26zoomType%3Dday&authResult=FAILED |
| 20 | |||
| 21 | 4 | Soh Keong | 6. Update Month |
| 22 | 7. Copy the Total downloaded value. |
||
| 23 | |||
| 24 | !mApp_2.png! |
||
| 25 | 1 | Soh Keong | |
| 26 | 5 | Soh Keong | 8. insert new record to DB |
| 27 | |||
| 28 | <pre> |
||
| 29 | INSERT INTO APP_DOWNLOAD_MONTHLY(YEAR_MONTH,APP_STORE,GOOGLE_PLAY) VALUES (202207,598,1238) |
||
| 30 | </pre> |
||
| 31 | |||
| 32 | 9. Run script |
||
| 33 | |||
| 34 | <pre> |
||
| 35 | $JAVA_PATH/java -Dprogram.name=GenCoswayAppMonthlyReport -classpath $CP$CP_EXCEL GenCoswayAppMonthlyReport 072022 |
||
| 36 | </pre> |