Reader feedback #19
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Reader feedback | |
| # This workflow pulls reader feedback from PostHog | |
| # and opens a GitHub issue with the last week of feedback. | |
| # The issue will be labelled with `docs-feedback` | |
| on: | |
| workflow_dispatch: | |
| schedule: | |
| - cron: '0 18 * * SUN' # once a week on Sunday | |
| permissions: | |
| contents: read | |
| issues: write | |
| jobs: | |
| grab_feedback_from_posthog: | |
| name: Pull feedback using API | |
| runs-on: ubuntu-latest | |
| env: | |
| POSTHOG_TOKEN: ${{ secrets.POSTHOG_PERSONAL_API_KEY }} | |
| ALGOLIA_TOKEN: ${{ secrets.ALGOLIA_ANALYTICS_KEY }} | |
| steps: | |
| - name: Run PostHog script | |
| run: | | |
| set -eo pipefail # Ensure the script fails on any command error | |
| echo "## Feedback from readers" > feedback.md | |
| echo "Three sections: feedback, top working searches, and top failed searches." >> feedback.md | |
| echo "Please check off the feedback and failed searches as you fix them and" >> feedback.md | |
| echo "please add the `doc-feedback` label to your PRs related to this issue." >> feedback.md | |
| echo " " >> feedback.md | |
| echo "You do not need to edit this issue with PR numbers, as everything with" >> feedback.md | |
| echo "the label will show in the GitHub project." >> feedback.md | |
| echo " " >> feedback.md | |
| curl --silent --fail \ | |
| --header "Content-Type: application/json" \ | |
| --data '{ "query": { "kind": "HogQLQuery", "query": "SELECT now() - INTERVAL 7 DAY as start_time, timestamp, properties.page, properties.text, properties.sentiment from events WHERE properties.sentiment IS NOT NULL AND timestamp > start_time ORDER BY properties.sentiment ASC"}}' \ | |
| -H "Authorization: Bearer $POSTHOG_TOKEN" \ | |
| https://app.posthog.com/api/projects/48961/query \ | |
| | jq -r '.results | to_entries[] | "- [ ] \(.value[2])", " feedback: \(.value[3])", " Rating: \(.value[4])", " timestamp: \(.value[1])"' >> feedback.md | |
| - name: Run Algolia scripts | |
| run: | | |
| set -eo pipefail # Ensure the script fails on any command error | |
| echo " " >> feedback.md | |
| echo "## Algolia top searches" >> feedback.md | |
| echo " " >> feedback.md | |
| echo "Note: Searches with zero hits are searches that are very popular and also not returning any results. They will also appear in the failed search list." >> feedback.md | |
| echo " " >> feedback.md | |
| curl --silent --fail \ | |
| -X GET \ | |
| -H "X-Algolia-API-Key: $ALGOLIA_TOKEN" \ | |
| -H "X-Algolia-Application-Id: ER08SJMRY1" \ | |
| "https://analytics.algolia.com/2/searches?index=starrocks" \ | |
| | jq -r '.searches | to_entries[] | "- \(.value.search)", " count this week: \(.value.count)", " Search hits: \(.value.nbHits)\n" ' >> feedback.md | |
| echo " " >> feedback.md | |
| echo "## Algolia top failed searches" >> feedback.md | |
| echo " " >> feedback.md | |
| curl --silent --fail \ | |
| -X GET \ | |
| -H "X-Algolia-API-Key: $ALGOLIA_TOKEN" \ | |
| -H "X-Algolia-Application-Id: ER08SJMRY1" \ | |
| "https://analytics.algolia.com/2/searches/noResults?index=starrocks" \ | |
| | jq -r '.searches | to_entries[] | "- [ ] \(.value.search)", " failures this week: \(.value.count)"' \ | |
| >> feedback.md | |
| - name: Create issue from file | |
| id: weekly-feedback-report | |
| uses: peter-evans/create-issue-from-file@ceef9be92406ace67ab5421f66570acf213ec395 | |
| with: | |
| title: Weekly documentation feedback from readers | |
| content-filepath: ./feedback.md | |
| labels: doc-feedback |