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. Please advise. No blending here
Curious if your join keys data is similar, but not identical. For example, one data source has a full URL and another one drops https part. In one case it is called URL and in another Links. Essentially it is the same data. Is there a way to work with such data? The data comes from linked platforms so I can't modify it to match
I created a mini GA report in sheets using GA-AddOn. the report is for different page paths, each one in one different sheet. Ho do you combine the metrics (pageviews) from the different Sheets in DataStudio?
Great video, thank you. Question - with Google sheets, how do you make the date range change the data from sheets when you change the date in data studio? Every time I create blende data between Google ads and sheets and view this in a table it pulls in all data in my sheets file, regardless of the data range I select in the data studio report? For example, I have January & February data in sheets and only select January in data studio date range, yet i can see sheets data for February in my table in data studio. Thanks
@ads courses, in outer join there is 3 category (left, right, full). In this video it shows blended data for left outer join. May I know how to make or blend for full data?
Great! Its really usefull. I'm just having a problem: when I blend two sources, one of the metrics is not importing the data, apper as "null". I already tried to change the variable type to Sum, or Count, etc, but I had no success... I'm still trying to fix this...
I found my mistake! There was some difference in the commom index between the Blended Sources. The Dimension commom index must be identical in the Sources. Problem resolved!
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. Please advise. No blending here
I have two separate sources and their ID is what joins them: i want to create a results card with the data counting how many of those people (ID) are in the other source.
Please, I'm having troubles combining 2 sources; both from Sheets. The thing is I have 3 union keys, and I'm not seeing the blended data in any graphic, I cant see one the data of one of them, but not both. What can I do? TY
When I blend two data sources (1. orders with SKU and order date, 2. SKU category) the date range disappears when I try to create a chart using the blended data source. Does the date have to be part of the join key? My second data source (2. SKU category) is simply table with SKU and SKU category and so doesn't have any transactional data and dates. Wonder what I'm missing here but I need the date control on the report for the viewer and it needs to work on the blended data
I am blending data from two data sources to get the cost, ie Facebook and Google. With this I need to then calculate CPL. But I am unable to blend the total cost above and leads. How else can I calculate this CPL?
Tried to do "t1 left join t2 on t1.key1=t2.key1 left join t3 on t1.key2=t3.key2" where key1 is not in t3 and key2 is not in t2. Not allowing me to do it because they asked for 2 keys for each dataset
If You're having any problems with data blending in GDS let me know in the comments section :)
Would it be easier to combine the data in Google sheets with formulas and just use that sheet as a data source instead?
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. Please advise. No blending here
I have blended two datasets but the problem is , its working for only single chart not for the whole report .
Great! How can I merge two GA properties and add this data together?
Curious if your join keys data is similar, but not identical. For example, one data source has a full URL and another one drops https part. In one case it is called URL and in another Links. Essentially it is the same data. Is there a way to work with such data? The data comes from linked platforms so I can't modify it to match
I created a mini GA report in sheets using GA-AddOn. the report is for different page paths, each one in one different sheet. Ho do you combine the metrics (pageviews) from the different Sheets in DataStudio?
You made it sound so easy hahaha. I get confused easily whenever I tried to blend data. Thank you for this. 😁
My pleasure 😊
Great video, thank you. Question - with Google sheets, how do you make the date range change the data from sheets when you change the date in data studio? Every time I create blende data between Google ads and sheets and view this in a table it pulls in all data in my sheets file, regardless of the data range I select in the data studio report? For example, I have January & February data in sheets and only select January in data studio date range, yet i can see sheets data for February in my table in data studio. Thanks
@ads courses, in outer join there is 3 category (left, right, full). In this video it shows blended data for left outer join. May I know how to make or blend for full data?
Great! Its really usefull. I'm just having a problem: when I blend two sources, one of the metrics is not importing the data, apper as "null". I already tried to change the variable type to Sum, or Count, etc, but I had no success... I'm still trying to fix this...
I found my mistake! There was some difference in the commom index between the Blended Sources. The Dimension commom index must be identical in the Sources. Problem resolved!
Great.... Hi dear, i need your help on advance level data merge. Any feature in GDS to merge 2 different dashboards in single dashboard.
ur video are awesome. can u please make complete series on google data studio. basic to advance level tutorials. thanks in advance.
Thank you :) I'll make a complete GDS tutorial in near future for sure. Stay tuned!
@@DataHeavens that will be the awsm.
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. Please advise. No blending here
I have two separate sources and their ID is what joins them: i want to create a results card with the data counting how many of those people (ID) are in the other source.
Please, I'm having troubles combining 2 sources; both from Sheets. The thing is I have 3 union keys, and I'm not seeing the blended data in any graphic, I cant see one the data of one of them, but not both. What can I do? TY
When I blend two data sources (1. orders with SKU and order date, 2. SKU category) the date range disappears when I try to create a chart using the blended data source. Does the date have to be part of the join key? My second data source (2. SKU category) is simply table with SKU and SKU category and so doesn't have any transactional data and dates. Wonder what I'm missing here but I need the date control on the report for the viewer and it needs to work on the blended data
how to blend more than 2 data sources eg,: A (key1) + B(key1,key2) + C(key2)
hi, I have issue in data blending between google analytics and google sheet based on date field.
blend data only have 10 dimensions, how to add more fields to dimension ?
hello, I have a question, can I blend two spreadsheets in GDS?
What program do you use to show on screen the keys your are tapping?? Also thanks for the tutorial it was really clear and nice to watch.
How to compare two charts with a different date range in blended view?
Hi nice explanation, can you explain how to apply percentages in graphs. I'm getting numbers only instead of percentage.
I am blending data from two data sources to get the cost, ie Facebook and Google. With this I need to then calculate CPL. But I am unable to blend the total cost above and leads. How else can I calculate this CPL?
SUM of conversions and leads then / SUM of cost per lead and cost per conversion
Tried to do "t1 left join t2 on t1.key1=t2.key1 left join t3 on t1.key2=t3.key2" where key1 is not in t3 and key2 is not in t2. Not allowing me to do it because they asked for 2 keys for each dataset
Hi... any luck to merge 2 different GDS
Simply brilliant
Im trying to add a metric without a value with other but the addition is ever 0.
Are you Fred?