Page MenuHomePhabricator
Create Task
Maniphest T374479

Campaigns-Product's Superset Dashboard
Closed, DeclinedPublic
Actions

Description

Help the campaigns team move key metrics from GSheets (Campaign Metrics GSheets) to Airflow and setup a Superset dashboard featuring those metrics.

List of metrics

MetricVisualization typeUpdate frequencyTable
Distinct new events in periodLine graphDailyactivity
Distinct registrations (participants registered) in periodLine graphDailyactivity
Distinct organizers in periodLine graphmonthlypeople
Distinct participants in periodLine graphmonthlypeople
Number of new-account-participants in periodLine graphDailyactivity



Filters 



    

  • Time range
    • 




References

Slide deck presentation

WIP Planning Notes Document

Analytics/Systems/Superset

Superset
Related Objects
Search...
Event Timeline
Iflorez created this task.Sep 10 2024, 6:24 PM
Restricted Application added a subscriber: Aklapper.  ·  View Herald TranscriptSep 10 2024, 6:24 PM
Iflorez added a subtask: T365404: Create a plan for moving campaigns-product metrics data to airflow.Sep 10 2024, 6:24 PM
Iflorez updated the task description. (Show Details)
Iflorez renamed this task from Campaigns' Event Registration Superset Dashboard to Campaigns-Product's Superset Dashboard.Sep 10 2024, 6:27 PM
Iflorez claimed this task.
Iflorez triaged this task as Medium priority.
Iflorez added projects: Connection-Team, User-Iflorez, Product-Analytics (Kanban).
Iflorez moved this task from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Iflorez updated the task description. (Show Details)Sep 10 2024, 6:30 PM
Iflorez updated the task description. (Show Details)Sep 10 2024, 6:54 PM
Iflorez added a subtask: T374491: Create ETL pipelines for campaigns-product baseline metrics.Sep 10 2024, 7:25 PM
Iflorez moved this task from Backlog to Paused_campaigns on the User-Iflorez board.Sep 10 2024, 7:31 PM
Iflorez updated the task description. (Show Details)Sep 10 2024, 10:36 PM
Iflorez updated the task description. (Show Details)Sep 11 2024, 5:42 PM
Iflorez updated the task description. (Show Details)Sep 17 2024, 9:18 PM
ifried subscribed.Sep 18 2024, 3:50 PM
Iflorez updated the task description. (Show Details)Sep 18 2024, 4:35 PM
Daimona moved this task from Backlog to Following on the Connection-Team board.Oct 2 2024, 4:21 PM
Iflorez added a comment.Oct 11 2024, 5:55 PM
This work is paused in Q2 with an aim to reopen in Q3. 

In the meantime, I will be outputting the following metrics on a monthly basis to these campaigns metrics sheets:



    

  • Number of distinct new events created in month
    • 

  • Number of distinct participants registered in month
    • 

  • Number distinct participants registered in period who created an account in the last 30 days
    • 

  • Number of distinct organizers organizing events created in month
    • 

  • Number of distinct organizers who use Invitation Lists in month
    • 

  • Number of Invitation Lists generated in month, by wiki.
    • 

kzimmerman closed this task as Declined.Apr 11 2025, 12:58 AM
kzimmerman subscribed.
@ifried After digging into the workload and requirements for this, I am declining this request. I would like to connect with you on how we can work with Campaigns in the future to set up data tracking/workflows that make it more feasible to set up dashboards.



For the time being, Irene will continue to provide the monthly updates.



Some notes:



    

  • In the past year, we have learned that it can take months for Product Analytics team members to set up data pipelines.
    • 

  • The data pipelines we set up have become a recurring maintenance burden, with some pipelines breaking due to upstream changes.
    • 

  • Irene noted that the overhead for outputting the metrics on a monthly basis has been pretty low.
    • 

kzimmerman closed subtask T365404: Create a plan for moving campaigns-product metrics data to airflow as Declined.Apr 11 2025, 12:59 AM
kzimmerman mentioned this in T365404: Create a plan for moving campaigns-product metrics data to airflow.
kzimmerman closed subtask T374491: Create ETL pipelines for campaigns-product baseline metrics as Declined.
kzimmerman mentioned this in T374491: Create ETL pipelines for campaigns-product baseline metrics.
kzimmerman mentioned this in T374500: ETL pipeline for campaigns-product key metrics: Destination tables schemas.
ifried added a comment.Apr 18 2025, 6:24 PM
@kzimmerman, apologies for the late reply - I am catching up on emails after the Core Experiences offsite! Thank you for this update. I understand why this work was declined, but I look forward to seeing what/if could be possible in the future, so we can more quick & regular data insights. For the time being, we'll continue to use Irene's monthly reports. Thanks!
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits