Payout Structures Update
TUNE offers a custom feature that allows you to bulk update Payout Structures using a CSV file. Customers with this feature enabled will see an Upload File option when navigating to the Edit Payout Structures page. If you do not see this option and would like to learn more, don't hesitate to get in touch with your Customer Success Manager or email support@tune.com.
*Important: The uploaded file completely overwrites the existing Payout Structure and any partner-specific settings for that Payout Structure.
CSV Upload
To begin, navigate to the Offers tab and select Payout Structures.
On the next page, you will see the option to Upload your CSV file.
File Requirements
- The file must be in CSV format.
- Partner-specific payouts need to have a column indicating which partner by specifying the TUNE partner_id
Mandatory fields:
- name
- payout
- At least one click or conversion parameter (adv_sub or aff_sub)
Valid headers
- name
- adv_sub
- adv_sub_operator
- adv_sub2 - adv_sub5
- adv_sub2_operator - adv_sub5_operator
- aff_sub
- aff_sub_operator
- aff_sub2 - aff_sub5
- aff_sub2_operator - aff_sub5_operator
- payout
- revenue
- amount
- partner_id
Valid operators
- EQUALS
- IN
- NOT
- LIKE
- NUMBER_EQUALS
- GREATER_THAN
- LESS_THAN
Example:
name |
adv_sub2 |
adv_sub2_operator |
payout |
partner_id |
Payout Structure for categories |
Electronics |
EQUALS |
15.00 |
5 |
*When using the IN operator, the value needs to be a comma or semi-colon delimited string wrapped in double quotes. Example: "text one, text two”
Note: If the matching operator column is not included, the upload will default to the text EQUALS operator.
Evaluation Order
Payout rules are assigned an evaluation order. Place the highest priority rules at the top of the file. For example, to ensure partner-specific rules take effect, place them higher than generic rules that could be applied to the same conversion.
Scheduled changes
If you would like to schedule a change in the future, you can use the date picker next to the upload button. This will allow you to set a date for when you would like the file to be applied.
Upload History
There is an additional tab under the Offer menu called “Payout Structure History” with a dashboard detailing the status and history of all files uploaded. The dashboard provides information about the file uploaded, the payout structure and partners it affects, and the date and status of any changes to be made.
Limitations
- Only default click and conversion parameters are supported (adv_sub1-5, aff_sub1-5, and source).
- Payout Structures based on Custom Parameters cannot be edited via CSV at this time.
Frequently Asked Questions
Why can't partners see Payout Structure rates when logging into the Partner Interface? - Make sure to check if your partner has an ad blocker or other browser extensions that could affect page loading
Why is an error received when uploading a new partner-specific payout? - If the partner never had a specific payout set before, you need to create a base payout structure under the partner-specific tab first, then try the upload again