Samuel Dare
  • Member for 5 years, 8 months
  • Last seen more than a month ago
What is the difference between Primary Key Contact ID, Contact Key, Subscriber Key and Subscriber ID?
Accepted answer
42 votes

Subscriber Key: An Email Studio attribute that is used as a unique identifier for contacts records. Has a one to one relationship with subcribers and is immutable (cannot be changed once set). This is ...

View answer
Contact Unsubscribed - where do they go?
Accepted answer
9 votes

When a contact unsusbcribes, they have their status on the AllSubscriber's List changed to Unsubscribe, so any messages sent to them will be held. In your case, even though you are using the same ...

View answer
Where do I view impression tracking?
Accepted answer
7 votes

Impression tracking allows you to track links built with ampscript. This is because when you build links with amspcript, they will not have friendly names unless you use Impression Regions or alias ...

View answer
SQL Incorrect syntax near ')'
6 votes

Remove the last , before the bracket. It's the last item and doesnt need to be followed by a ,

View answer
Adding additional column in All subscriber in Marketing cloud
Accepted answer
6 votes

You need to add it as an additonal attribute in profile management. Not only will the all subscribers list contain this additional column, but so would other lists. References: Create profile and ...

View answer
How can I access _subscribers data view from child business unit?
Accepted answer
5 votes

You need to prefix "ent" eg ent._subscribers

View answer
Individual Email Results stopped showing
Accepted answer
5 votes

Yes we have. There is an issue with your connector and you would need to refresh your SFMC token in Salesforce. If this doesnt work log a ticket with support. Reference: Clear Token

View answer
Automation Query Error in Marketing Cloud
Accepted answer
5 votes

The issue is with SMTPBounceReason. This field can return an excess of 4000 characters. To bypass this, remove leave the length field blank. This will force it to VARCHAR(MAX) (Over 4000 characters). ...

View answer
Query timing out, but looks right
Accepted answer
5 votes

The s.TriggeredSendCustomerKey = o.TriggeredSendCustomerKey is way more computationally expensive than AND s.TriggeredSendCustomerKey IN ('40712') AND o.TriggeredSendCustomerKey IN ('40712') ...

View answer
Using CASE to update a field
Accepted answer
5 votes

The problem is that you already have status by select * (status was already present in the table). I would advise you either don't use the select * or change the alias of the case function e.g. ...

View answer
Explaining AMPscript "MOD" function
Accepted answer
5 votes

Modulo is a core programming concept. It returns the last remaining digit. %%=Mod(@Outputday, 10)=%% (this shows 5, expected 1.5 as 15/10 = 1.5) 15/10 - Ten goes in 15 1, remainder 5. %=Mod(@...

View answer
Ampscript and deliverability
Accepted answer
4 votes

No it can’t. Ampscript is rendered server side hence only lives in the marketing cloud execution environment. Therefore it never hits the client and doesn’t affect delivery. The content the ampscript ...

View answer
What is SOAP Endpoint while connecting SFMC using Mulesoft?
4 votes

These depend on what stack you are on. you can check what stack your are on by: Going to trust.marketingcloud.com and entering your MID number log into marketing cloud and check the prefix to the ...

View answer
Mass unsubscribes
Accepted answer
4 votes

Follow these steps: Create a CSV with their Status, SubscriberKy and EmaiAddress Populate the status as for each contact as "Unsubscribed" Import this into the All Subscriber's List Note: If you ...

View answer
Unsubscribe Test - How to Check
Accepted answer
4 votes

You can search the All Subscribers list for their status, or query the _Subscribers Data view returning the EmailAddress and Status. The query should look like this SELECT EmailAddress ,Status ...

View answer
Ordered Data Extension into 3 ordered segments
Accepted answer
4 votes

Adam Spriggs has done a very good blog about this on his site: T-SQL Split Queries You would basically have to select your first populate then a left join with the old data extension and new one, ...

View answer
Email delivery time
Accepted answer
4 votes

Short Answer: No Explanation: The system also takes time to get its act together. Things rarely happen real time as it's goes through SFMC's Outbound Mail Messaging Pathway . Delivery times are ...

View answer
Connecting Marketing Cloud Child and Parent business unit to different salesforce instances
Accepted answer
4 votes

Out of the box, you can only connect one SF instance to your marketing cloud instance. To connect to more than one SF instance you would need to have multi- org provisioned in your account. Proceed ...

View answer
Export Data Extension data to Email, not FTP?
Accepted answer
4 votes

Short Answer: No Explanation: The two methods of exporting data from a data extension are : If the file is less than 20 MB it can be downloaded to your pc. Files larger than this will have to be ...

View answer
Did Audience Builder and Contact Builder merge?
Accepted answer
4 votes

Contact Builder is responsible for aggregating customer data from multiple source into a single customer view, known as the contact model in marketing cloud. For more information refer to the official ...

View answer
Bulk Delete from All Subscribers List
Accepted answer
4 votes

After a month long tussle with Marketing Cloud Support, I was finally able to resolve this. Our current set up is an Enterprise 2.0 account. The recommended method was to export the All Subscriber ...

View answer
List Import Error: Invalid Context Status
Accepted answer
4 votes

Figured out what was wrong. Initially the list was 2.2M long and I chose to go with the automatic mapping suggested by the wizard. This imported about 1.7 M customers and failed on the remainder. To ...

View answer
Finding MIN(1) date in a data extension - error message about aggregate functions
Accepted answer
3 votes

When you use an agregate function (e.g COUNT, MIN, AVERAGE, MAX), you have to finish the statement with a GROUP BY clause and include any column that is not agregrated. In your case it would be ...

View answer
A Question on Marketing Cloud Connector and AMPscript
3 votes

When you use campaigns to send emails via the connector, marketing cloud imports the campaigns as a Data Extension (and is visible in Salesforce Data Extensions for days). What this means is that ...

View answer
Custom Preference Page - External Key (Generate it / Retrieve preferences)
Accepted answer
3 votes

You would create the a cloud page in web studio and link it to the email via the CloudPageURL Function. The beauty of this is it encryts subscibers context data (e.g subscriberkey, emailaddress). You ...

View answer
Delete All Subscriber and Upload Lists again
3 votes

Although not recommended, you can delete subscribers from the all subscribers list. As opposed to doing in the the way you have highlighted, I would advice the following: Import the subscribers you ...

View answer
Booking date < = 30 days from the departure date. how we can achieve this requirement using DATEADD function In marketing cloud
3 votes

Almost there . Your code will return information 30 days after the departure_date__c. Change +30 to -30. SELECT Id , departure_date__c ,Booking_date__c FROM Reservation_DE WHERE Booking_date__c <...

View answer
Bulk Updates - Salesforce Marketing Cloud - Excel Connector
Accepted answer
3 votes

The Salesforce Excel Connector is to tool that works with Force.com (i.e Core Salesforce.com) and not Salesforce Marketing Cloud. Although these platforms are owned by the same company, it is ...

View answer
Salesforce Marketing Cloud SOAP API: Which Username and Password I need use for SOAP API calls?
Accepted answer
3 votes

What you need is your username and password (the same one you use to access SFMC). You would need to ensure that your user is a "API enabled" first though. See below from SFMC documentation: ...

View answer
Developer Accounts for ExactTarget
3 votes

This has been dormant for a while but for anyone looking for this in 2017... It's still not available. However if you work for a Salesforce Partner, you can have one provisioned . This version doesnt ...

View answer
1
2 3 4 5
9