APXOR Insights-Daily Reports

Assumptions : This report generated is sent on 25th April 2020. So the comparisons include data as of 24th April 2020, which will be taken as the Present Date.

Basic Metrics Tracking

Apxor lets you track three basic metrics from the four available metrics :

  1. Daily Active Users (DAU)
  2. Weekly Active Users (WAU)
  3. Monthly Active Users (MAU)
  4. New Installs

Daily Active Users

DAU

  1. The number mentioned on top indicates Daily Active Users (DAU) of 24th April 2020.

    • This data can be obtained from the dashboard on the day of receiving the Daily Digest Report by clicking on the Yesterday option on the Global Date Range

  2. Apxor lets you customize the deviations on a daily base, weekly base, monthly base.

    • For Daily base, the deviation will be between the present day and yesterday (i.e 24th April vs 23th April)
    • For Weekly base, the deviation will be between the present day minus 7 days (including the present day) (i.e 24th April vs 17th April)
    • For Monthly base, the deviation will be between the present day minus 30 days (including the present day) (i.e 24th April vs 25th March)

    Note: We have taken the first case to explain the example

  3. Deviations are calculated by the difference in the DAU of the Present Date and Previous Day’s Date

    • For Example: The DAU as of 24th April is the present date (i.e 24th April 2020). The DAU for yesterday will be 23rd March. These two user counts are taken to calculate deviations.

  4. The Percentage Difference can be calculated by the formula :

    daily-reports-formula-1

    • A negative value is indicated by a Red Arrow ▼ indicating a decrease in the count and a positive value is indicated by a Green Arrow ▲ indicating an increase in count.
    • For Example : The Daily Active User on the present day (24th April 2020) is 19580, the DAU count for yesterday(23rd April 2020) is 21650, then the percentage difference is calculated as [(19580 - 21650) / 21650] * 100 leading to -9.56. The report will indicate this value by a Red Arrow ▼ indicating a decrease of 9.56%

Weekly Active Users

WAU

  1. The number mentioned on top indicates Weekly Active Users (WAU) as of 24th April 2020.

    • Apxor calculates its WAU as the Present Date minus 7 days (including the Present Date).
    • This data can be obtained from the dashboard on the day of receiving the Daily Digest Report by clicking on the Last 7 Days option on the Global Date Range

  2. Deviations are calculated by the difference in the WAU of the recent week (last 7 days) and the previous week (recent week date minus 7 days ).

    • For Example: The WAU as of 24th April (the recent week) is the number of users between 24th April minus 7 days (including the Present Date) which will be 18th April - 24th April. The WAU for the previous week will be the Recent week minus 7 days, which will be 11th April - 17th April. These two user counts are taken to calculate deviations.

  3. The Percentage Difference can be calculated by the formula :

    daily-reports-formula-2

    • A negative value is indicated by a Red Arrow ▼ indicating a decrease in the count and a positive value is indicated by a Green Arrow ▲ indicating an increase in count.
    • For Example: The Recent Week User count is 120540, the previous week user count 125920, then the percentage difference is calculated as [(120540 - 125920) / 125920] * 100 leading to -4.27. The report will indicate this value by a Red Arrow ▼ indicating a decrease of 4.27%

Monthly Active Users

MAU

  1. The number mentioned on top indicates Monthly Active Users (MAU) as of 24th April 2020.

    • Apxor calculates its MAU as the Present Date minus 30 days (including the Present Date).
    • This data can be obtained from the dashboard on the day of receiving the Daily Digest Report by clicking on the Last 30 Days option on the Global Date Range

  2. Deviations are calculated by the difference in the MAU of the recent month (last 30 days) and the previous month (recent month date minus 30 days ).

    • For Example : The MAU as of 24th April (the recent month) is the number of users between 24th April minus 30 days (including the Present Date) which will be 26th March - 24th April. The MAU for the previous month will be the Recent month minus 30 days, which will be 25th February - 25th March. These two user counts are taken to calculate deviations.

  3. The Percentage Difference can be calculated by the formula :

    daily-reports-formula-3

    • A negative value is indicated by a Red Arrow ▼ indicating a decrease in count and a positive value is indicated by a Green Arrow ▲ indicating an increase in count.
    • For Example: The Recent Month User count is 331800, the previous month user count 437580, then the percentage difference is calculated as [(331800 - 437580) / 437580] * 100 leading to -24. The report will indicate this value by a Red Arrow ▼ indicating a decrease of 24%

