Hey Benjamin. Thank you for guiding on the Blending techniques applied on different data-source of same/different characteristics. However, I feel the data transformation process (data blending) would be too complex & time consuming if we are blending data from 2 data sources accounts from same platform, because there will be lot of dimensions/metrics to be considered for merging. Also, would be helpful if you can guide on how to include same dimensions from 2 different accounts from same platform. For e.g. If I am looking forward to roll-up data from 2 AdWords account, my blending key would be "Day", & I will add same dimensions & metrics under both the data sources and save it. (please correct me if I am wrong). In this case, common metrics can be merged to form a "Combined" metric through formula, however, what I have doubts is on how to combine/roll-up common dimensions (considering the values under the dimension can be same or different for e.g. Account Name) My query is not just regarding AdWords, but regarding merger of all those data-source which are sourced from same platform.
How to connect 2 pages in one filter in data studio if I change something in page 1 it is not changing in page 2 plz give me answer or I should create dashboard in single page?
Hi, thanks for the tutorial. Sadly I get a System Error when I try to blend two data sources together. I've followed your steps carefully and tried a few times. Would you be interested in taking a look?
I had the same isssue when trying to merge 2 website analytics data into one but I concluded that certain metrics and dimensions just cannot be used so it gives an error it really is frustrating at times when u think u have a solution only for that to happen
Hi Benjamin, I have two fact tables (data sources), factACTUAL and factBUDGET, and two dimension tables, dimCOA and dimDate. I can link/blend one of the two dimension tables to both fact tables, but I can only link the second dimension table to one of the two fact tables. What would be the problem? Thanks Jannie.
Hi! The platform doesn't add the numbers. It only shows a blue line but with 0, but in the separate charts both shows the curve with numbers. I want to combine the data from 1 property that was recollecting all 2020, and another one that starts recollecting data this year. Is this a problem?
what if I want to link two or multiple sheets with same data month on month, it should just be a source in continuation of next month and so on. But no master sheets. Please advise
Sir how can I add multiple tables form a single data source (postgresql). I am having 80+ tables so should I need to make 80+ connection for making a new report using new table every time???
Hi! Thank you for a great video. I'm combining data from google analytics + google spreadsheet but something goes very wrong. I want to add 20 leads that weren't tracked in google analytics on a particular date, from a spread sheet and combine the leads from those 2 data sources in a scorecard. I am using date as a join key and Default Channel Grouping as dimension since I want to attribute the leads to the correct channel. I have added a created field where I'm adding the leads from the different data sources together and using them as a metric but it doesn't show me the correct number. Do you have any idea of what I'm doing wrong? Thank you!
How we can blend 2 google sheet with same format and header name into google data studio? I try it but it always show just 1 file, it cant blend into 1 table. Can you help me? Thank you
4:50 man, I lost a 2 days trying to blend two different datas without success. Tha solve and save my day. thanks
Thank you so much for this! I wanted to combine two GA properties and analyze overall traffic via blended data. This was the perfect video to watch!
Thank you for this great tutorial. It works perfect ! It gives a good feeling learning something useful.
Hey Benjamin. Thank you for guiding on the Blending techniques applied on different data-source of same/different characteristics. However, I feel the data transformation process (data blending) would be too complex & time consuming if we are blending data from 2 data sources accounts from same platform, because there will be lot of dimensions/metrics to be considered for merging.
Also, would be helpful if you can guide on how to include same dimensions from 2 different accounts from same platform.
For e.g. If I am looking forward to roll-up data from 2 AdWords account, my blending key would be "Day", & I will add same dimensions & metrics under both the data sources and save it. (please correct me if I am wrong).
In this case, common metrics can be merged to form a "Combined" metric through formula, however, what I have doubts is on how to combine/roll-up common dimensions (considering the values under the dimension can be same or different for e.g. Account Name)
My query is not just regarding AdWords, but regarding merger of all those data-source which are sourced from same platform.
How to connect 2 pages in one filter in data studio if I change something in page 1 it is not changing in page 2 plz give me answer or I should create dashboard in single page?
Thank you, this was exactly what I was looking for + somethings I didn't know I wanted to know :)
Glad I could help!
Thanks a lot, great quick and simple explanation! Didn't know you could just right click and blend data 👀
Hi, thanks for the tutorial. Sadly I get a System Error when I try to blend two data sources together. I've followed your steps carefully and tried a few times. Would you be interested in taking a look?
I had the same isssue when trying to merge 2 website analytics data into one but I concluded that certain metrics and dimensions just cannot be used so it gives an error it really is frustrating at times when u think u have a solution only for that to happen
Great info... Can we merge 2 different dashboards in single dashboard
Hi Benjamin, I have two fact tables (data sources), factACTUAL and factBUDGET, and two dimension tables, dimCOA and dimDate. I can link/blend one of the two dimension tables to both fact tables, but I can only link the second dimension table to one of the two fact tables. What would be the problem? Thanks Jannie.
Could you please advise how to use same filter to view 2 tables from 2 data source. Thank you very much.
Hi! The platform doesn't add the numbers. It only shows a blue line but with 0, but in the separate charts both shows the curve with numbers. I want to combine the data from 1 property that was recollecting all 2020, and another one that starts recollecting data this year. Is this a problem?
what if I want to link two or multiple sheets with same data month on month, it should just be a source in continuation of next month and so on. But no master sheets. Please advise
Sir how can I add multiple tables form a single data source (postgresql). I am having 80+ tables so should I need to make 80+ connection for making a new report using new table every time???
Hi! Thank you for a great video. I'm combining data from google analytics + google spreadsheet but something goes very wrong. I want to add 20 leads that weren't tracked in google analytics on a particular date, from a spread sheet and combine the leads from those 2 data sources in a scorecard. I am using date as a join key and Default Channel Grouping as dimension since I want to attribute the leads to the correct channel. I have added a created field where I'm adding the leads from the different data sources together and using them as a metric but it doesn't show me the correct number. Do you have any idea of what I'm doing wrong? Thank you!
How we can blend 2 google sheet with same format and header name into google data studio?
I try it but it always show just 1 file, it cant blend into 1 table. Can you help me? Thank you
There is a way to show the sum of sessions of Site X + Site y? I don't understand which "join" I have o use to show it.
Thank u :)
thank you very much
Dear, my GDS is not picked up to additional columns which are inserted in Google sheet. Please help me...
Thanks
Great , thx man
So glad you liked it!
thx.....!!!
I like you.
How to add Facebook and Instagram data
Wow