GSA
SPIKE: Determine the best way to get GA4 data onto a monthly-updated data.gov public dashboard
Purpose
We want to have a system to get data from our GA4 account into charts/viz on a public page, but we're not sure how to do that.
Given above uncertainty, conducting research/investigation is needed to provide factual knowledge on future steps.
2 weeks of effort has been allocated and once compete, findings will be demonstrated and specific future actions will be decided.
Acceptance Criteria
- [ ] GIVEN usage data exists in Datagov GA4
WHEN 2 weeks expires
THEN viable options for populating a public dashboard will be presented AND a path forward will be chosen AND issues will be written to start that implementation
Background
https://docs.google.com/document/d/1tNQW2sRzwvew8IR8nz38teno_f-n3Y0OCQwBIHMT3mo/edit
https://developers.google.com/analytics/devguides/reporting/data/v1
Goals:
- Monthly updates
- Automation
Sketch
@robert-bryson , can you please add progress/update or any blockers to the ticket? Let's try to project a completion date. Is the end of this week a fair target?
Sure.
I spoke with Tim on Friday. I had a blocker around accessing the GA4 Data API via a credentials.json. I have access to one now and have a script sketched out. Will spend time on this today, but I think the approach of a Github action in the 11ty repo pulling the data via a python script should work well. We can either build the resulting CSV/JSON files into the 11ty build or post to S3 or any other option.
I was able to pull data from the Data API yesterday. I have started on proofing out a Github action to run it as a report and will continue on this today. In the near future I need to start thinking about how to display the reports, which reports are needed, and how to wire it all together. The charting examples shown on the data.gov front page would be a good place to start. @btylerburton is there a time over the next couple of days we can meet and discuss?
sure thing @robert-bryson, feel free to find a time on my calendar or hit me up on slack.
We had a quick sync on how the datagov site pulls data and preps it for charts.
@robert-bryson is this a good point to outline the path forward, close this ticket, and create tickets for remaining work? I would like to get #4743 worked on so that I can try to finish #4783. Then when I am gone the next couple weeks after 6/18, you and @btylerburton can try to complete dashboard POC/MVP.