Run contests by uploading a CSV to register contestants
If you want to run a Contest with complex entry requirements (e.g., Hashtag Posts, combinations of multiple conditions, etc.), the "Upload CSV to register applicants" type of Contest, which allows you to register applicants in bulk via CSV, is convenient.
What you can do with this Contest
- You can manually Add applicants by uploading an applicant list as a CSV file.
- The applicant list can be created in SocialDog.
- You can flexibly design entry requirements by editing the CSV file with tools like Excel to determine whether the entry requirements are met.
- Data created with external tools can also be used.
Examples of Supported Entry Requirements
For example, you can run Contests like the following:
- Hashtag Contests
- Posting specified Hashtags
- Entry by Following
- Collaboration Contests
- Following multiple Accounts
- Reposts of specified Posts
- Contest Contests
- Posts with specified Hashtags or keywords
- Following multiple Accounts
How to proceed
Before the Contest begins
- (Optional) Set up Keyword Monitor
- If Posts containing Hashtags or keywords are entry requirements, create a Keyword Monitor to collect the necessary Posts for entry. For details, please refer to Collect Posts containing keywords (Keyword Monitor).
After the Contest ends
- Create a "Upload CSV to register applicants" type of Contest (you can create it anytime)
- After the application period ends, create an applicant list (CSV file)
- Extract users who meet the entry requirements and create a CSV file with one X (Twitter) username per line for each applicant.
- Import the CSV file to register applicants
- Draw lots / Adjust winners
- Send DMs to winners
Creating a "Upload CSV to register applicants" Type of Contest
- From the menu, click [Contests].

- Click [New Contest].
- Click [Upload CSV to register applicants].
- Enter the following information:
- Contest Name: This is for internal management in SocialDog (not displayed to participants).
- Application Period: Collects users who Reposted within the set period as applicants.
- Social profile to host the Contest: Used as the sender when sending DMs.
- Click [Create Contest].
Preparing a CSV file for importing applicants
First, download user data that meets the conditions in a CSV file. The location from which you download the CSV file varies depending on the entry requirements.
Next, filter or combine the contents of the CSV file to create a CSV file of applicants who meet the entry requirements.
Downloading CSV files of Posts/Users containing Hashtags or keywords
- You can collect relevant Hashtags using the "Keyword Monitor" feature and download applicant information as a CSV file.
- You can filter by information included in the obtained CSV file (e.g., Post content, Post date/time, number of Followers).
For details, please refer to Collect Posts containing keywords (Keyword Monitor).
Downloading CSV files of users who Liked, Reposted, or quoted a specific Post
- With the "Post engagement" feature, you can get a list of users who Liked, Reposted, or quoted a specific Post.
- You can filter by information included in the obtained CSV file (e.g., quoted Repost content, Post date/time, Follow date/time, number of Followers).
For details, please refer to Check and react to users who engaged with Posts.
Downloading CSV files of users who Followed a specific Account
- You can download a CSV file of the Following/Followers list for Accounts Linked to SocialDog.
- You can filter by information included in the obtained CSV file (e.g., Follow date/time, number of Followers).
For details, please refer to Manage Followers.
CSV files downloadable from SocialDog's "Inbox", "Followers", and "Post engagement" may be usable as applicant lists without modification.
It's smoother to extract only Posts within the application period using a spreadsheet (e.g., Excel, Google Sheets) and then compile them into a CSV file.
Creating a CSV file with only users who meet All entry requirements
Integrate data for each entry requirement into a single file, exclude users who do not meet All entry requirements, and create the final applicant list.
CSV file format
- Each line should contain one user.
- The CSV file should only contain usernames. Including or not including
@at the beginning is acceptable. - The text encoding format should be Shift-JIS or UTF-8.
Importing applicants with a CSV file
- On the Contest applicant list screen, click [Import CSV file].
- Select the CSV file for import according to the on-screen instructions.
- Click [Import CSV file].
If you import a CSV file while applicants are already registered, existing "applicants" will be Deleted. The content of the "Winners" and "Winner Candidates" lists will not be Updated.
You can import up to 10,000 users at a time.