The South Hills Newsletter is located here: Shared Items>Shared Data Extensions>Preferences_Consumer>South Hills>South_Hills_Newsletter
The South Hills Newsletter get populated from an API and from zip code range emails using an Automation in the UPMC BU. The automation is called South Hills zip codes
The automation runs every Sunday and pulls zipcodes from GEO zipcodes grabbed from Adobe GEO information, Causeway, and All Sub data.
The zip code emails only get added once, and never override the current data in the South Hills Newsletter SDE.
The automation is located here: Populate Should Hills Newsletter zip code emails
The automation runs in this order to grab zip code based emails and inserts them in the South Hills Newsletter
- Grab all emails from South_Hills_Newsletter and updates South_Hills_Emails_Automation with cat, subcat and date
- The automation gebs Active emails with zipcodes from GEO zipcodes grabbed from Adobe GEO information, Causeway, and All Sub data updates South_Hills_Newsletter where email address is not in Shouth_Hills_Emails_Automation
- Grab all emails from South_Hills_Newsletter again and updates South_Hills_Emails_Automation with cat, subcat and date