You can export advertiser 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 advertisers in bulk or use that information outside the TUNE platform. Some examples of exported data are advertiser IDs, statuses, and company names.
How to Export Advertisers
From the main menu, go to Company > Customize Application > Import Data > Advertisers. Then, in the Download Advertiser Data section, click Download Advertisers to begin the download.
List of Exported Fields
The number of advertiser 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 advertiser | Numeric ID of the advertiser | 1004 |
| address1 | Main address | Up to 255 characters | 123 Demo St. |
| address2 | Secondary address | Up to 255 characters | Suite 200 |
| city | City in address | Up to 255 characters | Seattle |
| region | State or region in the address | Up to 255 characters | WA |
| country | Country in address | Two-letter capital letter country code | US |
| zipcode | Zip code of the address | Valid zip/postal code | 98101 |
| company | Name of advertiser/company | Up to 255 characters. If an advertiser is an individual, this is usually their first and last name | Test Company -or- John Doe |
| account_manager_id | The ID of the employee assigned to manage this advertiser | Numeric ID of the employee | 20 |
| status | Status of the advertiser account | active, pending, blocked, deleted, or rejected | active |
| phone | Phone number of the company | +(country code + area code + number) | +12065181318 |
| fax | Fax number of the company | +(country code + area code + number) | +12065181318 |
| signup_ip | The IP address that the user signed up from | 4 Numeric values separated by decimals: XXX.XXX.XXX.XXX |
45.121.240.70 |
| ref_id | Reference ID for this advertiser account in another system | Up to 255 characters | test123 |
| website | Website of Company | Does not work with “http://” prepended | www.example.com |
| first_name | First name of the advertiser | Up to 255 characters | John |
| last_name | Last name of the advertiser | Up to 255 characters | Doe |
| Email address of the user for the account | Any valid email address: XXXX@XXX.XXX |
john@example.com | |
| title | Job position at the company for user | Up to 255 characters | Media Buyer |