0

I am trying to add the ability to the marketing team to have custom personalization strings in Content Builder. I managed to create them but I have an issue to fill the Email Demographics table with data.

Let me explain the process :

  1. Go to Email Studio > Subscribers > Profile Management
  2. Create a new Attribute "Test Custom Attribute"
  3. Wait a couple of minutes
  4. Go to Contact Builder > Data Designer and click on the Email Data group attribute
  5. You will find the "Test Custom Attribute" in the Email Demographics Data Extension
  6. Go to Email Studio > Content Builder
  7. Create/Edit an Email and add a content block
  8. You will find your "Test Custom Attribute" as a Personalization String in the UI

Now the idea is to populate this table with data coming from an existing data extension (the population).

I know that it is possible to create an "internal import" from a Data Extension into All Contacts - Push or SMS but not Email.

I know also that it is possible via API using the /contacts/v1/contacts route.

My question is : Is it possible to populate "Email Demographics" Data extension from an existing data extension using Automation Studio (Import or SQL activity)?

0

There are multiple ways you can achieve this easiest would be SQL query:

SELECT *,

FieldName as 'Test Custom Attribute'

from FirstTable

and select it as an overwrite/or update.

Or as a Script activity - using AMPscript you can use the UpdateDE or UpsertDE functions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.