Filters vs Queries Flashcards
1
Q
Can be used on lists and DEs
A
Filter
2
Q
Uses measures for behavioral data
A
Filter
3
Q
“All” fields in source data extension are in filtered data extension
A
Filter
4
Q
User interface automatically creates filtered list or filtered DE
A
Filter
5
Q
Can be used on DEs only
A
Query
6
Q
Uses data view table for behavioral view
A
Query
7
Q
Supports joins, unions, nested queries, counts, sums, and more
A
Query
8
Q
Results data extension can contain fields from the DEs being queried
A
Query
9
Q
Requires knowledge of SQL
A
Query
10
Q
Results data extension must be created to get final results
A
Query
