This one is straightforward. The ‘File Transfer’ activity
Posted: Mon Dec 23, 2024 4:54 am
Data Extract
As the name suggests, this activity extracts the data from your chosen source within Marketing Cloud Engagement and creates it in a new file. It can also transform file formats. For example, from an XML to a comma-delimited file.
You might use this activity to extract data into a new file in your FTP that can then be used outside of Marketing Cloud. For example, you might use it to extract engagement activity metrics for a series of journeys you have running.
File Transfer
unzips or decrypts a file in your Marketing Cloud FTP Site. You bulgaria number code could use this to securely transfer the file to a new location.
SQL Query
SQL is an industr-standard language for manipulating data sources to meet your needs. In Marketing Cloud Engagement, SQL Activities allows you to extract data from one or more data tables (Data Extensions) and put the results into a new table.
This is super useful for creating clean, understandable data for marketers to use effectively. For example, if you have a table of customers and a table of purchases made by customers, you can merge the two tables together and provide a neat single table listing out all your customers, and the last product they purchased.
SQL Queries should also be used when you have advanced filter logic, as the Filter activity (see below) can often become hard to read and understand when using multiple fields from multiple objects.
Filter
For those with straightforward data segmentation needs, a ‘Filter’ does the job. Much like SQL Query, a ‘Filter’ applies a set criteria to your database to create a new table of data containing only the filtered records. You’ll need to create the ‘Filter’ in Email Studio before automating it within Automation Studio.
This option is great for quickly creating Data Extensions or Groups of select contacts, for use within Journey Builder or Email Studio. For example, whittling out all those interested in a specific product or service, or based on demographic information.
As the name suggests, this activity extracts the data from your chosen source within Marketing Cloud Engagement and creates it in a new file. It can also transform file formats. For example, from an XML to a comma-delimited file.
You might use this activity to extract data into a new file in your FTP that can then be used outside of Marketing Cloud. For example, you might use it to extract engagement activity metrics for a series of journeys you have running.
File Transfer
unzips or decrypts a file in your Marketing Cloud FTP Site. You bulgaria number code could use this to securely transfer the file to a new location.
SQL Query
SQL is an industr-standard language for manipulating data sources to meet your needs. In Marketing Cloud Engagement, SQL Activities allows you to extract data from one or more data tables (Data Extensions) and put the results into a new table.
This is super useful for creating clean, understandable data for marketers to use effectively. For example, if you have a table of customers and a table of purchases made by customers, you can merge the two tables together and provide a neat single table listing out all your customers, and the last product they purchased.
SQL Queries should also be used when you have advanced filter logic, as the Filter activity (see below) can often become hard to read and understand when using multiple fields from multiple objects.
Filter
For those with straightforward data segmentation needs, a ‘Filter’ does the job. Much like SQL Query, a ‘Filter’ applies a set criteria to your database to create a new table of data containing only the filtered records. You’ll need to create the ‘Filter’ in Email Studio before automating it within Automation Studio.
This option is great for quickly creating Data Extensions or Groups of select contacts, for use within Journey Builder or Email Studio. For example, whittling out all those interested in a specific product or service, or based on demographic information.