Skip to main content

#Salesforcemarketingcloud1 discussing

🚀 Available for Freelance Projects | Salesforce Marketing Cloud (SFMC)

Salesforce Marketing Cloud Specialist with 3+ years of experience delivering automated, personalized, and CRM-driven marketing solutions.

Expertise: 

✔ Email Studio | Journey Builder | Automation Studio 

✔ AMPscript | SQL | HTML/CSS  

✔ Audience Segmentation & Dynamic Personalization 

✔ SFMC + Salesforce Sales Cloud Integration 

✔ Customer Journeys & Campaign Automation

Open to short-term, long-term, and remote freelance opportunities.

Feel free to connect or message to discuss your SFMC requirements.

#Salesforcemarketingcloud #SFMC #Salesforce #Email #AMPscript #Journey Builder #Freelance Project Work #Freelancing Work #Freelancing

0/9000

Hi Trailblazers 👋 

I’m a Salesforce Marketing Cloud professional with 5 years of hands-on experience across Journey Builder, Automation Studio, Data Extensions, Contact Builder, CloudPages, and API integrations, and I’ve recently been working closely with Salesforce AI, Data Cloud, and Agentforce-related use cases

I’m currently exploring new opportunities in Salesforce Marketing Cloud / Agentforce and would truly appreciate any referrals or guidance from this amazing community. 

📍 Location preference: United States (San Francisco Bay Area – open to hybrid/onsite/remote) 

Alongside opportunities, I’d also love to connect with experienced Trailblazers who can mentor or guide me on upskilling further in Agentforce, AI-driven automation, and advanced SFMC architecture—especially from a real-world implementation perspective. 

Happy to share my background or connect 1:1. 

 Thank you in advance to this wonderful community 🙏 

#TrailblazerCommunity #Salesforcemarketingcloud #Agentforce #Salesforcejobs #SFMC  #SalesforceAI

0/9000

Are you ready to be a part of the best transportation system in the world? Our team has developed an RFI that could lead to the development of a SOW for a ready-set-go team to lead the last of our buildout for the Salesforce Marketing Cloud. Review the RFI, and register to attend our workshop later this month to learn more about how you can help make LA Metro the best it can be!

#SalesforceMarketingCloud

The RFI

https://lnkd.in/g8GDKyBC#Marketing Cloud
0/9000

⚫️ 🔴Efficient Data Extension Folder Structure Management via SSJS  Organize & Optimize Your Data Assets⚫️ 🔴

Full Episode: ▶️https://youtu.be/68sxrrDkERw

Blog: 🔗https://b2shashi.blogspot.com/2023/06/efficient-data-extension-folder.html

 

The title "Efficient Data Extension Folder Structure Management with SSJS: Organize and Optimize Your Data Assets" highlights the importance of effectively managing folder structures for Data Extensions using SSJS (Server-Side JavaScript). This approach enables you to organize and optimize your data assets efficiently, resulting in improved data management, easier access, and streamlined processes.

Explanation of Folder. Add function via SSJS:

The Folder. Add function in SSJS allows you to create new folders within your Marketing Cloud account's Data Extensions section. With this function, you can specify the parent folder in which the new folder should be created and provide a name for the folder. This helps maintain a well-structured hierarchy, making it easier to categorize and locate Data Extensions based on specific criteria or purposes, by leveraging the Folder. Add function, you can programmatically create folders to suit your organization's data management needs, automating the process and ensuring consistency.

Explanation of DataExtension.Add function via SSJS:

The DataExtension.Add function in SSJS enables you to programmatically create new Data Extensions within a specified folder. By utilizing this function, you can define the properties of the Data Extension, such as its name, fields, and data types. This allows for the dynamic creation of Data Extensions, making it convenient to handle large datasets or automate the creation of Data Extensions for specific purposes. The DataExtension.Add function is crucial in efficiently managing and organizing your data assets within the Marketing Cloud platform, simplifying data storage and retrieval processes.

Reference :

Blog - https://b2shashi.blogspot.com/2023/06/efficient-data-extension-folder.html

 

-------------------------------------

We make videos that will help you to be more confident, more prepared, and more agile in building Salesforce Marketing Cloud use cases. Knowledge building and sharing are everything, so we want to prepare you as a pro learner and bigger contributor with greater confidence, a charismatic self, and a respected professional.

WHOM WE SERVE:

Beginners, intermediate, experienced Salesforce Marketing Cloud Professionals

WHY WE EXIST:

There is a need for a voice that carries the torch for learners who are looking for experienced professionals who can guide them to the best of their intent. We are that voice. •

Subscribe now! Enjoy and stay connected with us!!

 

⚫️ 🔴Efficient Data Extension Folder Structure Management via SSJS Organize & Optimize Your Data Assets⚫️ 🔴Full Episode: ▶️https://youtu.be/68sxrrDkERwBlog: 🔗https://b2shashi.blogspot.

1 comment
0/9000

