Desktop MAU/DAU in Tier1 Countries

This is a proof of concept for generating protosaur dashboards with a docker-etl workload (https://github.com/mozilla/docker-etl)

The data in this table is not validated and may not be accurate

Part 1: Tier1 countries (US, CA, GB, DE, FR)

Part 1.1: Desktop MAU/DAU contribution from each Tier1 countries w.r.t Global

Stored as img/desktop_[COUNTRY NAME]_mau_dau_ratio.jpeg for each country

Part 1.2 Desktop MAU/DAU contribution from Tier1 w.r.t. Global

Stored as img/desktop_MAU_tier1_contribution.jpeg

Stored as img/desktop_DAU_tier1_contribution.jpeg

Part 1.3 Desktop MAU/DAU from Tier1 countries

We show for each **Tier1** country (US, CA, DE, FR, GB) and (Global/Tier1/RoW) 4 different plots (from left to right)

Stored as img/desktop_[COUNTRY NAME]_mau_dau.jpeg for each country

1. MAU for each year

2. MAU w.r.t MAU on Jan01 for each year

3. DAU (7d MA) for each year

4. DAU (7d MA) w.r.t that on Jan01 for each year

Part 1.4 Desktop DAU contribution per User State

Stored as img/desktop_[COUNTRY]_user_state_dau_contribution.jpeg

User state is based on v3 of user state expalined here.

Directly run from `clients_last_seen` daily is expensive (> 6TB) so that we create an aggregation table to store the historical data, and only append daily data to it. Hence the numbers might be different from direct run.

Part 2: Top countries not in Tier 1 (CN, IN, BR, ID, RU, PL)

Besides Tier1 countries, there are another 6 countries (CN, IN, BR, ID, RU, PL) that has top rank MAU/DAU. In total these 11 countries usually contribute ~60% of our DAU/MAU.

Part 2.1: Desktop MAU/DAU contribution from Top countries w.r.t Global

Stored as img/desktop_[COUNTRY NAME]_mau_dau_ratio.jpeg for each country

Part 2.2 Desktop MAU/DAU contribution from Top11 w.r.t. Global

Stored as img/desktop_MAU_top11_contribution.jpeg

Stored as img/desktop_DAU_top11_contribution.jpeg

Part 2.3 Desktop MAU/DAU from Top countries

Stored as img/desktop_[COUNTRY NAME]_mau_dau.jpeg for each country

1. MAU for each year

2. MAU w.r.t MAU on Jan01 for each year

3. DAU (7d MA) for each year

4. DAU (7d MA) w.r.t that on Jan01 for each year

Part 2.4 Desktop DAU contribution per User State

Stored as img/desktop_[COUNTRY]_user_state_dau_contribution.jpeg