SEO and GA4: Keywords That Convert - Looker Studio Report

Подписаться 11 тыс.

Просмотров 1,6 тыс.

50% 1

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/Analytic...
Want to master PPC, get more in-depth learning and be Google Adwords Certified?
Check out our course here bit.ly/PPCCours...

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

@DataDrivenU Месяц назад

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

@AhmedHassan-dv5zq 6 месяцев назад

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 6 месяцев назад

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

@gikis1 6 месяцев назад

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 6 месяцев назад

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!

@cambsdigital Месяц назад

How did you get the 'keyword' dimension? TY

@DataDrivenU Месяц назад

If your GSC is connected properly it should be there out of the box?

@TrafficJamForever 26 дней назад

@@DataDrivenU I would have the same question as @cambsdigital As in the example shown in the video this field isn't on the list of dimensions and metrics either, so I presume this must be a calculated field.

@DataDrivenU 25 дней назад

it's the Query dimension - I just renamed it :)

@TravisBarker-dv3oq 4 месяца назад

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 4 месяца назад

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 2 месяца назад

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 2 месяца назад

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

@anondontwant 6 месяцев назад

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

@DataDrivenU 6 месяцев назад

Do you have GSC data source connected?

@anondontwant 6 месяцев назад

@@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!

@DataDrivenU 11 дней назад

@@eikemx thank you very much for stepping in with a very useful explanation!