Google Analytics 4

Sample

 

https://connectors.windsor.ai/googleanalytics4?api_key=[your API key]&date_preset=last_7d&fields=source,medium,campaign,transactionrevenue&_renderer=csv


Fields

IDTypeNameDescription
account_idTEXTAccount IDThe Account ID
account_nameTEXTAccount NameThe Account Name
averagesessiondurationNUMERICAverage session durationThe average duration (in seconds) of users' sessions.
campaignTEXTCampaign (alias for Campaign name)The name of the marketing campaign. Present only for conversion events.
campaign_nameTEXTCampaign nameThe name of the marketing campaign. Present only for conversion events.
cityTEXTCityThe city from which the user activity originated.
conversionsNUMERICConversionsThe count of conversion events.
countryTEXTCountryThe country from which the user activity originated.
dateDATEDateThe date of the event, formatted as YYYYMMDD.
defaultchannelgroupingTEXTDefault channel groupingThe conversion's default channel grouping is based primarily on source and medium. An enumeration which includes 'Direct', 'Organic Search', 'Paid Social', 'Organic Social', 'Email', 'Affiliates', 'Referral', 'Paid Search', 'Video', and 'Display'.
devicecategoryTEXTDevice categoryThe type of device: Desktop, Tablet, or Mobile.
eventnameTEXTEvent nameThe name of the event.
firstusersourcemediumTEXTFirst user source / mediumThe combined values of the dimensions 'firstUserSource'and 'firstUserMedium'
fullpageurlTEXTFull page URLThe hostname, page path, and query string for web pages visited; for example, the fullPageUrl portion of https://www.example.com/store/contact-us?query_string=true is www.example.com/store/contact-us?query_string=true.
mediumTEXTMediumThe medium attributed to the conversion event.
newusersNUMERICNew usersThe number of users who interacted with your site or launched yourapp for the first time (event triggered: first_open or first_visit)
pagetitleTEXTPage titleThe web page titles used on your site.
sessioncampaignnameTEXTSession Campaign NameThe marketing campaign name for a session.Includes Manual Campaigns and Campaigns from integrationlinkages like Google Ads and Search Ads 360.
sessionsNUMERICSessionsThe number of sessions that began on your site or app (event triggered: session_start).
sourceTEXTSourceThe source attributed to the conversion event.
totalrevenueNUMERICTotal revenueThe sum of revenue from purchases, subscriptions, and advertising (Purchase revenue plus Subscription revenue plus Ad revenue).
totalusersNUMERICTotal usersThe number of distinct users who have logged at least one event, regardless of whether the site or app was in use when that event was logged.
transactionidTEXTTransaction IDThe ID of the ecommerce transaction.
transactionrevenueNUMERICTransaction revenue (alias for Total revenue)The sum of revenue from purchases, subscriptions, and advertising (Purchase revenue plus Subscription revenue plus Ad revenue).
transactionsNUMERICTransactionsThe count of transaction events with purchase revenue. Transaction events are in_app_purchase, ecommerce_purchase, purchase, app_store_subscription_renew, app_store_subscription_convert, and refund.
userengagementdurationNUMERICUser engagementThe total amount of time (in seconds) your website or app was in the foreground of users' devices.