I'm looking at doing a Time Series chart for Transactions. It will show the last 30 days on GA4 and then the previous period last year on UA. Are you able to do different time frames? Data just shows as nothing
A comparison to the previous year should absolutely be working. Are you using the built-in compare function on the chart, or are you showing the two time periods in separate charts?
Question: Is there a way to rename the new SUM Metric? I have it set as "Blended Sessions" like you but what if we'd like to change that so it shows up differently in the chart and legend?
Question. Following the same procedure, the blended table always indicates no data, though I have data in both GA4 and UA tables. In your example it only happens, but I did also pageviews and get the same result always: an empty table. Any suggestions please? Thank you .
Double-check the join for the blend to make sure it's set up the same as the video, and check that the date is matching in both. Otherwise, if you'd like us to take a look, share the dashboard (edit access please) with playbook@kickpoint.ca and we can check it out!
This is honestly one of the best tutorials ever! The only issue i'm personally experiencing is that the user numbers and comparison percentages are wrong? For example, in February, there was 5,500 visitors, but the blended scorecard shows it as 5,200. Why would this be?
Great video. Thank you so much for posting this. So i have a question: I've successfully followed the steps and everything works - except pulling UA data from google sheets as they're about to cut off acess to UA data ! - and am now trying to present my data by say Year Month but it won't aggregate the session data. Is this something to do with the session formula? Would love to get your help on this 🙏
This is a super helpful video. Thank you. Could you display the line graph with the dimension month and drill down the dimension year so you can see each year visually from January to December? Or do I need to modify the formula? The following isn't working. Dimension Date Type: Month Display Format: Month Formula: COALESCE(GA3 Date,GA4 Date) Breakdown Dimension: Date Type: Year Display Format: Year Formula: COALESCE(GA3 Date,GA4 Date)
Try "Year Month" for the first dimension instead of just "Month". I just tried that myself and was able to get both Date Types/Display Formats to return data.
@@kp_playbookThank you; that is great. However, it creates a continuous line by "Month Year", so the x-axis has Jan-22 through Mar-24. I'm looking to create multiple lines by Year. So, the x-axis is fixed to Jan-Dec, and each line on the y-axis is the Year (2022, 2023, 2024).
@@ChadSolomon Ah I see! I was able to reproduce this now. The issue seems to be with the UA data only -- if I use the date as a breakdown for GA4 data only, it works, but when I change it to UA it doesn't. This could have something to do with how dates are set in UA data vs GA4. What I would recommend is export your UA data -- which you should be doing anyway, sooner rather than later -- and then try this blend again with your exported UA data and see if that fixes it. We'll be releasing a follow up video showing how to update this blend for exported data sources as we get closer to the UA deletion date. Do you have a plan for exporting your UA data yet?
Amazing video thank you so much! Is it possible to create the date cutoff point in a table if it doesn't contain the date column? For example I'm trying to blend UA and GA4 data to show a list of page titles with sessions, new users etc., but there's an overlap in UA and GA4 gathering data so coalesce is adding them together. When I add a date filter to the blended data table it's only pulling from one of the sources rather than both.
Make sure that your date filter is using a calculated coalesced date field instead of the individual field from one of the data sources in your blend. That will fix it!
Great question! We'll update this tutorial as people move their data into other places, but you can do this blend with exported UA data in Google Sheets or BigQuery as well, same process.
You would still use the date field for the blend itself, but towards the end where Dana changes the date grouping to weeks - just change it to months instead.
Sorry, our mistake -- that part got edited out for time. Here is what to do: click on the little date icon to the left of the date dimension (you should see a pencil icon). Then in the "data type" drop down on the window that opens, select the grouping that you want (in your case Date & Time > Year Month is probably the best fit). The data will change right away, and you can click out of the data type selection box. If you run into more problems, let us know!
triend copy your blended code but show this Invalid formula - Function "FORMAT_DATETIME" doesn't support FORMAT_DATETIME(TEXT, NUMBER). Function "FORMAT_DATETIME" supports FORMAT_DATETIME(TEXT, DATE), FORMAT_DATETIME(TEXT, DATETIME).
It isn't recognizing the COALESCE(UA Date,GA4 Date) part of the formula as a date. Make sure that your UA Date and GA4 Date fields have a type of "Date". You can check that by going into the data source itself. If you're still getting stuck, feel free to share what you have with playbook@kickpoint.ca or email us there! We're happy to help.
Unbelievably helpful. THANK YOU!
You're very welcome!
You are AMAZING. Thank you a million times over!
You are so welcome! Happy to help.
Super, helpful!
Glad it was helpful!
Amazing Tutorial, thank you very much!
Glad it was helpful!
I'm looking at doing a Time Series chart for Transactions. It will show the last 30 days on GA4 and then the previous period last year on UA. Are you able to do different time frames? Data just shows as nothing
A comparison to the previous year should absolutely be working. Are you using the built-in compare function on the chart, or are you showing the two time periods in separate charts?
@@kp_playbook is there a way I can send you a screen recording via email. It would save my life!
@@kp_playbook is there a way I can screen record and email you? It would save my life!
Yes, email us at playbook@kickpoint.ca!
Thanks a lot Dana! Really helpful :)
So glad we could help!
wow, just wow, thanks Dana!!🔥
Thank you so much! We're glad you like it!
@@kp_playbook too late now to play with but there goes my Tuesday!!
This tutorial is saving me, thanks so so much!!
Question: Is there a way to rename the new SUM Metric? I have it set as "Blended Sessions" like you but what if we'd like to change that so it shows up differently in the chart and legend?
If you mouse over the metric name, you should see a little pencil icon -- click that and then you can rename it!
Question. Following the same procedure, the blended table always indicates no data, though I have data in both GA4 and UA tables. In your example it only happens, but I did also pageviews and get the same result always: an empty table. Any suggestions please? Thank you .
Double-check the join for the blend to make sure it's set up the same as the video, and check that the date is matching in both. Otherwise, if you'd like us to take a look, share the dashboard (edit access please) with playbook@kickpoint.ca and we can check it out!
Answer: I was missing the date control field! Amazing video. Thank you.
@@frankberrocal Oh good, I'm glad it was an easy fix! You're very welcome!
This is honestly one of the best tutorials ever! The only issue i'm personally experiencing is that the user numbers and comparison percentages are wrong? For example, in February, there was 5,500 visitors, but the blended scorecard shows it as 5,200.
Why would this be?
I wonder if the leap day would cause any problems? Do the numbers work for January?
Great video. Thank you so much for posting this. So i have a question: I've successfully followed the steps and everything works - except pulling UA data from google sheets as they're about to cut off acess to UA data ! - and am now trying to present my data by say Year Month but it won't aggregate the session data. Is this something to do with the session formula? Would love to get your help on this 🙏
Are you blending with Google Sheets instead of with UA? We'll be making a new video showing how to do that since we're almost at the UA sunset date.
This is a super helpful video. Thank you. Could you display the line graph with the dimension month and drill down the dimension year so you can see each year visually from January to December? Or do I need to modify the formula? The following isn't working.
Dimension
Date Type: Month
Display Format: Month
Formula: COALESCE(GA3 Date,GA4 Date)
Breakdown Dimension:
Date Type: Year
Display Format: Year
Formula: COALESCE(GA3 Date,GA4 Date)
Try "Year Month" for the first dimension instead of just "Month". I just tried that myself and was able to get both Date Types/Display Formats to return data.
@@kp_playbookThank you; that is great. However, it creates a continuous line by "Month Year", so the x-axis has Jan-22 through Mar-24. I'm looking to create multiple lines by Year. So, the x-axis is fixed to Jan-Dec, and each line on the y-axis is the Year (2022, 2023, 2024).
@@ChadSolomon Ah I see! I was able to reproduce this now. The issue seems to be with the UA data only -- if I use the date as a breakdown for GA4 data only, it works, but when I change it to UA it doesn't. This could have something to do with how dates are set in UA data vs GA4. What I would recommend is export your UA data -- which you should be doing anyway, sooner rather than later -- and then try this blend again with your exported UA data and see if that fixes it. We'll be releasing a follow up video showing how to update this blend for exported data sources as we get closer to the UA deletion date. Do you have a plan for exporting your UA data yet?
@@kp_playbook@kp_playbook, that's a great shout; no, I have no plan to export the UA data. Do you have a video on that, or is it coming?
@@ChadSolomon We will definitely have a video coming on that. Right now we're trying out the export service by Analytics Canvas.
hi! i'm having issues with the initial right click > blend stage... after doing that i get only one row of data!
Yes, the initial blend is incorrect -- follow the instructions (or better yet, the video, you can see we have that happen too!) on how to fix it.
yes it all worked out in the end... thank you!@@kp_playbook
Glad to hear it!
Hey, I get user configuration error with this blend. I tried it exactly as you showed, just with sessions to test, but it gives this error
Can you provide more details as to what the error is? We can take a look.
Amazing video thank you so much! Is it possible to create the date cutoff point in a table if it doesn't contain the date column? For example I'm trying to blend UA and GA4 data to show a list of page titles with sessions, new users etc., but there's an overlap in UA and GA4 gathering data so coalesce is adding them together.
When I add a date filter to the blended data table it's only pulling from one of the sources rather than both.
Make sure that your date filter is using a calculated coalesced date field instead of the individual field from one of the data sources in your blend. That will fix it!
thank you!@@kp_playbook
Such a great tutorial - What will you be doing when the UA data is no longer available?
Great question! We'll update this tutorial as people move their data into other places, but you can do this blend with exported UA data in Google Sheets or BigQuery as well, same process.
This is Awesome. What would the modification be to use Months of Year instead of Date?
You would still use the date field for the blend itself, but towards the end where Dana changes the date grouping to weeks - just change it to months instead.
@@kp_playbookCan you point to where this is in the video? I'm not seeing where she changes the date grouping to weeks.
Sorry, our mistake -- that part got edited out for time. Here is what to do: click on the little date icon to the left of the date dimension (you should see a pencil icon). Then in the "data type" drop down on the window that opens, select the grouping that you want (in your case Date & Time > Year Month is probably the best fit). The data will change right away, and you can click out of the data type selection box. If you run into more problems, let us know!
top top top
Thank you!
triend copy your blended code but show this
Invalid formula - Function "FORMAT_DATETIME" doesn't support FORMAT_DATETIME(TEXT, NUMBER). Function "FORMAT_DATETIME" supports FORMAT_DATETIME(TEXT, DATE), FORMAT_DATETIME(TEXT, DATETIME).
It isn't recognizing the COALESCE(UA Date,GA4 Date) part of the formula as a date. Make sure that your UA Date and GA4 Date fields have a type of "Date". You can check that by going into the data source itself. If you're still getting stuck, feel free to share what you have with playbook@kickpoint.ca or email us there! We're happy to help.