Skip to main content
주제#Filter Data Extension

#Filter Data Extension토론 중인 항목 4개

질문해 보세요...
Taylor Thomas 님이 #Marketing Cloud에 질문했습니다
9월 17일 오후 3:06
Supressing contacts from data extension

I pulled a list of unengaged subscribers that have not opened at least one of our last 3 monthly sends. I want to suppress these contacts from our filtered data extension which we use to send to. How do I do this? And how would I keep this automated to continuously remove unegaged contacts. 

 

#Marketing Cloud  #Filter Data Extension

답변 3개
  1. Mradul Srivastava (Pepsico)
    9월 22일 오전 6:43

    @Taylor Thomas

    If you don't want to use the SQL queries then you can utilize measures. This is not widely used feature anymore because everyone prefer to write code instead of looking for an out of the box solution. 

    Review this help document -

    https://help.salesforce.com/s/articleView?id=mktg.mc_es_measures.htm&type=5

     

    Once you will configure your measure, you can then use it in the fliter criteria while creating filtered data extension too.

답변을 작성하세요...
0/9000
Intkhab Samani (Hytech professionals Salesforce Developer) 님이 #Marketing Cloud에 글을 올렸습니다
7월 23일 오후 4:41

How can I get all the Order Items in data Extension  

 

Query :  

SELECT 

    p.[FirstName], 

    p.[LastName], 

    p.[Id], 

    p.[Name], 

    p.[PersonContactId], 

    p.[PersonEmail], 

    p.[Membership_End_Date__c], 

    m.[Auto_Renew_Formula__c], 

    p.[Is_Member__c], 

    p.[PersonId__c], 

    p.[Deceased__c], 

    p.[Exclude_From_Renewal_Letters__c], 

    p.[Credit_Card_Expiration_Date__c], 

    p.[Member_Type__c], 

    p.[Membership_status__c], 

    p.[IsPersonAccount], 

    p.[Continuous_Member_Since_At_Least_Date__c], 

    p.[Exclude_From_Mail__c], 

    p.[AANP_Membership__c], 

    p.[Exclude_From_Email__c], 

    p.[PersonHasOptedOutOfEmail], 

 

    o.[TotalAmount], 

    o.[OrderNumber], 

 

    oi.[OrderId], 

    oi.[Product2Id], 

 

    pr.[Name] AS Product_Name, 

 

    pm.[Name] AS Payment_Method_Name, 

    pm.[ChargentBase__Card_Expiration_Month__c], 

    pm.[ChargentBase__Card_Expiration_Year__c], 

    pm.[ChargentBase__Card_Last_4__c], 

    pm.[ChargentBase__Card_Type__c], 

 

    

    co.[ChargentOrders__Charge_Amount__c], 

    co.[ChargentOrders__Payment_Start_Date__c], 

    co.[ChargentOrders__Payment_Status__c], 

 

    DATEDIFF(day, GETDATE(), p.[Membership_End_Date__c]) AS [Days_To_Expire] 

 

FROM [Person Account Master DE] p 

 

LEFT JOIN Membership__c_Salesforce m 

    ON p.[AANP_Membership__c] = m.[Id] 

 

LEFT JOIN ChargentBase__Payment_Method__c_Salesforce pm 

    ON p.[Auto_Renewal_Payment_Method__c] = pm.[Id] 

 

LEFT JOIN Order_Salesforce o 

    ON m.[Order__c] = o.[Id] 

 

LEFT JOIN OrderItem_Salesforce oi 

    ON o.[Id] = oi.[OrderId] 

 

LEFT JOIN Product2_Salesforce pr 

    ON oi.[Product2Id] = pr.[Id] 

 

 

LEFT JOIN ChargentOrders__ChargentOrder__c_Salesforce co 

    ON o.[Id] = co.[Standard_Order__c] 

 

WHERE 

    DATEDIFF(day, GETDATE(), p.[Membership_End_Date__c]) = 14 

    AND p.[Auto_Renew__c] = 'true' 

    AND p.[Is_Member__c] = 'true' 

AND p.[Deceased__c] ='false' 

    AND p.[Membership_Status__c] = 'Active' 

    AND p.[IsPersonAccount] = 'true' 

    AND p.[PersonEmail] IS NOT NULL 

    AND p.[Credit_Card_Expiration_Date__c] IS NOT NULL 

    AND p.[Credit_Card_Expiration_Date__c] > p.[Membership_End_Date__c] 

 

Based on abovve Query I m getting Exact Record In Query Editor the Same resullt I want to have In DE as well but what happening instaed i m Getting Only 1 Result in DE  

 

How can I get all the Order Items in data Extension Query : SELECT p.[FirstName], p.[LastName], p.[Id], p.[Name], p.[PersonContactId], p.[PersonEmail], p.[Membership_End_Date__c], m.

 

 

Data Extension Congiguration.png

 

 

Query Studio - Multiple Entries.png

 

 

 

#Marketing Cloud  #Filter Data Extension

댓글 1개
  1. Mradul Srivastava (Pepsico)
    7월 24일 오전 5:35

    @Intkhab Samani

    Query Studio results doesn't include primary key. However, the Data Extension where you are storing the data has only 1 primary key field - ParentContactID. 

    So, if you want all three records to be stored in the Data Extension, you will need to either -

    • Remove the primary key, or
    • Create a composite primary key using additional fields.
댓글을 작성하세요...
0/9000