Hello SFMC

  SFMC Daily is a short blog of 5 Q/A which will help you keep up to date with your SFMC Interviews. Lets solve the SFMC Puzzel with Astro !!! Q - What is the difference between an Engagement Split and a Decision Split? A -  Decision Split: based on contact attributes. By placing a Decision Split in a journey, Journey Builder evaluates the data of that specific contact, sending them down the path they are eligible for. Engagement Split: based on contact engagement/activity. Based on whether a customer opens, clicks an email link, or the email bounces, the Engagement Split activity sends customers down the path they are eligible for. Q - What are some of the standard SFMC email reports? A- Account Send Summary: displays all responses for an SFMC account, organized by send. Email Performance by Domain: displays email sends results for each domain sent to for a single send. Email Send: displays how many emails have been sent from the account. Subscriber Engagement:displays which ...

Marketing Cloud application uses JavaScript code processed by Marketing Cloud servers. Instead of using the browser to render the JavaScript on the client-side computer, Marketing Cloud executes the JavaScript on the server when rendering. Use Core server-side JavaScript functions to personalize landing pages and create applications to run on Marketing Cloud. Use Platform server-side JavaScript functions to work with messages, landing pages, and applications. You should exclusively use AMPscript or Platform object server-side JavaScript functions in email messages and reserve your use of Core library server-side JavaScript to landing pages and applications. You can use SSJS just like ampscript to insert data/update data into a Data Extension . <script runat="server"> var rows = Platform.Function.InsertData("CustomerData",["FirstName","LastName","Email"],["Joe","Smith","jsmith@example.com"]); </...

