Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Segment or calculated metric matching one eVar value to another

Avatar

Level 4

Scenario: eVar1 captures the Search Term, eVar2 captures the Product name displayed following the search.

How can we identify the Products displayed where they the Product Name matched the preceding Search Term?

But in general - for segments or calculated metrics the available functions all relate to static values. Is it possible to compare the eVars?

Thank you

1 Accepted Solution

Avatar

Correct answer by
Level 10

Now it's clearer. If this seems to be an important scenario for your team, you may want to consider the implementation enhancement by enriching the online data with offline data (read about data sources and transaction ID). As an outcome, you will be able to run a report in AA that will show you online and offline orders. Together with the segment (those who viewed a product but did not purchase) this should help recognise if significant amount of orders followed onsite search happen offline.

Does it help?

View solution in original post

15 Replies

Avatar

Community Advisor

Dear

Avatar

Level 4

Sorry Pratheep,

Let me give you two scenarios (I realize they are quite different in nature, but both stumped me in segment creation):

Scenario 1:

Visitor enters a search term captured in v1. The search results in several matches - exact and fuzzy, with the top result being the closest match. The top result is captured in v2. I want to create a segment that would include the visits where v1 matched v2. How?

Scenario 2:

Visitor views several products. Visitor does or does not place an order for one of these products, on this same visit or later. Say I want to create a segment for the visitor/product combination where there is a product view and no order for this product?

Any thoughts would be appreciated.

Avatar

Level 10

Scenario 2 is absolutely possible — just build a segment when a certain product had Product Views (or/and cart additions, checkouts, etc.) but was not purchased (order does not exist). This is probably one of the most commonly used scenarios for remarketing.

Avatar

Level 4

When you say "a certain product" - do you mean one specific product? Sure, that's possible. I mean across the entire catalog, all the situations where any visitor viewed but did not purchase any product. Can you please clarify?

Avatar

Level 10

You can specify a certain product or product category if the scenario is to offer the product(s) the prospective customers probably were interested in. However, if you just want to build a segment of those who saw any product and did not purchase anything, then just do not specify the product in the segment.

If you could share more details regarding you business scenario/goal/problem, then the community may give you a better way to reach the desired goal using the existing functionality of AA.

Avatar

Level 4

Andrey, it's neither of these!

I am looking to capture all situations where customer X has viewed Product Y and did not buy this product Y. Where X and Y are not static values.

Avatar

Level 10

Let's imagine it's possible, what would be your next action (what is the scenario)?

Avatar

Level 4

I'd check if this visitor placed an offline order with me for this product. For ALL such visitor/product combinations.

Avatar

Level 4

That's it for now, validating a hypothesis.

Avatar

Level 10

Sorry, it does not explain the scenario. What hypothesis do you consider?

Avatar

Level 4

Whether there is a significant number of visitors who use the site to view the product then place their orders offline. If yes, cluster by visitors and/or by products to see the patterns, re-evaluate internal processes.

Avatar

Correct answer by
Level 10

Now it's clearer. If this seems to be an important scenario for your team, you may want to consider the implementation enhancement by enriching the online data with offline data (read about data sources and transaction ID). As an outcome, you will be able to run a report in AA that will show you online and offline orders. Together with the segment (those who viewed a product but did not purchase) this should help recognise if significant amount of orders followed onsite search happen offline.

Does it help?

Avatar

Level 4

Thanks Andrey, it would seem you were right the first time - there is no solution for my specific request.