I have a built the following workflow to extract Campaigns, Delivery associated each Campaign, Delivery Logs of each of the Deliveries
Stage-1 : Query Campaign
This extracts all the Campaigns.
Output Fields: Campaign Id, Campaign Label
Stage-2 : Enrichment with Delivery
This extracts the Delivery associated with each of the Campaigns extracted in Stage-1.
Output Fields: Campaign Id, Campaign Label, Delivery Id, Delivery Label
Stage-3 : Enrichment with Delivery Logs
This extracts the Delivery Logs associated with each of the Delivery extracted in Stage-2.
Stage-4 : Change dimension - Delivery Log
This changes the target dimension to Delivery Logs.
Stage-5 : Enrichment – Campaigns Deliveries and Delivery Logs
This enrichment simply adds the Delivery Logs fields to output. In Stage-3, it simply joined to Delivery Logs but any of the Delivery Logs fields were not taken to output.
Output Fields: Campaign Id, Campaign Label, Delivery Id, Delivery Label, Delivery Log Event Date, Status, Recipient Id, Scv Id
Stage-6 : Data extraction
The output of the Stage-5 is written to the file.
This is working fine.
Now I would like to pull the “Subject” (i.e., Email Subject) from the “Email header parameters” associated with the Delivery schema.
I can see the data item “Subject” and many more when browsed from the Source schema as shown below.
Browsed from the Source schema
But, I can’t see the data item “Subject” and many more when browsed from the Query or Enrich activity as shown below.
Browsed from the Query or Enrichment
Could you please advise.
It appears to be a universal constant for Message Center, at least when I was experimenting on it back in 2014.
By shunting all the messages into /dev/null and making some optimizations I got it to 60/s, fwiw.