Reporting on site searches in GA4 & Looker Studio

แชร์
ฝัง
  • เผยแพร่เมื่อ 16 พ.ย. 2024

ความคิดเห็น • 12

  • @History-Women
    @History-Women ปีที่แล้ว

    Hi! Do you have any idea how to track the conversion rate on a search term? I'd like to optimize site search, but I need results before & after i've made adjustments. Please do let me know, all the purchase and conversion metrics don't work in these reports.

    • @Twooctobers
      @Twooctobers  ปีที่แล้ว

      Someone else asked this same question - it's a bit weird, but yes: th-cam.com/video/YhQGltyzKKg/w-d-xo.html

  • @moritzschmitz-justen3734
    @moritzschmitz-justen3734 10 หลายเดือนก่อน

    First of all, thank you for this useful video. It worked just fine with one exception. If I use the LOWER Function, it does convert all search terms to lower case but it apparently doesn't do deduplication. It show multiple terms - all written in lower case - but as if these were different searches. Is there a function to really deduplicate/ consolidate these search terms?

    • @Twooctobers
      @Twooctobers  10 หลายเดือนก่อน +1

      Ah - I think I forgot to apply the LOWER() function to the search term in the url - it should be HYPERLINK(CONCAT("xyz.com/?s=",LOWER(Search term)),LOWER(Search term)) - does that fix it?

    • @moritzschmitz-justen3734
      @moritzschmitz-justen3734 หลายเดือนก่อน

      @@Twooctobers Thanks. Fixed!

  • @JoachimTranberg
    @JoachimTranberg ปีที่แล้ว

    I found this video during my research for a problem.
    I need to figure out a way of seeing which search_terms that leads to conversions
    I need to have search_terms as a dimension with the following metrics: count, conversions, conversion rate, revenue
    I cant figure out how to do it. Do you have any idea?

    • @Twooctobers
      @Twooctobers  ปีที่แล้ว

      I figured out how to do conversions: th-cam.com/video/YhQGltyzKKg/w-d-xo.html
      I don't think there's a way to tie revenue to search terms in reporting/explorations, but it would be possible in BigQuery.

  • @hamalishah
    @hamalishah ปีที่แล้ว

    Hi there,
    Your tutorial has really helped me in my work but I would like to know how can i get the "Search Term", as I don't see it in my fields in Looker Studio. It doesn't appear in the Data. Please help me.

    • @Twooctobers
      @Twooctobers  ปีที่แล้ว +2

      Try going to Resource > Manage added data sources, then click to EDIT your GA4 data source, then REFRESH FIELDS (lower left). Google added Search term as a dimension to the GA4 data source in June, so it may just need refreshing.

    • @hamalishah
      @hamalishah ปีที่แล้ว

      @@Twooctobers I highly appreciate your quick response. I did refresh but couldn't find "Search Term" as a Dimension

    • @Twooctobers
      @Twooctobers  ปีที่แล้ว

      Hmm, that's odd - as a workaround you can create a custom "Search term" dimension, event-scoped, populated by the search_term event parameter. Unfortunately, it will only start collecting data after you set it up.

    • @mlcsudesign1722
      @mlcsudesign1722 5 หลายเดือนก่อน

      @@Twooctobers Thanks this has been really helpful