Products Review Data Tracking : Adobe Analytics | Community
Skip to main content
hanishkathpal
hanishkathpal
Level 2
December 22, 2017
Solved

Products Review Data Tracking : Adobe Analytics

  • December 22, 2017
  • 4 replies
  • 3133 views

Hello,

We have review for number of products on our e-commerce website.We want to see till how many reviews on a products impacted conversion ratei.e. After What number of reviews on product/s does not impact conversion rate.

ProductReview CountMetric1 (unique Visitor)Metric2 (Orders)Metric3 (Revenue)Metric4 (Conversion rate)....and so on.
SKU_10
SKU_21
SKU_32
--
--
--
SKU_Nn

Please provide your valuable inputs to implement such kind of tracking.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by PratheepArunRaj

    Dear Hanshika,

    The same cane be done using Merchandising Variable.

    Enable Merchandising Variable(In custom conversion variable) for product and capture the review against the product to report.

    Link : Merchandising eVars [SiteCatalyst] - Analytics Demystified

    Thank You!

    Arun

    4 replies

    PratheepArunRaj
    Community Advisor and Adobe Champion
    PratheepArunRajCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    December 25, 2017

    Dear Hanshika,

    The same cane be done using Merchandising Variable.

    Enable Merchandising Variable(In custom conversion variable) for product and capture the review against the product to report.

    Link : Merchandising eVars [SiteCatalyst] - Analytics Demystified

    Thank You!

    Arun

    Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
      hanishkathpal
      hanishkathpalAuthor
      Level 2
      December 26, 2017

      Hi Pratheep Arun Raj,

      Thanks for your reply.

      From the suggested solution,  I understand I only will be able to see "Review Counts" as dimensions and success events as metrics  in the Reporting of adobe analytics, As shown below,

      Review Counts (eVar #n)ProdViewCart AdditionOrders ...and so on.
      210021
      550073
      640062
      ----
      ----
      nmkp

      *Values in the Table above are random numbers.

      Will I be able to see "Review Counts"  as metric in "Products" Report as shown in below Table,

      Products (SKU)
      		ProdViewCart AdditionReview CountsOrders ...and so on.
      Sku_1100251
      Sku_2500763
      Sku_34006122
      -----
      -----
      Sku_nmknp

      *Values in the Table above are random numbers.

      In the above Report "Review Counts" metric could be filled with Most Recent allocated review counts for nth SKU for the selected date range.

      Also If I have understood incorrectly on the provided solution It will be grateful if you can elaborate it to some more extent.

      Thanks & Regards,

      Hanish

      PratheepArunRaj
      Community Advisor and Adobe Champion
      PratheepArunRajCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      December 26, 2017

      Dear Hanshika,

      As you know, below is the product syntax.

      "Category;Product;Quantity;Price;eventN=X[|eventN2=X2];eVarN=merch_category[|eVarN2=merch_category2]"

      To capture Review Counts as dimension, you should enable Merchandising for the variable as pointed out earlier and use an eVarN (Last delimiter value).

      To capture Review Counts as event, you should just use an eventN (Second last delimiter value).

      But, based on your objective you should capture it in a dimension and not in an event.

      If you capture it in an event, it will sum all the Review Counts & not by last Review Count.

      Example:

      Customer applying a product "A" on 13 Dec 2017 with review count 8 (Review Count as on 13 Dec).

      Customer applying a product "A" on 14 Dec 2017 with review count 9 (Review Count as on 14 Dec).

      Customer applying a product "A" on 15 Dec 2017 with review count 10 (Review Count as on 15 Dec).

      Then, table will be like,

        

      ProductReview Count (Metric)
      A27

      So, you cannot find your base goal : Impact of product reviews on conversion rate.

      Thank You!

      Arun

      Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
        hanishkathpal
        hanishkathpalAuthor
        Level 2
        December 26, 2017

        Dear Pratheep Arun Raj,

        Thanks a lot. Your suggestions were very helpful.

        Regards,

        Hanish

          Terms & ConditionsAccessibility statement

          Loading footer...