Skip to main content

Subscriber Key

 

Task 1: Export and Analyze All Subscribers List

  • Identify the count of Active, Unsubscribed, Bounced, and Held subscribers





Task 2: Create and Import Subscribers with Custom Subscriber Keys


Map Subscriber Key to Customer ID & Email Address to Email Address

  • Create an import file with:

    • Subscriber Key (Use a unique Customer ID instead of email)

    • Email Address

    • Status (Set all to Active)

  • Import the file into All Subscribers

  • Check if SFMC correctly maps the Subscriber Key instead of the email




Task 3: Test Subscriber Status Changes

  • Manually unsubscribe a subscriber from All Subscribers

  • Try sending an email to that subscriber and verify if SFMC blocks the send

  • Change the status back to Active and retry the send




Unsubscribe a subscriber from All Subscribers







Task 6: Explain Subscriber Key vs. Subscriber ID


Write a short explanation (under 100 words) comparing the two


  • Subscriber Key is a user-defined unique identifier. You (the marketer) choose this value (e.g., a CRM ID or email) to uniquely identify subscribers across different channels and data extensions.
  • Subscriber ID is a system-generated unique identifier. It is a numeric ID created automatically by Marketing Cloud for internal database tracking and is typically only visible via APIs or system data views.


Prepare a real-world scenario where using a custom Subscriber Key is beneficial
A common real-world scenario for using a custom Subscriber Key (instead of an email address) is managing household accounts where multiple family members share a single email address.
Scenario: The Family Loyalty Program
  • The Problem: A family (e.g., the Cruz family) joins a retail loyalty program using one shared email address (cruz-family@email.com). If the brand uses "Email Address" as the unique identifier, the system can only store one set of data (like birthdates or preferences) for that entire family.
  • The Custom Solution: By setting a custom Subscriber Key based on a unique Loyalty Card ID for each person, the brand can:
    • Differentiate Members: Store separate birthdays for twin daughters, Jill and Lisa, even though they share an inbox.
    • Send Targeted Content: Trigger two separate "Happy Birthday" emails with unique coupons to the same email address on the same day.
    • Maintain History: Track individual purchase histories and engagement for each family member .

    Task 7: Troubleshooting Exercise

    • A subscriber reports not receiving emails, but they exist in a Data Extension


    When a subscriber exists in a Data Extension (DE) but is not receiving emails, the issue usually lies in their status 
    1. Check "All Subscribers" Status: Search for the Subscriber Key in the All Subscribers list. If their status is Unsubscribed, Held, or Bounced, Marketing Cloud will automatically block the send.
    2. Verify DE Relationship: Ensure the Data Extension is marked as Sendable and that the correct field (the Subscriber Key) is mapped to Subscribers on Subscriber Key in the "Subscriber Relationship" settings.


Comments

Post a Comment

Popular posts from this blog

A/B Testing

Confluence link 1:  https://elearningit24.atlassian.net/wiki/external/MzA3YWUxNjI3YzBkNGZiZmFlZTc1ZGIzYmU1ZmM1MmQ   What is A/B Testing? A/B testing, also known as split testing , is a controlled experiment where two versions of a webpage, email, ad, or any digital asset are tested against each other to determine which one performs better. Why? Higher open rates Better Engagement Increased Sales and Lead conversion Reduced unsubscribed rates Date Driven- No assumption & Proven Results Test Type Subject Line Email Content Area From Name Send Date & Time Pre Header   Email Test Template: Friendly and Personalised Straight to the point & Action Oriented Confluence Link 2:  https://elearningit24.atlassian.net/wiki/external/NDk0Zjg0ODk3YjAwNDI5ZjkxOTVmMTAxNTQ3ZjlhNmQ Subject Line A/B Test: A/B Testing Use Case: Optimizing Email Subject Lines for Higher Open Rates Scenario- Subject Line: A company wants to increase the open rates of its promotional emails in Sa...
Post a Comment
Read more

Email Marketing Campaings

Use Cases of Standard Data Extensions 1. Customer Data Storage Scenario : A retail business wants to store customer information, such as names, email addresses, and purchase history, for email marketing campaigns. Solution : Use a standard data extension to store and manage customer data securely and efficiently. Data Extension Structure Field Name Data Type Length Required Primary Key SubscriberKey Text 50 Yes Yes FirstName Text 50 Yes No LastName Text 50 Yes No EmailAddress EmailAddress N/A Yes No PurchaseHistory Decimal N/A No No Sample Records SubscriberKey FirstName LastName EmailAddress PurchaseHistory 001 John Doe john.doe@example.com 1500.50 002 Jane Smith jane.smith@example.com 200.00 https://mc.s8.exacttarget.com/cloud/#app/Email/C12/Default.aspx?entityType=none&entityID=0&ks=ks%23Subscribers
Post a Comment
Read more

SQl Query

  Workflow: Journey Builder> Automation Studio> New Automation Enter Query: Drag and drop Schedule in  Start with a Starting Source and the SQL Query> Choose Query> Create New Query Activity> Name your file and add your query (Field name thats part of the DE you create separately- Example: FirstName, LastName, Subscriber Key) Create a new DE in Email Studio with the query field> Select The test DE which was created: Select Target DE and Save & Run Workflow: Select All Activities and Run Workflow: Activity Details: Run Completed with updated DE Edit/ add another query: Copy Source DE and create a new DE with same fields that we are running in SQL: Run the updated SQL Query added Activity and DE updated with Records: Completed Status: Received error: When the Query field and the DE created field does not match When an existing Query is being run, if we try to run another query Fixed the error by matching same field Waiting for existing query to complete
Post a Comment
Read more