SFMC Foundations Session 01

SFMC Foundations Session 01 - Data Management

Рет қаралды 26,538

3 жыл бұрын

SFMC Foundations Session 01 - Data Management
by Vladimir Silak
Hosted by Marketing Cloud Grp, Cyberjaya Malaysia
Hands-on Scenario Quip:
quip.com/1WU0Ak6RaiVb/MC-Foun...

Пікірлер: 37

@Rani-nu8jh 3 жыл бұрын

Excellent session. Looking forward to the others! Thank you!

@archanashastry9066 3 жыл бұрын

An excellent session.Thanks so much for this

@pinakim11 2 жыл бұрын

This is pure gold. 🙏

@aniruddhashimpi3044 3 жыл бұрын

Excited to attend all the sessions 😀

@lorenzventura 2 жыл бұрын

This is one of the most informative resources about SFMC out there. Very valuable. Thank you

@sprudhvi3969 2 жыл бұрын

Waiting for next sessions related to data management.Great Video!!

@semmundialbirebaixadoparbe2905 Жыл бұрын

You're the best Vlad, thank you

@digamberrawat 3 жыл бұрын

To answer the second question around the unique identifier. It is a quite a common question ... If you do not have a dedicated identity management system or a crm like sfdc then you can use the universal guid function to generate unique IDs. It is supported both in ampscript and sql. Even supported in different programing languages like java and . net, Incase you want to generate it in an external system before pushing contacts via API.

@sastenashe1O1 3 жыл бұрын

Thank You for the video :)

@VISHAKSNAIR 3 жыл бұрын

This is one of the best foundation video I have gone through for SFMC. I have been recently going through some starter courses and videos through Udemy and youtube, but this one personally felt the best!

@JapHendyWijaya Жыл бұрын

thankyou

@venson80 3 жыл бұрын

HI Shibu.. in the initial document we have mention of only 5 source DE's customer, membership, booking and rental. but the DE's created are more than this in actual flow. how can we interpret the actual number of DE's we require for the total flow. and if the do we have any team review/approval on the flow coverage before we start working on creating DE's and email templates. are this additional DE's (Rental Survey Event Queue and Rental Survey Journey Track) defined and provided by data architect, do we get the required attributes in that DEs as we get for source DE's. please detail how the logic in selecting entry source DE.

@venson80 3 жыл бұрын

HI Shibu.Question again on the time format. I have different time formats on the data loaded to a DE based on different regions in the file. How can i make all the dates are mapped to a common timing ( BU User Set Timing) while loading or when querying on the date field in the SQL query. thank you.

@sfmctrailblazers 3 жыл бұрын

It's recommended that you set your timezone in the settings so that the date formats map correctly. Please refer to the links - help.salesforce.com/articleView?id=sf.mc_overview_timezone.htm&type=5 & help.salesforce.com/articleView?id=sf.mc_overview_supported_date.htm&type=5. The second link specifies that you can set the date format when importing. Another option is to convert the DE field to date format you need when querying in SQL or using AMPscript FormatDate function in Email / Cloudpages - salesforce.stackexchange.com/questions/274238/date-format-in-sql-query

@venson80 3 жыл бұрын

HI Shibu. Apart from the mapping attributes from the source file, what are the other standard attributes (eg: Created date )we should use in the DE which might be standard and will be used with any sendable DE used for tracking/filtering or updating the content/subscriber during the journey. Do we have any such standard attributes to use by default( attribute is not as part of source-DE mapping file provided by the source team) which would benefit us in course of time or can we update the attribute later in the DE as required by making it nullable. ( Eg : initially i have not created the attribute "Valid Credit Card" but found that this would be used as a filter to divide the population based on the journey progress ). so can i add this attribute later ( even when we have records in the DE) with nullable value...plz advise

@sfmctrailblazers 3 жыл бұрын

The attributes in the DE would be something that you would configure based on the biz process where you would be applying it for - some DEs that are created from Template already have few default Attributes pre-set - like TriggeredSendDataExtensions, Send Log, etc. Before creating the data model, it helps to review the biz process, and review the rough data flow and identify the data points that you will need. And as you mentioned, you can go and add in additional attribute fields later - but do be careful and refer to these links for the downstream impact of adding new fields - help.salesforce.com/articleView?id=sf.mc_cab_edit_a_data_extension.htm&type=5 & help.salesforce.com/articleView?id=000356355&language=en_US&mode=1&type=1

@patriciaboyce8143 3 жыл бұрын

I love these! Is there one for the Admin work?

@sfmctrailblazers 3 жыл бұрын

These foundational videos arent't specific for Dev - can be useful for any newbie starting off in SFMC - even for Admins. Idea is to have folks familiarize themselves with common features that they may come across as part of their daily work.

@pratikap1230 3 жыл бұрын

Thank you so much for the video... One question : could you please tell us -How to check automation log details ?

@sfmctrailblazers 3 жыл бұрын

You can check in the Activity tab of an Automation workflow to see the details of success and failure runs. There's limitations to the details that is visible in logs when errors occur though.

@indrajayekkaluri3610 3 жыл бұрын

Hi Shibhu, where can I find registration link for coming session for these series?

@sfmctrailblazers 3 жыл бұрын

Bit.ly/SFMCF2 Bit.ly/SFMCF3 Bit.ly/SFMCF4 Bit.ly/SFMCF5

@andycorbett207 3 жыл бұрын

This is just what I need! Is there an option to join the live sessions?

@sfmctrailblazers 3 жыл бұрын

Hi Andy - yes we just had the second session earlier today. We have 3 more sessions left in the series - please do register for these events using the links below: Bit.ly/SFMCF3 Bit.ly/SFMCF4 Bit.ly/SFMCF5 We will be adding the recordings to the playlist at kzfaq.info/sun/PLntZFZH56rSe1BiQwdVFRJ4U07YJo1D2C

@andycorbett207 3 жыл бұрын

@@sfmctrailblazers Thank you!

@andycorbett207 3 жыл бұрын

Ah, just realised this will be 4am in my time zone! I will look forward to the recording.

@indrajayekkaluri3610 3 жыл бұрын

Is there any chance to get MC guided implementation document used in the session?

@sfmctrailblazers 3 жыл бұрын

Will check - Vlad said we will try to share a quip doc with sm scenario to try out later this month

@findx5798 2 жыл бұрын

I am trying to change my career from Testing to SFMC.. I am totally new to SalesForce. If I watch these series will I be able to attend for interviews? is there any possibility to do hands onn practise

@sfmctrailblazers 2 жыл бұрын

These are meant more for folks who are starting off on SFMC and need a quick overview of the platform features that they will mostly be using for their day to day work. There is no free sfmc dev org - you will have to join a customer or partner for the same. Trailhead academy does provide training so u may get access for a short time.

@bgm1542 2 жыл бұрын

I recently came across a term called seed list data extension, could you please let me know about it?

@sfmctrailblazers 2 жыл бұрын

Theres no specific category called Seed List DE in SFMC afaik - you can create a list or DE and store email addresses for the purpose of maintaining a seed list - either for testing purposes or using in campaigns. There is the option to create a testable DE though which you can use specifically for testing email sends. You can check the box Is Testable after checking Is Sendable when configuring the DE properties.

@bgm1542 2 жыл бұрын

Thanks much for clarification.