Expand my Community achievements bar.

Applications for the Community Advisor Program Class of 2025 are NOW OPEN – Apply Today!
SOLVED

Enrich from file without reconcilliation

Avatar

Level 3

I am wanting to send an email which contains content data from a file, this data is generic i.e. it doesn't relate to a specific profile, it is purely email content. I think this can be done using the API, but I am trying to find a way to do it with a Load File in the first instance if possible.

 

1. I want to run a query that finds the people the email is going to go to.

2. Load a file with the additional data.

3. Enrich each email address with the additional data

4. Send email with the additional data

 

The issue I am facing is that I have to reconcile the load file data to the profile, but there is no reconciliation as the data is generic for all profiles, I simple want to append the data to the temporary resource so I can use the content inside the email.

 

Is there a way to do this?

 

I thought I had a fallback method of creating a table that has the data contained inside it, so the load file updates the table with the data to be used in the email, and then I simply use the data from that table inside the email content. But it seems like I can't keep a table of data inside Campaign that can then be used within an email, without it being linked to a profile, which means I have the same issue of reconciliation.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@michaelwilding, You should be able to do this with enrichment activity. Steps to get the data added to each profile,

 

  • Load the file data and save it as an audience.
  • Have a separate workflow containing query activity to pull profiles and read audience activity to read data loaded from the file.
  • Use enrichment activity with 1 cardinality link (source and destination value as 1) and add an additional data section.SatheeskannaK_0-1690225027600.png

    Enrichment relation definition will look like this,

    SatheeskannaK_1-1690225085214.png

     

Thanks, Sathees

View solution in original post

6 Replies

Avatar

Correct answer by
Community Advisor

@michaelwilding, You should be able to do this with enrichment activity. Steps to get the data added to each profile,

 

  • Load the file data and save it as an audience.
  • Have a separate workflow containing query activity to pull profiles and read audience activity to read data loaded from the file.
  • Use enrichment activity with 1 cardinality link (source and destination value as 1) and add an additional data section.SatheeskannaK_0-1690225027600.png

    Enrichment relation definition will look like this,

    SatheeskannaK_1-1690225085214.png

     

Thanks, Sathees

Avatar

Level 3

@SatheeskannaK thank you for the reply. The file doesn't contain any profile data, just email data such as subject line, body copy, sign off etc. Can I still save it as an audience?

Avatar

Level 3

So I can!

Avatar

Community Advisor

Yes, you can still save it as audience and the difference is the type of audience will be "List". 

Thanks, Sathees

Avatar

Level 3

Could you explain what is happening when the source and definition expressions are 1 please?

I didn't realise I could use Audiences in this way. Effectively I can use an audience to store any type of flat data?

Avatar

Community Advisor

Could you explain what is happening when the source and definition expressions are 1 please? - Considers the link between source and destination is always true.

I didn't realise I could use Audiences in this way. Effectively I can use an audience to store any type of flat data? - Yes, you're right.

Thanks, Sathees