Exporting Offers

You can export offer information from your network to a comma-separated value (CSV) file in just a few clicks. This can be useful if you want to update offers in bulk or otherwise use that information outside of the TUNE platform. Some examples of exported data are offer descriptions, offer statuses, payout settings, and revenue settings.

How to Export Offers

From the main menu, go to Company > Customize Application > Import Data > Offers. Then in the Download Offer Data section, click Download Offers to begin the download.

List of Exported Fields

The number of offer fields you can export using this tool is slightly smaller than the set of fields you can import. The following table contains all fields exported by the above process:

Column Name Description Possible Values Example
id ID of the offer Numeric ID of the offer 42
name Name of the offer Up to 255 characters Offer name
description Description of the offer Up to 65,535 characters This is an offer description
offer_url URL to the default landing page of the offer Any URL (http:// included) along with defined macros http://example.com?trans={transaction_id}
preview_url URL to preview landing page Any URL (http:// included) http://example.com
expiration_date Date and time the offer will expire (in UTC, not network time) YYYY-MM-DD HH:MM:SS 2020-01-31 23:59:59
advertiser_id ID of advertiser account Numeric ID of existing advertiser 20
protocol Protocol for conversion tracking http – HTTTP iFrame pixel
https – HTTPS iFrame pixel
http_img – HTTP Image pixel
https_img – HTTPS Image pixel
server – Server postback w/ transaction_id
server_affiliate – Server postback w/ partner ID
status Status of offer active, pending, paused, or deleted active
currency Three character symbol of the country currency See list of options here USD
payout_type How partners are compensated recorded as cost cpa_flat – Cost per Conversion (CPA)
cpa_percentage – Cost per Sale (CPS)
cpa_both – Cost per Conversion + Cost per Sale (CPA + CPS)
cpc – Cost per Click (CPC)
cpm – Cost per Thousand Impressions (CPM)
revenue_type How advertisers will pay recorded as revenue cpa_flat – Revenue per Conversion (RPA)
cpa_percentage – Revenue per Sale (RPS)
cpa_both – Revenue per Conversion + Revenue per Sale (RPA + RPS)
cpc – Revenue per Click (RPC)
cpm – Revenue per Thousand Impressions (RPM)
default_payout Flat rate payout set for the offer Monetary value with two decimal places. 5.00
percent_payout Percentage payout to a partner for a sale Whole percentage number (no % symbol) 25
max_payout Flat rate revenue set for the offer Monetary value with two decimal places. 7.00
max_percent_payout Percentage of a sale collected as revenue Whole percentage number (no % symbol) 30
tiered_payout Turns on tiered payouts for offer. Each tiers’ payout + revenue must be set in app 1 (enabled) or 0 (disabled) 0
is_private Enables offer to be private 1 (enabled) or 0 (disabled) 0
redirect_offer_id ID of the offer to redirect to when paused/expired Numeric ID of offer 44
converted_offer_id ID of the offer to redirect to if user has already converted Numeric ID of offer 44
converted_offer_url Custom URL to redirect to when user has already converted Any URL (“http://” included) along with defined macros http://othersite.com
conversion_cap Number of daily conversions allowed for offer Numeric whole number 2000
session_hours Number of hours the user session/cookies will be tracked Numeric whole number. 168
require_approval Requires approval for partner to access offer 1 (enabled) or 0 (disabled) 0
terms_and_conditions Adds terms & conditions to offer partners have to agree to Up to 255 characters Terms and conditions here
approve_conversions Turns on setting that requires approve all conversions for this offer 1 (enabled) or 0 (disabled) 0
allow_multiple_conversions Setting allows multiple conversion from same transaction ID 1 (enabled) or 0 (disabled) 0
allow_website_links Setting that allows custom landing page URLs to be passed in tracking links 1 (enabled) or 0 (disabled) 0
show_custom_variables Turns on setting to allow custom variables to be passed to advertiser 1 (enabled) or 0 (disabled) 0
set_session_on_impression Start tracking users on impression instead of click 1 (enabled) or 0 (disabled) 0
display_advertiser Option to show advertiser in partners interface 1 (enabled) or 0 (disabled) 0
enforce_geo_targeting Enforces geotargeting for offer 1 (enforced) or 0 (disabled) 1
dne_list_id ID of the suppression list for this offer Numeric ID of suppression list 2
email_instructions_from Text specifying instructions for email campaigns Up to 255 characters Test email instructions here
email_instructions_subject Text listing approval subjects for email campaigns Up to 255 characters Test email subjects here
is_seo_friendly_301 Turns on SEO friendly links for offer 1 (enabled) or 0 (disabled) 0
ref_id Reference ID for offer Up to 255 characters test123