Monday, February 26, 2024

Trailblazer Community Event: Kolkata Trailblazers Spring 24 Connect

 

Motivation behind this

 
2 Trailblazers community groups have successfully organized in-person event on 24th February, 2024 and it has a great time meeting with Kolkata Trailblazers. Being group leader I would convey my thanks to all of them.

Organizers:


Venue:

Webel IT Park Tower 1, BN4 , Salt Lake Sector V, Kolkata 700091

Attendees: 70+




Sessions:


1) GraphQL in LWC


Speaker: Anamika Mondal

This session covers:
  • Overview
  • REST vs GraphQL API
  • Live Demo
  • Benefits & Limitations
  • Q&A


2) Tips to pass Salesforce Data Cloud Consultant certification


Speaker: Santanu Boral


Glimpse of Event



Join with us at our Telegram Channel

Thank you for joining with us and receiving gifts for all.

Further Reading


Saturday, February 3, 2024

Tips for passing Salesforce Marketing Associate Certification

 

Motivation behind this


Salesforce has come up associate level certification on Marketing, which drives me to brushing up the knowledge on this area and successfully pass this certification on 30th Jan 2024. 

Sharing my tips to prepare and pass this certification for trailblazers.



Exam Outline


Content40 multiple-choice questions and up to 5 non-scored questions
Time allotted to complete the exam70 minutes
Passing score65% (26 answers to correct)
Registration fee: USD 75 plus applicable taxes as required per local law
Retake fee: Free
Delivery options: Proctored exam delivered in an online environment that can be accessed
through Partner Learning Camp (PLC)
References: No hard-copy or online materials may be referenced during the exam
Prerequisite: None



Topics



Preparation




3) Attended and gone through Marketing Cloud Email Specialist Practice Test which is un-proctored and help to judge preparation just before actual exam. Through this is not needed, but it covers the depth of the knowledge.

4) Useful blogs:

Exam Structure


For each question there are only 3 options and only one option to choose. As there are no multi-choice answers, so it will be less confusing on choosing the answers.

Few Important points to cover for exam


Though this certification doesn't have any pre-requisite but if anyone clears Marketing Cloud Email Specialist certification then it will be easier for them. 

Marketing Concepts (28%)


  • Email Message best practices:


  • CAN-SPAM requirements (2 questions):
    • Accurate identify the sender in the header information
    • Subject line should represent the content of email
    • Identify message as an Ad, unless you have express consent from Subscriber.
    • Include physical mail address.
    • Provide Opt-out mechanism
    • Honor Opt-out request promptly. Unsubscribe in 10 days, and mechanism must be operational for at-least 30 days after mailing.
  • Subscriber opt-in, single opt-in vs. double opt-in, opt-in best practices:
    • Don't force people to subscribe
    • Make email signup form/links prominent
    • keep you opt-in short
  • Personalize message with dynamic content
  • Value proposition should be simple and clear
  • Responsive vs. Mobile aware design
  • A/B Testing:
    • Subject lines, Email, Content Areas, From Names, Send Dates & Times, Preheaders.
  • Content Detective:
    • mirrors logic of spam-filters
    • finds potential problems and suggest solutions
  • Validation:
    • Content and data being used for Dynamic Content rules are built correctly.
    • Guide Template language and AMPScript is written properly.
    • validates required elements: Unsubscribe link, physical mailing address.
  • Send Preview:
    • Review email before sending both static and subscriber specific way
  • Test Preview:
    • Combines all forms of test sending in one location (Test Send, Send Preview, UI Test Send)
pay attention to each of the testing tools (3 questions)
  • GDPR rules apply to European Union. (1 question)

