Kick Point Playbook offers online training courses for people at all stages of their marketing career. Learn core principles, systems, practical techniques, and best practices, that you can apply to your unique situation. Transform your analytics, reporting, and SEO skills with help from our courses.
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 🙏
Hey Dana - I gain a lot of knowledge watching your webinars, talks and blogs. I wanted to ask a question if we have our GA4 properly setup do we still opt to make GA4 reports in looker studio? My second question is that I saw a blog video of yours on Moz's website and you talked about using BigQuery along with GA4. Can you please make a details video on that how to we export and use the data and how do we use BigQuery?
First question: that's up to you! We often still make our dashboards in Looker Studio because we want to combine more data sources or visualize the data in a way that isn't available to us in GA4. Second question: Sure, we can add that to our list of content to publish! But in the meantime if you do want to learn about BigQuery and GA4, Johan has an excellent resource at www.ga4bigquery.com/
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?
Hi Dana, Does this new change mean that someone who completes a website contact form after an organic search and lands on a thank you page won't register if we have set up a conversion event for ty-page? Will our existing events ONLY show if they were triggered by a Google Ad?
You'll still see the events no matter how people got there, and key events will be recorded no matter how people got there. You'll only see a conversion if it's via Google Ads (display, search, RU-vid, etc).
They're listed here in the early feature kill list for March: support.google.com/analytics/answer/11583528?hl=en So unfortunately it looks like they are gone!
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?
You should be able to view these revised URLs in any report, but yes an Exploration would work as well. They'd populate the page location dimension which is also used to populate the page path dimension.
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?
Thank you KP Playbook, this was very very helpful! We are curious how this inclusion of the new variable in GTM can then connect with reports on GA4. We have pages on our site where a script passes along a variable, in this case, it begins with a question mark in the URL, and thereby the default GA4 doesn't see the various pages that run off of that check mark. We have the Document Location URL now captured (verified in Omnibug on Chrome), but now we don't know how to pull that data in a GA4 report. Can't thank you enough for posting this type of information. Take care.
If you go back to any time before September 2023 in any attribution reports where you have a channel dimension -- traffic acquisition, user acquisition, etc, you'll likely be "missing the data" and need to change your Primary Dimension to "Default Channel Group"
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!
Hey there, i just tried this method and added Pinterest as pr your guidance. However, Pinterest is still not reflecting in session source/medium. I see FB, Insta, Tiktok all visible, but not Pinterest. Can you suggest what to do?
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?
Awesome video, very to the point and easy to digest the information, I am currently pursung my Bachelor's in Digital Marketing. This video was extremly helpful and I will be chacking out the rest of your content!
How long have you been involved in marketing? Love picking others brains on topics about marketing to see odifferent perspectives to help fuel the learning process.@@kp_playbook
@@kp_playbook so tons of experience, what would you say would be the biggest things to focus on as a new digital marketer when it comes to building tested experience?
@@YesterdaysTomorrow Dana says, "Don't be afraid to implement changes and observe the results, even if you aren't 100% sure if those changes will help or not. Many marketers get caught in a trap of worrying about potential negative impacts from their changes and end up not actually putting good ideas into practice."
I am now trying to apply this to my G4. I am stuck at 1:50, my screen does not have the Admin tab at this point. I'm not sure where it iss hiding and how I can force it up. Guidance please. You just skimmed a bit fast there because of the screen change regarding thhee channel group. I do not have the settings wheel on the lower left either.
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.
@kp_playbook, thanks for this great video - one of the best, intuitive simple and easy to follow tutorial on this subject! it was a big suprise to me to know that by default GA4 does not track hashmarks on the site=)