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

[tdlowden]

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]

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

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]

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]

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

[tdlowden]

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

[btylerburton]

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

[tdlowden]

@robert-bryson can you give an update?

[tdlowden]

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