Expand my Community achievements bar.

Join expert-led sessions on Real-Time CDP & Journey Optimizer designed to boost your impact.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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