New Installs

New Installs is calculated in the same manner as Daily Active Users with the same level of customizations to choose from the deviations. The only difference between New Installs and Daily Active Users is by their definitions of metrics.

New Installs :

  • Number of Users who Installed the app.
  • Calculated using the event installs

Daily Active Users :

  • Number of returning users to the app.
  • Calculated using the event apx_app_opened

Tracking Event Metrics

  • You can choose upto 10 events and their usage (event count) that you want to track on a daily basis from the Daily Digest Report. The number mentioned below the event name is the number of event occurrences on the present date (24th April 2020)

  • For deviation comparisons, you can choose 2 types of comparisons available from the following options :

    1. to compare the event count with the previous day’s data
    2. to compare the event count with the previous week’s data
    3. to compare the event count with the previous month’s data

Deviations on a Day-to-Day basis: The deviation is calculated by using the present date’s event count (24th April 2020) vs previous date (23rd April)

Deviations on a Weekly basis: The deviation is calculated by using the present date’s event count (24th April 2020) vs present date minus 7 days (17th March)

Deviations on a Monthly basis: The deviation is calculated by using the present date’s event count (24th April 2020) vs present date minus 30 days (25th March)

  • Percentage Difference for Deviation is calculated using the formula

    daily-reports-formula-3

    • A negative value is indicated by a Red Arrow ▼ indicating a decrease in count and a positive value is indicated by a Green Arrow ▲ indicating an increase in count.

Example:

DayEvent Count
Present Day
(on 24th April 2020)		4356
Previous Day
(on 23rd April 2020)		6571
Previous Week
(on 17th April 2020)		9003
Previous Month
(on 25th March 2020)		3489

Deviation Calculation

Deviation TypeFormulaDeviation %
Day to Day Deviation[(Present Day User Count - Previous Day User Count ) / Previous Day User Count ] * 100 Decreased by 33%
Weekly Deviation[(Recent Week User Count - Previous Week User Count ) / Previous Week User Count ] * 100 Decreased by 51%
Monthly Deviation[(Recent Month User Count - Previous Month User Count ) / Previous Month User Count ] * 100 Increased by 24%

Sample of the Report with Event as Post Share and Deviations as Weekly and Monthly Comparison

Post Share

Tracking Funnel Conversions

  • You can track funnel conversions between any 2 events with a configurable time window. The conversion mentioned between the events is the conversion on the present date (24th April 2020)

  • For deviation comparisons, you can choose 2 types of comparisons available from the following options :

    1. to compare the conversions with the previous day’s data
    2. to compare the conversions with the previous week’s data
    3. to compare the conversions with the previous month’s data

Deviations on a Day - to - Day basis: The deviation is calculated by using the present date’s conversion (24th April 2020) vs previous date’s conversion (23rd April)

Deviations on a Weekly basis: The deviation is calculated by using the present date’s conversion (24th April 2020) vs present date minus 7 days’ conversion (17th March)

Deviations on a Monthly basis: The deviation is calculated by using the present date’s conversion (24th April 2020) vs present date minus 30 days’ conversion (25th March)

  • Percentage Difference for Deviation is calculated using the formula

    daily-reports-formula-5

    • A negative value is indicated by a Red Arrow ▼ indicating a decrease in count and a positive value is indicated by a Green Arrow ▲ indicating an increase in count.

Example:

DayConversion Rate (window period: 1)
Present Day
(on 24th April 2020)		4.3%
Previous Day
(on 23rd April 2020)		5.2%
Previous Week
(on 17th April 2020)		1.5%
Previous Month
(on 25th March 2020)		3.2%

Deviation Calculation

Deviation TypeFormulaDeviation %
Day to Day Deviation[(Present Day Conversion - Previous Day Conversion ) / Previous Day Conversion ] * 100 Decreased by 17%
Weekly Deviation[ (Present Day Conversion - Previous Week Conversion ) / Previous Week Conversion ] * 100 Increased by 186%
Monthly Deviation[ (Present Day Conversion - Previous Month Conversion ) / Previous Month Conversion ] * 100 Increased by 34%

Sample of the Report with Conversion Window as 1 Day and Deviations as Weekly and Monthly Comparison :

Funnel

Custom Reports

All the Basic Metrics and Event Metrics are displayed as a time series graph to understand behaviors over a wider time span. You can click on the link attached in the Daily Digest to get your Custom Reports

Sample of Custom Reports

Report-1 Report-2

← BehaviourCampaigns →