Breadcrumbs

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

 
{
'shopmy': 'Transaction Date',
'partnerize': 'Date Time'
}

{
'shopmy': 'date',
'partnerize': 'date'
}

partner_id

The Partner Identifier

Dimensions

 
{
'shopmy': 'Creator Name',
'partnerize': 'Partner ID'
}

{
'shopmy': 'creator_name',
'partnerize': 'partner_id'
}

partner_name

The Partner Name

Dimensions

 
{
'shopmy': 'Creator Name',
'partnerize': 'Partner Name'
}

{
'shopmy': 'creator_name',
'partnerize': 'partner_name'
}

country

Name of the country the purchase was made in

Dimensions

 
{
'shopmy': 'Country',
'partnerize': N/A
}

{
'shopmy': 'country',
'partnerize': N/A
}

total_conversions_value

This represents the cost of the order/purchase

Metrics

 
{
'shopmy': 'Order Amount',
'partnerize': 'Total Order Value'
}

{
'shopmy': 'order_amount',
'partnerize': 'total_order_value'
}

total_commission_amount

This represents the commission an affiliate/partner makes off each order/purchase

Metrics

 
{
'shopmy': 'Commission Amount',
'partnerize': 'Total Commission'
}

{
'shopmy': 'commission_amount',
'partnerize': 'total_commission'
}

total_conversions

This represents the total number of orders of an affiliate/partner

Metrics

 
{
'shopmy': 'N/A',
'partnerize': 'Total Conversions'
}

{
'shopmy': 'N/A',
'partnerize': 'total_conversions'
}

total_clicks

This represents the total number of clicks of an affiliate/partner

Metrics

 
{
'shopmy': 'N/A',
'partnerize': 'Total Clicks'
}

{
'shopmy': 'N/A',
'partnerize': 'total_clicks'
}

total_conversion_items

This represents the total number of items in an order

Metrics

 
{
'shopmy': 'Number of Items',
'partnerize': 'Total Conversion Items'
}

{
'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

 
{
'shopmy': 'Flat Fees'
'partnerize': 'N/A'
}

{
'shopmy': 'total_flat_fees',
'partnerize': 'N/A'
}