[📊 DATA] campaigns data #47
Description
We need help with on chain metrics for campaigns essentially kickstarter on chain on near where you can create fundraisers on behalf of other peope with referrals and optional minimum target amount
v1.campaigns.staging.potlock.near
https://potlock.org/campaign-specs
- referrals earned for users, campaign creator
- how many campaigns are created by a creator
- how many campaigns are made on behalf of someone
- average minimum funding amount
- how many campaigns have a minimum and maximum
- the range between minimum and maximum and target if exists
- timeline for a raise
- how many people get refunded
- how long until a campaign hits minimum target
- size of donations
- whether donors are funding multiple campaigns
- which projects have most campaigns made in their behalf
- analysis of type of campaigns being made
- total funding raised by time
- how multiple campaigns on behalf of project impact amount raised (whether it makes fundraising slower)
- impact on minimum amount driving donations
- whether people who donate to campaigns have previously donated through pots or direct donations. Or created list
- whether people who donated to campaigns have donated to that particular proejct before
- relationship between campaign creator and beneficiary if not same person (where they previously a donor, do they follow on near social, are they a new account)
- potlock fees generated
- influence of campaigns on new project creations
And any combination of these queries