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 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.
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
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?
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
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???
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
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.
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, this was exactly what I was looking for + somethings I didn't know I wanted to know :)
Glad I could help!
Thank you for this great tutorial. It works perfect ! It gives a good feeling learning something useful.
Could you please advise how to use same filter to view 2 tables from 2 data source. Thank you very much.
Thanks a lot, great quick and simple explanation! Didn't know you could just right click and blend data 👀
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 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.
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
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?
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
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???
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.
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
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.
Great info... Can we merge 2 different dashboards in single dashboard
Thank u :)
Great , thx man
So glad you liked it!
thank you very much
Thanks
thx.....!!!
I like you.
Dear, my GDS is not picked up to additional columns which are inserted in Google sheet. Please help me...
How to add Facebook and Instagram data
Wow