Application Support:Upload Conversions
From HasOffers
Upload conversions by transaction IDs or affiliate / offer information. The file must be in TXT or CSV format. To upload conversions, hover over the Reports tab, select Conversion Report and then click Upload Conversions.
You can then record and update conversions into your network by uploading a list of Transaction IDs. If the Transaction ID 7899549879 references a click for offer ID 1 generated by affiliate ID 5, then when uploaded a conversion will be created that is tied to this click. You can pass transaction ID to the advertiser or to other networks by including {transaction_id} in the Offer URL. On click this value will be dynamically replaced with the ID of the click transaction that references the affiliate offer and other tracking information.
You can record conversions with affiliate and offer information. Uploading conversions with this method will just record conversions based on the specified data. It won't update any conversions, only create new ones.
Approve Pending or Record Conversions by Transaction ID
Use this to approve pending conversions or record conversions with the specified Transaction IDs.
This upload method is used to approve conversions that are currently Pending. If a conversion has a status of Pending because the offer has require approval of conversions enabled, then you can create a list of the Transaction IDs relating to pending conversions. Uploading a list of Transaction IDs for pending conversions will update the status of the conversions to Approved.
You can also record conversions by specifying Transaction IDs. If a Transaction ID correspond to a valid user session, then uploading the Transaction ID will record a conversion based on the session information. Sale amount can be included as an optional field when the offer payout or revenue is based on a percentage of the sale. No additional fields will be processed besides sale amount when recording conversions.
Required fields:
- transaction_id - ID of user session
Optional fields:
- sale_amount - amount of total sale which is important when offer payout or offer revenue is percentage of sale amount
By only specifying Transaction IDs, the upload script performs the following actions:
- If a conversion already exists for the Transaction ID and the status of the conversion is pending, the conversion will be set to approved.
- If a conversion does not exists for the Transaction ID, a conversion will be created based on the session information associated with the Transaction ID.
If the upload is only going to include Transaction IDs, then you can just list Transaction IDs separated by commas.
7899549879, 45648978935, 6877563215489
If the upload is only going to include Transaction IDs with sale amount, then you need to include a Header row that specifies the columns with each new conversions on a new line.
transaction_id, sale_amount
7899549879, 19.00
45648978935, 1.50
Bulk Updating Conversions in Your Network
This advanced conversion upload method bulk updates already recorded conversions in your network. You can update affiliate payouts for an offer retro-actively using this method.
Required field:
- transaction_id - ID of user session
Optional fields:
- status - pending, approved, rejected
- payout - amount affiliate is compensated for conversion
- revenue - amount network earns for conversion
- sale_amount - amount of total sale which is important when offer payout or offer revenue is percentage of sale amount
- affiliate_manager_id - Id of employee managing affiliate.
- advertiser_id - Id of advertiser for offer.
- advertiser_manager_id - Id of employee managing advertiser.
- offer_url_id - Id of offer URL.
- offer_file_id - Id of offer file.
- ad_campaign_id - Id of ad campaign.
- ad_campaign_creative_id - Id of ad campaign creative.
- payout_type - cpa_flat, cpa_percentage, cpa_both, cpc, cpm
- revenue_type - cpa_flat, cpa_percentage, cpa_both, cpc, cpm
- source - Affiliate source passed in by affiliate when session was started.
- affiliate_info1 - Affiliate sub 1 passed in by affiliate when session was started.
- affiliate_info2 - Affiliate sub 2 passed in by affiliate when session was started.
- affiliate_info3 - Affiliate sub 3 passed in by affiliate when session was started..
- affiliate_info4 - Affiliate sub 5 passed in by affiliate when session was started.
- affiliate_info5 - Affiliate sub 6 passed in by affiliate when session was started.
- advertiser_info- Advertiser sub passed in by advertiser when conversion pixel / URL called.
- user_agent - User agent for user when session was started.
- country_code - Country code for user when session was started.
- datetime - Date time object created formatted like YYYY-MM-DD HH:MM "2010-09-08 10:48". Default today.
- refer - Referral URL where session was started..
- ip - IP address used to create conversion.
- is_adjustment - Flag to mark if the conversion was created as an adjustment. Set to 1.
- currency - 3 letter Currency code of Affiliate Invoice.
By specifying the transaction IDs along with additional information, the corresponding conversions will updated based on the specified data. If the status of a conversion is pending and status isn't set in the upload, the conversion will be set to approved.
To format an this type of upload, include a header row in the first line with optional fields. Then specify the Transaction IDs with additional information, each on a new line.
transaction_id, status, payout, revenue, sale_amount
7899549879, approved, 12.00, 15.00, 19.00
45648978935, , 1.50
6877563215489, rejected
Upload New Conversions without Transaction IDs
You can also upload conversions with affiliate and offer information and no transaction IDs. This method creates conversions based on the specified information.
Affiliate ID and offer ID are required for each conversion recorded this way.
Required fields:
- affiliate_id - ID of affiliate
- offer_id - ID of offer
- payout - amount affiliate is compensated for conversion
- revenue - amount network earns for conversion
Optional fields:
- status - pending, approved, rejected
- sale_amount - amount of total sale which is important when offer payout or offer revenue is percentage of sale amount
- affiliate_manager_id - Id of employee managing affiliate.
- advertiser_id - Id of advertiser for offer.
- advertiser_manager_id - Id of employee managing advertiser.
- offer_url_id - Id of offer URL.
- offer_file_id - Id of offer file.
- ad_campaign_id - Id of ad campaign.
- ad_campaign_creative_id - Id of ad campaign creative.
- payout_type - cpa_flat, cpa_percentage, cpa_both, cpc, cpm
- revenue_type - cpa_flat, cpa_percentage, cpa_both, cpc, cpm
- source - Affiliate source passed in by affiliate when session was started.
- affiliate_info1 - Affiliate sub 1 passed in by affiliate when session was started.
- affiliate_info2 - Affiliate sub 2 passed in by affiliate when session was started.
- affiliate_info3 - Affiliate sub 3 passed in by affiliate when session was started..
- affiliate_info4 - Affiliate sub 5 passed in by affiliate when session was started.
- affiliate_info5 - Affiliate sub 6 passed in by affiliate when session was started.
- advertiser_info- Advertiser sub passed in by advertiser when conversion pixel / URL called.
- user_agent - User agent for user when session was started.
- country_code - Country code for user when session was started.
- datetime - Date time object created formatted like YYYY-MM-DD HH:MM "2010-09-08 10:48". Default today.
- refer - Referral URL where session was started..
- ip - IP address used to create conversion.
- is_adjustment - Flag to mark if the conversion was created as an adjustment. Set to 1.
- currency - 3 letter Currency code of AffiliateInvoice.
If status isn't set, then conversions will be recorded as approved.
To format an this type of upload, include a header row in the first line with at least required fields. Then specify the conversion information, each on a new line.
affiliate_id, offer_id, status, payout, revenue, sale_amount
1, 1, approved, 12.00, 15.00, 20.00
1, 1, , 1.50, 2.00
1, 1, rejected, 5, 10
Email this page to a friend or co-worker
