Two Google tools for marketing reports: the Analytics Data API pulls GA4 numbers into your own scripts, and Looker Studio builds shareable report pages.
- Kind
- Tool
- Keeplight status
- Researched, not yet tested
- Cost
- As of 2026-11: Google says Looker Studio is free. API quotas were not confirmed.
- Connects to
- Google Analytics 4, Looker Studio, Google Cloud
- Official site
- developers.google.com/analytics/devguides/reporting/data/v1
What it does
The Google Analytics Data API gives code access to the same report data you see in Google Analytics. It returns reports, realtime reports, and metadata, and has client libraries for several languages.
Looker Studio is Google's report builder. Google's developer page says it is free, and anyone can build connectors for it with Apps Script.
Use them together when a team wants a report that updates itself. The API suits custom pulls into a sheet or script. Looker Studio suits a visual report for clients. Some features of the API are in preview and may change, so check each one before you rely on it.
Use cases
Pull weekly traffic into a sheet
A scheduled script calls the Data API's runReport method and writes sessions and conversions to a sheet that your team reads.
Show a live report to a client
Build a Looker Studio report with your numbers and share the link, so the client sees current results.
Check what is happening right now
The realtime report covers the last 30 minutes (60 for Google Analytics 360 properties), which is useful on launch day.
Connect a source Looker Studio lacks
A community connector built with Apps Script brings an outside data source into a Looker Studio report.
How to start
- Open Google Cloud, pick a project, and enable the Google Analytics Data API.
- Set up sign-in with Application Default Credentials: run gcloud auth application-default login with the cloud-platform and analytics.readonly scopes, as the quickstart shows.
- Give your Google account access to the GA4 property in Google Analytics (Google's quickstart names no role, so confirm what access is enough).
- Run a first runReport request with one dimension and one metric.
- Open lookerstudio.google.com, start a new report, and add your data source.
- Share the report link and check the numbers against Google Analytics.
Visit Google Analytics Data API and Looker Studio
Researched, not yet tested: Keeplight has read the docs but has not run it yet. Prices and features change, so check the official site before you buy.