SPIKE: Determine the best way to get GA4 data onto a monthly-updated data.gov public dashboard

GSA / data.gov

Main repository for the data.gov service

https://data.gov

Other

546 stars 87 forks source link

SPIKE: Determine the best way to get GA4 data onto a monthly-updated data.gov public dashboard #4726

Open tdlowden opened 2 months ago

tdlowden commented 2 months ago

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

gujral-rei commented 1 month ago

@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?

robert-bryson commented 1 month ago

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.

robert-bryson commented 1 month ago

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?

btylerburton commented 1 month ago

sure thing @robert-bryson, feel free to find a time on my calendar or hit me up on slack.

tdlowden commented 4 weeks ago

Were you two able to sync up @btylerburton @robert-bryson ? Any updates?

btylerburton commented 4 weeks ago

We had a quick sync on how the datagov site pulls data and preps it for charts.

tdlowden commented 3 weeks ago

@robert-bryson can you give an update?

tdlowden commented 3 weeks ago

@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.