7 votes
Accepted

What are the benefits of Subscriber key Migration?

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 ...
user avatar
  • 5,447
6 votes

How to Delete Subscribers From All Subscribers list

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 ...
user avatar
  • 17.1k
5 votes
Accepted

AMPScript Lookup From Child Business Unit

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: ...
user avatar
  • 7,432
5 votes
Accepted

Adding BU to Corporate edition : what impacts?

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 ...
user avatar
  • 17.1k
4 votes

Get all fields in DE via API or Query

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....
user avatar
  • 7,432
4 votes
Accepted

Find active subscribers for each month for last 6 months

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 ...
user avatar
  • 10.6k
4 votes

Exact Target: Customize Unsubscribe link with encoded Parameter

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 ...
user avatar
4 votes

Integrate data in the child or parent BU in SFMC?

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 ...
user avatar
  • 17.1k
4 votes
Accepted

Encrypting Marketing Cloud Reports

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 ...
user avatar
  • 10.6k
4 votes
Accepted

Can 2 different BU see only records created by themselves on a shared DE?

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, ...
user avatar
  • 5,447
4 votes
Accepted

Enabling multi-org for specific BUs only

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 ...
user avatar
  • 10.6k
4 votes
Accepted

Disable Multi Factor Authentication (MFA) Notification in SFMC

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
user avatar
  • 7,432
4 votes
Accepted

Connecting a Mobile App to multiple BUs

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 ...
user avatar
  • 4,163
4 votes

Can I connect a child BU and leave the parent BU disconnected?

If you truly want the DE to be "in the Child BU" (note the quotation marks*), indeed you would need multi-org. Then the synchronized DEs show up in the Child BU / Synchronized Data Extension ...
user avatar
3 votes
Accepted

Update Data Extension in Parent BU when Data Extension in Child BU gets updated( move data from Child BU to Parent

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 ...
user avatar
  • 10.6k
3 votes

Get all journey ids via API/Query?

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 ...
user avatar
3 votes
Accepted

Pulling Data from _Subscribers at BU level with SQL Query

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):...
user avatar
3 votes
Accepted

First "0" is missing when displaying a number starting with "0", with GTL

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

landing page - sharing with another Business unit

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 - ...
user avatar
  • 17.1k
2 votes
Accepted

How to create new API Integration package for each Business Unit in marketing cloud

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 ...
user avatar
2 votes

Contact vs Subscribers in BUs

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 ...
user avatar
  • 7,432
2 votes

Querying system data views only for parent account

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] ...
user avatar
  • 4,358
2 votes

How a non-prod BU affects a Prod BU on reputation/metrics terms?

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-...
user avatar
  • 28.2k
2 votes

How a non-prod BU affects a Prod BU on reputation/metrics terms?

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 ...
user avatar
  • 7,432
2 votes
Accepted

How to Delete Subscribers From All Subscribers list

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 ...
user avatar
  • 3,676
2 votes

SFMC SSL Configuration

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 ...
user avatar
2 votes
Accepted

Error appending a Data Extension referenced in query

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 ...
user avatar
  • 28.2k
2 votes
Accepted

BU structure for MultiCloud setup with Einstein (Marketing, Commerce, Sales/Service)

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 ...
user avatar
2 votes
Accepted

Limit number of emails sent to user across multiple Business Units with Override Option

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 ...
user avatar
  • 4,358
2 votes

Inner Join with Data view and data extension in SFMC not working

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 ...
user avatar
  • 1,359

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