04-20-2016 07:02 PM
I was wondering what you guys use to track performance of your marketing campaigns? We tried using Web report studio but found it extremely difficult and clunky to work with. Also, did you create seperate reporting schema or do you run the reports straight of the CDM?
Thanks, appreciate any insight
04-21-2016 04:24 AM
I believe the CDM schema is organised enough to start off with your reporting for campaigns. Unless you want to build cubes to incorporate data like response-feedback from channels and the take-up. I will suggest using SAS Visual Analytcs, its in memory processing and data exploration will help you with that quick analysis and on the fly reports. Plus you don't have to worry about the cubes.
04-21-2016 01:34 PM
Thanks Ubaid, I am specifically looking at running fixed, regular tracking reports and preferably something that the marketing manager can run themselves, you know, those same response reports that shows uptske , ROI etc. As these are doing the same analysis for every single campaign , I dont want my designers to spend time running these reports.
I am worried that putting these reports directly on the CDM for fear of impacting performance of the actual campaigns.
04-22-2016 08:20 AM
From my experience, I believe a different database/table is required for reporting :-
04-28-2016 11:32 AM
The CDM is published to after a campaign is executed. I would think that as long as your CDM is not tied into the Information Map that your CI Studio reads from for campaigns you should not have any performance issues.
For reporting we use an ETL on a nightly basis that reads from CDM and populates another schema for Tableau and Cognos users.