Mobile App Report¶

Steps¶

Get data from Google¶

1. Visit Google Play Console

2. Update the "Install events" to Monthly
3. Update the period to Last Month
4. Copy the Total downloaded value from the chart.

_________________________________________________________________________________________________________________________________________________________

_________________________________________________________________________________________________________________________________________________________

Get data from Apple¶

5. Visit Apple Store

6. Update Month
7. Copy the Total downloaded value.

_________________________________________________________________________________________________________________________________________________________

_________________________________________________________________________________________________________________________________________________________

8. insert new record to DB

INSERT INTO APP_DOWNLOAD_MONTHLY(YEAR_MONTH,APP_STORE,GOOGLE_PLAY) VALUES (202207,598,1238)

9. Run script

$JAVA_PATH/java -Dprogram.name=GenCoswayAppMonthlyReport -classpath $CP$CP_EXCEL GenCoswayAppMonthlyReport 072022