You can export offer information from your platform 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 use that information outside 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/Export Data > Import/Export Offers.
Then, click Download Offers in the Download Offer Data section to begin the download.
List of Exported Fields
The number of offer fields you can export using this tool is slightly smaller than those you can import. The following table contains all fields exported by the above process:
| Column Name | Description | Possible Values | Example |
|---|---|---|---|
| id | The ID of the offer | The 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 the landing page | Any URL (http:// included) | http://example.com |
| expiration_date | Date and time the offer will expire (in UTC) | YYYY-MM-DD HH:MM:SS | 2020-01-31 23:59:59 |
| advertiser_id | The ID of the advertiser account | Numeric ID of existing advertiser | 20 |
| protocol | Protocol for conversion tracking | HTTP – HTTP 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 |
| Column Name | Description | Possible Values | Example |
| currency | Three character symbol of the country's currency | See a 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 | A flat rate payout is 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 offers. Each tier’s payout + revenue must be set in-app | 1 (enabled) or 0 (disabled) | 0 |
| Column Name | Description | Possible Values | Example |
| is_private | Enables offer to be private | 1 (enabled) or 0 (disabled) | 0 |
| redirect_offer_id | The ID of the offer to redirect to when paused/expired | The numeric ID of the offer | 44 |
| converted_offer_id | The ID of the offer to redirect to if the user has already converted | The numeric ID of the offer | 44 |
| converted_offer_url | Custom URL to redirect to when the user has already converted | Any URL (“http://” included) along with defined macros | http://othersite.com |
| conversion_cap | The number of daily conversions allowed for an 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 a partner to access offers | 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 the setting that requires approval for all conversions for this offer | 1 (enabled) or 0 (disabled) | 0 |
| allow_multiple_conversions | The setting allows multiple conversions from the 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 |
| Column Name | Description | Possible Values | Example |
| show_custom_variables | Turns on the setting to allow custom variables to be passed to an 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 | The ID of the suppression list for this offer | The numeric ID of the 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 |
| ref_id | Reference ID for offer | Up to 255 characters | test123 |