ERD for Google Analytics 4 | Weld

7 tables

Loading diagram…

campaign_performance

property_id

string

session_campaign_name

string

date

date

total_users

double

sessions

double

engaged_sessions

double

events_per_session

double

engagement_rate

double

event_count

double

conversions

double

total_revenue

double

user_engagement_duration

double

channel_traffic

property_id

string

session_default_channel_grouping

string

date

date

total_users

double

sessions

double

engaged_sessions

double

events_per_session

double

engagement_rate

double

event_count

double

conversions

double

total_revenue

double

user_engagement_duration

double

social_media_acquisitions

property_id

string

session_source_platform

string

date

date

total_users

double

sessions

double

engaged_sessions

double

events_per_session

double

engagement_rate

double

event_count

double

conversions

double

total_revenue

double

user_engagement_duration

double

audience_overview

property_id

string

date

date

total_users

double

new_users

double

sessions

double

sessions_per_user

double

screen_page_views

double

user_engagement_duration

double

events_overview

property_id

string

event_name

string

date

date

event_count

double

total_users

double

event_count_per_user

double

total_revenue

double

page_path

property_id

string

page_path

string

date

date

screen_page_views

double

total_users

double

new_users

double

event_count

double

conversions

double

total_revenue

double

user_engagement_duration

double

browser_and_operating_system_overview

property_id

string

operating_system

string

browser

string

date

date

total_users

double

new_users

double

engaged_sessions

double

engagement_rate

double

event_count

double

conversions

double

total_revenue

double

Table

Sub table