Yodlee Monthly Performance Dashboard

Yodlee_GA4_Monthly_Performance_Report_-_WIP.pdf

Note: This is a interactive dashboard on Looker Studio that will change with controls like the data range.

BigQuery (SQL) Application

At the time of creating this dashboard, google had API limits on the GA4 connecter. Once the limit was reached data would stop displaying data. In order to reduce the usage of the API, we decided to create scorecards using BigQuery instead of the API connecter.

This was the first time I used SQL for a dashboard and how I started to see its practical application.

-- Query is used to add conversions to monthly performance dashboard

-- buiness_type, hostname, and geo.country is used for filtering purposes

SELECT

event_name,

(SELECT value.string_value FROM UNNEST(event_params) WHERE key="business_type") AS business_type,

device.web_info.hostname,

geo.country

From

`e-paratext-352821.analytics_304319127.events_*`

WHERE

(_TABLE_SUFFIX BETWEEN @DS_START_DATE AND @DS_END_DATE)

-- FROM and WHERE is used to uss data range within looker studio.