How To

Year End Reporting Best Practices

Ah, January; time for new resolutions and everyone’s favorite – year-end reporting! With that in mind, we wanted to cover some of the most popular reports that our customers use to sum up their year and plan for the upcoming year.

Overall Review


 

For all businesses, we recommend that you utilize the Cross-Channel Dashboard , which provides a high level, trended view of your GMV/Revenue performance. 


 

The Cross-Channel Dashboard is broken down by channels and sites so that you can quickly identify areas of your business that are improving or declining. With this dashboard you can see two types of revenue:

  1. Attributed Revenue , which answers the question "What channels are generating my sales?” 
  2. Transactional Revenue , which answers the question "Where are my sales occurring?"

Transaction Review


For transactional channels such as Marketplaces and Webstores there are a few primary reports that we recommend at year-end:

Payment Cleared Reports – These reports allow you to see the most pertinent details of each order. They can be scheduled in the Report Center to run daily, weekly, monthly or quarterly. The Payment Cleared report contains orders broken down at an Invoice level, while the Payment Cleared Detail report breaks out each invoice line item and is a better choice if you are interested in the product details of each order as opposed to just the totals.  

SKU Activity Reports – These reports allow you to see the performance data about SKUs during a certain time period. This report is ideal for extracting information on which SKUs are selling well and should be promoted in the next year, as well as which SKUs are not selling well and should be adjusted.

Advertising Channels


 

For advertising-based channels such as Comparison Shopping or Paid Search, there are a few primary reports. These are available within the interface and allow you to drill down, filter and export data to show the data that is important to you. They also appear within the Report Center.

Performance Reports – These are by far the most popular reports and views for Paid Search or Comparison Shopping channels. The Performance Reports groups your performance data points by channel, provider, campaigns, etc. so you can see the health of your channel at various levels. They report data such as clicks, marketing cost, order count, assists, revenue, margin, etc. and equip you to make business decisions on where you should spend your advertising budget. Start by running these reports at a channel level and drill down into data points that are high or low to determine if more budget should be allocated or if changes need to be made. 

Conversion Report – This report provides the details on all orders that have been tracked in ChannelAdvisor for Paid Search or Comparison Shopping. The data includes the order date and time, the order ID (useful to map back to your internal system), amount, keyword/SKU credited with the order and more. Use this data to see which keywords or SKUs are contributing to sales for your business. 

Reference


Ah, January; time for new resolutions and everyone’s favorite – year-end reporting! With that in mind, we wanted to cover some of the most popular reports that our customers use to sum up their year and plan for the upcoming year.

Overall Review


 

For all businesses, we recommend that you utilize the Cross-Channel Dashboard , which provides a high level, trended view of your GMV/Revenue performance. 


 

The Cross-Channel Dashboard is broken down by channels and sites so that you can quickly identify areas of your business that are improving or declining. With this dashboard you can see two types of revenue:

  1. Attributed Revenue , which answers the question "What channels are generating my sales?” 
  2. Transactional Revenue , which answers the question "Where are my sales occurring?"

Transaction Review


For transactional channels such as Marketplaces and Webstores there are a few primary reports that we recommend at year-end:

Payment Cleared Reports – These reports allow you to see the most pertinent details of each order. They can be scheduled in the Report Center to run daily, weekly, monthly or quarterly. The Payment Cleared report contains orders broken down at an Invoice level, while the Payment Cleared Detail report breaks out each invoice line item and is a better choice if you are interested in the product details of each order as opposed to just the totals.  

SKU Activity Reports – These reports allow you to see the performance data about SKUs during a certain time period. This report is ideal for extracting information on which SKUs are selling well and should be promoted in the next year, as well as which SKUs are not selling well and should be adjusted.

Advertising Channels


 

For advertising-based channels such as Comparison Shopping or Paid Search, there are a few primary reports. These are available within the interface and allow you to drill down, filter and export data to show the data that is important to you. They also appear within the Report Center.

Performance Reports – These are by far the most popular reports and views for Paid Search or Comparison Shopping channels. The Performance Reports groups your performance data points by channel, provider, campaigns, etc. so you can see the health of your channel at various levels. They report data such as clicks, marketing cost, order count, assists, revenue, margin, etc. and equip you to make business decisions on where you should spend your advertising budget. Start by running these reports at a channel level and drill down into data points that are high or low to determine if more budget should be allocated or if changes need to be made. 

Conversion Report – This report provides the details on all orders that have been tracked in ChannelAdvisor for Paid Search or Comparison Shopping. The data includes the order date and time, the order ID (useful to map back to your internal system), amount, keyword/SKU credited with the order and more. Use this data to see which keywords or SKUs are contributing to sales for your business. 

Reference


0
Your rating: None Average: 3 (1 vote)
0
Your rating: None Average: 3 (1 vote)