TAB Data: Campaigns


We use "campaign" to define any attempt to raise funds using peer-to-peer or crowdfunding. Due to the wide variety of possible funding mechanisms not all fields are available for all platforms. Where possible, we map platform-specific fields onto our own fields. If this is not possible (e.g risk_rating) we will leave the value unchanged but mark the field as platform-provided.

We strip HTML markup from the descriptive fields.

We convert currency values into four main currencies: GBP, USD, EUR and JPY. If the campaign has ended, we will use the exchange rate on the campaign's end date; if not we use the rate on the day of import.


Field Descriptions

Identifiers

Unique campaign identifiers. This encompasses identifiers added by TAB (such as the uuid), and those added by the platform (such as the project_id). We include the platform campaign URL in this section, since it uniquely identifies the campaign.

Key Description Example
identifiers.uuid

This is generated by TAB using the platform identifier and any other platform-provided identifiers (such as the platform_id) to provide a globally unique identifier across all platforms

api-10000-icuken31337icuken
identifiers.platform_campaign_url

Main campaign URL on the originating platform. This will be blank if the data originated from a non-web source e.g CSV data feed

http://www.exampleplatform.com/projects/my_project
identifiers.project_id

Identifier that is supplied by the platform to uniquely identify this campaign. Note that this is not always available, which is why we supply our own uuid to uniquely identify a campaign.

1001
identifiers.platform_id

TAB-specific ID used to identify the originating platform

443
identifiers.platform_name

Originating platform name

Kickstarter
Categories

Campaign categorisation. While some classifiers such as funding_type, funding_category and gics_industry_group are defined by TAB, the rest are defined by the platforms themselves (e.g tags)

Key Description Example
categories.funding_type

Campaign funding types. This is a more detailed classification than funding_categories:

  • C: community shares. These are investments in community-owned enterprises that are co-operative in nature and aim to benefit the community in which they operate.
  • B: bond. A bond is a debt investment in which an investor loans money to an entity for a defined period of time.
  • DE: debenture. Similar to a bond but debentures are not backed by collateral.
  • D: donation. A donation is the giving of money, without any expectation of a financial return.
  • E: equity. An equity investment means buying shares or stock in a company and is generally regulated by a national regulatory organisation.
  • IN: insurance. A mechanism that allows users to pool funds together to form a fund for insurance claims.
  • IV: invoice trading. Invoice trading is the process in which SMEs (sellers) auction their invoices online, as a way to gain quick access to money that would otherwise be tied up.
  • L: loan. A loan is money given to someone for a set period of time with the expectation that it will be repaid.
  • ME: membership / subscription. A campaign may invite a recurring subscription from supporters to achieve their aim. Subscription members then receive ongoing access to the product or service they have supported.
  • ML: microloan. A microloan is the loan of a very small amount of money. Microloans are often made to entrepreneurs in developing countries to enable them to establish a business and therefore become self-sufficient. Microloans may or may not be repaid, and may or may not carry interest.
  • RS: revenue sharing. Revenue-sharing arrangements mean an investor agrees to receiving a share of the organisation's revenue in exchange for their investment.
  • R: reward-based. Rewards refers to a pledge of money in support of a project or business in return for a gift
  • Y: royalties. Royalties are recurring payments made in return for the use of something (such as a book or soundtrack). How much money an investor makes from an investment in royalties will depend on how much the asset is used.
R
categories.funding_category

Broad campaign funding category

categories.gics_industry_group

We use NLP techniques to automatically tag campaigns with one of the standard GICS industry groups

Media
categories.category

Platform-specific category

Music
categories.tags

Campaign tags. Note that the set of possible tags is likely to vary widely between platforms

Dates

Start / end dates

Key Description Example
dates.start_date

Start date/time for this campaign. Where this is not available we default to the first date we encounter the campaign

2015-01-01T00:00Z
dates.end_date

End date/time for this campaign. If this is not available and the campaign is ongoing we default to today's date

