Iterations for Data source for health and funnel metric - Githubissues

DostEducation / RP_IVR_analytics

This is a cloud function based webhook processing service that is being using to get webhook calls from RapidPro to capture different analytical data point.

GNU Affero General Public License v3.0

4 stars 1 forks source link

Iterations for Data source for health and funnel metric #114

Closed Satendra-SR closed 3 years ago

Satendra-SR commented 3 years ago

Is your feature request related to a problem? Please describe. As moving forward, we need to make changes in charts and data sources.

Describe the solution you'd like

[x] Create new data sources if required.
[x] Update existing data sources as required.
[x] Create new stories if required

Describe alternatives you've considered None

Additional context None

Satendra-SR commented 3 years ago

This remained unused, we can take it forward to the next sprint.

rudresh commented 3 years ago

Renamed the column user_phone to user_phone_number in user_experience data source. This change now allows data studio to apply the filter on all charts as the column name is now consistent across all data sources.

rudresh commented 3 years ago

There are few data discrepancies in the funnel metrics. The details are captured here

rudresh commented 3 years ago

@prtkdost capturing the debugging session feedback:

[x] Update the data sources to include both content and non-content calls
[x] is_content should be true for the content calls
[x] For non-content call the value of the following should be null
- [x] corrected_listen_seconds,
- [x] total_content_duration,
- [x] average_listen_rate,
- [x] engagement_level,
- [x] is_user_active
[x] There are few remaining discrepancies with is_call_delivered. Example: 9598002712 on 22-Jun

prtkdost commented 3 years ago

Cool. Also change the formula for is_user_active from > to >=20.

rudresh commented 3 years ago

[x] total_unique_content_delivered should only calculate where flow_category is content otherwise show null.
[x] average_listen_rate should come null but coming as 0. Possibly, the check for flow_category content is missing
[x] engagement_level should show null where flow_category is not content

rudresh commented 3 years ago

Fix errors with the engagement monthly data sources

[x] total_unique_content_delivered and other related fields
[x] corrected_listen_seconds and other related fields
[x] Add the following fields in all the 8 engagement data source

program_name
preferred_time_slot
signup_status
partner_name
district
parent_type

rudresh commented 3 years ago

[x] add a new column is_current_week, is_current_month in the useragewise data sources.

Satendra-SR commented 3 years ago

Split into stories based on the new requirements.

rudresh commented 3 years ago

Update the engagement data sources to include

[x] total_prompt_delivered - count the total number of content having prompts. Include if the content was delivered multiple times.
[x] total_prompt_responded - count if a single prompt was answered that day. If there are more than one prompt responded in a day, count it as one.

Satendra-SR commented 3 years ago

[x] Check if there are nullable content ids in the prompt and prompt response table. If they are after 1 June, we need to fix that.

Satendra-SR commented 3 years ago

Closing this as validated with @prtkdost