Skip to main content
Argomenti#SFMC Consultant

#SFMC Consultant0 utenti parlano di questo argomento

Anirudh Venugopal Warrier (Sr SFMC Associate presso Epsilon) ha fatto una domanda in Salesforce.org Marketing Cloud
6 feb 2024, 06:31
SQL Query Doubt

Is there any SQL Query to update an attribute Touch = 'Touch2' in the DE only if Propensity values lie between 0.6 and 0.7 and Lapsed days lie between 60 and 80 and Qualfying Date is null. Currently tried Update function in SQL , that seems to be not working 

 

#Marketing Cloud #SFMC Consultant #Sql Queries

2 risposte
  1. Nobuyuki Watanabe (NAC / FPT Japan Holdings Group) Forum Ambassador
    6 feb 2024, 13:58

    Hi, @Anirudh venugopal

    In Marketing Cloud, the UPDATE statement is not supported; only the SELECT statement is supported. Therefore, when configuring a SQL Query Activity, you can choose Update under Data Action. If you choose to use Update, it is necessary to set a primary key within the data extension.

     Hi, @Anirudh venugopalIn Marketing Cloud, the UPDATE statement is not supported; only the SELECT statement is supported.

Anirudh Venugopal Warrier (Sr SFMC Associate presso Epsilon) ha fatto una domanda in Salesforce.org Marketing Cloud
16 gen 2024, 09:58
Reports in SFMC on IP Address

Is there any Reports in SFMC based on IP Address where i can see KPI's such as opens, clicks , bounces for a particular IP Address?

 

#Salesforce #Marketing Cloud #SFMC Consultant #Marketing Cloud

1 risposta