Data Library Field Mapping - Affiliate Performance

Overview

This document describes how all affiliate platform columns are mapped to the affiliate_performance Certified Datasource.

To understand which Alli Data Data sources are used within the affiliate_performance report, see the following link: https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/4053565466?atl_f=PAGETREE

Platforms include:

Partnerize
ShopMy

The value N/A identifies that the platform does not have a mapping for the corresponding column.

Column	Description	Dimensions / Metrics / Categorizations	Platform UI Name Mapping	Platform Mapping
id	The Internal Alli Id of the Record	`N/A`	`N/A`	`N/A`
date	The Date of Performance Data	Dimensions	CODE `{ 'shopmy': 'Transaction Date', 'partnerize': 'Date Time' }`	CODE `{ 'shopmy': 'date', 'partnerize': 'date' }`
partner_id	The Partner Identifier	Dimensions	CODE `{ 'shopmy': 'Creator Name', 'partnerize': 'Partner ID' }`	CODE `{ 'shopmy': 'creator_name', 'partnerize': 'partner_id' }`
partner_name	The Partner Name	Dimensions	CODE `{ 'shopmy': 'Creator Name', 'partnerize': 'Partner Name' }`	CODE `{ 'shopmy': 'creator_name', 'partnerize': 'partner_name' }`
country	Name of the country the purchase was made in	Dimensions	CODE `{ 'shopmy': 'Country', 'partnerize': N/A }`	CODE `{ 'shopmy': 'country', 'partnerize': N/A }`
total_conversions_value	This represents the cost of the order/purchase	Metrics	CODE `{ 'shopmy': 'Order Amount', 'partnerize': 'Total Order Value' }`	CODE `{ 'shopmy': 'order_amount', 'partnerize': 'total_order_value' }`
total_commission_amount	This represents the commission an affiliate/partner makes off each order/purchase	Metrics	CODE `{ 'shopmy': 'Commission Amount', 'partnerize': 'Total Commission' }`	CODE `{ 'shopmy': 'commission_amount', 'partnerize': 'total_commission' }`
total_conversions	This represents the total number of orders of an affiliate/partner	Metrics	CODE `{ 'shopmy': 'N/A', 'partnerize': 'Total Conversions' }`	CODE `{ 'shopmy': 'N/A', 'partnerize': 'total_conversions' }`
total_clicks	This represents the total number of clicks of an affiliate/partner	Metrics	CODE `{ 'shopmy': 'N/A', 'partnerize': 'Total Clicks' }`	CODE `{ 'shopmy': 'N/A', 'partnerize': 'total_clicks' }`
total_conversion_items	This represents the total number of items in an order	Metrics	CODE `{ 'shopmy': 'Number of Items', 'partnerize': 'Total Conversion Items' }`	CODE `{ 'shopmy': 'number_of_items', 'partnerize': 'total_conversion_items' }`
total_flat_fees	This represents the fees incurred by the client for hosting their products on the platform	Dimension	CODE `{ 'shopmy': 'Flat Fees' 'partnerize': 'N/A' }`	CODE `{ 'shopmy': 'total_flat_fees', 'partnerize': 'N/A' }`