You can export advertiser 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 advertisers in bulk or otherwise use that information outside of 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 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 advertiser | Numeric ID of 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 address | Up to 255 characters | WA |
| country | Country in address | Two-letter capital letter country code | US |
| zipcode | Zip code of address | Valid zip/postal code | 98101 |
| company | Name of advertiser/company | Up to 255 characters. If advertiser is an individual, this is usually their first and last name | Test Company -or- John Doe |
| account_manager_id | ID of the employee assigned to manage this advertiser | Numeric ID of employee | 20 |
| status | Status of advertiser account | active, pending, blocked, deleted, or rejected | active |
| phone | Phone number of company | +(country code + area code + number) | +12065181318 |
| fax | Fax number of company | +(country code + area code + number) | +12065181318 |
| signup_ip | 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 advertiser | Up to 255 characters | John |
| last_name | Last name of the advertiser | Up to 255 characters | Doe |
| Email address of user for the account | Any valid email address: XXXX@XXX.XXX |
john@example.com | |
| title | Job position at company for user | Up to 255 characters | Media Buyer |