Marketing Cloud Engagement Basics (22%)


  • Marketing Cloud Get to know


  • Roles are collection of permissions (1 question)
  • SAP (Sender Authentication Package) helps to improve deliverability of emails to inboxes of target recipients. It consists of:
    • Private Domain, Account Branding, Dedicated IP Address, Reply Mail Management.
  • Send Classification: (1 question)
    • Sender Profile - From information for a send in a central location
    • Delivery Profile - Delivery information of a message in a central location
    • CAN-SPAM Classification - define this as Commercial or Transactional.
  • Roles & Responsibilities of Marketing Team: (1 question)
    • Marketing Manager - Leads strategy, manages team, serves as Admin for MC Engagement.
    • Data Architect - Solution designing, data modeling, leads integration, builds data views, drive data analysis.
    • Content Manager - Deals with creative content.
    • Campaign Manager - Campaign implementation, delivery, QA, campaign approval.
    • Solution Architect - Implements business needs including campaign, automation, audience segmentations, technical configurations, QA and supports deployment
  • Create Email (1 question)

  • Sending

  • Marketing Cloud Engagement Report types (1 question)
    • CloudPages - Access data from Smart Capture form using CloudPages DE
    • Contacts - Total number of billable contact of account or individual contact.
    • Discover - templates with measures and attributes preselected to answer a specific business question.
    • Journey Builder - tracking for emails sent through Journeys
    • Mobile - SMS, tracking of subscribe, unsubscribes
  • Read when to use custom preference center

Email Sending and Journeys (22%)


  • Data Objects:

  • List & Data Extension - similarities and differences
    • List - collection of subscribers who receives communication.
    • Data Extension - you can think about database table. It not only contains sendable data like list, but also relational data like purchases, inventory etc.

  • Profile Center & Subscription Center


  • Contact Key - Unique identifier assigned to Contact
  • Contact Id - A number which Salesforce uses to identify a Contact at backend.
  • Subscriber KeyPrimary key for your subscribers. In Email Studio, contacts are identified by the Subscriber Key, which becomes the Contact Key in Contact Builder.
  • Primary Key - Uniquely identifies rows in Data Extension
There are 3 to 4 questions related to Contact Key, Subscriber key, Primary Key and Relational Table


  • 3 types of Data Extension (1 question)
    • Standard - building custom set of fields.
    • Filtered - create subset or segment from existing DE.
    • Random - randomly select subscribers from source DE.
  • Sendable DE - has send relationship and map to a subscriber. Contacts are added to All Contacts when we send them.
  • Nonsendable DE - reference data used for personalization purpose, e.g. weather, orders, products.
  • Shared DE - shared Data extensions to other BUs upon storing them in Shared DE folders.


  • Send Throttle - sends emails the way you specify every day, starting the day you specify, until all emails send.
  • PreBuild Burst - Send email fast, good for flash sales or emergency messaging.
  • Import data (2 questions)

  • Journey Builder - guides customers through each step of their journey
    • Anatomy of Journey


    • Entry Sources:
    • Contact Entry Settings: (1 question)




Data Management (18%)

  • Filter vs. Query
 

  • Data Extension Templates (1 question)

  • SQL Data Views: (1 question)
    • Bounce Identify and then suppress commonly bounced email addresses from sends.
    • Click and Open - Query these data views in Automation Studio to view click and open data for emails.
    • Complaint - Query this data view in Automation Studio to view complaints data related to emails.
    • Journey - Find a journey's status, created and last modified date, and other general journey information using this Journey Builder data view

Reporting and Analytics (10%)


  • Tracking

  • Reporting

  • Journey Builder Reports: (1 question)
    • JB Email Send Summary - Tracking and engagement metrics for emails sent in journeys over a specified time frame. Choose specific journeys and versions to include in the report.
    • JB Email Sends By Day -  Tracking and engagement metrics for emails sent in journeys, aggregated by day, for a specified time frame, along with specific journeys and versions to include in the report.
  • IP Warming - Gradually increasing volume of the email sent by a new IP address.
Hope it will help you to prepare and pass this exam.

Thanks for reading!

Note: The pictures and concepts have taken from Salesforce materials.

Further Reading

Tuesday, January 23, 2024

Tips for passing Salesforce Data Cloud Consultant Certification

 

Motivation behind this


Salesforce has taken a great initiative on Data Cloud area (previously known as CDP) during Dreamforce 2023, which drives me to gather knowledge on this area and successfully pass this certification on 20th Jan 2024. 

Sharing my tips to prepare and pass this certification for trailblazers.




Exam Outline


Content60 questions
Time allotted to complete the exam105 minutes
Passing score62% (37 answers to correct)
Registration fee: USD 200 plus applicable taxes as required per local law
Delivery options: Proctored exam delivered in an online environment that can be accessed
through Partner Learning Camp (PLC)
References: No hard-copy or online materials may be referenced during the exam
Prerequisite: None