2015-01-03T00:00Z
dates.duration

The campaign duration in days i.e the difference between the start date and the end date inclusive. This means that campaigns that start and end on the same day will have a duration of 1.

Funding

A fields related to the funding status of a campaign. This includes the goal and amount raised to date

Key Description Example
funding.currency

Campaign currency, as an ISO 4217 code

GBP
funding.funding_status

TAB-defined campaign funding status

  • funded: Campaign is funded i.e has reached it's goal within the required timeline
  • failed: Campaign failed. This may be because it didn't meet it's goal within the required timeline or was cancelled.
  • not_yet_funded: Campaign is ongoing and has not yet reached it's funding target
  • unknown: The campaign status is unknown. This is usually when either funding amounts or timelines are not made available by the platform
funded_ended
funding.goal

Campaign goal (i.e target), in the campaign-specified currency. Note that this should be the current goal, which may well be a 'stretch goal' if the initial goal was met

1234
funding.goal_fx.JPY

Goal in JPY

funding.goal_fx.USD

Goal in USD

funding.goal_fx.GBP

Goal in GBP

funding.goal_fx.EUR

Goal in EUR

funding.min_goal

The minimum target required before the campaign can be deemed successful. Generally this is only relevant for certain 'Reward' or 'Charity' type projects where the project need not raise the full amount to be successful, as opposed to an 'all or nothing' style campaign

1234
funding.raised

The total amount raised to date, in the campaign currency.

1000
funding.raised_fx.JPY

Amount raised in JPY

funding.raised_fx.USD

Amount raised in USD

funding.raised_fx.GBP

Amount raised in GBP

funding.raised_fx.EUR

Amount raised in EUR

funding.funders

The total number of funders (i.e backers) contributing to this campaign

Location

Campaign location. If not supplied by the platform we will default to the primary platform location.

Key Description Example
location.country_code

ISO 3166-1 alpha-2 country code

GB
location.city

City

Cambridge
location.state

State or county

Cambridgeshire
Ownership

Campaigns may be associated with individuals, teams or companies.

Key Description Example
ownership.individual.id

A unique identifier for the user, set by the originating platform

1231
ownership.individual.username

User's username on the platform

darth_vader
ownership.individual.full_name

User's full name

Thomas the Tank Engine
ownership.individual.email

User's email.

sauron@gmail.com
ownership.company.name

Company name

ACME Widgets
ownership.company.company_url

Main company website

http://www.myinventedcompany.com
ownership.company.business_sector

Organisation's business sector.

Intergalactic domination
ownership.company.contact_email

Contact email

hello@insidetab.io
ownership.company.contact_phone

Organisation's contact telephone number.

+44 12345 678901
ownership.company.date_founded

When was the organisation founded?

2010-09-01
ownership.company.description

A short description of the organisation.

ownership.company_registration.registrar_name

The name of the national companies registrar

Companies House
ownership.company_registration.registered_name

The registered name of the company

TAB U.K. LTD
ownership.company_registration.id

National companies registrar's issued company ID. In a limited number of cases it is estimated using the Companies House search functionality.

08321670
ownership.company_registration.postcode

The postcode of the registered address

CB1 2LA
ownership.company_registration.url

The company URL on the registrar's website

https://beta.companieshouse.gov.uk/company/08321670
Descriptive fields

Fields used to describe this campaign, including links to any associated campaign media such as image thumbnails and videos.

Where the source language is non-English we use the Google Cloud Translation API to provide English translations.

Key Description Example
description.title

Headline title for the campaign

Fanstastic Widget
description.subtitle

Campaign subtitle

This widget will revolutionise your sock drawer!
description.description

The full textual description for this campaign. Note that if the source language is not English this translated description will be based on the first 256 characters in the original description

The Death Star is the newest and best in mobile military space platforms
description.project_thumbnail_url

Small image that represents this project

http://www.platform.com/a/b/myimage.png
description.facebook_url

URL to the Facebook page for this campaign

