8

Yes this is frustrating but "expected behavior". It's not unique to importing Salesforce records either. If you have a Sendable Data Extension and complete a Guided Send Email, then repeat this again at a later date with updated email addresses in the in the Sendable DE, the emails will be sent to the previous Subscriber. The email address in the Sendable ...


6

In your scenario, you'd use the update SSJS function to change the status of the subscriber. Here is an example: <script runat="server"> Platform.Load("core","1"); var subscriber = {"Status": "Active"}; var subObj = Subscriber.Init("Subscriber_Key_Here"); var status = subObj.Update(subscriber); </script>


6

First, you need to create a sendable data extension, which at least should contain your subscriber key. This will be populated by querying Subscribers Data View, with your criteria defined in the SQL Query. Based on your use case, you should filter on fields: DateJoined and Status. Once you have found the subscribers you want to delete, you can use the ...


5

Update It has just occurred to me that it is possible to retrieve Email Subscriber Profile Attributes using Data Binding. I don't know why this didn't occur to me earlier. Simply use the string: {{Contact.Attribute."Email Demographics".sub_id}} Note that this will only work for required attributes. If sub_id is nullable (that is, it does not contain a ...


5

This is a feature called Event Durability. It is expected that the client retains the last replayId it has seen, and pass this in to the streaming handshake to resume where they left off. There's no way to clear this early and yet provide durability. The events do drop off after 24 hours. You will need to modify your code to remember the last replayId.


5

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, ...


4

Checking for GUID IS NOT NULL should work: SELECT * FROM table_name WHERE TACTIC_ID = '0088' AND LOCALE = 'US' AND ACTIVE = '1' AND GUID IS NOT NULL


4

As long as the account is an Enterprise 2.0 account, you can query Profile Attributes by accessing the _EnterpriseAttribute data view. Data View: EnterpriseAttribute Simply do a join onto the _EnterpriseAttribute table, and you'll have access to all of your fields.


4

Platform events are inherently momentary. They don't have a duration as such, but they are stored on the platform for 24 hours to facilitate replay. Events exist in a channel, a stream, which is watched by one or more subscribers. They aren't independent objects, they don't store state, and they have no permanence - they simply represent some occurrence ...


3

You need to configure the triggered send to add the subscribers to the list, as otherwise only the email is sent like in your case. Add subscribers to this listDetermines whether the list accepts new subscriber information of subscribers who trigger this email interactionIf selected, the send adds the subscriber to a selected list if that email address ...


3

To my knowledge, the only two status values that an end user is able to set is either 'Unsubscribed' or 'Active'. According to Global Support, the other two statuses are for internal (SFMC) use only. To be able to manipulate or otherwise make use of Bounce/Held, you would need to create different global suppression lists for each and import/edit these ...


3

As per the sfmc documentation there is no option to set a retention policy on the All Subscribers list. However, there are ways to purge the subscribers within the account. Manual option: Write a sql query to create a target list that needs to be purged. Then export the DE to FTP as a txt, csv file where the file will be re-imported into a new list. Then ...


3

That is correct, opt-in can only be done manually, or opt-in from mobile or via API. Opt-out can be done via Import in Mobile - All contact and populate the Status field with the value Unsubscribe (MobileConnect Demographics).


3

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 wish to delete into a list. Delete the list Select the option to also delete them from the all subscribers list. Note: If you have an enterprise 2.0 ...


3

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 can also pass additional data as attributes within the function. On the cloud page, you would retrieve the parameters using the RequestParameter Ampscript ...


3

As the Subscriber Key should be unique per subscriber/user/contact and not per journey entry this workaround isn't a good one in my opinion. With this workaround you would have multiple records for the same contact in your All Subscribers list. I rather suggest fixing this problem on the journey level. However, the solution depends on the way your journey ...


3

To start at the basics, there are two types of data structures, which are data extensions and lists. And a group is a segment of a list. As Journey Builder only works with data extensions, you cannot use a group as an entry source for a journey. To better understand when to use which data structure, check out the documentation article "List versus Data ...


2

If you mean to check all the subscribers you have in a particular DE that contains their SubscriberKey, you can write a query to join these records on the _Subscribers data view to determine their subscription status in All Subscribers. https://help.marketingcloud.com/en/documentation/exacttarget/interactions/activities/query_activity/data_view_subscribers/


2

The options recommended: Journey Builder sends (cause these are easy) can actually deal with these scenarios using Population as a main source of the channel identifier (email address) and then within the journey configuration you can actually overwrite that selecting the email address from event source data extension. Assuming that you have email address ...


2

@cmbob I've ran into this issue as well. How it was explained to me by support is that the business unit level data view, _Subscribers, only contains records that have a different status from the parent. So, if a records is 'active' in both the parent and child, then that record will not exist in this data view. The best way I have found for determining ...


2

Based on what you have said now, you will need to join the _Open data view with the _Click Data view. This will allow you to grab the correct information and activities you need, I have written a query that will get what you have requested so far plus the calculated fields you require. Calculated Fields Email Clicked (Boolean Field) Email Opened (Boolean ...


2

IF you have a Profile Attribute configured on your account e.g. Greeting, and if you had a field in your Sending Data Extension as the same name i.e. Greeting; then at time of send, the value of Greeting in your Data Extension will be added to the Profile Attribute in all Subscribers. If you then send an email to another data extension which doesn't have ...


2

Assuming you have a significant amount of subscribers, I broke this into two queries. I am sure there are many other SQL experts that could likely make this even better, but I think this should get the job done for you. YOUR DE: (NO_OPEN_6months) SubscriberKey | JobID | SubscriberID | EmailAddress | Sent Date | AccountID | Not_Opened I would ...


2

There is no way to 'merge' subscribers. Every individual Contact with a unqiue Subscriber Key also had system defined attributes which can only be changed by Salesforce Service Team and requires their side action, which is quite costly. They would be able to change Subscriber Key from one value to another and retain the history, but not merge two (or more) ...


2

Below is the quick answers to your questions. Followed by some good reference points. Scenario 1: Yes they would be sent to. Transactional emails also, by default, ignore opt out status - unless you choose option to honor it. Yes added to All Subscribers. Status would be active Scenario 2: Yes they would be sent to. Yes added to All Subscribers. ...


2

You shouldn't tamper with the Subscriber Key relationship when creating a DE from a Triggered Send DE template. The generated relationship of SubscriberKey field should equal the Subscriber Key value in your Triggered Send DE; don't override this relationship. As per the documentation, the Triggered Send core SSJS function that is used to send a Triggered ...


2

It means that the contract was signed for 75000 Contacts - and if this amount is exceeded, Salesforce will bill the client for extra. Do note that the amount of Contacts does not equal the amount of Subscribers in AllSubscribers list. Contact in Marketing Cloud is a sendable record with a unique ContactKey identifier. Meaning if you set up Marketing ...


2

Turns out the case-sensitiveness put a block on my attempts. results[0].Status (with the S capitalized on Status) gave the expected result. Thanks for the comments that pointed out the issue.


2

Had the same issue with the recent Winter 19 release and resolved it by replacing the MC components. First remove the Marketing Cloud custom links on Contact, Lead and Campaign object layouts in Sales Cloud. Then on the layouts add the Visualforce Pages AccountActions (depends per object) and drag to the place in the page layout. Example from Campaign ...


2

You cannot delete Platform Event records. This is mentioned in the documentation: Unlike custom objects, you can’t update or delete event records. The only way you can delete event records is by deleting its definition altogether: When you delete a platform event definition, it’s permanently deleted.


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