Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

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

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