CJAM: Tell a Story with Your Data

June 2, 2017

Here at CJ, we have no shortage of data. Everything you need to know about your consumers is flowing through our system, the CJ Account Manager (CJAM), and ready for you to collect and analyze.

Just like a massive library of books, there are two keys to sifting through all that data:

  1. Where to look (and how to get there)
  2. How to read the data once you find it

To help you do this, we've pulled together three common reporting use cases, illustrating how you can dig in, decipher, and tell a stronger story with your data. In case you need a refresher on reporting in general, check out this short video overview: Reporting Overview.

 

“What’s driving low EPC and Conversion Rates?”

First, let’s run a report…

Performance by Program: Daily Trend, Last 30 Days (or longer)

  • This will show you which days saw the weakest EPC or CR, and when the decline began
  • Note: a major influx in clicks can drive these averages down, so look for that as well!

Then…

Performance by Publisher: No Trend, Custom Date Range 

  • Set a date or date range that may have stood out in the last report
  • This will help you determine if a particular publisher is pulling down those metrics
    • If there is, check out their sites to see if their ad placement is attracting traffic that’s not likely to convert for you
    • Reach out and start optimizing!

If no publishers stand out…

Performance by Link: No Trend, Custom Date Range

  • Set this to the same date range as your Performance by Publisher report
  • This will show you if any particular links or promotions drove clicks that weren’t converting
  • Dig in to determine what changed from your more successful promotions

 

“Did that site-wide sale improve engagement?”

You guessed it, let's run a report...

Performance by Publisher: Monthly Trend, Custom Date Range of a few months before the sale through today

  • This will give you a chart of your overall performance (use the drop-down to see additional metrics like Sales, Clicks, etc.) as well as a data table showing how each of your publishers is performing.
    • Download and open this report in Excel to start analyzing trends by publisher
    • For tight promotional dates (just a few days or so), set this report to a Daily trend instead
  • By selecting all of your data and building a pivot table, you can see:
    • If publishers drove more clicks or sales during the promotion than they did prior
    • If Average Order Value was higher during the promotion than it was prior

Also, try…

Mail > Email Campaigns

  • Did you send a newsletter about your sale? How about after?
  • Use this page to see your open rates* which can indicate higher engagement and interest in the program *(Only HTML messages report opened mail)

 

“How is each product affecting our ROAS?”

First, let’s run a report…

Performance by Program: Daily Trend, Last 30 Days (or longer)

  • Dividing Sale Amount by Publisher Commission gives you your Return on Ad Spend (ROAS)
  • Calculate your ROAS for the whole period, and for each day, to give yourself a program-wide baseline

Then…

Performance by Product: Daily Trend, Last 30 Days (or longer)

  • This will show how each of your SKUs is performing, and what your ROAS is for each
  • If you’re offering different commission rates for specific products, this is where you’re going to see how those rates are making a difference
  • If your ROAS is lower than you'd like on certain days, or for certain products, consider engaging with your publishers
    • Discuss the products they’re focusing on and how your promotions are—or aren’t—driving consumers to products that drive the healthiest returns
    • For additional insight, run a Performance by Product by Publisher report, to see which publishers are driving a low ROAS!

Do you have a product catalog but aren’t seeing product-specific data? You likely have a “simple” pixel integration. Connect through the Support Center to unlock product-level insights with an “advanced” pixel integration.

As you gather and act upon this newfound data, be sure to check out our Support Center. It’s chock full of best practices and ideas to guide you along the way. You can also read these articles as you follow-through on the stories of your data:

Our data is only as powerful as the stories you tell with it. Use the above information to find the answer you are looking for.

 

Anonymous's picture
Anonymous (not verified)
June 11, 2017
I know this may sound stupid, but when I am sent to one of your pages to apply to the campaign for Dish, it uploads me to "your phone number" I then put my number in,, but that just connected me to the caller/response person, (customer service asking how they could help me. Clearly I did not do something right. Please explain. Thank you---Judy
CJ Affiliate's picture
June 13, 2017
Hi Judy, can you send us your contact info and account ID to socialmedia@cj.com so we can follow up on this for you? Otherwise, if you prefer you can contact our Client Support team by logging in to your account and clicking the ? in the upper right corner and submitting a request. You can also reach the Client Support team at 1-800-761-1072. Thank you!

Add new comment