SEO and GA4: Keywords That Convert - Looker Studio Report

Want more tips and tricks on Analytics, SEO, PPC and more?
Head over to bit.ly/J_YT
Want to take your Analytics skills to the next level and be Google Analytics Certified?
Check out our course here bit.ly/AnalyticsCourse_YT
Want to master PPC, get more in-depth learning and be Google Adwords Certified?
Check out our course here bit.ly/PPCCourse_YT

[@AhmedHassan-dv5zq]

Very helpful report. Cant believe i haven't thou6of that in all my years of digital marketing 😑 Thanks for this video, data riven u always has the best stuff for analytics and reporting!

[@DataDrivenU]

Thank you very very much - we're glad our efforts are making a difference!

[@DataDrivenU]

Here's the formula for LP_no_domain: TRIM(SUBSTR(Landing Page,31,100))

[@gikis1]

Hi and thanks for sharing your work :) Your solution is based on the assumption that the revenue is evenly distributed between all the sessions and the landing pages, which is wrong. There can be users discovering the product/looking up reviews, which makes it possible to have zero-conversion keywords too, resulting in uneven transaction distribution. While the offered solution is good as a very simplified proxy, I would avoid using it for keyword prioritisation.

[@DataDrivenU]

Hi - thx for watching carefully - tbh I was expecting this type of objection to the procedure :) Yes you can definitely avoid it, but if you have access to any large ecommerce ppc AND gsc dataset I encourage you to go ahead and compare the lists of kws that perform (from g ads and the one obtained using this technique) and pls share your insights here. Thx!

[@TravisBarker-dv3oq]

thank you!! This is really helpful! Im having one problem. Because the length in the SUBSTR syntax is 100, the table only grabs URL will 100 characters in the page path and nothing else. Is there a way to make Looker grab any and all page paths?

[@DataDrivenU]

Thx for the kind words :) I think changing that number to whatever fits your use case will do... right now it grabs UP to 100 chars.

[@ValentinPyatenko]

Do you use standard Search Console connector from Google in this video? Because I was trying to do the same I've noticed that standard GSC connector doesn't provide "Landing Page" dimension. Or maybe it's not for everyone

[@DataDrivenU]

yes, we use the standard one... have no idea what could go wrong in your connection.. :(

[@anondontwant]

Bit confused - I don't have the landing page dimension in Looker Studio - am I doing something wrong?

[@DataDrivenU]

Do you have GSC data source connected?

[@anondontwant]

@@DataDrivenU I do! Do I need to set up landing page as a custom ga4 dimension or something?

[@eikemx]

@@anondontwant When adding GSC to the Looker Studio Report as a new data source, you have two options: "URL Impressions" and "Site Impressions". If you select URL Impressions instead of Site Impressions you get access to the Landingpage Data from your GSC within the Looker Report. I hope that helps!