Topics















Preparation



2) PLC Course: Get to know Data Cloud


4) Data Cloud Useful Videos:
5) Data Cloud Related Questions and Answers:
     Many of the similar questions/concepts appeared in the exam.

6) Data Cloud Trail Org Provisioning


Data Cloud Trial Orgs are now available via Partner Learning Camp (Demo Org tab).
Please use Demo Type of DCDO (Data Cloud Demo Org) to request your 30 day Trial org via PLC.
Note in order for the demo org tab to be visible you must complete the ‘Simple Demo Org Fundamentals’ course.
Please review the rules of engagement here: https://sfdc.co/dctrialorgroe
(also includes screenshot on how to request a Data Cloud Trial Org)



Few Important points to cover for exam


Though this certification doesn't have any pre-requisite but if any one has knowledge on Marketing Cloud, then it will be easy for them to pass. If we understand following concepts it will be easy to pass the exam.

Solution Overview (18%)

Overview of Data Cloud and its processes

Maximize clicking on the photo

Data Cloud powers companies with unified, real-time data.

Data Cloud Technical Capability Map

Maximize clicking on the photo



How Data Cloud works?


Core pillars of Data Cloud Capabilities:

  • Connect all your data sources whether batch or streaming data. Data from Salesforce, legacy systems, web, app data and data lakes can be brought into Data Cloud.
  • Prepare your data through transformation and data governance features.
  • Harmonize your data to a standard data model.
  • Unify data with identity resolution rulesets. Connect, match and resolve customer data.
  • Query and analyze data using insights.
  • Use AI to predict behavior.
  • Segment your data and activate to use in various channels to create personalized experiences.
  • Analyze your data using supported analytic tools.
  • Output data to multiple sources to act on data based on your business needs. Data can be activated in Marketing Cloud Engagement, Advertising, Personalization and Intelligence.
  • Continue to review, measure, and optimize data.
Note: There are few questions on the processes and what comes next during the exam.

How marketers can be benefited by using Data Cloud?
  • Create unified customer profiles across all touchpoints by connecting identities, engagement data, customer orders, loyalty, and marketing journeys.
  • Build smarter audience segments using insights and filtering capabilities.
  • Activate data from anywhere across your organization.
  • Capture and unify data from anywhere with a high-scale data ingestion service.
  • Analyze your data using tools like Tableau or Marketing Cloud Intelligence.
Data Cloud Use Cases
  • Data Cloud drives customer success in different industries.
  • Data Cloud provides transparency and security of data gathered from individuals who provide consent for its use and receive value in exchange.
  • Use cases for Data Cloud Capabilities:
    • Gain insights on data streams in real time and trigger follow-up actions.
    • Build complex segments of unified individuals with related data from multiple platforms.
    • Aggregate data from multiple systems to understand a customer’s true lifetime value across multiple accounts and devices.
  • Key differentiator of Data Cloud:
    • Uses Customer 360 Data Model
    • User-friendly interface and built on Lightning
    • Integrate easily with Salesforce products (Sales, Service, Marketing, Loyalty etc.) and AppExchange.
  • Data Ethics:
    • Way for companies to build trust and transparency with their customers and data.
    • Moral guidelines about the gathering, protection, use, and sharing of data and how it affects individuals
    • It's not ethical to store any kind of user information without taking the consent.

