Greetings! I see in the business version that an excel download is available.
It would be useful to see an example of such a report to see how the info is presented before committing to a Business package.
Perhaps you could export our latest competition as an excel and send to me?
Thank you !
Alan.
When opening the export modal you have various options to export your data. You can export for example:
Voters
This contains three sheets. The first sheet contains all voters in rows and their votes represented in columns. If you require additional attributes like email, phone number or anything else, this will also be represented in rows per voter. See following example:
| Image 1 | Image 2 | Image 3... | Created at | Updated at | |
|---|---|---|---|---|---|
| Voter name 1 | 1 | 2 | 3 | Timestamp | Timestamp |
| Voter name 2 | 1 | 2 | 3 | Timestamp | Timestamp |
| Summary | 2 | 4 | 6 |
The second sheet shows the distribution of votes when using a rating vote type like star rating. See following example:
| Image 1 | Image 2 | Image 3... | |
|---|---|---|---|
| Voted with +1 | 2 | 0 | 0 |
| Voted with +2 | 0 | 2 | 0 |
| Voted with +1 | 0 | 0 | 3 |
The third sheet contains all comments represented in following columns: ID, Name, Comment, Parent ID, Parent type Parent Content, Created at.
Votes
The Votes export is a simple table which shows each vote in a row. So a voter could be represented in multiple rows. See following example:
| Vote | Voters | Option | Created at | Updated at |
|---|---|---|---|---|
| 1 | Voter 1 | Image 1 | Timestampt | Timestampt |
| 1 | Voter 1 | Image 2 | Timestampt | Timestampt |
| 2 | Voter 2 | Image 1 | Timestampt | Timestampt |
| 1 | Voter 2 | Image 2 | Timestampt | Timestampt |
Images
When exporting images you can download a zip file containing all uploaded source images in their original resolution. If you export images as excel you receive a table containing following information:
| ID | Option | Participations | Ratings | Sum | Resolution | Creator | Created at |
|---|---|---|---|---|---|---|---|
| 1 | Image 1 | 2 | 4.5 | 9 | 1920x1920 | Name 1 | Timestamp |
| 2 | Image 2 | 3 | 5 | 15 | 1920x1920 | Name 2 | Timestamp |
| 3 | Image 3 | 1 | 2 | 2 | 1920x1920 | Name 3 | Timestamp |
When requiring additional attributes from submitters, which you should if you want to contact them, you see each additional attribute in a extra row.
Thank you. Alan.