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.
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.
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
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
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.
TAB-specific ID used to identify the originating platform
Originating platform name
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)
Campaign funding types. This is a more detailed classification than funding_categories:
Broad campaign funding category
We use NLP techniques to automatically tag campaigns with one of the standard GICS industry groups
Campaign tags. Note that the set of possible tags is likely to vary widely between platforms
Start / end dates
Start date/time for this campaign. Where this is not available we default to the first date we encounter the campaign
End date/time for this campaign. If this is not available and the campaign is ongoing we default to today's date
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.
A fields related to the funding status of a campaign. This includes the goal and amount raised to date
Campaign currency, as an ISO 4217 code
TAB-defined campaign funding status
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
Goal in JPY
Goal in GBP
Goal in EUR
Goal in USD
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
The total amount raised to date, in the campaign currency.
Amount raised in JPY
Amount raised in GBP
Amount raised in EUR
Amount raised in USD
The total number of funders (i.e backers) contributing to this campaign
Campaign location. If not supplied by the platform we will default to the primary platform location.
State or county
Campaigns may be associated with individuals, teams or companies.
A unique identifier for the user, set by the originating platform
User's username on the platform
User's full name
|Thomas the Tank Engine|
Main company website
Organisation's business sector.
Organisation's contact telephone number.
|+44 12345 678901|
When was the organisation founded?
A short description of the organisation.
The name of the national companies registrar
The registered name of the company
|TAB U.K. LTD|
National companies registrar's issued company ID. In a limited number of cases it is estimated using the Companies House search functionality.
The postcode of the registered address
The company URL on the registrar's website
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.
Headline title for the campaign
|This widget will revolutionise your sock drawer!|
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|
Small image that represents this project
URL to the Facebook page for this campaign
URL to the Twitter page for this campaign
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.
Concepts extracted from the title
Concepts extracted from the subtitle
|spam|internet of things|
Concepts extracted from the full description
Fields specific to debt campaigns
Purpose of the loan
Is this debt product issued to an individual?
Is this a property-funding deal?
Is this debt product secured?
The platform-assigned textual risk category for the project. Note that the set of possible risk categories is likely to vary between different platforms
The platform-assigned numerical risk rating for the project. Note that the range of possible risk ratings is likey to vary between different platforms
If this is a secured loan, what is the amount of the security?
Platform-provided description of the asset security
Platform-provided description of the level of guarantees for the loan
|Security Offered First Charge|
Loan to value ratio
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
Total interest the borrower will pay to the lender over the lifetime of the loan
Normalised status of a loan (loan campaigns only)
Loan length or a revenue-sharing agreement in months
Date of the final repayment
Date that the loan defaulted
Total paid for this loan. This includes the principal, interest, any fees as well as default recoveries
Total interest paid on the loan to date
The amount repaid from the principal (i.e 'goal')
Total late fees paid to date
A sum of all fees paid for a loan project
Amount the borrower has to repay each month
Fields specific to equity campaigns
A comma-delimited list of applicable tax relief schemes. Note that this can also be used for donations projects
Percentage of equity offered
Minimum percentage of equity offered, if equity on offer is a range
Maximum percentage of equity offered, if equity on offer is a range
Pre-money valuation, in the project currency
Maximum pre-money valuation, in the project currency
Country-specific share type definition
The current price of a single share on the secondary market for equity campaigns
The total number of shares sold
The total number of shares on offer
The total number of shares released for this company