7

I've been in a project that involved a Subscriber Key migration to Sales Cloud format when both key variations existed in the system at the same time, and the reasons why client went through with it are as follows: Get rid of duplicate Contacts for the billing purposes. Keep all the Send History and Subscription Permissions tied to the same Contacts. Get ...


6

Are you sure you just want to delete all subscribers? There are few reasons why I will recommend you using the Contact Deletion Framework: Deleting from All Subscribers will not necessarily remove the subscriber from billable contacts. And it will still count towards your utilisation. Sendable data extensions might also contain traces of these contacts, ...


5

Any DE that is in the shared folder is "owned" by the EID (Parent MID) If you need to access it within a child BU you need to use the ENT. prefix. You need to update your ampscript to the following: %%[ set @key = [id] set @fname = Lookup ('ent.shoppers', 'first_name', 'id', @key) ]%%


4

As provide in the example on this question 'Retrieve the Data Extension Fields using Soap Api' <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <soapenv:Header> <fueloauth>XXXXXXXXXXXX</fueloauth> ...


4

Your first query does not include the _Open data view, so it won't work for your use case. If you want to display all subscribers who opened an email, you can use the following, bearing in mind what Lukas said - Data Views only hold last 6 months worth of tracking data: SELECT s.SubscriberKey, j.EmailName, s.EventDate as SentDate, o.EventDate as ...


4

Are you testing this with a Data Extension and do you have a field in it named 'SubscriberKey'? If not, you will need to use '_SubscriberKey' to pull in the system defined SubscriberKey value, like noted here. Additionally, it doesn't appear that for your use case you should be using URLEncode(), and should be using Base64Encode(). Something similar to ...


4

There is not a simple answer to this, as it is very much depending on organisational structure when it comes to your client's data and digital marketing activities. If there is a need for keeping the data separate between BU1 and (future) BU2 (e.g. contacts in BU1 should not be visible in BU2 and vice versa), splitting the current BU in two will be a ...


4

Always integrate to ENT (root BU) and use automation studio in ENT to sync into child BUs using Shared Data Extensions. Even the day you choose to upgrade to Multi-Org connector, the integration still is done with the ENT BU, which technically holds all the synchronised data extensions, across all the BUs. This will still allow you to inject contacts into ...


4

Use a File Transfer Activity in Automation Studio: Create a file transfer activity to move, unzip, encrypt, or decrypt a file in Marketing Cloud Automation Studio. Click Create Activity. Select File Transfer. Provide a name, external key, and description. Complete the fields on the Properties page. Select Manage File or Move a File From Safehouse. ...


4

Unfotunately it is not, the access is not based on the records inside the Data Extension but the Data Extension location itself. You will need to create and use different Shared Folder for each BU, with different Data Extension inside of it. Then you'll be able to merge these two DE's into one with SQL in your parent BU, if required.


4

If you turn on multi-org, it will be turned on for all BUs. To achieve the above setup, you could use two separate API users in SFMC: one with access to BU A and connected to org A, second one with access to BU B and C and connected to org B. Verify your setup with SF support before you turn on multi-org, because it cannot be turned off once enabled. Here’...


4

It appears the only way to disable this notification is to enable MFA. According to these release notes this will become mandatory at some point


4

This is not a supported use-case as of 20220114. It can be accomplished, but it should not be done. The application can launch with the configuration of your global BU and be switched to a child BU once the user is identified, but the data in the parent BU will become stale overtime and there's no guarantee that it will continue to work without some sort of ...


3

If you have Marketing Cloud SFTP, you could create an automation in Child BU, that would export all the data from your DE to FTP, and another automation in Parent BU, that would import this file from FTP and update the data in your DE in Parent BU. This wouldn't be possible in real-time though, you could automate it to run every hour or so. Check out the ...


3

Yes, you can retrieve all journeys using the following REST API request: Host: https://YOUR_SUBDOMAIN.rest.marketingcloudapis.com GET /interaction/v1/interactions/ Content-Type: application/json Authorization: Bearer YOUR_ACCESS_TOKEN Just iterate through the JSON response and snag the ID for each of your journeys.


