Hi Ketan,To receive the status update for SMS deliveries you need to make sure the SMS process is running . This can be confirmed from the Monitoring tab of the home screen in Adobe Campaign.If you see the SMS process is running , you need to check for errors in the logs to find the reason why the S...

Hi Senthil,This will need a deeper look into the workflow design and schema details . The attribute username is not OOTB in nms:recipient so we need to check how the structure is updated and many other things.It will be best if you can open a support ticket regarding this. Else , please share the wo...

Hi Rama,I think you probably should look at Integrating Campaign and Analytics as tracking in Campaign is limited to clicking on Links sent by you and does not capture if a Purchase was converted.If Analytics is integrated , the click in Campaign can be mapped to a Webpage in Analytics and then the ...

Hello Jameel,You can just add the internal name of the delivery on the same filtering criteria. I have updated the screenshot with the details again.

Hello ,You can query on the Recipient table with filtering condition like :" TrackingLogRcp does not Exist such as Url type=Open" AND "Date is on or after (current date-3). This should give you the recipients who have not opened emails in the last 3 days.Please find a screenshot for how the query sh...

Hi Courtney,you can check this documentation on how to use read-list : https://docs.campaign.adobe.com/doc/AC6.1/en/WKF__General_operation_Importing_data.html#Using_data_from_a_list-_Read_listSimply put , you can use a read-list activity directly with a delivery to send the delivery provided the lis...

Hi Lordcohen,If you do not have access to Offers then may be you can Create a workflow and query the recipient table and format your query to something like :recipient id is not empty (or any condition like recipients of a delivery) AND Offer_propostion status = Accepted. It should give you a result...

    Hello Lordcohen,The offers that were clicked should be present in the propositions tab under the offer Category folder in Live offers folder. So you can select the offer from the Categories folder and go to Propositions to view the offers clicked.Alternately , if you have activated offers from t...

Hello Jill,This is the forum for Adobe Campaign , please redirect your query to the correct forum : https://forums.adobe.com/community/premiere_elements

Hello Andrea,I believe the SQL script is generated when you try to update the DB structure . If this is true , the script is editable. Can you change the SET DEFAULT to 1 from 0 and see if the default changes to True.