https://www.facebook.com/blahblah
description.twitter_url

URL to the Twitter page for this campaign

https://www.twitter.com/blahblah
Concepts

We apply NLP techniques to each of the available unstructured fields and extract noun-phrases. This can be a more convenient resource to characterise a campaign than the full textual descriptions.

Key Description Example
concepts.title

Concepts extracted from the title

fantastic widget|large
concepts.subtitle

Concepts extracted from the subtitle

spam|internet of things
concepts.description

Concepts extracted from the full description

Debt-specific fields

Fields specific to debt campaigns

Key Description Example
debt.description.loan_purpose

Purpose of the loan

Debt consolidation
debt.description.is_individual

Is this debt product issued to an individual?

True
debt.description.is_property

Is this a property-funding deal?

False
debt.risk.is_secured

Is this debt product secured?

False
debt.risk.risk_category

The platform-assigned textual risk category for the project. Note that the set of possible risk categories is likely to vary between different platforms

A
debt.risk.risk_rating

The platform-assigned numerical risk rating for the project. Note that the range of possible risk ratings is likey to vary between different platforms

500
debt.risk.security_value

If this is a secured loan, what is the amount of the security?

123123123
debt.risk.security_description

Platform-provided description of the asset security

First charge
debt.risk.loan_guarantee

Platform-provided description of the level of guarantees for the loan

Security Offered First Charge
debt.risk.LTV

Loan to value ratio

12.3
debt.interest.interest_rate

Interest rate offered in the loan. If the platform is a loan auction site, we compute the weighted interest rate from all the successful transactions. For debenture and bonds projects this is the interest rate provided on the investment

4.3
debt.interest.total_interest_payable

Total interest the borrower will pay to the lender over the lifetime of the loan

4.75
debt.repayment.loan_status

Normalised status of a loan (loan campaigns only)

repaid
debt.repayment.loan_term

Loan length or a revenue-sharing agreement in months

60
debt.repayment.final_repayment_date

Date of the final repayment

debt.repayment.default_date

Date that the loan defaulted

debt.repayment.total_paid

Total paid for this loan. This includes the principal, interest, any fees as well as default recoveries

1500
debt.repayment.interest_paid

Total interest paid on the loan to date

4.3
debt.repayment.principal_repaid

The amount repaid from the principal (i.e 'goal')

12345
debt.repayment.late_fees_paid

Total late fees paid to date

0
debt.repayment.loan_fee

A sum of all fees paid for a loan project

100
debt.repayment.monthly_installment

Amount the borrower has to repay each month

150
Equity-specific fields

Fields specific to equity campaigns

Key Description Example
equity.tax_relief

A comma-delimited list of applicable tax relief schemes. Note that this can also be used for donations projects

"EIS"| "SEIS"
equity.equity_offered

Percentage of equity offered

equity.min_equity_offered

Minimum percentage of equity offered, if equity on offer is a range

equity.max_equity_offered

Maximum percentage of equity offered, if equity on offer is a range

equity.pre_money_valuation

Pre-money valuation, in the project currency

1000000
equity.pre_money_valuation_fx.JPY

Pre-money valuation in JPY

equity.pre_money_valuation_fx.USD

Pre-money valuation in USD

equity.pre_money_valuation_fx.GBP

Pre-money valuation in GBP

equity.pre_money_valuation_fx.EUR

Pre-money valuation in EUR

equity.max_pre_money_valuation

Maximum pre-money valuation, in the project currency

2000000
equity.current_investment_valuation

The current valuation of the investment

12345
equity.total_funding_round_amount

The total size of the funding round. Applicable when part of the funding amount is raised off the platform

123123123
equity.share_type

Country-specific share type definition

A
equity.current_share_price

The current price of a single share on the secondary market for equity campaigns

123
equity.num_shares_sold

The total number of shares sold

12
equity.num_shares_offered

The total number of shares on offer

123
equity.num_shares_total

The total number of shares released for this company

4000