Hi everyone
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
Hi there,
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.
Thanks,
Ubaid
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.
From my experience, I believe a different database/table is required for reporting :-
Thanks,
Ubaid
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.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)
SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.
Find more tutorials on the SAS Users YouTube channel.
Listen to the Reimagine Marketing podcast
Assess your marketing efforts with a free tool
SAS Customer Intelligence Learning Subscription (login required)