Skip to main content
navin_kumar0601
Level 4
Nov 25, 2022 6:44 PM UTC
Solved

AEP - ODE - Profile and Offer Export

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. 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Danny-Miller
Danny-MillerAccepted solution
Adobe Employee
Nov 28, 2022 5:32 PM UTC

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 in thread

1 reply

Danny-Miller
Adobe Employee
Danny-MillerAdobe EmployeeAccepted solution
Adobe Employee
Nov 28, 2022 5:32 PM UTC

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
Translate
    Terms & ConditionsAccessibility statement

    Loading footer...