In Salesforce Marketing Cloud, data views are pre-built tables of data that store subscriber information and the last six months of tracking data for your account. While data views cannot be accessed from the user interface, they can be used like any other data extension: you can write a query against a data view in Automation Studio or in the …
SQL for Salesforce Marketing Cloud
SQL is a very critical skill for anybody who wants to make a successful career working in Marketing Cloud. In SFMC, data extensions and Contact Builder use a relational database. There comes SQL which provides a good way to execute queries and retrieve data for reporting or segmenting audiences. As a Marketing Cloud consultant, developer or data analyst, good knowledge of …
Salesforce Certifications : Do they really matter?
Everyday I see posts on LinkedIn about people sharing news about passing Salesforce certifications. Some newbies clearing their first certification exam (mostly Salesforce Administrator) or some experienced folks increasing their certification tally to 10 or 20 or even to thirties. It makes me very happy to see these individuals who are working hard and putting effort to learn new things …
Unsubscribe Management for Templated Emails Sent from Salesforce CRM
If you use Salesforce as your CRM tool and Marketing Cloud as your email tool, unsubscribe management is taken care of by SFMC. If you send emails via a journey, the emails include an unsubscribe link which when your email recipients click, it updates their unsubscribe preference in the system. So when you send an email next time, the system …
Tokenization in Salesforce & Marketing Cloud to Comply with Canadian Data Residency Requirements
There are data residency requirements through Government legislation in Canada that mandates businesses to store personally identifiable information (PII) of their customers only in Canada. The requirements are even stricter for certain industries, such as financial services. For Salesforce CRM, the servers are based out of Canada and thus all the information is saved within the country. However, Marketing Cloud …
Local Search Marketing and its Advantages for Small Businesses
Implementing a marketing strategy in a small business can be complicated, but at the same time extremely profitable. With so many competitors in the market, even in the same area, standing out from the crowd is one of the most difficult tasks. Search Engine Optimization (SEO) is one of the most popular methods used by entrepreneurs who want to market …
Distributed Marketing Use Case for Contact Center
Recently, I worked on a project to set up Distributed Marketing feature for a Bank’s contact centre. The feature allowed contact centre agents working for a Bank to send Marketing approved emails to customers from within the service console in Salesforce. The feature was greatly liked by agents and we saw good adoption rates after some training and persuasion. Use …
Creating a package in Marketing Cloud for API Integration
In Marketing Cloud, navigate to setup Under Platform Tools, expand Apps and click Installed Packages. Click New. Give the package a name and description so that you can easily identify it as your first test package. Save the package. After the package is saved, you can view the package details. Under Components, click Add Component. In our case, …
SQL Query to find if email was delivered, opened, clicked and event-dates
As an email marketer you will probably be in situations where you will be required to send a targeted marketing email to customers/prospects to achieve a desired outcome. And few days after the email is deployed you may be asked to provide a report to show how many emails were delivered/bounced, recipients who received the email, if they opened or …
Resources for SFMC Email Developers
SFMC Object Finder Chrome Extension This is a very useful chrome extension that can be used to search and locate Data Extensions, Email, Content Area, Email Template, Query Activities, User Initiated Definitions, Data Filter Definitions and Automations. I use this Chrome extension a lot and I recommend all Marketing Cloud professionals to add this extension to their browser. https://chrome.google.com/webstore/detail/sfmc-object-finder/bkicfdfanedgnlddinjiojphnehpjnpd Email …
- Page 1 of 2
- 1
- 2