VERIFIED SOLUTION i

How to rebuild historical data for Portrait Suite products on a campaign by campaign basis

Product Feature: Reports

Database: SQL Server


 

To reset the statistics on a campaign by campaign basis in Portrait HQ, you can reset the campaign statistics by clicking the ‘Force rebuild of campaign performance history’ link on the Campaign Monitor’s page in the Portrait HQ application.  You can get to this page via 'MyView':
Rebuild Campaign

When prompted, remember not to tick the box to delete treatment and behaviour logs.

 Delete Treatment Logs

This sets all the campaign’s statistics back to 0 (by calling the DW_SP_REMOVE_CAMPAIGN_HISTORY stored procedure). When the DW Populate package next runs, the statistics will be correctly re-generated.

UPDATED:  March 23, 2017