Plan, execute, measure and optimize customer experiences

Campaign tracking

Reply
New Contributor
Posts: 4

Campaign tracking

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

New Contributor
Posts: 2

Re: Campaign tracking

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

New Contributor
Posts: 4

Re: Campaign tracking

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.

New Contributor
Posts: 2

Re: Campaign tracking

 

From my experience, I believe a different database/table is required for reporting :-

  1. When Volume of campaigns processed is huge, and the campaign run window overlaps the report run window.
  2. If reporting needs to consolidate results not only from CDM, but from other sources as well.
  3. If the campaign tracking reports need frequent run and the runs take long time.

Thanks,

Ubaid

 

Contributor
Posts: 46

Re: Campaign tracking

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. 

 

Ask a Question
Discussion stats
  • 4 replies
  • 373 views
  • 2 likes
  • 3 in conversation