You want to identify the best times to send your emails through a custom report. You’d like to see each hour of the day as a separate row and the average open and unsubscribe rates listed out by hour. Which type of chart should you select?
Choose an answer
Tap an option to check your answer.
Correct answer: Pivot table.
Why this is the answer
A pivot table is used when report data needs to be displayed in rows with metric values broken out by category. In this case, each hour of day can appear as a separate row. Average open rate and unsubscribe rate can then be shown as separate measured values for each hour. This chart type is best suited for comparing multiple email performance metrics across time-based groupings.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed