Summary
With that, you now have a strong understanding of ETL and data manipulation inside Marketing Cloud Automation Studio. Whether you are looking to use SQL queries or import or extract files, you should now have all the information you need to maximize the use of these activities in your automation.
You have dived deep into what exactly ETL is and now have a strong enough understanding of it in general, as well as how it relates in Marketing Cloud, that you can likely impress your friends at the next party with how smart you are. Well, if they are also into nerdy technical things like us, otherwise they might just give you a blank stare as you try to explain it.
We also learned that for Transform, the two activities we want to concentrate on are the SQL Query activity and Filter activities. These offer the best segmentation options, with SQL Query activities offering a more versatile capability of transforming outside of just segmentation.
Next, we will take you through...