{"id":6558,"date":"2024-04-07T18:13:23","date_gmt":"2024-04-07T16:13:23","guid":{"rendered":"https:\/\/chartud.io\/blog\/how-to-add-the-percentage-of-the-total-in-looker-studio-and-google-analytics-4\/"},"modified":"2025-09-16T16:52:00","modified_gmt":"2025-09-16T14:52:00","slug":"share-percentage","status":"publish","type":"post","link":"https:\/\/chartud.io\/en\/blog\/share-percentage\/","title":{"rendered":"How to Add the Percentage of the Total in Looker Studio and Google Analytics 4?"},"content":{"rendered":"\n

It is one of those things that are<\/strong> missed in Google Analytics 4<\/strong> compared to Universal Analytics, and it is not understood how it is not currently available.<\/p>\n\n\n\n

This is the percentage that a value represents within the total when we talk about specific metrics.<\/p>\n\n\n\n

For example: if you are analyzing Sessions by Acquisition Channels, and you know that you have 15400 sessions from Organic Search… <\/p>\n\n\n\n

What percentage of the total Sessions does that channel account for?<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

We automatically had this in Universal Analytics, but we don’t have it in Google Analytics 4.<\/p>\n\n\n\n

There are two ways to make it visible again<\/strong> so that the analyses you do in your Google Analytics 4 reports<\/a> are more convenient.<\/p>\n\n\n\n

\ud83d\udc49Check out our selection of Looker Studio templates<\/strong><\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n

1. Vitaminizing your Tables in Looker Studio<\/h2>\n\n\n\n

This is something you can do in Looker Studio with any data source, not just Google Analytics 4.<\/p>\n\n\n\n

In Chartud<\/strong> we also use it a lot in Google Ads templates<\/a> or in SEO dashboards<\/a>.<\/p>\n\n\n\n

For example, to know the percentage of the total that a specific URL represents in terms of Search Console Clicks, or the same but in the case of a Google Ads campaign or ad group.<\/p>\n\n\n\n

It is about creating a new column<\/strong> in a Looker Studio table-type chart where you can see the share that metric has.<\/p>\n\n\n\n

\"\"
Table with the % of total sessions represented, in this case by Channel Group.<\/figcaption><\/figure>\n\n\n\n
<\/div>\n\n\n\n

To achieve this you must do the following:<\/strong><\/p>\n\n\n\n

1- Add the same metric right after the metric you want to get the percentage of the total from. That is, put the same metric twice.<\/strong> <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

2- Edit the second metric<\/strong>. Click on the pencil icon and change \u201cData type\u201d to Percentage<\/strong>: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Now in \u201cComparison calculation\u201d choose Percentage of total<\/strong>> Relative to the corresponding data<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Now you will have the metric showing the percentage of the total:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

As you can see it’s simple<\/strong> and you can apply it in a few clicks.<\/p>\n\n\n\n

Think about how it can help you beyond this example and try to apply it.<\/p>\n\n\n\n

<\/div>\n\n\n\n

With a Chrome Extension that Adds it in GA4<\/h2>\n\n\n\n

If in addition to having it in Looker Studio you want to have it in Google Analytics 4 I have good news. <\/p>\n\n\n\n

There is a Google Chrome extension that adds the percentage directly in the GA4 tables.<\/strong><\/p>\n\n\n\n

Of course, you can only use it for this tool and not for others such as Google Search Console<\/a> or Google Ads, or any other data source.<\/p>\n\n\n\n

This is the GA4Fixer extension<\/a> and one of the functions it has is to add the % of the total in the reports. That easy. <\/p>\n\n\n\n

\"ga4<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Either of these two ways are good to always have this important element when analyzing and drawing conclusions from our reports.<\/p>\n\n\n\n

I use both. I always have the extension installed and I make the modification that I have mentioned in the Looker Studio templates<\/a>. <\/p>\n\n\n\n

What uses do you think of?<\/p>\n\n\n\n

Most downloaded templates:<\/strong><\/p>\n\n\n