Data Cloud Setup and Administration (12%)

  • Data Cloud Provisioning:
    • Sharing rules and other data restrictions in Core CRM doesn't apply to data stored in Data Cloud.
    • Data is not stored as sObjects, but in the Data Lakes outside of Core CRM.
    • When to use existing data org and when to use new org.
      • Existing - Customer data housed in single Salesforce Org. Customer is using Loyalty Management & Promotions.

      •   New org for Data Cloud - Multiple Customer Salesforce org exists, highly complex architecture exists, existing org is highly customized.
  • Steps of initial setup process
    • Setup Data Cloud Account
    • Configure additional profiles (pay attention what Marketing Manager & Data Aware Specialist and Marketing Specialist do)
    • Setup connectors to connect data sources. It has following pre-built connectors:
      • Salesforce Clouds, such as CRM, Marketing Cloud, B2C Commerce, and Marketing Cloud Personalization.
      • External sources, such as external file storage (Google Cloud Storage, Amazon S3).
      • API and mobile connectors, such as Ingestion API, Web, and Mobile SDK.

  • How the data is ingested:
    • Batch:  CRM Connector, Marketing Cloud 
    • Near-real time: Ingestion API
    • Real-time: Web, mobile connector
  • Packaging & Data kits:
    • When to use unmanaged package and managed packages.
    • Data Kits - Helps to bundle CRM data streams and data models with flexibility and ease. This experience makes deploying multiple CRM streams as easy as Data Cloud out-of-the-box bundles and easy to deploy across orgs.


  • Administrator reports and dashboards:
    • Lightning Report Builder - analyzing your Salesforce data. Group, filter, and summarize records to answer business questions.
    • Lightning Chart - visual overview of data
    • Lightning Dashboard - create report on Data Cloud Object with custom report type and include them in dashboards.

  • Flow Integrations:
    • Chaining Data Cloud processes e,g, ingestions, segments and activation.
    • Run a process in sequence rather than waiting to run at a scheduled time.
    • Sending error notifications.
    • Data Cloud actions are used in Flow Builder to create automated flows. So near real-time execution. Refer Create Workflows in Data Cloud using Flows
    • Available Flow actions:
      • Data Ingestion for CRM data stream, S3 data stream.
      • Publish Calculated Insights.
      • Trigger Identity Resolution Job
      • Publish/Materialize Segments and activate.

Data Ingestion and Modeling (20%)

  • Data Modeling:
    • Standard Data Model is normalized.
  • Configure Data Stream

    • See the Data Sources as below

    • Data Stream operates on Single Object or file.
      • Marketing Cloud - Data Extension
      • Salesforce CRM - Contact or Case
      • B2C Commerce - Sales Order 
    • Category
      • Profile - Individuals with their identifiers, demographic and profile attributes, and contact points (such as email, phone, or postal address).
      • Engagement - time-series data points, customer transactions, opening/clicking emails, web browsing history. Event Time Field should be immutable. For example, Case creation date.
      • Others - Data about products, categories, store branch locations.

    • Data Source Object Schema
      • Data Cloud automatically adds three lineage fields: Data Source, Data Source Object, Internal Organization
      • Header Level - raw source data, read only.
      • Only Text, Number, Date, DateTime are supported as Data Type.
      • Formula field - For row level transformations and creation of composite key with the help of CONCAT(), NOW()
    • Refresh Mode:
      • Upsert
      • Full Refresh

  • CRM Data Integration:
    • Starter Data Bundles - Sales (Account, Contact, Lead), Service (Account, Contact, Case), Loyalty Cloud
    • Object should have Read and View All permissions with Read access to each fields.

  • Harmonization with Customer 360 Data Model for Data Cloud
    • Default model for Sales, Service, Marketing, as well as unification, segmentation, and activation purposes.
    • Common DMO - Contact Point <Channel>, Individual, Party Identification, Product Catalog, Sales Order, Email Engagement, Case.
    • Party = Individual.Id


    • Data Transformations
    • Data Modeling Process:

    • Data Explorer - validation and configured data objects.

Data mapping looks like this below:



Identity Resolution (Unify) (14%)

  • Implementing Identity Resolution
 
  • Use of Calculated Insights:
    • Summarize data
    • Attempt to establish uniqueness of the identifiers, whether or not contact points are shared across individuals.
    • Identify how many contact points are coming from any given source.
    • Inspect whether or not the address (if used as a contact point) was correctly imported.
    • Verify any potential mapping or relationship issues that might lead to incorrect unification results.
  • Difference between Unified Individual vs Individual:
    • Unified Individual - Match rules and reconciliation rules have been applied related to source Individual records to each other. Complete lineage is retained.
    • Individual - A person/customer from specific data source like Marketing Cloud.
    • Three match rules are available to link multiple records to unified customer profile: Exact Name and email, Exact email, Exact Phone Number
  • Reconciliation Rules: pickup the winner
    • Most frequent - Is selected across matched records
    • Last Updated - Its default, requires the Last Modified Date attribute to be mapped in the data stream
    • Source Sequence - Follows the ranked order of the data streams
  • To inspect data more thoroughly, use Data Explorer, Profile Explorer, Calculated Insights
  • Party Identification matching: Party Identification DMO requires 5 mandatory attributes as follows:
  • Anonymous Profiles - Is Anonymous field must is set to 1 and once at least one Individual profile is matched with an anonymous record. They are excluded from known profile utilization.
  • Resolution Summary to validate Identity Resolution ruleset validation.

