Category: Marketing Cloud
-
What Are _PushAddress and _PushTag Attributes?
Question What Are _PushAddress and _PushTag Attributes? Answer The _PushAddress and _PushTag Data Views in Salesforce Marketing Cloud store information about device-specific push notification details and tagging information for personalization and targeting, respectively. You can retrieve their attributes by using the DataExtensionField retrieve request in the SOAP API or querying them in SQL. Here are…
-
Why Does Query Timeout in Automation Studio?
Question Timeout Error in Automation Studio but Not in Query Studio I’m encountering an issue where a query runs successfully in Query Studio within a minute but times out in Automation Studio. Details: Here’s the query causing the timeout issue: My Questions: Keywords: Marketing Cloud, Query Studio, Automation Studio, Query Timeout Answer The issue likely…
-
How to Automate Contact Deletion in Marketing Cloud?
Question With the GDPR laws in place, it is important to ensure that contacts can be removed from Marketing Cloud. I am currently trying to automate the process of contact deletion using existing tools and looking for possible solutions. Currently, I am using the Remove() function from the Subscriber Object in the Core SSJS library…
-
SFMC SQL Query for 90 Days Filter
Question How to Retrieve Records in SFMC SQL Where a Date Field Equals 90 Days from Today? I’m facing issues with an SQL query in Salesforce Marketing Cloud (SFMC) to retrieve records where the date field (Check_In_Date__c) equals exactly 90 days from today. I do not want to retrieve records between today and the date…