AMPscript Exercise AMP-E03a - Lookups & LOOPs 1

Рет қаралды 6,243

Күн бұрын

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

Пікірлер: 10

@ravidubey122 Жыл бұрын

Awesome, learned a lot. Thank you

@srilakshmi4508 5 ай бұрын

Awesome Cam.. thanks a lot

@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.

@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!