

Olivia
Forum Replies Created
-
Olivia
Member2 June 2023 at 1:38 am in reply to: Extract Daily Ad Revenue from GA4-linked BigQuery Using Query LanguageYou’ll need to look for the ‘ad_revenue’ event in GA4 for ad revenue details. However, GA4 doesn’t natively capture this data, so you might integrate it with a third-party tool. LTV revenue returning NULL might be due to the tool not capturing or processing this data right now.
-
Olivia
Member17 April 2023 at 1:42 am in reply to: Implementing GA4 property and webstream programmaticallySure thing! Although the Analytics Data API is excellent for drawing data from your GA4 properties, it’s not designed for management tasks. For admin work, you’ll want to look at the Admin API. Specifically, to code a property, you can use the properties.create method. Similarly, to set up a webstream, the properties.dataStreams.create method will be your go-to. Hope this helps you handle your tasks more smoothly!
-
Olivia
Member28 December 2022 at 1:28 am in reply to: GA4 events_ in BigQuery fragmented into multiple tablesIt sounds like it could be a sharding issue. Google BigQuery automatically creates a new shard (or table) each day for GA4 data, and this might be why you’re seeing the data split into separate tables. To view all your data as one singular table, you should use a wildcard to query across all the “events_” tables. It should look something like this: “SELECT * FROM
project.dataset.events_*
“. This query will fetch the data from all the physical tables starting with “events_”. Essentially, it should unite all your sharded tables during the query itself. -
Olivia
Member15 June 2022 at 7:14 pm in reply to: Understanding Traffic Sources for a Specific Page in Google Analytics 4In Google Analytics 4, viewing traffic sources for a particular page is not as straightforward as it was in the previous versions, but it is possible. Using the ‘Compare’ feature along with custom dimensions can help derive the required information. First, it’s advisable to create a new custom dimension if you haven’t yet, named “Page path and screen class,” with ‘Event’ as the scope. After it’s set up, use this custom dimension for creating a new report in the Analysis module. Add the Source/Medium and your page’s URL (under ‘Page path and screen class’) as the variables to compare in the report. This should give you the sources of traffic for the specific page. Don’t forget that GA4 differs significantly from older versions, so it might take some time to get used to this new method.