Mobile App Report » History » Revision 6
Revision 5 (Soh Keong, 08/30/2022 02:32 PM) → Revision 6/7 (Soh Keong, 08/30/2022 03:13 PM)
h1. Mobile App Report h2. Steps h3. Get data from Google 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 2. Update the "Install events" to *Monthly* 3. Update the period to *Last Month* 4. Copy the Total downloaded value from the chart. _________________________________________________________________________________________________________________________________________________________________ !mApp_1.png! _________________________________________________________________________________________________________________________________________________________________ h3. Get data from Apple 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 6. Update Month 7. Copy the Total downloaded value. _________________________________________________________________________________________________________________________________________________________________ !mApp_2.png! _________________________________________________________________________________________________________________________________________________________________ 8. insert new record to DB <pre> INSERT INTO APP_DOWNLOAD_MONTHLY(YEAR_MONTH,APP_STORE,GOOGLE_PLAY) VALUES (202207,598,1238) </pre> 9. Run script <pre> $JAVA_PATH/java -Dprogram.name=GenCoswayAppMonthlyReport -classpath $CP$CP_EXCEL GenCoswayAppMonthlyReport 072022 </pre>