AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4K members online now
4K 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