3

There are multiple levels to your question, I will try to focus more on the background, architectural question than on the specifics (of subscriber filters and queries onto _subscribers from child BU): A 2-BU, Parent-Child setup is typically not used for hard separation of data for two brands, where BU "A" gets only Data of brand A, and BU "B" gets only ...


3

If you use the formatnumber function you can keep the leading zero: {{=formatnumber(TrackingNumber, "d6")}} here is the doc for using Ampscript within GTL


3

No - Cloud Pages are linked to single a Business Unit. However, when building them, you can use Content builder and have all your elements reside in Shared content across multiple Business Units - making creating similar pages in more BUs quicker tha recreating all from scratch. If you can be more specific on your use case, more exact advice can be provided....


2

yes you will need new credentials if you are using rest API or using token authentication for SOAP API. Here is a guide to create your new credentials in SFMC. Check if you have the right permission set for the task. https://developer.salesforce.com/docs/atlas.en-us.mc-app-development.meta/mc-app-development/install-packages.htm P.S You will have to be on ...


2

The help page 'Contact Definition and Count Determination' does a great job breaking this down. All subscribers are contacts but not all contacts are subscribers. Subscribers are contacts that are belong to a channel (email/sms/push/ott) Best guess is this spike has come from synchronized data extensions. This help article 'Permanently remove Contacts or ...


2

Add a WHERE clause and use the AccountID. The AccountId is also known as the MID. You can highlight over the dropdown of your business unit to locate this number. Select s.X , j.Y , o.Z from [_Job] j Join [_Open] o on j.jobid = o.jobid WHERE j.AccountID = '123456'


2

The reputation is not per BU - it is per IP and domain. So if you use the same IP and Domain across all your BUs, if there is one bad apple, your entire batch is ruined. As SFMC does not have a 'non-prod' option really (other than in very limited situations via a Sandbox edition) then in the eyes of SFMC and in all receiving ISPs and email clients, what ...


2

This is your best reference: 'Sender Reputation Overview and Best Practices for Marketing Cloud' Sender Reputation is usually based on the sender's IP address, but domain reputation is tracked by some ISPs (ISPs plan on more domain-based measures in future). So if the child BU is using the same IP and domain they will affect reputation for sure.


2

You need to create a list in your parent Business Unit: Email Studio > Subscribers > Lists Then import the subscribers you want to delete into this list. Then, delete this list and check the box to delete the Subscribers from All Subscribers.


2

This may or may not be what they are referring to but in my experience we've had the option of purchasing 1 domain for use with the cloudpages and links within emails. Then another domain for portfolio content. The portfolio SSL is optional, but you can configure both if necessary.


2

This was likely a bug or something in SFMC where it did not recognize that the shared DE referenced was the same as the target. (perhaps something to do with the ent. prefix? not sure) The policy for all SFMC BUs is that if a Query references the target DE inside of it, it MUST be update only. Personally I find this to be a very useful safeguard even though ...


2

After a lot of research, engaging with Salesforce, Salesforce MVPs, etc. and still no standard best practices applicable to that Multicloud Setup, I had a very productive workshop together with some very knowledgable and experienced Salesforce Architects for Marketing and B2C Commerce Cloud. Workshop conclusions During this workshop we discussed that as ...


2

You can solution this using Data Extension Retention Settings in Shared Data Extensions and the UpsertDE AMPscript function or the _Sent data view and Exclusion Scripts. Though it's not the most simplistic way of doing it, there is nothing currently out-of-the-box that allows you to manage how many emails a subscriber receives. Create a data extension in ...


2

This is because all your columns in select statement needs to be in the group by clause. Ideally, it should only be the subscriber key / job id(In case you are trying to find the max sent date for a job). Refer to this article


2

Yes, the shared data extensions belong technically to the root/topmost business unit (this is why you always need to use ENT.[Data extension name] when referencing them in SQL queries). So taking a snapshot of them in e.g. one child BU, and deploying to another child BU will always cause you problems, as you technically ask deployment manager to create same ...


Only top voted, non community-wiki answers of a minimum length are eligible