Segmentation (18%)

  • Segmentation - Why it is required?
    • Use segmentation to break down your data into useful segments to understand, target, and analyze your customers.
    • Container basics - create relationships between your related attributes.
      • If you place "yellow" and "scarf" in the same Order Product container using AND query engine looks for a customer who purchased a “yellow scarf” as a single product on the purchase.
      • If you place "yellow" and "scarf" in separate containers, the query engine looks for customers who purchased any yellow product and also purchased a scarf of any color.

  • Difference between delete and deactivate a segment:
    • If you delete or deactivate a segment, there's no functionality to re-enable it.
    • If you deleted (or deactivated) in error, you must recreate the segment. 
    • If you plan to use the segment again, stop the publish schedule instead of deleting the segment.
  • Calculated Insights in Segmentation:
    • Segmentation On - entity must be a profile when using Calculated Insights in segments
    • For insights to appear in segments, the table that you segment on must be added to the query as a JOIN.
    • The primary key of the segmented table must also be a dimension in your created insight.
    • The Segment Container can only include one metric.
    • Streaming insights aren't currently supported in segments.
  • Identity Resolution in Segmentation:
    • Use Identity Resolution to create two different rulesets for the individual entity.
    • For the first ruleset, use stricter match rules, and for the second ruleset, use more general match rules and add Ruleset ID fuzzy
    • To build a new segment based on the fuzzy ruleset, use Unified Individual fuzzy in the Segment On field.
  • Value Suggestion in Segmentation:
    • Allow you to search data values along with type ahead functionality to surface ingested values for your attributes.
  • Segment timezone is org timezone.

Insights

Data Cloud lets us define and calculate multi-dimensional metrics from your entire digital data state in Data Cloud.
These metrics can include factors such as Customer Lifetime Value (LTV), Recency Frequency Monetary (RFM), Most Viewed Categories, and Customer Satisfaction Score (CSAT).
  • Calculated Insights:
    • Build multi-dimensional metrics
    • LTV, Most Viewed Categories, and CSAT at the profile, segment, or population level
    • Activate for personalization.
    • Compute complex attribute
    • Used in segmentation
  • Streaming Insights:
    • Done through Data Actions
    • Process Event Streams on near real-time data streams like web & mobile SDK. For example, real-time calculations, Business process orchestration, real-time alerts.
    • Drive Automation (Flow and Webhook)
    • The aggregation time window for a streaming insight can be a minimum of five minutes and a maximum of 24 hours.
  • Insights vs. Formulas vs. Segmentation Operators

Act on Data (18%)

  • Activation of Segments: materializes and publishes your segment to activation platforms
    • Cloud File Storage Activation Target - Amazon S3
    • Marketing Cloud Activation Target - After you create and activate segments to Marketing Cloud, they show up in Contact Builder as a Shared Sendable Data Extension.
    • Data Cloud Activation Target - curated DMO
    • External Activation Platform Activation Target - create and define activation platform metadata that can be packaged and listed on AppExchange
  • Segments are found in Data Cloud via the Query API or directly via Data Explorer.

  • Data ActionsThe supported data action targets are Salesforce Platform Event, Webhook, and Marketing Cloud.

Good to know areas

  • Following table depicts which objects supports in which functionalities.


  • Suitable use of nested segments.
  • How to match personalization on Activation targets.
  • Use of different kinds of APIs (ConnectAPI, Query API, Ingest API)
  • Use of Contact Point <Channel> of Customer 360 model
  • Segmentation filtering logic
  • Different model types.
  • Loading data from Amazon S3 bucket and usage for different file types.
  • Creating segments for birthday campaign 

Thanks for reading!

Note: The pictures and concepts have taken from Salesforce materials.

Further Reading for other certifications