Editing the campaigns.csv File

You can edit the campaigns.csv file in different ways, depending on your Webtrends Analytics 9 license and your reporting goals.

If you want to edit the rows in the file to modify the information about each campaign, without changing the dimensions included, you can edit it as a Microsoft Excel file, adding your own data to each existing column, and save it. Omit the data in any columns you will not use, but do not remove the heading. This is the easiest way to modify the campaigns.csv file, and does not require any additional configuration of custom reports or dimensions. Users who have not licensed Custom Reporting can use this method to generate the full set of Campaigns reports. However, if you leave some columns blank, the corresponding reports may contain columns with no data.

If you want to change the dimensions that are included in your campaigns report, you can edit the heading row.

  1. Navigate to the installation directory\storage\config\wtm_wtx\datfiles\datasources directory.
  2. Create a backup copy of the campaigns.csv file and rename it.
  3. Edit the campaigns.csv file by deleting any dimensions in the heading row that you do not want to include in your Campaigns reports. For example, if you want to eliminate the Marketing Activity, Marketing Program, Partner, and Placement dimensions, edit the standard heading row:

    CampaignID,Description,Creative,Creative Type,Demand Channel,Marketing Activity,Marketing Program,Offer,Partner,Placement

    so it reads as follows:

    CampaignID,Description,Creative,Creative Type,Demand Channel,,,Offer,,

    Do not delete any of the commas that delimit the fields. Do not re-order the columns in the file. Deleting the comma delimiters or reordering the fields results in an incomplete analysis or inaccurate data.
  4. Make a copy of the Most Recent Campaign (drilldown) dimension and edit it to remove the levels you removed from the translation file.
  5. Make a copy of the campaigns custom report and edit it to use the new version of the Most Recent Campaign (drilldown) dimension.
  6. Do the same for other reports that use the Most Recent Campaign (drilldown) dimension. Preconfigured custom reports that rely on this drilldown dimension include:
    • Campaigns by Countries
    • Campaigns by DMA
    • Campaigns by New vs. Repeat Buyers
    • Campaigns by New vs. Returning Visitors
    • Campaigns by Regions
    • Campaigns by Time
    • Creative Types
    • Creatives
    • Offers
  7. Click Web Analysis > Report Designer > Templates, edit the report template, and click Content to add the new reports to the report template.
  8. In your report profile settings, click AdvancedReports and enable the new versions of the campaigns custom reports.