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 |
http |
| 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) |
cpa_flat |
| 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) |
cpa_flat |
| 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 |