Skip to content

Reader feedback

Reader feedback #19

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