Expand my Community achievements bar.

SOLVED

AEP - ODE - Profile and Offer Export

Avatar

Level 4

With in AEP, is there a way to export both Profile and Offers together. i.e I am looking for an output, where Example given below

ProfileID OfferID OfferID
id1 ofid1 ofid2

 

Challenge, I see is Offers (Decision Object Repository - Personalized Offers ) dataset is missing my Pkey with-in Record Schema. 

 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Try looking at this, it basically points you to the dataset and Query Service.

Here is some starter SQL, but you may need to reconsider your output data structure.

select identityMap, 
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY.NAME, 
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.CHANNELID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.SCORE
from ode_decisionevents_xxxx
where _ACP_BATCHID = '[guid]'
limit 10

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

Try looking at this, it basically points you to the dataset and Query Service.

Here is some starter SQL, but you may need to reconsider your output data structure.

select identityMap, 
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY.NAME, 
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.CHANNELID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.SCORE
from ode_decisionevents_xxxx
where _ACP_BATCHID = '[guid]'
limit 10