Campaign Data

“Crowdfunding Campaigns: Metrics, Success Factors, and Key Insights”

@kaggle.preethamgouda_campaign_data

Table List

1 table(3.07 MB)

Campaign Data

@kaggle.preethamgouda_campaign_data.campaign_data

3.07 MB
100000 rows
14 columns

campaignid CampaignID	goalamount GoalAmount	raisedamount RaisedAmount	durationdays DurationDays	numbackers NumBackers	category Category	launchmonth LaunchMonth	country Country	currency Currency	ownerexperience OwnerExperience	videoincluded VideoIncluded	socialmediapresence SocialMediaPresence	numupdates NumUpdates	issuccessful IsSuccessful
CID_00000	76159	73518.02895458053	15	1903	Film	September	Australia	GBP	11	Yes	41758	3
CID_00001	69394	60068.68328829211	49	469	Art	October	Australia	GBP	7	Yes	79112	48
CID_00002	18652	22958.153469639627	58	148	Film	February	USA	EUR	17	No	3942	9	1
CID_00003	19487	24229.048389653817	39	780	Film	October	Germany	AUD	10	No	22047	35	1
CID_00004	26734	17984.630310924433	68	1622	Games	September	Australia	AUD	12	Yes	72568	17
CID_00005	33621	26373.54114484342	88	819	Film	April	USA	EUR	8	No	73736	25
CID_00006	77380	59282.025167388725	47	1214	Art	June	UK	CAD	14	Yes	24899	42
CID_00007	2510	1631.4183607999023	65	1487	Music	September	Australia	CAD	17	No	55200	1
CID_00008	83434	59637.68697851212	72	225	Technology	February	Australia	CAD	17	No	90320	38
CID_00009	43798	50387.41949692357	53	1304	Film	July	Australia	GBP	2	Yes	27659	27	1


CREATE TABLE campaign_data (
  "campaignid" VARCHAR,
  "goalamount" BIGINT,
  "raisedamount" DOUBLE,
  "durationdays" BIGINT,
  "numbackers" BIGINT,
  "category" VARCHAR,
  "launchmonth" VARCHAR,
  "country" VARCHAR,
  "currency" VARCHAR,
  "ownerexperience" BIGINT,
  "videoincluded" VARCHAR,
  "socialmediapresence" BIGINT,
  "numupdates" BIGINT,
  "issuccessful" BIGINT
);