Technical Requirements

Product manager’s Dashboard

It is necessary to extract data from GA4 (BigQuery) and Facebook ads (BigQuery) and Google ads (BigQuery) and implement the following widgets in Looker Studio:

1. MAU/DAU %

2. DAU

3. MAU

4. CAC

5. 14-Day retention

6. 7-Day retention

7. 3-Day retention

8. CR Traffic > Registration (channel average)

Based on the Google Sheets document, with tasks to implement:

1. Weekly Product tasks completed

2. Product Manager's task from Development list

3. Product Manager's task from Management list

All necessary data is in the table.

Marketing

Behavioral

It is necessary to extract data from GA4 (BigQuery) and build a widget.

1. Based on event - "search_Global"

   1. top 50 products (passed as parameters in this event)

   2. and separately top 50 stores name of the store (passed as parameters in this event)

2. Based on event - "tutorial_viewed", data is passed in parameters

   1. Users viewed the 1st slide

   2. Users viewed 2 slides

   3. Users viewed 3 slides

   4. …

   5. Users viewed 9 slides

   6. In each slide % of users from those who started viewing slides (onboarding) to those who closed onboarding

   7. Average number of slides viewed by users (arithmetic mean)

3. Based on event - "sign_ups" number of guest users

4. Based on event - "sign_ups" number of registered users.

   1. Total number of users

   2. Only those who registered via Google

   3. Only those who registered via email

   4. Only those who registered via Apple

5. Based on event - "location login"

   1. table with the 25 most common locations sorted from most common to least common (cities)

6. ?? Based on event - "location login district"

   1. for each of the 25 cities display the most common districts 10 pieces from most common to least common in a table

7. Based on event - "location login change district"

   1. for each of the 25 cities display the most common districts 10 pieces from most common to least common that changed (conditionally registered at home, and then changed location to near work)

8. Based on event - "radius changed"

   1. display in a table the most common radii top 10

9. Based on event - "filter selected"

   1. display in a table the most common categories top 10 filters

   2. % of all users to those who in the filter selected the red discount badge

10. Based on event - "shop clicked"

    1. top 25 stores that are clicked

11. Based on event - "shoplist add"

    1. % of the total number of users to those who added to the shop list

       1. Products

       2. Catalogs

       3. products - marked as completed

       4. catalogs - unmarked as completed

12. Based on event - "add to favourites"

    1. % of the total number of users to those who added to favorites

       1. Stores

       2. Products

13. Based on event - "catalog opened"

    1. % of the total number of users to those who interacted with the catalog

       1. catalog click event

       2. Tab_catalog_opened

14. Based on event - "catalog_shared"

    1. % of the total number of users to those who shared products catalogs or shop lists at least once

Advertising

Based on data in BigQuery, we expect a table

    https://docs.google.com/spreadsheets/d/1j-k7Ix8u0EPkuEUI_dA5Baj3JdsIw_7YZnq-Vhiwrws/edit?usp=sharing

Project Manager

Based on data from the server JIRA. Which is under VPN

1. List of tasks for the current release in a table

   1. There should also be a release date here

   2. Number of closed tasks

   3. Separate widget - number of bugs reported by testers in the release

   4. Separate widget - number of bugs fixed by the team in the release

2. List of tasks for the current sprint in a table

   1. List of tasks for the current sprint in a table

   2. Number of closed tasks

3. Total team time in a table logged in per day for all 7 days of the week and number of hours in the week a separate column (vacations need to be deducted) for special tasks in JIRA

4. Total planned (estimated in tasks) team time for each day of the week 7 days

5. Number of covered automated tests qa automator in the week

6. Filters

   1. Dropdown with filters

      1. Team: mobile, web, parsers

      2. time period (sprint number, release, week)