Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Products Review Data Tracking : Adobe Analytics

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

1380363_pastedImage_0.png

Link : Merchandising eVars [SiteCatalyst] - Analytics Demystified

Thank You!

Arun

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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.

1380363_pastedImage_0.png

Link : Merchandising eVars [SiteCatalyst] - Analytics Demystified

Thank You!

Arun

Avatar

Level 2

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

Avatar

Community Advisor

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

Avatar

Level 2

Dear Pratheep Arun Raj,

Thanks a lot. Your suggestions were very helpful.

Regards,

Hanish