To view a database's entries, click Entries in the main menu. Find the list with the entries you'd like to view, click the down arrow icon to the right of the name, then select View Entries from the dropdown menu.
If you are in the Campaign Builder, the easiest way to access your entries is to look at your Form Widget (or Voting Widget) in the Edit Widgets Panel, then click the number of entries next to the little inbox icon.
The new layout of the View Entries page makes all of your entry filtering options more accessible. Finding and manipulating your entries is now much easier. Here's a rundown of each section and the multiple things you can do with your entries.
Regardless of which filters or sorting you end up using, your entries will appear on the right-hand side of the screen. Each entry will show you the following info:
- If the entry is approved (checkmark in the top-left corner) or not approved (no checkmark)
- The number of votes the entry has (in the top-right corner)
- The image or a still frame from a video (if attached)
- The name submitted with the entry
- The email address submitted with the entry
- The date and time that the entry was submitted
Hovering over each entry, you'll see a View Details button appear. Click the button to view the specific details about that entry - more in-depth information can be found in the Entry Details help doc.
Use the Search field in the top-left corner of the page to look through your entries using a single word or phrase. The Label field allows you to search through your entries by simply typing in the label name. Your results will automatically be displayed on the right.
All of your filtering options appear on the left-hand side; you can use any combination of options to show the exact entries that fit all of your filter criteria. As you select options, the selected entries appear on the right in real time. Your options are:
In the Approved filter, you can select whether you want to see only entries that are Approved, entries that are Not approved, or both.
If you're looking for specific entries within a date range, you'd set those parameters in the Date filter. Enter dates in both the From and To fields for a specific range, or set just one or the other for all entries after (or before) a specific date.
The name of the list you're viewing will appear here in the Lists filter - if you want to add entries from other lists in to your filter, you can do so here; just click Select Lists and choose the lists you'd like to add.
The Campaigns filter lets you select your entries by the campaign name instead of the list name - just click Select campaigns. Selecting a campaign will show all the entries attached to that campaign, whether it has only one form or multiple.
If you only want to see entries with images, check the box in the Image filter for Has image. If you'd rather target entries without, check the No image box.
The Video filter is similar to the Image filter; check the box next to Has video to see entries with videos, and the box next to No video for entries without.
If you're running a contest with multiple rounds of voting, you can use the Votes filter to show only entries that have votes from rounds 2 or 3.
If you have entries in your list from multiple countries, the Country field will allow you to sort out entries from a specific country.
The Test Entries filter allows you to take a look at your test entries for the campaign; just check the box to see the tests.
To sort the entries, click the button next to the number of entries at the top. Your options are to sort your entries by Newest, Oldest, Most Votes, and Least Votes.
The I Want To... drop-down menu is where you'll find three helpful features:
Selecting the Export option will allow you to export the selected entries to any email address you choose. If you want just the entry information (name, email, date, etc), select Comma Separated Values (.csv), which is a file type that is able to be imported into most common spreadsheet programs. If you need the images that were submitted with the entries, select Images - that will send a compressed .zip file with all of the images.
After that, select which fields to include using either Only visible fields or All fields, and type in the email address to which the file will be sent, then click Export & Close.
Note: The Export feature is only available on the Starter Plan or higher.
Importing a .CSV file into Excel
If your list includes any special characters, you'll need to follow these instructions carefully or you'll see random characters in Excel:
- Find the downloaded file on your computer and rename the extension to .txt instead of .csv.
- In Excel, click File > Open, then locate and select the downloaded and renamed file. An import dialog will appear.
- In the import dialog, designate that the file is Delimited with a Comma, and that the File Origin is set to UTF-8.
- Click Finish.
If you have filtered entries from multiple lists or campaigns, the Copy To feature allows the combining all of the selected entries into a new standalone list. Simply type in the name of your new combined list in the first field, and if you would like to add any tags to the new list, add those in the second field. Click the Continue button, and your screen will automatically be directed to the View Entries page of your new list.
Advanced Entry Picker
The Choose randomly option opens the Advanced Entry Picker, which can be used to select a winner at random from the chosen entries. Enter in the number of entries you'd like to pick, then add any labels (if any) that you'd like to have applied to the entries that are selected. You can also choose to allow entries to be chosen more than once, and also factor in extra votes/points for each entry. When everything is set satisfactorily, click Submit & Close and it'll show you the chosen entry or entries.
There are a few other options available when working with entries:
If entries are not automatically being approved, manual approval can be handled with this option. Click on each entry to highlight it, then click Approve and then All to approve the selected entries. To remove an approval, select the entry to be unapproved, then click Approve, then None.
To add a label to a large group of entries at once, click on the selected entries to highlight them, then click Label. From there, type the labels you'd like to add (separate each with a comma) in the field up top. If the entries already have any labels, they will be displayed underneath. When you have the labels typed out that need to be added, click Save.
To delete entries, click to highlight the entries to be removed, then click Delete. A prompt will appear asking to confirm the selection - click Delete again to permanently remove the selected entries.
Note: Entries deleted in this way are not recoverable. In addition, entries removed this way are not removed from the overall entry count attached to your account. To remove entries from counting towards the allowance, you will need to delete the entire list.