Data Studio
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Combine individual language pages into one result

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

My website is in 2 languages, with the language used defined within the URL path. Currently when I do a page views bar-chart in Data Studio I see 2 entries for each page, 1 for each language, but I would like to be able to view the total page views for both languages combined.

 

Eg: The same page is available in English and French via these URLs: 

https://www.pad-fairs.com/paris/en/exhibitor/dutko/

https://www.pad-fairs.com/paris/fr/exhibitor/dutko/

 

To make things a little more complicated, I also want the bar chart to display all sub-pages of /paris/*/exhibitor

 

Is this possible?

 

Thanks.

Combine individual language pages into one result

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @TwoByTwoDesign,

 

You could try making a new field in your data source with some REPLACE regex to make this part of the URL uniform. I believe the following should work if you replace 'Page' with the correct URL field for your data.

 

REPLACE(Page, '/fr/', '/en/') 

 

Let me know if that helps,

Ben