Project

General

Profile

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>