Are you interested in tracking average order value and product id from e-commerce transactions that happen in your shopping cart back into your LiveBall console for reporting and optimization? No problem! You can track the average order value and product id back to LiveBall by adding these fields to the Convert tracking script (located in your LiveBall console) and placing this javascript on the confirmation page of your website or shopping cart.

Before We Begin

To track average order value and product id successfully back to LiveBall, you will first create these data fields in your LiveBall console.

1. Hover over the “Integration” tab and select “Data Collection”
2. Create a unique data field category by clicking “+ category”
3. Input a category name for this data and click save (i.e. “AOV Data Fields”)
4. Add a new data field by clicking “+ data field”
5. Input a data field title (i.e. “order value”)
6. Input a data name
1. Please note that this will be the label under which LiveBall saves the order value and product id. The data name cannot have any spaces and will be plugged into your tracking script (i.e. “OrderValue”).
7. Click save
8. Repeat steps 5-7 for any other e-commerce data you wish to track (i.e. product id, SKU, order #, etc.)

Let’s Get Started!

Now that the data fields have been created in LiveBall, insert the below javascript before the closing </body> tag of your external confirmation page (i.e. your shopping cart thank you page). You’ll work with your website or shopping cart administrator to dynamically populate the script with the order value and any other information you are passing.

<!-- LiveBall Convert Javascript begins -->

<script type="text/javascript" src="https://yourconsole.postclickmarketing.com/Outside/liveball.js"></script>

<script type="text/javascript">

liveballRecognize("yourconsole.postclickmarketing.com");

liveballData("averageordervalue", "REPLACE_WITH_AVERAGE_ORDER_VALUE");

liveballData("other_data", "REPLACE_WITH_OTHER_DATA");

liveballConvert();

</script>

<!-- LiveBall Convert Javascript ends -->

*Please note that ”averageordervalue” and “other_data” are placeholders for the data names you created in the “Before we begin” portion above. These will be replaced with the data names you create and save in your console’s Data Collection. Additionally, please note that “yourconsole” is also a placeholder and will need to be replaced with the default address of your LiveBall console. The postclickmarketing part of the domain should not be changed, however.

Reporting

Once the above Javascript is in place, the data points in the script will track back to LiveBall. From there, you can generate a Source and Creative Drilldown report that will include these particular data points’ values. To view this report, follow these steps:

1. Click the “Reports” tab in your LiveBall console
2. Click “+ report”
3. Select either “System” or “Portfolio” as the scope of your report
1. If you selected “Portfolio,” then select the portfolio you would like included in the report
4. Select “Source and Creative Drilldown” as your report type
5. Select the data field category (which was created in the “Before we begin” section above)
6. Select the average order value data field
7. Select “average” from the drop-down to the right of the data field
8. Click “+ data field”
9. Repeat steps 5-6 for product id, if applicable
10. Select “count” next to the product id data field
11. Select the date range for which you would like to view this data
12. Click “run”
13. On the next page, select the blue refresh button toward the top of the screen to begin downloading a Excel-ready .csv file for this report
14. When you open your Source and Creative Drilldown report, you will see average order value and other data in the columns to the right