AMPscript is a scripting language that you can embed within HTML emails, text emails, landing pages, SMS messages, and push notifications from MobilePush. The system processes the script at the point where you include it in the message to render content on a subscriber-by-subscriber basis. You use AMPscript to include information from your data extensions in your messages and to update data extensions with information from your landing pages. Ampscript can be used to personalize the email to include the individuals information like first name. For this in your email include - Dear %%first_name%%, ..................... where first_name is the data extension field name. Ampscript can also be used to  in a landing page to interact with the web service SOAP API to create a triggered send . %%[ var @emailaddr, @ts, @tsDef, @ts_subkey, @ts_sub, @ts_statusCode, @errorCode SET @emailaddr = "help@example.com" SET @ts = CreateObject("TriggeredSend") SET @tsDef = Cr...

There are two different ‘types’ of automations you can make inside of Automation Studio. They are the Scheduled Automation and the  File Drop Automation .  These automations trigger when a file is dropped in a FTP location. File Drop Automation includes below options - Use File name pattern Similar to LIKE in SQL, the file name pattern looks for string in the file name.  Eg. '%abc%' No File name pattern If you set it to run on all files (no filename pattern), this will ‘lock’ that folder and will not allow any other file automations to select this folder.  It is not recommended to use the Import or Export folders  for this activity, but to instead create custom subdirectories for these automations.

SFMC Mystery is a Puzzle to help ace your interview in SFMC. Lets solve the below questions and help find Astro !!!  1. ___________ is a list of subscribers who have opted-in to receive the communications. 2. _________ and _________ are two different ways to segment the data. 3. __________, __________ and _________ are the three steps to send the data from SFMC to FTP using automation studio? Answers below ... Answers below.... Answers: 1. Publication Lists 2. Data Filters  , SQL 3.  SQL (will store the data in a Data extension), Data Extract (Data extension extract option),  File Transfer (Safehouse to FTP)

Welcome to SFMC Daily.  SFMC Daily is a short blog of 5 Q/A which will help you keep up to date with your SFMC Interviews. Lets solve the SFMC Puzzel with Astro !!! Q- How does Dynamic Email work? You can define a dynamic content block in an email to display (render) information based on the subscriber’s attributes, data extension values, or audiences. Two ways: 1.    you can build a dynamic content block adding rules by point and click in email editor 2. using ampscript if else as well we can achieve this. Q- Name the entry sources in Journey Builder. Journey Builder Entry Sources include: Data Extension : contacts in a sendable data extension (the most commonly used). Salesforce Data:  contacts are added to the entry source, driven by something happening in Salesforce (eg. a record being created or updated). Audience:  if you’re using Audience Builder to create and publish audiences. Event:  for date-based events (eg. birthdays, anniversaries, reminders, ...

Course Link : Why use Data view ? Query data views using Automation Studio for up to six months of Marketing Cloud subscriber and journey information. Few Most Used Dataviews: Open Dataview:  Query this data view in Automation Studio to find email opens for your Marketing Cloud account. Sent Dataview:  Query this data view in Automation Studio to find the subscribers sent emails from your Marketing Cloud account. Job Dataview:  Query this data view in Automation Studio to find data on Marketing Cloud email send jobs. Sample Query: Data Views to retrieve how many times a user opened an email in the last 60 days. SELECT o.SubscriberKey as email , COUNT ( * ) as Count_Opens FROM _Open o WHERE o.JobID IN ( SELECT distinct s.JobID FROM _Sent s WHERE s.EventDate > convert ( date , getDate() -60 ) ) and o.isunique = 1 GROUP BY o.SubscriberKey Dataview Schema Table -  https://sfmarketingcloudhome.files.wordpress.com/2021/02/dataviews_2...

Synchronised Data Extension Vs Data Extension Data extension   Data extension is like a table with different columns that can hold data in rows. You could use this data extension to store Subscriber information or related information that will be used for sending emails. You have to mark it as Sendable in order to send emails from Data extensions. Syncrhonized Data extension This data extension is mainly used to populate Salesforce Standard/custom object data from Sales cloud/service cloud into Marketing cloud. We should integrate Salescloud with Marketing cloud using Marketing cloud connect  before creating Syncrhonized Data extension. Salesforce Data Extensions in Marketing Cloud Connect A data extension is a table that contains your data. With Marketing Cloud Connect, push tracking data from the Marketing Cloud back to your Sales or Service Cloud orgs using Salesforce data extensions (SFDEs). Push any tracking data for emails sent to SFDE audiences using Marketing Cloud Sal...

Send classifications include these components: Delivery Profile Sender Profile You create the delivery profile and sender profile separately before you create the send classification.  Sender Profile A sender profile within Marketing Cloud Setup specifies the From information for a send in a central location. Marketing Cloud Email reuses that information across multiple sends without requiring selection each time. The sender profile contains the name and address that the message appears to be from in the subscriber's email client. Delivery Profile A delivery profile within Marketing Cloud Setup specifies the delivery information for a message in a central location. Marketing Cloud reuses the information, across multiple sends, without requiring selection of the information each time. When you create a delivery profile, specify the IP address to use. If you do not use a private domain, you select the account default. If you use one or more private domains, you can select the privat...

Evergage - Interaction Studio Salesforce Interaction Studio integrates with company systems to enable companies to gain a comprehensive view of each customer and prospect, develop in-depth behavioral analytics and leverage machine learning capabilities based on customer and prospect interaction data. Using Interaction Studio, companies can deliver maximally relevant, individualized user experiences throughout the customer journey in real time, during key moments of customer and prospect interaction, and across channels including web, social, mobile, and more. Certification - Interaction Studio Accredited Professional Exam Exam Registration Procedure -  1. Get access to  https://partners.salesforce.com/ 2.  Complete Partner Learning Camp Course on Interaction Studio 3. Apply for Exam using Examity platform from PLC Dashboard. 4. Schedule and Task Exam. Some Major Topics to cover for exam are: 1. Sitemap Implementation 2. Pagetypes, Contentzones, Events and Listners in Site...

SFMC ADMIN works on mainly below set of activities - 1. User Access Management 2. Business Unit Creation/Management 3. Setting up FTP. 4. SFDC Integration with SFMC using Connector. 5. User Audits. 6. Role Creation/Role Assignment. 7. Sender Profile Creation. 8. Send Classification Setup. 9. Out of the Box Report Creation 10. Check Email Delivery in My Tracking 11. Monitor Automations/Report Failures 12. Contact Delete based on California Consumer Privacy Act (CCPA) 13. Data Extension Creation, Data Management 14. Checking Data in All Contacts to find out relevant Information. 15. Checking Subscriber Status in All Subscribers 16. Sharing TriggerSend Definition ID to Dev Team 17. Creating Installed Packages 18. Sharing ClientID/Secret to Relevant Teams. 19. Configuring Sync DE. Certifications Salesforce Certified Marketing Cloud Administrator Link >> https://trailhead.salesforce.com/credentials/marketingcloudadministrator