README.md

Looker Studio Blends

This section contains information about Blends used in Looker Studio. In total there are 4 blends.

GA4 Event Name & Image Blend

What	Table 1	Join	Table 2
Table	ga4_documentation_events_and_images		ga4_documentation_events_and_documentation_status
Join	event_name	Inner Join	event_name
Table Name	GA4 Image Table		GA4 Event Table
Dimensions	event_name Event Image [Calc]		event_name

GA4 Event & Parameter Blend

What	Table 1	Join	Table 2
Table	ga4_documentation_events_and_documentation_status		ga4_documentation_parameters_and_documentation_status
Join	event_name	Left Outer Join	event_name
Table Name	GA4 Events Table		GA4 Parameters Table
Dimensions	event_name event_group event_description Event Last Seen Days [Calc] Event Name Search [Calc] Event Description Search [Calc] Event Name URL [Calc] platform_web_checkmark [Calc] platform_ios_checkmark [Calc] platform_android_checkmark [Calc]		event_name parameter_name Parameter Name Search [Calc]
Metrics	event_count_total Total Events [Calc]

GA4 Event Name and Daily Event Count Blend

What	Table 1	Join	Table 2
Table	ga4_documentation_events_daily_counts		ga4_documentation_events_and_documentation_status
Join	event_name	Inner Join	event_name
Table Name	GA4 Event Daily Count Table		GA4 Event Documentation Table
Dimensions	event_name event_count_android event_count_ios event_count_total event_count_web event_date		event_name platform_android platform_ios platform_web

GA4 Parameter & Parameter Daily Count Blend

What	Table 1	Join	Table 2	Join	Table 3
Table	ga4_documentation_parameters_daily_count		ga4_documentation_parameters_and_documentation_status		ga4_documentation_anomaly_detection
Join	event_name parameter_name parameter_scope	Inner Join	event_name parameter_name parameter_scope	Left Outer Join	event_date parameter_name parameter_scope
Table Name	GA4 Parameter Daily Count		GA4 Parameter Documentation		GA4 Anomaly Detection
Dimensions	event_date parameter_name parameter_scope parameter_count_web parameter_count_ios parameter_count_android parameter_count_total event_name		parameter_name parameter_scope platform_web platform_android platform_ios event_name		parameter_scope event_name event_date event_or_parameter_name anomaly_description platform event_or_parameter_type
Metrics	Parameter Count				net_change_percentage expected_count actual_count upper_bound lower_bound