Demo - Unlocking Personalized Magic:  Experience Dynamic Subject Line

https://lnkd.in/dXJii4tP

 

In today's digital landscape, standing out in the cluttered inbox is crucial. That's where personalization comes in. By tailoring your email content to each recipient, you can increase engagement, build stronger connections, and drive higher conversions.With SSJS, you have the ability to leverage dynamic data and create personalized email experiences at scale. Whether you want to include the recipient's name, location, recent purchase history, or any other relevant information, SSJS empowers you to do so effortlessly. In this tutorial, we walk you through the process of setting up and utilizing the personalization string in email using SSJS. We cover the basics of SSJS syntax, demonstrate how to access and manipulate data within your email template, and provide real-life examples to inspire your own personalized email campaigns.

#salesforce    #sfmc #salesforcemarketingcloud #SSJS #javascript 

-------------------------------------

We make videos that will help you to be more confident, more prepared, and more agile in building Salesforce Marketing Cloud use cases. Knowledge building and sharing are everything, so we want to prepare you as a pro learner and more prominent contributor with greater confidence, a charismatic self, and a respected professional.

WHOM WE SERVE:

Beginners, intermediate, experienced Salesforce Marketing Cloud Professionals

WHY WE EXIST:

There is a need for a voice that carries the torch for learners who are looking for experienced professionals who can guide them to the best of their intent. We are that voice. •

Subscribe now! Enjoy and stay connected with us!!

0/9000

We have had several occurrences where our users send directly to a Data Filter. When this occurs, duplicate Subscriber records are created and the SubscriberKey does not match our expected format. We use Marketing Cloud Connect to sync Contacts from Service Cloud so we expect to have our SubscriberKey as their Contact ID. These duplicate contacts have the SubscriberKey as their email address.

 

We've poked around in custom permissions but do not find anything that we can use to restrict sending to a Data Filter. There is a permission, that can be applied to a custom role, that prevents them from viewing a Data Filter, however, this then prevents them from using the filtered Salesforce Data Extension (via synchornized data) as their recipient list in a send. 99% of our DEs are filtered from a Master Data Extension (MDE) and synchronized data is the source of the MDE. Therefore, negating this as an option.

 

There was a permission Xpress > Emails > SendToFilter (Deny) but that didn't seem to have any effect.

 

Is there any technical means to prevent our users from sending directly to a filter?

8 answers
  1. Florin Valean (Creation Technology Solutions Limited) Forum Ambassador
    Apr 4, 2023, 8:15 PM

    From what I know there's no way to enforce all templates to include a specific block but perhaps you already have a content block that is used in all emails such as the footer block. You could include that piece of Ampscript there.

0/9000
1 answer
  1. Apr 3, 2023, 10:52 AM

    Hello @Anirudh Venugopal Warrier,

     

    Primary key violations occur when an attempt is made to insert a record with a primary key value that already exists in the table. Here are a few ways to resolve primary key violations in SQL queries:

    1. Check the input data: Ensure that the input data is correct and does not contain any duplicate values. If the input data is coming from a file or another database, verify that it is correct and does not contain any errors.
    2. Use a MERGE statement: Use a MERGE statement to update existing records and insert new records. A MERGE statement can be used to perform both INSERT and UPDATE operations in a single statement.
    3. Use a subquery: Use a subquery to check if the record already exists before inserting it. The subquery can check for the existence of the primary key value in the table and return a boolean value that can be used to determine whether to insert the record or not.
    4. Use an UPSERT statement: An UPSERT statement is a combination of an INSERT and an UPDATE statement. It will try to insert a record, and if it already exists, it will update the existing record.
    5. Use a transaction: Wrap the INSERT statement in a transaction to ensure that the primary key violation is caught and handled correctly. This will ensure that the entire operation is either committed or rolled back in case of an error.
    6. Remove the primary key constraint: If you do not need the primary key constraint, you can remove it from the table. However, this is not recommended as it can lead to data inconsistencies and make it difficult to maintain the integrity of the data.

    By using one of these methods, you should be able to resolve the primary key violation issue in your SQL query. 

0/9000
2 answers
  1. Nobuyuki Watanabe (NAC / FPT Japan Holdings Group) Forum Ambassador
    Apr 3, 2023, 8:39 AM

    If you want to know the records of the remaining paths, update a Marketing Cloud contact record in Journey Builder using the "update contact" activity. And you can query the DE.If you want to know the records of the remaining paths, update a Marketing Cloud contact record in Journey Builder using the

0/9000
1 answer
0/9000
2 answers
  1. Mar 28, 2023, 8:05 AM

    Hello @Anirudh Venugopal Warrier,

    SELECT *

    FROM [Your Data Extension]

    WHERE DateField >= DATEADD(day, 30, GETDATE())

    Replace "Your Data Extension" with the name of your data extension, and "DateField" with the name of the date field you want to filter by. This query will select all records where the value in the "DateField" is equal to or greater than 30 days ahead of the current date.

0/9000