Hi @RyanMoravick, Great, as always happy to help. Regards, Celia

Hi @RyanMoravick, You can use the following ones:WHERE transactionDate = DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)WHERE transactionDate = CURRENT_DATE - 1 Both methods should give you the results from yesterday. ¡Hope this is helpful! Regards, Celia

Hi @jpetermarias, Sure I will be in touch for any queries and I'll let you  know how all it goes.

Hi @RyanMoravick , The issue might arise if the transactionDate may  include date and time.  To manage this you can try with the following options: -Using DATE(): WHERE DATE(transactionDate)='2024-09-04'-Using a range of time to cover the entire day: WHERE transactionDate >= '2024-09-04' AND transac...

Hi @random_guy_tech, To my understanding by product profiles you mean how to manage users and groups.I share with you some documentation links:Users Management (Advanced, Basic)Organizational UnitsList of RolesManaging groups and usersIf you need more clarification, just let me know. Regards,Celia 

Hi @NickMannion, To manage roles, permissions, and access labels within the tool for your needs you can perform the following steps: 1.Limit editing of Audience Criteria:-Use custom user roles to assign permissions. Create a role that allows only certain users to edit audience criteria, ensuring tha...

Hi @Tooka, Click Through rate is based on uniqueclicks/delivered (Taking into account that denominator for rate calculation is based on delivered only). For open rate and other metrics check this link: Indicator calculation | Adobe Campaign Regards, Celia

Hi @SachinJa4, Practice tests available on the Solutions Partner portal will help you to understand the concepts and the mechanic covered within the exam. You may find some questions of the practice tests in the real exam. In any case, it is not an indicator that you will do well in the final exam, ...

Hi @tommy_8 , The SQL error occurs because the query is trying to insert data into a temporary table while joining other tables, but one table ( "wkf122737358_query2") does not exist or is incorrectly referenced. Despite profile substitution is not enabled, the query still attempts to join with the ...

Hi @AndrewJo5, There isn't really a "table" component available in the drag and drop editor. What I normally do is create a table layout directly within the HTML editor. I share with you and example that creates a table with two columns.<table width="100%" cellpadding="0" cellspacing="0" border="0">...