How to update URLs when sending the same email from different business units/sites

Question

We have a scenario where the same content is published across multiple sites, and we want to send the same email to the different sites from their related business units. The branding in the email is straight forward enough, but we want the links in the email to point to the appropriate domain related to the business unit.

Assuming that the links are the same, just with different domains:

• http://www.site1.com/path/to/article/
• http://www.site2.com/path/to/article/
• http://www.site1.com/path/to/another/article/
• http://www.site2.com/path/to/another/article/

I hate to create a copy of the email for each send in each BU and run a replace on the domain, but maybe some AMPScript that would change the contents of the email at send time based on the sending BU? Is there another mechanism that I'm not aware of that could simplify this?

Answer 1

In Shared Data Extension store BU MID as Primary Key and link assigned to that BU. Ten you can use %%memberid%% personalization String as value for lookup and get your link from a DE. Given your DE columns are 'MID' and 'Link', code would look something like this:

set @memberId = AttributeValue('memberid')
set @linkData = LookupRows('DE_WITH_BU_AND_LINK', 'MID', @memberId)
if RowCount(@linkData) == 1 then
    set @urlBase = Field(Row(@linkData, 1), 'Link')
else
    RaiseError('No link for BU found', true)
endif