Measuring performance

[deepakqlikview_123]

Hi All,

Can u please tell me how to perform comparison for above scenario in below case,

The first is their Christmas campaign and the second is the New Year sales campaign.

You are asked to deliver an interactive dashboard to help the CEO analyse the performance of the email marketing campaign over Christmas and the New Year sales.

tables are

Customer table

Customer

Age

Country

Gender

Campaign table:

Campaign id

Start

End

Name

Cost

Cliks table:

EmailOpenTime

Customer id

Month

Year

Clicked

Thanks in advance

[#2]

Hey Deepak,

It would be helpful if you could be a little bit more specific.

Do you have your Data Model designed yet. I would strong recommend getting together with a data expert(if these tables are in Oracle , then a oracle developer who knows about these tables) and see how these different tables can be linked together to design your model.

Once a solid DM is designed then as per the business requirement you can design your dashboards.

Thanks

AJ