Epic: Org Dashboard
Overview
We need to manage the work for the Org dashboard, so that we can prioritize and recruit.
Action Items
- [x] Go the Org tab for Org dashboard and copy all of the links in the issue to a comment in the bottom of the issue and indicate whether they are public or private.
- [ ] Copy all of the link lists from the issues into a comment on this issue
- [ ] Remove duplicates
- [ ] ~Remove the public private status~
- [ ] Revise Org Dashboard Roadmap
Resources/Instructions
- HfLA Dashboards: Project Board
- HfLA website: Dashboard Roadmap: Org Dashboard
- HfLA website: HfLA Dashboard Development Roadmap
- All Dashboards Epic: https://github.com/hackforla/website/issues/6614
Hi @Eleftherios01.
Please don't forget to add the proper labels to this issue. Currently, the labels for the following are missing:
- Complexity, Role, Feature, Size
NOTE: Please ignore this comment if you do not have 'write' access to this directory.
To add a label, take a look at Github's documentation here.
Also, don't forget to remove the "missing labels" afterwards. To remove a label, the process is similar to adding a label, but you select a currently added label to remove it.
After the proper labels are added, the merge team will review the issue and add a "Ready for Prioritization" label once it is ready for prioritization.
Additional Resources:
Issues related to Org Dashboard
- [x] https://github.com/hackforla/website/issues/6229
- [x] https://github.com/hackforla/website/issues/4537
- [ ] https://github.com/hackforla/website/issues/4276
- [ ] https://github.com/hackforla/website/issues/542
- [ ] https://github.com/hackforla/website/issues/503
- [ ] https://github.com/hackforla/team-analytics/issues/2
- [ ] https://github.com/hackforla/team-analytics/issues/1
- [ ] https://github.com/hackforla/team-analytics/issues/3
- [ ] https://github.com/hackforla/website/issues/128
These links have been processed into the comment below
- https://github.com/hackforla/live-dashboard-automation/actions/workflows/schedule_run_to_update_data.yaml
- [ ] Have access, its located in ____
- [x] public
-
Live Project Board Issues Dashboard (Current)
- [ ] Have access, its located in ____
- [x] public
- https://github.com/hackforla/live-dashboard-automation/blob/main/.github/workflows/schedule_run_to_update_data.yaml#L56-L58
- [ ] Have access, its located in ____
- [x] public
-
Repo: live-dashboard-automation, tab: Actions
- [ ] Have access, its located in ____
- [x] public
-
HfLA-Website: Task List Dev leads
- [ ] Have access, its located in ____
- [x] public
- https://www.hackforla.org/dashboard/
- [ ] Have access, its located in ____
- [x] public
-
Tutorial: Create a Google Analytics data source
- [ ] Have access, its located in ____
- [x] public
- https://github.com/hackforla/website/issues/2776
- [ ] Have access, its located in ____
- [x] public
-
Hack for LA new volunteer survey - Form
- [ ] Have access, its located in ____
- [x] public
-
Survey Data Workbook
- [x] Need access, its located in ____
- [ ] public
-
Survey Data Workbook tab
- [x] Need access, its located in ____
- [ ] public
-
B: Hack for LA Self Onboarding
- [ ] Have access, its located in ____
- [x] public
- https://github.com/hackforla/website/issues/2212
- [ ] Have access, its located in ____
- [x] public
-
Figma page with layout for Dashboard pages iframe
- [ ] Have access, its located in ____
- [x] public
-
Removing vertical scrollbar in iframe
- [ ] Have access, its located in ____
- [x] public
- Looker Studio Help: Save or publish your chart
- [ ] Have access, its located in ____
- [x] public
- Google Docs Help: Save or publish your chart
- [ ] Have access, its located in ____
- [x] public
-
Survey Data Workbook
- [x] Have access, its located in ALL Hack for LA projects > hackforla.org website > surveys > data workbook
- [x] public
-
Copy of Survey Data Workbook
- [ ] Have access, - it's located in HfLA: Dashboards > HfLA: Dashboards > Org
- [x] public
- https://github.com/hackforla/website/issues/128
- [ ] Have access, its located in ____
- [x] public
-
Exclude internal traffic
- [ ] Have access, its located in ____
- [x] public
-
[GA4] Set up Analytics for a website and/or app
- [ ] Have access, its located in ____
- [x] public
-
[UA] Set up the Analytics Google tag [Legacy]
- [ ] Have access, its located in ____
- [x] public
- https://matomo.org/
- [ ] Have access, its located in ____
- [x] public
- https://github.com/matomo-org/matomo/issues/13016
- [ ] Have access, its located in ____
- [x] public
- https://matomo.org/get-matomo/
- [ ] Have access, its located in ____
- [x] public
- https://analytics.google.com/analytics/web/#/report/trafficsources-overview/a167506267w233696729p219257270/
- [ ] Have access, its located in ____
- [x] public
- https://analytics.google.com/analytics/web/#/report/conversions-goals-overview/a167506267w233696729p219257270/
- [ ] Have access, its located in ____
- [x] public
-
Campaign URL Builder
- [ ] Have access, its located in ____
- [x] public
-
Digital Marketing Overview
- [ ] Have access, its located in ____
- [x] public
-
[UA] Create and manage view filters [Legacy]
- [ ] Have access, its located in ____
- [x] public
-
Google Analytics and Mixpanel Modeling Analysis #35
- [ ] Have access, its located in ____
- [x] public
- https://matplotlib.org/stable/tutorials/introductory/pyplot.html
- [ ] Have access, its located in ____
- [x] public
- https://matplotlib.org/
- [ ] Have access, its located in ____
- [x] public
- https://pandas.pydata.org/docs/
- [ ] Have access, its located in ____
- [x] public
- https://numpy.org/doc/
- [ ] Have access, its located in ____
- [x] public
-
Events that trigger workflows
- [ ] Have access, its located in ____
- [x] public
-
Workflow syntax for GitHub Actions
- [ ] Have access, its located in ____
- [x] public
-
github-script
- [ ] Have access, its located in ____
- [x] public
-
GitHub REST API documentation
- [ ] Have access, its located in ____
- [x] public
-
GitHub GraphQL API documentation
- [ ] Have access, its located in ____
- [x] public
-
Building and testing Python
- [ ] Have access, its located in ____
- [x] public
-
setup-python
- [ ] Have access, its located in ____
- [x] public
-
Data Analysis Issue
- [ ] Have access, its located in ____
- [x] public
-
Data Analysis PR
- [ ] Have access, its located in ____
- [x] public
- https://github.com/Aveline-art/team-analytics/blob/prototype/Data%20Analysis.ipynb
- [ ] Have access, its located in ____
- [x] public
- [ ] Have access, its located in ____
- [x] public
- https://github.com/hackforla/website/issues/542
- [ ] Have access, its located in ____
- [x] public
- https://github.com/hackforla/website/issues/503
- [ ] Have access, its located in ____
- [x] public
- https://github.com/hackforla/website/issues/432
- [ ] Have access, its located in ____
- [x] public
-
Hack for LA Website Redesign
- [ ] Have access, its located in ____
- [x] public
-
Page Insights User Guide
- [ ] Have access, its located in ____
- [x] public
-
Rage Clicks, Error Clicks, Dead Clicks, and Thrashed Cursor | Frustration Signals
- [ ] Have access, its located in ____
- [x] public
-
Frustrated Sessions
- [ ] Have access, its located in ____
- [x] public
- https://hackforla.org/gender-equity
- [x] Have access, its located in ____
- [ ] public
V1
- https://www.hackforla.org/dashboard/
- Iframe views (for some reason, they go to different pages. Decide which page they should go to and open issue on website team to fix links)
- Web view: https://datastudio.google.com/embed/reporting/16J9XI19pQejSDNFvjl_V3ZezJ502rM_a/page/qx6RB
- Mobile view: https://datastudio.google.com/embed/reporting/1xNlu1xcL5y6jh95lX3xr0zb2FCqD92Gm/page/gIfSB
Data
- During onboarding we ask them to fill out a form in B: Hack for LA Self Onboarding Slide Deck
- Survey Data Workbook- it's located in ALL Hack for LA projects > hackforla.org website > surveys > data workbook
- Copy of Survey Data Workbook- it's located in HfLA: Dashboards > HfLA: Dashboards > Org
- Remote Onboarding
- New Member
- View Form
- [Edit Form]
- Edit Form, Responses tab
- [Survey Data Workbook tab]
- Project Leader
- [View Form]
- [Edit Form]
- Edit Form, Responses tab
- [Survey Data Workbook tab]
- Donor/Sponsor
- [View Form]
- [Edit Form]
- Edit Form, Responses tab
- [Survey Data Workbook tab]
- Government
- [View Form]
- [Edit Form]
- Edit Form, Responses tab
- [Survey Data Workbook tab]
- Non-Profit
- [View Form]
- [Edit Form]
- Edit Form, Responses tab
- [Survey Data Workbook tab]
- Transportation & Parking
- [View Form]
- [Edit Form]
- Edit Form, Responses tab
- [Survey Data Workbook tab]
- Other
- [View Form]
- [Edit Form]
- Edit Form, Responses tab
- [Survey Data Workbook tab]
Hack for LA GitHub Actions that support Dashboard
- Repo: live-dashboard-automation, tab: Actions
- schedule_run_to_update_data.yaml] confirm that these workflows are part of the org dashboard and are not used in the issues dashboard, or are they used in both
- Repo: live-dashboard-automation, tab: code /.github/workflows/schedule_run_to_update_data.yaml
- Repo: live-dashboard-automation, tab: code /.github/workflows/schedule_run_to_update_data.yam#L56-L58
Code
- Repo: team-analytics
- Repo: https://github.com/Aveline-art/team-analytics/ - Files from another repo that is related but not owned by HfLA, instead it is owned by Ava Li, a former volunteer at HfLA and the code created there was for this project
- code file: Data Analysis Issue
- code file: Data Analysis PR
Other links
- Figma page with layout for Dashboard pages iframe
- Hack for LA Website Redesign - this is a document of how we used initial data from the org dashboard to make data driven decision on change to the website.
Tutorials, Help files and Community Discussion boards
- Looker Studio Help: Tutorial: Create a Google Analytics data source
- Looker Studio Help: Save or publish your chart
- sitepoint Community Discussion: Removing vertical scrollbar in iframe
- Matplotlib: Pyplot tutorial
- pandas: pandas documentation
- NumPy: NumPy Documentation
- GitHub Docs: Events that trigger workflows
- Google Docs Help: Save or publish your chart
- GitHub Docs: Workflow syntax for GitHub Actions
- GitHub Docs: GitHub REST API documentation
- GitHub Docs: GitHub REST API documentation Version=2022-11-28
- GitHub Docs: GitHub GraphQL API documentation
- GitHub Docs: Building and testing Python
- GitHub Actions marketplace:
- github-script - This action makes it easy to quickly write a script in your workflow that uses the GitHub API and the workflow run context.
-
setup-python - This action provides the following functionality for GitHub Actions users:
- Installing a version of Python or PyPy and (by default) adding it to the PATH
- Optionally caching dependencies for pip, pipenv and poetry
- Registering problem matchers for error output
- FullStory help: Page Insights User Guide
- FullStory help: Rage Clicks, Error Clicks, Dead Clicks, and Thrashed Cursor | Frustration Signals
- FullStory help: Frustrated Sessions
Google Analytics Login, Tutorials and objectives
- Hack for LA website WIKI: Digital Marketing Overview
- Google Analytics Too: Campaign URL Builder
- Log in with [email protected] to see
- Google Analytics - GA 4
- Google Analytics - Universal Analytics (deprecated)
- Alternative to GA: https://matomo.org/
- Question about GDPR: https://github.com/matomo-org/matomo/issues/13016
@Eleftherios01
- [x] Review this issue https://github.com/hackforla/website/issues/128 adding a list of links at the bottom
- [x] Review the list against the comment directly above with the organized links to see if there are any links we didn't already capture
@Eleftherios01 find the issue that these links are from
Link: https://github.com/hackforla/team-analytics/issues/3
-
Data Analysis Issue
- [ ] Have access, its located in ____
- [x] public
-
Data Analysis PR
- [ ] Have access, its located in ____
- [x] public
- https://github.com/Aveline-art/team-analytics/blob/prototype/Data%20Analysis.ipynb
- [ ] Have access, its located in ____
- [x] public
- Progress: i reviewed https://github.com/hackforla/website/issues/128 and added all links of the issue at the bottom. These should be added in the organized link list. I additionaly reviewed the link list and checked if there were any links not captured in the organised list.
- Blockers: none
- Availability:
- ETA:
- Pictures or links* (if necessary):
- remember to add links to the top of the issue if they are going to be needed again.
We have updated the list of all links from all issues and added it above. We are now ready to work on the roadmap.
- [x] Create a new issue for requirements https://github.com/hackforla/website/issues/7725
This is the spreadsheet you will use Dashboard - Org - Competitive or Comparative Analysis Template
-
this issue as an example https://github.com/hackforla/website/issues/7640
-
[x] work on the issue you create
- Progress: I created it this issue and inserted all relevant info based on the https://github.com/hackforla/website/issues/7640. i filled theDashboard - Org - Competitive or Comparative Analysis Template with as many features/functions I could extract from the Org roadmap. The roadmap need to be reviewed by Bonnie as highlighted areas may be need editing or reajustment
-
- Availability: Blockers: none
-
- ETA: Availability:
-
- Pictures ETA: or links* (if necessary):
- Pictures or links* (if necessary):
- [ ] Fix all the form links in the top part
- [x] do GA4 tutorials
We created a new page in the Hack for LA Data Science repo wiki, called Dashboard Resources - this page has all the tutorial links from each of the issues
1.Progress: I have completed GA4 tutorials 2.Availability: Blockers: none 3.ETA: Availability: 4.Pictures ETA: or links* (if necessary): 5.Pictures or links* (if necessary):
For the next time, work in the dashboard:
- [x] add the correct urls for each v1 page
- [x] add the chart type of each chart name
- [x] add values
1.Progress: I added in the dashboard the correct urls for each v1 page, the chart type of each chart name, values. 2.Availability: Blockers: none 3.ETA: Availability: 4.Pictures ETA: or links* (if necessary): 5.Pictures or links* (if necessary):
1.Progress: Fixed most of the form links in the top part 2.Availability: Blockers: i need access to certain drive folders in order to paste the edit form links here. Additionally, i should copy paste Survey Data Workbook tab links. I can find the Copy of Survey Data Workbook in the drive folder and not the original. is there an original? to confirm 3.ETA: Availability: 4.Pictures ETA: or links* (if necessary): 5.Pictures or links* (if necessary):
2025-02-16 Emailed the owner of the Project Leader form to make an appointment with me to move it and all the other assets he owns in the shared with me Survey folder to the Dashboard Folder>Org>Survey folder
Rabia and I will make a spreadsheet to aid in the moving of files.
Here is the repo with all the details about moving files https://github.com/hackforla/google-drive-migration
2025-02-16 Emailed the owner of the Project Leader form to make an appointment with me to move it and all the other assets he owns in the shared with me Survey folder to the Dashboard Folder>Org>Survey folder
Rabia and I will make a spreadsheet to aid in the moving of files.
Here is the repo with all the details about moving files https://github.com/hackforla/google-drive-migration
@ExperimentsInHonesty
While searching the drive migration repo, I found the following assets for the website drive migration. Do we still need to create a new spreadsheet?
- https://github.com/hackforla/google-drive-migration/issues/15
- HfLA website: drive migration spreadsheet
email to Harish
- Thank you for moving the remaining files
- Still need help with
- Moving Shyam's files
- Deleting these empty folders
@Rabia2219 Please list the other people (who own the surveys or the responses sheet) who we need their files moved, for this project.
We still have surveys to move, have emailed all the file owners, waiting for them to book. If they haven't booked an appointment on Monday 2025-03-10, Rabia and Bonnie to email them again.
If another week goes by without them making an appointment with me. Then copy the files, and repoint the spreadsheets.
@Rabia2219 Please list the other people (who own the surveys or the responses sheet) who we need their files moved, for this project.
@ExperimentsInHonesty Here's the list of people that need their files moved (already sent email)
- Ahdithan Uthayakumar (done as of 2025-04-11)
- Andrew Ma (done as of 2025-05-01)
- Jacqueline Riley
- Shawn Duenas
@Eleftherios01 I fixed all the sheets except for the following, because I don't want to break anything in the existing dashboard.
- Remote Onboarding
- New Member
We need to review the dashboard to figure out which sheet each is linking to. I am working on figuring that out now.
- [ ] On This sheet Survey Data Workbook, Google Form Links Tab we have a column for which sheet is the dashboard using as its input (column H). We need to figure out which spreadsheet is being used by the dashboard and if some are not being used at all.
The org data pipeline has been fixed. See https://github.com/hackforla/data-science/issues/224#issuecomment-3197987091