The Best Report in NetSuite (for Marketers)

The Best Report in NetSuite (for Marketers)

The Campaign Response Report

I want to let you in on a little secret.  In fact, it’s the best kept secret for any Marketing professional using NetSuite.  There’s a customizable report that will tell you everything you want to know – about how your email campaign performed.

Building the Report

Start by navigating to Reports > Marketing > Campaign Response > Customize Detail

This should take you here:

Click on the pencil icon next to the Category 1 label to select it and then click on the Remove Column button.  This will change Campaign 2 to Campaign 1.  Click on the pencil next to Campaign 1 and click Remove Column again.  You should now be left with the Title 1 row next above the Results column.

Next, we want to add the following new Columns.  We can find additional data fields using the Add Fields options on the left side of the screen:

  • Recipient: Name (Grouped)
    • Found under Campaign Response > Recipient
      • Rename the Column Label to Contact
      • Move this Column all the way to the left so it’s nested under the Title of the Campaign
  • Event: Date Created
    • Found under Lead Source > Event
  • Recipient: Email
    • Found under Campaign Response > Recipient
  • Recipient: Email Bounced
    • Found under Campaign Response > Recipient

Click Preview to see the results.  They should look something like this:

Feel free to go back and add any other columns to customize the report with data you’d like to see here also.  Change the Title of the report to Campaign Responses or any name you prefer and Click Save.

Your New Best Friend

Voila!  You now have a Report that tells you all the people who opened, clicked through, and unsubscribed to your recent email campaign.  Update and customize the date range to show a single day, a week or a month depending on the results or how many campaigns you’re hoping to see.  This report also tells you when any of the above mentioned actions occurred by the recipient, and you can even click through right to the contact record to get more granular or make any updates to that contact.

For more information, contact Keystone!

Keystone. Your NetSuite solution provider and integration partner.

Call – 866­-546-­7227 | Email –

Seth is the Marketing Manager for Keystone Business Services.  He is responsible for developing and maintaining the annual marketing calendar and budget, as well as executing and analyzing marketing campaigns for Keystone.  Seth has over 10 years of Marketing experience, having spent a year as Assistant Marketing Manager for Officite, as well as the prior 5 years as Marketing Coordinator for Tauer & Johnson.  He has over 10 years of experience with a variety of different ERP and CRM platforms, including NetSuite, Salesforce, Goldmine, ACT, and Pivotal.  Seth recently received his MBA from Louisiana State University-Shreveport and holds a BS in Speech Communication with a specialization in Public Relations from Southern Illinois University-Carbondale.