- Marketing analyst
- Junior
- 30 min
A channel quality review by country
For the Larkspur review, build a free-form table with Session default channel group and Device category in Rows, and Sessions, Engaged sessions and Engagement rate in Values. Filter Country to United States and Device category to desktop, both with exactly matches.
Skills and rubricA channel quality review by country
- I put session channel and device in Rows and all three requested session metrics in Values because the review compares both traffic volume and engagement within the same session scope. I reconcile engaged sessions divided by sessions with the rate for a source row.
- A returning user can arrive through a different channel. I retain session channel because first user channel would assign later sessions to the original acquisition channel and change the question. A user may contribute more than one session.
- I retain the source records, the saved work and the checked output because another analyst must be able to reproduce this result. I record the observation window and the unresolved limitation. The decision owner approves any exception before this result changes a business action.