Expand my Community achievements bar.

SOLVED

How to display Offer to specific users

Avatar

Level 1

Hi,

I'm very new to Target Classic and have been searching the documentation for a solution to my question but with no luck.

What I need to do is serve a specific Offer depending on whether a custom mbox parameter value exists in an array of values.

So far, this is what I have:
1. Pass in my mbox parameter
2. Create 3 experiences and target a Custom Segment for each Offer. Each Custom Segment uses Visitor Behavior to check if my custom parameter is equal to a single value.
3. If the mbox parameter is equal to specific value then, show that Offer.

This all works right now, but I'm only checking against one unique value in each Offer. I need to compare the mbox parameter to an array of values for each Offer and if the value is found in the array then show that Offer.

I've tried creating Profile Attributes for each Offer, for example:

var offerBArray = [ '1','2','3' ];
if ( offerBArray.indexOf( profile.parameter2 ) != -1 ) {
return true;
} else {
return false;
}

Then setting the Visitor Behavior to this Custom Profile and checking if the value is true.
But this isn't working. I'm at my wits end. Could someone please help? Eventually, I would like to make it so that instead of hard coding the array of values, I can compare to the results of a SQL query. But, I'm not sure if that can be done.

Thank you,

  Lawrence
 

1 Accepted Solution

Avatar

Correct answer by
Level 8

lmissak wrote...

Hi Nikhil,

Thank you for responding to my question. Here is a list of documentation links that I have been looking through. I haven't found anything that indicates how to achieve what I need.

https://marketing.adobe.com/resources/help/en_US/tnt/pdf/js_expression_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/pdf/Expression_targeters_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/help/
https://marketing.adobe.com/developer/documentation/test-target/c-testandtarget-api

1. I need to pass in a parameter (unique user ID created by us, not TnT) through the mbox,
2. check to see if that user ID belongs to a data set that I retrieve through a SQL query
3. depending on which group it belongs to, server the correct Offer.

Can I check the mbox parameter against  data from a SQL query in real-time?
Can I import the data into Adobe Analytics and read it from there?
Let's say that the query will divide users into 4 groups, can I create Segments out of these groups?

Sorry for all the questions but I haven't been able to find answers to any of this and it seems like it should be able to be done.

Thank you,

 Lawrence

 

Hi Lawrence,

 

I've answered your questions below. Please have a look and let me know in case of any queries.

Can I check the mbox parameter against data from a SQL query in real-time? : This is custom implementation. You'll need to reach out to Adobe consulting or Client Care to check if this is possible /supported.


Can I import the data into Adobe Analytics and read it from there? : This is possible through Analytics for Target. However I'm not sure if this supports what you're looking for. Have a look at the documentation.
 

Let's say that the query will divide users into 4 groups, can I create Segments out of these groups? : This is custom implementation. You'll need to reach out to Adobe consulting or Client Care to check if this is possible /supported.

 

Thanks

Nikhil

View solution in original post

5 Replies

Avatar

Level 8

lmissak wrote...

 

Then setting the Visitor Behavior to this Custom Profile and checking if the value is true.
But this isn't working. I'm at my wits end. Could someone please help? Eventually, I would like to make it so that instead of hard coding the array of values, I can compare to the results of a SQL query. But, I'm not sure if that can be done.

Thank you,

  Lawrence
 

 

 

Hi Lawrence,

 

Are you following any documentation to achieve the result you mentioned? If yes please share the documentation link. If not I would request to start on Adobe Target Classic help documentation.

Have a look and do let us know in case of any queries.

 

Thanks

Nikhil

Avatar

Level 1

Nikhil Bisne wrote...

lmissak wrote...

 

Then setting the Visitor Behavior to this Custom Profile and checking if the value is true.
But this isn't working. I'm at my wits end. Could someone please help? Eventually, I would like to make it so that instead of hard coding the array of values, I can compare to the results of a SQL query. But, I'm not sure if that can be done.

Thank you,

  Lawrence
 

 

 

Hi Lawrence,

 

Are you following any documentation to achieve the result you mentioned? If yes please share the documentation link. If not I would request to start on Adobe Target Classic help documentation.

Have a look and do let us know in case of any queries.

 

Thanks

Nikhil

 

Hi Nikhil,

Thank you for responding to my question. Here is a list of documentation links that I have been looking through. I haven't found anything that indicates how to achieve what I need.

https://marketing.adobe.com/resources/help/en_US/tnt/pdf/js_expression_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/pdf/Expression_targeters_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/help/
https://marketing.adobe.com/developer/documentation/test-target/c-testandtarget-api

1. I need to pass in a parameter (unique user ID created by us, not TnT) through the mbox,
2. check to see if that user ID belongs to a data set that I retrieve through a SQL query
3. depending on which group it belongs to, server the correct Offer.

Can I check the mbox parameter against  data from a SQL query in real-time?
Can I import the data into Adobe Analytics and read it from there?
Let's say that the query will divide users into 4 groups, can I create Segments out of these groups?

Sorry for all the questions but I haven't been able to find answers to any of this and it seems like it should be able to be done.

Thank you,

 Lawrence

Avatar

Correct answer by
Level 8

lmissak wrote...

Hi Nikhil,

Thank you for responding to my question. Here is a list of documentation links that I have been looking through. I haven't found anything that indicates how to achieve what I need.

https://marketing.adobe.com/resources/help/en_US/tnt/pdf/js_expression_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/pdf/Expression_targeters_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/help/
https://marketing.adobe.com/developer/documentation/test-target/c-testandtarget-api

1. I need to pass in a parameter (unique user ID created by us, not TnT) through the mbox,
2. check to see if that user ID belongs to a data set that I retrieve through a SQL query
3. depending on which group it belongs to, server the correct Offer.

Can I check the mbox parameter against  data from a SQL query in real-time?
Can I import the data into Adobe Analytics and read it from there?
Let's say that the query will divide users into 4 groups, can I create Segments out of these groups?

Sorry for all the questions but I haven't been able to find answers to any of this and it seems like it should be able to be done.

Thank you,

 Lawrence

 

Hi Lawrence,

 

I've answered your questions below. Please have a look and let me know in case of any queries.

Can I check the mbox parameter against data from a SQL query in real-time? : This is custom implementation. You'll need to reach out to Adobe consulting or Client Care to check if this is possible /supported.


Can I import the data into Adobe Analytics and read it from there? : This is possible through Analytics for Target. However I'm not sure if this supports what you're looking for. Have a look at the documentation.
 

Let's say that the query will divide users into 4 groups, can I create Segments out of these groups? : This is custom implementation. You'll need to reach out to Adobe consulting or Client Care to check if this is possible /supported.

 

Thanks

Nikhil

Avatar

Level 8

Hi Lawrence,

 

Let me look into and revert soon.

 

Thanks

Nikhil

Avatar

Level 1

Nikhil Bisne wrote...

lmissak wrote...

Hi Nikhil,

Thank you for responding to my question. Here is a list of documentation links that I have been looking through. I haven't found anything that indicates how to achieve what I need.

https://marketing.adobe.com/resources/help/en_US/tnt/pdf/js_expression_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/pdf/Expression_targeters_cheat_sheet.pdf
https://marketing.adobe.com/resources/help/en_US/tnt/help/
https://marketing.adobe.com/developer/documentation/test-target/c-testandtarget-api

1. I need to pass in a parameter (unique user ID created by us, not TnT) through the mbox,
2. check to see if that user ID belongs to a data set that I retrieve through a SQL query
3. depending on which group it belongs to, server the correct Offer.

Can I check the mbox parameter against  data from a SQL query in real-time?
Can I import the data into Adobe Analytics and read it from there?
Let's say that the query will divide users into 4 groups, can I create Segments out of these groups?

Sorry for all the questions but I haven't been able to find answers to any of this and it seems like it should be able to be done.

Thank you,

 Lawrence

 

Hi Lawrence,

 

I've answered your questions below. Please have a look and let me know in case of any queries.

Can I check the mbox parameter against data from a SQL query in real-time? : This is custom implementation. You'll need to reach out to Adobe consulting or Client Care to check if this is possible /supported.


Can I import the data into Adobe Analytics and read it from there? : This is possible through Analytics for Target. However I'm not sure if this supports what you're looking for. Have a look at the documentation.
 

Let's say that the query will divide users into 4 groups, can I create Segments out of these groups? : This is custom implementation. You'll need to reach out to Adobe consulting or Client Care to check if this is possible /supported.

 

Thanks

Nikhil

 


Hi Nikhil,

Thank you for your help. I will follow up with Adobe Client Care as you suggested.

 

Thank you,
     Lawrence