Import PR & Social Media Contacts
Step-by-Step Instructions
You can import your contacts into BuzzStream from a CSV file.
First, download our CSV import template so you can quickly get your data into the correct column ordering.
For the data specifications that describe the allowable values for each column, click here.
Here’s a quick preview of how the CSV file will look if you open it with Excel and start pasting your data into the appropriate columns.
Once you get all of your data into the appropriate columns, click “Save As,” choose CSV as the format, and give your file a name.
Next, Excel will prompt you with two dialog boxes–click Ok” and “Yes” when prompted.
Now, login to BuzzStream and go to the “PR & Social Media” tab and click “Import Contacts”.
Click the “Browse…” button and select the CSV file that you want to import and then click Upload.
The upload will begin. Once complete, you will see the following message:
Your upload is done and you’ll be sent an e-mail once the import is complete. It may take anywhere from 5 minutes to 2 hours for an import to complete, depending on the size.
What happens if I import the same person, media outlet, or article more than once?
If you import a person, media outlet or article that has already been added, BuzzStream skips it. However, if you import a person that has already been added, but the media outlet and/or article is not already associated with that person, the media outlet and article will be added to that person’s contact record. For example:
- You have an existing contact record for “Marshall Kirkpatrick,” a writer at the media outlet “ReadWriteWeb”
- You import a record for “Marshall Kirkpatrick” at the media outlet “Marshall Kirkpatrick’s Blog,”
- The media outlet “Marshall Kirkpatrick’s Blog” will be added to Marshall Kirkpatrick’s contact record in addition to ReadWriteWeb.
How do I export my contacts from BuzzStream?
You can export your BuzzStream contacts into a .CSV file. CSV files can be viewed opened in spreadsheets, databases and e-mail systems (e.g., Microsoft Outlook and Gmail).
- To export People, go to PR and Social Media>People and click Export Contacts
- To export Media Outlets, go to PR and Social Media>Media Outlets and click Export Contacts
CSV Import Format Specification
| Column | Name | Required? | Default value | Required values/formats | Notes |
| 1 | Person First Name | Yes | |||
| 2 | Person Last Name | Yes | |||
| 3 | Assigned To | No | User conducting import | First and last name of an existing user in your account. | |
| 4 | Overall Rating | No | NULL | Very High, High, Medium, Low, Very Low | |
| 5 | Person About | No | NULL | ||
| 6 | Email 1 | No | NULL | ||
| 7 | Email 2 | No | NULL | ||
| 8 | Email 3 | No | NULL | ||
| 9 | Email 4 | No | NULL | ||
| 10 | No | NULL | |||
| 11 | Linked In | No | NULL | ||
| 12 | No | NULL | |||
| 13 | Friend Feed | No | NULL | ||
| 14 | Contact Us Url | No | NULL | ||
| 15 | Phone 1 | No | NULL | ||
| 16 | Phone 2 | No | NULL | ||
| 17 | Fax | No | NULL | ||
| 18 | Address Line 1 | No | NULL | ||
| 19 | Address Line 2 | No | NULL | ||
| 20 | City | No | NULL | ||
| 21 | State | No | NULL | ||
| 22 | Zip | No | NULL | ||
| 23 | Country | No | NULL | ||
| 24 | Media Outlet Name | No | NULL | ||
| 25 | Media Outlet Website | No | NULL | Valid website address (e.g. http://www.foo.com) | Required if value set in column 24 does not already exist with a Media Outlet Website address. |
| 26 | Media Outlet Type | No | NULL | Blog, Newspaper, Radio, TV, Magazine, Trade Publication, Forum, Shopping Guide, Wire Service, Calendar, Traditional Media, Other | |
| 27 | Media Outlet Job Title | No | NULL | ||
| 28 | Media Outlet About | No | NULL | ||
| 29 | Article Url | No | NULL | Valid website address (e.g. http://www.foo.com) | Required if values are set in columns 29-33. |
| 30 | Article Headline | No | NULL | ||
| 31 | Article Coverage | No | No | Yes or No | Indicates if the article was coverage of your company or client. |
| 32 | Article Media Outlet | No | NULL | Must be the name of an existing media outlet or within the same import. | |
| 33 | Article Publication Date | No | NULL | mm/dd/yyyy | |
| 34 | Person Tag 1 | No | NULL | ||
| 35 | Person Tag 2 | No | NULL | ||
| 36 | Person Tag 3 | No | NULL | ||
| 37 | Person Tag 4 | No | NULL | ||
| 38 | Person Tag 5 | No | NULL | ||
| 39 | Person Tag 6 | No | NULL | ||
| 40 | Person Tag 7 | No | NULL | ||
| 41 | Person Tag 8 | No | NULL | ||
| 42 | Person Tag 9 | No | NULL | ||
| 43 | Person Tag 10 | No | NULL | ||
| 44 | Person Tag 11 | No | NULL | ||
| 45 | Person Tag 12 | No | NULL | ||
| 46 | Person Tag 13 | No | NULL | ||
| 47 | Person Tag 14 | No | NULL | ||
| 48 | Person Tag 15 | No | NULL | ||
| 49 | Person Tag 16 | No | NULL | ||
| 50 | Person Tag 17 | No | NULL | ||
| 51 | Person Tag 18 | No | NULL | ||
| 52 | Person Tag 19 | No | NULL | ||
| 53 | Person Tag 20 | No | NULL | ||
| 54 | Person Tag 21 | No | NULL | ||
| 55 | Person Tag 22 | No | NULL | ||
| 56 | Person Tag 23 | No | NULL | ||
| 57 | Person Tag 24 | No | NULL | ||
| 58 | Person Tag 25 | No | NULL | ||