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
3.2K members online now
3.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Merging tables in one data source in Data Studio

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am using Google Data Studio for reporting and used Google Search console as Data Source. We have 2 different tables in data source and I want to use all the fields from two tables to create a report. How we can merge the tables to be used in one Google Data Studio report?

Merging tables in one data source in Data Studio

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Neha G

 

You can't currently merge data in Google DataStudio. You;d have top do this externally (for example in Google Sheets) then reconnect the merged data source to your report.

 

Hope that helps,

Ben

Re: Merging tables in one data source in Data Studio

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thanks Ben. We want to use this for automatic reporting. If we have to get
merge data in Google sheets, it would be time consuming. Right now, we
can't merge two tables from a single source (Search Console and GA in my
case)? Using some plugin or paid version, is it possible or we can create
calculated field in one table based on other table?

Merging tables in one data source in Data Studio

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi Neha, 

 

I am also looking for solution to this problem. Did your team find any smart solution?

 

Thanks a lot!

 

Maggie