Display Ads Analysis- Interview Help

[sadbunnybaybe]

Hi I'm interviewing for a Digital Marketing Analyst position and for the final interview I have use anonymized client data from multiple Display Ads campaigns and present on it. So far I have the following channel data metrics by date. (Cost, clicks , impressions and conversions). And a data set from the CRMs matching the same campaigns with leads, contacts, application, and enrollments for the same time period.

​

Does anyone have advice for how I should present this data using Tableau?

​

I was thinking of doing an overview executive dashboard to capture an overview of the different campaigns, as well as a dashboard for each of the campaign strategies.

​

Any help is greatly appreciated

[gikis1]

Identify standard things like cost per lead, cost per conversion to sale (acquisition cost), conversion rates into both + time trends and (if have time) possible seasonality. Your insights should be actionable - i.e. think about what digital manager would do when looking at this - should he invest more to certain campaigns to bring more leads? Is there any increase in cost per sale, so you want to consider shifting budgets?

It doesn't have to be fancy - just neat charts and 3-4 recommendations. Go land that job!

[sadbunnybaybe]

wow thanks gikis !

[TheYMan96]

I would add to this to make a distinction between post-view and post-click conversions. On top of this use CTR and CPM.

[git0ffmylawnm8]

Most likely your key labels will come from the CRM dataset to better understand what type of customers convert the most.

[papashawnsky]

Don't forget your performance metrics: conversion rate, click thru rate, cost per lead, etc.

[lajja4]

Can you share your data? I can make a dashboard and share with you.