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> |