Kickstarter Campaign Optimization: A Data-Driven Approach Using SQL

This report presents a data-driven analysis using SQL to assist a group of board game enthusiasts in planning their Kickstarter campaign. The analysis focuses on determining an appropriate funding goal by examining successful table game campaigns, estimating the required number of backers, and suggesting reward pricing based on average pledges. It also investigates the differences between successful and unsuccessful campaigns in terms of funding goals, backer numbers, and campaign duration, concluding that while goal amount and backer numbers significantly impact success, campaign duration does not. The findings provide actionable insights for the enthusiasts to make informed decisions, enhancing their chances of a successful campaign. Desklib offers similar solved assignments and study tools for students.

COVER PAGE
Fill your details

Introduction
This report discusses the findings of applying a set of basic data science skills through use of SQL on a set
of existing data to help determine the viability of setting up a kick starter campaign for a group of board
games enthusiasts. By analyzing the existing data, information that can be very helpful to the group can
be derived to help them make decisions about different aspects of the campaign.
Data analysis
Data analysis will be performed based on the provided guidelines which are;
1. How much money to aim for i.e. setting up the goal
To determine how much money the group of board games enthusiasts should aim for it’s
necessary to get the average goal for campaigns that are similar in nature. According to the data
provided the best category matching board games is games which can further be specified to
table games. Using the table games sub category we can get the average goal for all campaigns
that have been successful so far. Failed campaigns are ignored because they can cause a higher
degree of inaccuracy thus focusing on only the successful will give more precise information.
By using this query;
select avg(goal) from campaign where sub_category_id in (SELECT
id FROM `sub_category` where name like '%table%') and
outcome='successful' group by sub_category_id;
Based on the results above, the group should aim for approximately 10258 as their goal.
2. Number of backers needed
The number of backers needed/expected for the campaign can be obtained by getting the
average backers for a sub category that is similar to board games which table games like in the
guideline above. Using the query below, we can get the average backers for successful board
games;
select avg(backers) from campaign where sub_category_id in
(SELECT id FROM `sub_category` where name like '%table%') and
outcome='successful' group by sub_category_id;
Thus according to the results the group will need atleast 785 backers.
3. Price of the rewards
The price of the rewards can be extracted based on the total money and the expected backers
thus by dividing the total money to the expected number of backers we can get the approximate
price for the rewards which is around $13.
4. Are the goals of successful and unsuccessful significantly different
Based on the data there is a significance difference on the goals for successful campaigns and
goals for unsuccessful campaigns. By using the query below, a clear illustration of the difference
between successful and unsuccessful is shown;

select a.goal as successful,b.goal as failed,a.goal-b.goal as
difference from
(select avg(goal) as goal from campaign where
outcome='successful') a,
(select avg(goal) as goal from campaign where outcome='failed')
b;
The results above show that unsuccessful campaigns have higher goals as compared to
successful campaigns and the difference between the two is significant.
5. How do successful and unsuccessful campaigns differ in terms of the number of backers,
Using the query below, we can show the average number of backers for both successful and
unsuccessful campaigns;
select a.backers as successful,b.backers as failed from
(select avg(backers) as backers from campaign where
outcome='successful') a,
(select avg(backers) as backers from campaign where
outcome='failed') b;
According to the results above, successful campaigns have a higher number of backers as
compared to unsuccessful campaigns. The difference between the successful and unsuccessful
campaigns is also a significant difference.
6. How much money on average are backers pledging
Using the query below, the average amount backers are pledging can be derived from the
provided data;
select avg(pledged/backers) from campaign;
According to the results shown from the query above, the average amount of money pledged by
the backers is 78.
7. Influence the average pledge amount should have on the prices of rewards.
According to the data provided, the higher the pledge amount, the higher the prices of rewards
since higher pledges means that the campaign will have more money thus the prices can be
higher.
8. Does duration of a campaign have an impact?
By evaluating the average difference between the launch date and the deadline for both
successful and unsuccessful campaigns, the impact can be determined. The query below can be
used to evaluate the data;
select a.period as successful,b.period as failed from
(select avg(datediff(deadline,launched)) as period from campaign
where outcome='successful') a,

(select avg(datediff(deadline,launched)) as period from campaign
where outcome='failed') b;
Based on the results shown above, there is no significant difference of the average time
between the launch date and the deadline for both successful and unsuccessful campaigns thus
the time difference does not have a major impact on the success of a campaign.
Conclusion
By using the data analysis results described in each of the guidelines in the section above, the board
games enthusiasts group can be better insights on their campaign which will facilitate better decision
making.