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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.