AMPscript Exercise AMP-E03a - Lookups & LOOPs 1

Подписаться 8 тыс.

Просмотров 6 тыс.

50% 1

Cameron Robert steps through an AMPscript Exercise (AMP-E03a) using LookupRows and FOR LOOPs to solve a series of tasks in Salesforce Marketing Cloud.
📄 Exercise Link: github.com/camrobert/Salesfor...
Key Moments:
Introduction (0:00)
AMPscript Exercise Setup (1:19)
AMPscript Task 1: Table of Names (2:50)
AMPscript Task 2: Add Beams & Points (6:34)
AMPscript Task 3: Add Last Beam Completed (13:44)
AMPscript Task 4: Add Unfinished Beams (17:50)
AMPscript Task 5: Add Accuracy (21:59)
Summary (26:29)
This exercise is part 1 of 2. Try the next exercise here:
▶️ Exercise AMP-E03b: • AMPscript Exercise AMP...
Salesforce Documentation:
• AMPscript LookupRows: developer.salesforce.com/docs...
• AMPscript For Loops: developer.salesforce.com/docs...
Trailhead Links:
• AMPscript for Marketers: trailhead.salesforce.com/cont...
• Code with AMPscript: trailhead.salesforce.com/en/c...
Contact:
/ camrobert
www.cameronrobert.com.au/
/ auscamrobert
Music: www.bensound.com

Опубликовано:

20 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 10

@giovane___8507 2 года назад

Congrats Cameron! It's an amazing initiative! Super helpful!

@anshumanmishra7575 Год назад

Hi Giovane, could you understand the logic in which @beams is being populated? It is not storing value from any DE nor through any function. Same with @points.

@ravidubey122 Год назад

Awesome, learned a lot. Thank you

@srilakshmi4508 5 месяцев назад

Awesome Cam.. thanks a lot

@stevenduong8126 Год назад

Could you please advise the tool you used to draw the diagram relationship? Thanks.

@CameronRobert Год назад

Dbdiagram.io, it’s a great tool!

@stevenduong8126 Год назад

@@CameronRobert Thanks so much, Sir.

@TechloverSam 2 года назад

I am getting an error "failed to convert parameter value from a string to a int32." after running first loop. 03:48

@CameronRobert 2 года назад

What section of the code are you up to? If you get stuck, try following the code exactly as seen in the video, or check the last pages of the Exercise document for copies of the code answers.

@TechloverSam 2 года назад

@@CameronRobert Its is working now! Thanks.😃🙌 I have a question for you! I want to insert the same data in one column. For example: The column name "Account_Id" should have the value "20" for all rows and update/upsert the DE also. How can I achieve this using AMPscript or SS.JS? Please help!