Project

General

Profile

Mobile App Report » History » Version 7

Soh Keong, 10/21/2022 03:40 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 6 Soh Keong
_________________________________________________________________________________________________________________________________________________________________
14 1 Soh Keong
!mApp_1.png!
15 6 Soh Keong
_________________________________________________________________________________________________________________________________________________________________
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 1 Soh Keong
7. Copy the Total downloaded value.
23 4 Soh Keong
24 6 Soh Keong
_________________________________________________________________________________________________________________________________________________________________
25 4 Soh Keong
!mApp_2.png!
26 6 Soh Keong
_________________________________________________________________________________________________________________________________________________________________
27 1 Soh Keong
28 7 Soh Keong
-8. insert new record to DB-
29 5 Soh Keong
30 7 Soh Keong
-INSERT INTO APP_DOWNLOAD_MONTHLY(YEAR_MONTH,APP_STORE,GOOGLE_PLAY) VALUES (202207,598,1238)-
31 1 Soh Keong
32 5 Soh Keong
9. Run script 
33
34
<pre>
35 7 Soh Keong
$JAVA_PATH/java -Dprogram.name=GenCoswayAppMonthlyReport -classpath $CP$CP_EXCEL GenCoswayAppMonthlyReport 072022 #APP_STORE #GOOGLE_PLAY
36 5 Soh Keong
</pre>