[SalesForce] Auto Update All Subscribers list from Filtered Data Extension

I noticed unlike Standard Data Extensions, email addresses from Filtered Data Extensions are not automatically updated to All Subscribers.

Does anyone know how to make it an automatic process or how can I write a simple query to add these email addresses from my Filtered Data Extensions to the All Subscribers List?

What I am trying to do is to update any new email addresses from a filtered data extension to the All Subscribers List. Hence the columns that I am interested in are: "Email_Address__c" from "FilteredDE" as well as "SubscriberKey" and "EmailAddress" from "_subscribers".

p.s. Sorry I am quite new to SQL Query, so I will need some help to start off with the query script.

Thanks in advanced! 🙂

Best Answer

The one and only approach that is working for me is via 3 activities and an automation to run all these activities in sequence.

1) Data Extract

2) File Transfer

3) Import

Related Solutions

[SalesForce] Insert/ Update new rows from one data extension to another via query

First of all, I don't think you can use Query to update All Subscriber Lists, as query only works with Data Extensions (local or shared), system data extensions can not be selected (_Sent, _Open etc)

And You can't use insert , delete or update keyword in Marketing Cloud query, it is not standard TSQL, to implement "insert into" you have to use select query and include the PK column. Marketing cloud uses the dataset from select query to match and update target data extension rows, that is why PK column must be configured in targeted DE to allow "Append" or "Update" action.

"Data actions" on targeted Data Extension

Append - only add new data
Update - only update existing data
Overwrite - delete all records in target data extension and insert all records from your query.

so an update query should look like this

select Email_Address__c as 'EmailAddress',
Email_Address__c as 'SubscriberKey'
From [FilteredDE]

then select targeted data extension and "Update" type. Assume that your targeted data extension has SubscriberKey column set to PK, above query will find records that match SubscriberKeys and update EmailAddress column to values in [FilteredDE].[Email_Address__c]

Best Answer

Related Solutions

[SalesForce] Insert/ Update new rows from one data extension to another via query

Related Topic