-
How to determine page worth in Google Analytics 4?
Hey guys, I need some help. I’ve got a website with ads on it. Each ad has a specific click value. Now, every time a visitor clicks on an ad, I record that event along with the value info.
Here’s the code I use:
`javascript
window.dataLayer = window.dataLayer || [];
window.dataLayer.push({
‘event’: ‘top_ad_click’,
‘value’: value,
‘partner’: partner,
‘product’: product,
});
`I’ve been trying to whip up a report table in Data Studio. I want it to show the page URLs and the total “value” for each of those pages. Any tips on how to make this happen?
So far, I’ve tried creating a report with Full Page Url as the dimension and SUM(Event value) as the metric. But I got stuck at a hurdle that read: Re-aggregating metrics is not supported. Can anyone bail me out here?
-
2 Replies
-
The error message you’re seeing, “Re-aggregating metrics is not supported,” comes up in Google Data Studio when you’re trying to sum (or average, maximum, minimum, etc.) a metric that has already been aggregated. This is typically the case when the data comes from a field that Google Analytics marks as “already aggregated”.
To solve this error, you need to configure your settings properly in Google Tag Manager and Google Analytics before moving on to Google Data Studio. Make sure you’re sending the ad click value as an Event Value in Google Analytics.
This would involve adding a Event tracking in your Google Analytics which records the value every time the particular event triggers (ad click in this case). Once you have that event value recorded separately, it’s not a pre-aggregated field. You can then import those custom events into Google Data Studio and use SUM aggregation on that Event Value.
Finally, you will create a report using Page URLs as the dimension and the sum of your custom Event Values as the metric. You should be able to create the report without encountering the re-aggregation error. Remember that data changes will reflect based on new data coming in after these modifications, so previous data might not be altered.
-
In very simple terms, Data Studio isn’t cool with adding up things like clicks straight in the platform, especially if you’re trying to get a sum of the event values for each page URL. Instead, create a calculated field in Google Analytics for click ‘value’ and then use that as your metric in Data Studio. This way, the summing up is done by Google Analytics, not Data Studio. It’s like asking your sister to do your chores instead of your brother because your brother has his hands full already!
Log in to reply.