- Display Name – the user-friendly label shown in the UI
- Name – the internal identifier used in the system
- Description – explanation of the field’s meaning and context
- Ontology – the data format (e.g., TEXT, DATETIME, BOOLEAN)
Event
Event
Company awards
Company awards
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Award name | award_name | Name of the award or endorsement that was given to the company. | string |
| Reason for award win | award_reason | Text describing justification for the company receiving an award including the key criteria and accomplishments that led to the win. | string |
| Organisation bestowing award | awarding_body | Name of the institution or organisation that granted the award, accolade, or certification. | string |
| Event name | event_name | Name of the award event. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Link | link | URL to the announcement or reference page. | url |
| Snippet | snippet | Short excerpt or highlight text summarizing the award or announcement | string |
| Title | title | Official title or headline of the award or recognition | string |
Office closing
Office closing
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Reason for office closing | reason_for_closure | Text describing the reason for the office closing. | string |
| Location of closing office | office_location | Text describing where the office is located. | string |
| Number of employees impacted | number_of_employees_affected | Number of employees impacted by the office location closing. | integer |
| Title of closing office article | title | Title of published news report or article on company’s office closing. | string |
| Snippet | snippet | Short excerpt or highlight text summarizing the award or announcement | string |
| Link to article | link | Link to article announcing the company’s office closing. | url |
| Event name | event_name | Name of the event related to office closing. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
Employee's workplace anniversary
Employee's workplace anniversary
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Employee’s full name | full_name | First and last names associated with the individual, appended with a space. | string |
| Workplace company name | company_name | Name of the company where the individual is employed. | string |
| Number of years at company | years_at_company | Number of years employee has been working at the company. | integer |
| Employee’s job title | job_title | Current job title listed on the employee’s professional profile. | string |
| Workplace anniversary date | job_anniversary_date | Date and time the employee’s anniversary data was collected by Explorium. | datetime |
| Employee event timestamp | event_time | Date of employee’s upcoming workplace anniversary. | datetime |
| Employee LinkedIn® URL | linkedin_url | URL associated with the individual’s LinkedIn® profile. | url |
| Event name | event_name | Name of the event related to the employee’s workplace anniversary. | string |
Opens new office
Opens new office
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Purpose of new office | purpose_of_new_office | Short description of the new office’s purpose, extracted from the article. | string |
| Link to article | link | Link to article announcing the company’s new office. | url |
| Location of new office | office_location | Text extracted from the article indicating where the new office is located. | string |
| Number of employees at new office | number_of_employees | Number of employees working from the new office’s location. | integer |
| Title of new office article | title | Title of published news report or article on company’s new office. | string |
| Snippet | snippet | Short excerpt or highlight text summarizing the award or announcement | string |
| Event name | event_name | Name of the event related to company’s new office. | string |
New funding round
New funding round
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Date of funding round | funding_date | Date funding round took place. Formatted YYYY-MM-DD. | datetime |
| Company name | company_name | Name of company appearing in news reports and articles. | string |
| Amount raised in funding | amount_raised | Size of investment in dollars extracted from the article. | number |
| Snippet of article | snippet | Snippet of the published article or report on company’s new investment. | string |
| Link to article | link | Link to article announcing the company’s new investment. | url |
| Funding round stage | funding_stage | Funding round stage extracted from the report or article. | string |
| Source of article | report_source | Name of source where news report or article about company’s new investment was published. | string |
| News event timestamp | event_time | The timestamp indicating when the event actually occurred | datetime |
| Investors in funding round | investors | List of investors in the funding round. | array<string> |
| Lead investor | lead_investor | Name of the lead investor in the funding round. | string |
| Title of new funding round article | title | Title of published news report or article on company’s new funding round. | string |
| Date of funding round | founding_date | Date funding round took place. Formatted YYYY-MM-DD. | datetime |
| Funding round stage | founding_stage | Funding round stage extracted from the report or article. | string |
| Event name | event_name | Name of the event related to company’s new funding round. | string |
| Investment Amount | investment_amount | The numerical value of the investment (without currency) | number |
| Investment Currency | investment_amount_currency | The currency code (ISO 4217) of the investment amount. For example, USD for US Dollars or EUR for Euros | currency_code (nullable) |
| Investment Amount (Formatted) | investment_amount_string | The investment amount displayed together with the currency in a human-readable format. For example, 5,000,000 USD. | string |
New product launch
New product launch
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Name of product | product_name | Name of the company’s newly announced product. | string |
| Product Description | product_description | A text field that provides details about the product | string |
| News report publishing date | event_time | The timestamp indicating when the event actually occurred | datetime |
| Snippet | snippet | Snippet of the published article or report on company’s new product. | string |
| Title of new product article | title | Title of published news report or article on company’s new product. | string |
| Link to article | link | Link to article announcing the company’s new product. | url |
| Event name | event_name | Name of the event related to company’s new product launch. | string |
New investment
New investment
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Type of investment | investment_type | Type of investment extracted from the report or article. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Target of investment | investment_target | Text extracted from the article describing the target of the investment. | string (nullable) |
| Snippet of article | snippet | Snippet of the published article or report on company’s new investment. | string |
| Title of new investment article | title | Title of published news report or article on company’s new investment. | string |
| Link to article | link | Link to article announcing the company’s new investment. | url |
| Amount of investment | investment_amount | Size of investment in dollars extracted from the article. | number (nullable) |
| Investment Currency | investment_amount_currency | The currency code (ISO 4217) that specifies the currency of the investment amount. For example, USD for US Dollars or EUR for Euros. | currency_code (nullable) |
IPO announcement
IPO announcement
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Date of IPO | ipo_date | Date and time the article reporting on the company’s IPO was collected by Explorium. | datetime |
| Company name | company_name | Name of company appearing in news reports and articles. | string |
| Company valuation | offer_amount | Valuation of company at time of IPO. | number |
| Number of issued shares | number_of_shares | Number of shares issued at the time of IPO. | integer |
| IPO stock exchange | stock_exchange | Stock exchange where the IPO occurred. | string |
| Price per share | price_per_share | Company’s price per share at time of IPO. | number |
| Ticker | ticker | Stock symbol of the company that IPOd. | string |
| Event name | event_name | Name of the event related to company’s IPO. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Status | status | Indicates the current state or condition of the record. This field helps track the lifecycle or progress of the entity. | string |
New partnership
New partnership
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Link to article | link | Link to article announcing the company’s new partnership. | url |
| Name of partnering company | partner_company | Name of the company’s newly announced partner. | string |
| Title of new partnership article | title | Title of published news report or article on company’s new partnership. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Partnership purpose | purpose_of_partnership | Short description of the partnership’s purpose. | string |
| Snippet of article | snippet | Snippet of the published article or report on company’s new partnership. | string |
| Event name | event_name | Name of the event related to company’s new partnership. | string |
New executive level hires
New executive level hires
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Company name | job_company_name | Name of the company where employee change event occurred. | string |
| Executive’s current job department | job_department | Individual’s current job department, derived from their current job title. If employee change type is ‘Employee left the company’, value is NULL. | string |
| Executive’s full name | full_name | First and last names associated with the individual, appended with a space. | string |
| Executive’s role change event | change_type | Title of employee change event that occurred. E.g. executive joined the company. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Executive’s current job title | job_role_title | Individual’s current job title listed on their professional profile. If employee change type is ‘Employee left the company’, value is NULL. | string |
| Executive’s LinkedIn® URL | linkedin_url | URL of the individual’s LinkedIn® profile. | url |
| Event name | event_name | Name of the event related to employee’s role change. | string |
Employee changed role
Employee changed role
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Employee’s previous job title | previous_job_title | Individual’s previous job title listed on their professional profile. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Employee’s current job title | current_job_title | Individual’s current job title listed on their professional profile. | string |
| Employee’s current workplace | current_company_name | Name of the company where the individual currently works. | string |
| Current workplace entity ID | current_company_id | Explorium’s 32 character unique entity ID associated with the individual’s current workplace. | string |
| Employee’s previous workplace | previous_company_name | Name of the company where the individual previously worked. | string |
| Previous workplace entity ID | previous_company_id | Explorium’s 32 character unique entity ID associated with the individual’s previous workplace. | string |
| Event name | event_name | Name of the event related to employee’s role change. | string |
Employee changed workplace
Employee changed workplace
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| New Company Name | current_company_name | Name of the company where the individual currently works after the job change. | string |
| New Company ID | current_company_id | Unique identifier of the company where the individual currently works. | string |
| New Job Title | current_job_title | Individual’s current job title at the new company. | string |
| Previous Company Name | previous_company_name | Name of the company where the individual was previously employed. | string |
| Previous Company ID | previous_company_id | Unique identifier of the company where the individual was previously employed. | string |
| Previous Job Title | previous_job_title | Individual’s job title before switching companies. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Event name | event_name | Name of the event related to the employee’s company change. | string |
Mergers and acquisitions
Mergers and acquisitions
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Merger or acquisition | merger_or_acquisition | Indicates if the event is a merger or acquisition. | enum |
| Event description | description | An overview of the merger or acquisition. | string |
| Involved companies | companies_involved | List of companies involved in the merger or acquisition. | array<string> |
| Acquisition price | acquisition_price_amount | Amount paid in the acquisition. | number (nullable) |
| Strategic objective | strategic_objective | Text describing the strategic objective or motivation behind the merger or acquisition. | string |
| Acquisition currency | acquisition_price_currency | Type of currency used for the acquisition. | currency_code (nullable) |
| Link to article | link | URL to article about the merger or acquisition. | url |
| Title | title | The headline of the article, summarizing its main topic | string |
| Snippet | snippet | A short summary or preview of the article | string |
| Event name | event_name | Name of the event related to the merger or acquisition. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
Lawsuits and legal proceedings
Lawsuits and legal proceedings
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Legal case type | case_type | Classification of the legal case e.g. Patent infringement, Fraud, etc. | string |
| Court | court | Court or legal body overseeing the case e.g. U.S. District Court. | string |
| Link to report | link | Link to article or report about the legal issue. | url |
| Event name | event_name | Name of the event related to the legal proceedings. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Title | title | The headline of the article, summarizing its main topic | string |
| Snippet | snippet | A short summary or preview of the article | string |
Outages and security breaches
Outages and security breaches
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Type of incident | incident_type | Categorization of the type of incident that occurred e.g., outage, data breach. | string |
| Impacted systems | impacted_systems | Text listing the systems that were impacted by the incident. | array<string> |
| Number of affected customers | number_of_affected_customers | Number of company’s customers affected by the incident. | integer |
| Link to article | link | Link to article reporting the outage, security incident, or data breach. | url |
| Title | title | The headline of the article, summarizing its main topic | string |
| Snippet | snippet | A short summary or preview of the article | string |
| Event name | event_name | Name of the event related to the incident. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
Cost cutting
Cost cutting
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Cost cutting actions | action_taken | A summary of the measures implemented to reduce costs. | string |
| Expected savings | expected_savings_amount | Projected amount of cost savings as a result of the cost cutting measures, if appears in the text. | number (nullable) |
| Affected departments | departments_affected | A list of departments impacted by the cost-cutting measures. | array<string> |
| Savings currency | expected_savings_currency | Currency of the projected amount of savings resulting from the cost cutting measures. | currency_code (nullable) |
| Link to article | link | Link to article reporting the cust cutting measures taken by the company. | url |
| Event name | event_name | Name of the event related to the cost cutting measures. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Title | title | The headline of the article, summarizing its main topic | string |
| Snippet | snippet | A short summary or preview of the article | string |
Hiring (per department)
Hiring (per department)
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Role location | location | Location of the position inferred from the available information. | string |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Number of available roles | job_count | Number of open positions company is hiring for at the selected site and department. | integer |
| Job titles | job_titles | List of the open position titles listed per department and site. | array<string> |
| Department | department | Company department where the open positions were listed. | string |
| Event name | event_name | Name of the event related to the company’s hiring activity. | string |
Workforce Increase / Decrease (per department)
Workforce Increase / Decrease (per department)
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| QoQ change in department count | department_change | Quarter over quarter rate of change in the number of employees working at the selected department. Calculation: (current quarter headcount of department / prev. quarter headcount of department) * 100. | integer |
| Event time | event_time | The timestamp indicating when the event actually occurred | datetime |
| Department trend type | change_type | Type of department change type: Increase | Decrease | string |
| Event name | event_name | Name of the event related to the department change. | string |
Enrichment
Enrichment
Firmographics
Firmographics
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Explorium entity ID | business_id | Explorium’s 32 character unique entity ID associated with a company’s specific site, branch, or HQ. | string |
| Ticker symbol | ticker | A stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | string |
| Country | country_name | The country where the company’s headquarters are located. | string |
| Region | region_name | State or region where the company’s headquarters are located. Region equivalent in the UK is county or shire. | string |
| string | city_name | The city where the company’s headquarters are located. | string |
| Street | street | The company’s street name and number | string |
| ZIP code / postal code | zip_code | Company’s postal code or Zipcode | zip code |
| Business description | business_description | An overview or summary of the business’ mission statement, offered services and general industry. | string |
| SIC code | sic_code | Company’s Standard Industrial Classification four-digit code. | string |
| SIC code description | sic_code_description | Description of the Company’s Standard Industrial Classification four-digit code. | string |
| LinkedIn industry category | linkedin_industry_category | Industry category classification the business was assigned by LinkedIn®. | string |
| NAICS description | naics_description | Description of the 2017 NAICS industry code. | string |
| NAICS | naics | 2017 North American Industry Classification System code that classifies the particular organization or business. | string |
| Yearly revenue range all sites | yearly_revenue_range | Assigned revenue range category, generated at all company sites. All company sites includes the company’s headquarters and all company branches. Company revenue is measured per fiscal year. Search ‘Firmographics: Yearly revenue bucket categories’ in Explorium’s resource center for additional information. | object |
| Locations Distribution | locations_distribution | JSON containing the country’s alpha-2 code, and correlating number of locations the entity has per country. | array<object> |
| Number of employees range all sites | number_of_employees_range | Value displayed is the range of the company’s number of employees falls. The number of employees is the sum of employees from all company sites, including the headquarters and all of the company branches. Search ‘Firmographics: number of employees bucket categories’ in Explorium’s resource center for additional information. | object |
| LinkedIn® profile | linkedin_profile | Company’s LinkedIn® profile page | string |
| Company website | website | Company’s main website URL | string |
| Company name | name | Name of the company | string |
| Business logo | business_logo | Link to the company’s logo. | url |
Technographics
Technographics
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Company’s full tech stack | full_tech_stack | Full list of technologies used by the company in all categories. | array |
| Company’s full nested tech stack | full_nested_tech_stack | Full nested list of technologies used by the company. | array |
| Testing and QA tech stack | testing_and_qa | List of testing and QA technologies used by the company. | array |
| Sales tech stack | sales | List of sales technologies used by the company. | array |
| Programming languages and frameworks tech stack | prog_langs_and_frameworks | List of programming, languages, and frameworks technologies used by the company. | array |
| Productivity and operations tech stack | productivity_and_operations | List of productivity and operations technologies used by the company. | array |
| Product and design tech stack | product_and_design | List of product and design technologies used by the company. | array |
| Platform and storage tech stack | platform_and_storage | List of platform and storage technologies used by the company. | array |
| Operations software tech stack | operations_software | List of operations software technologies used by the company. | array |
| Operations management tech stack | operations_management | List of operations management technologies used by the company. | array |
| Marketing tech stack | marketing | List of marketing technologies used by the company. | array |
| IT security tech stack | it_security | List of IT security technologies used by the company. | array |
| IT management tech stack | it_management | List of IT management technologies used by the company. | array |
| HR tech stack | hr | List of HR technologies used by the company. | array |
| Health tech tech stack | health_tech | List of health tech technologies used by the company. | array |
| Finance and accounting tech stack | finance_and_accounting | List of finance and accounting technologies used by the company. | array |
| Ecommerce tech stack | ecommerce | List of ecommerce technologies used by the company. | array |
| Devops and development tech stack | devops_and_development | List of devops and development technologies used by the company. | array |
| Customer management tech stack | customer_management | List of customer management technologies used by the company. | array |
| Computer networks tech stack | computer_networks | List of computer networks technologies used by the company. | array |
| Communications tech stack | communications | List of communications technologies used by the company. | array |
| Collaboration tech stack | collaboration | List of collaboration technologies used by the company. | array |
| Business intelligence and analytics tech stack | bi_and_analytics | List of business, intelligence, and analytics technologies used by the company. | array |
Contact details
Contact details
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Individual’s professional email validity status | professional_email_status | Recommended validity status for the listed ‘Professional email’ address. Returns one of the following possible values: ‘valid’ emails are determined as safe to email, ‘invalid’ emails are addresses we recommend to erase from mailing lists, ‘catch-all’ emails are created as a precaution by domain owners. For recommendations on how best to use ‘catch all’ emails, read more on our resource center page ‘Email validation: catch-all domains’. | object |
| Individual’s emails | emails | List of all email addresses associated with the individual labeled as a professional or personal email address. | array |
| Individual’s professional email | professions_email | Current professional email address associated with the individual | string |
| Individual’s mobile phone | mobile_phone | Individual’s direct dial mobile phone number. | string |
| Individual’s phone numbers | phone_numbers | List of all phone numbers associated with the individual. | array |
Professional profile: contact and workplace
Professional profile: contact and workplace
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Individual’s gender | gender | Gender reported by the individual on their profile. If gender is not reported on profile, returned value is ‘null’. | string |
| Individual’s city of residence | city | Individual’s city of residence reported on profile. | string |
| Individual’s country of residence | country_name | Individual’s country of residence reported on profile. | string |
| Individual’s State / Region of residence | region_name | Individual’s state or region of residence reported on profile. | string |
| Individual’s workplace: company website | company_website | URL to the company website belonging to the individual’s workplace. | string |
| Individual’s workplace: company LinkedIn® url | company_linkedin | URL to the company LinkedIn® page belonging to the individual’s workplace. | string |
| Individual’s LinkedIn® URL | URL of the individual’s LinkedIn® profile. | url | |
| linkedin_url_array | LinkedIn® Identifier Array | A list of LinkedIn® profile URLs associated with the prospect. Each entry may include a standard public URL and/or a URN-based URL. | array[string] |
| Individual’s age group | age_group | Individual’s estimated age group. | string |
| Individual’s work experience background | experience | List of work experience background entries on the individual’s profile. May include: company name, company website, job title, seniority level, role, start date, end date, and more. Includes current work experience activities if listed. | array |
| Individual’s educational background | education | List of educational background entries on the individual’s profile. May include: institutions name, institutions website, degree category, major, start date, end date, and more. Includes current educational activities if listed. | array |
| Individual’s interests | interests | List of all interests reported by the individual on their profile. | array |
| Individual’s skills | skills | List of all skills reported by the individual on their profile. | array |
| Individual’s job department | job_department | Individual’s job department, derived from their current job title. | object |
| Individual’s seniority level | job_seniority_level | Individual’s top seniority level, derived from their current job title. | object |
| Individual’s workplace: company name | company_name | Name of the company the individual listed as their workplace. | string |
| Individual’s job title | job_title | Individual’s current job title listed on their professional profile. | string |
| Individual’s full name | full_name | First and last names associated with the individual, appended with a space. | string |
Strategic insights on public companies
Strategic insights on public companies
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Form description | form_description | Summary of the filing, including the type of form submitted, the statutory authority requiring its submission, and details on whether specific disclosures are included or excluded. The filing is prepared and submitted by the company it pertains to, in compliance with SEC regulations. | string |
| 10-K filing document link | link_to_html | URL linking to the main HTML document of the company’s specific 10-K filing, containing financial statements, management analysis, and other key information submitted to the SEC. | url |
| File’s accession number | accession_number | Unique identifier for the file submitted by the company to the SEC, including the company’s CIK, the fiscal year of the filing, and the sequential number of the filing within that year. | string |
| Form type | form_type | Type of form that was filed by the company. In most cases the form type is 10-K. | string |
| Company’s target market strategy | target_market | Text describing the company’s target market strategy. Insights extracted from publicly published reports. | array |
| Company’s value proposition | company_value_proposition | Text describing the company’s core product or service value proposition strategy. Insights extracted from publicly published reports. | array |
| Company’s focus and strategy | company_focus | Text describing the company’s main focus areas and business strategy. Insights extracted from publicly published reports. | array |
| Company’s CIK | cik | Unique numeric identifier assigned by the SEC distinguishing a company in the EDGAR filing system. Typically consists of up to 10 digits and may include leading zeros. Used for retrieving financial filings and compliance documents. | string |
| Company name | company_name | Name of the company. | string |
| Time of filing | filed_at | Date and time the filing was submitted, formatted YYYY-MM-DDTHH:MM:SS±HH:MM. | string |
| 10-K filing index link | link_to_filing_details | URL linking to the index page of the company’s specific 10-K filing, which lists the main filing document, exhibits, and supplemental files submitted to the SEC. | url |
| Company’s partnership strategy | company_partnerships | Text describing the company’s partnership strategy. Insights extracted from publicly published reports. | array |
| Company’s product development | company_product_development | Text describing the company’s product development focus and strategy. Insights extracted from publicly published reports. | array |
| Company’s marketing and sales strategy | company_marketing_sales | Text describing the company’s marketing and sales strategy. Insights extracted from publicly published reports. | array |
| Ticker symbol | ticker | Stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | string |
Business challenges of public companies
Business challenges of public companies
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Company’s innovation | technological_disruption | Text describing the company’s technological disruption and innovation. Insights extracted from publicly published reports. | array |
| 10-K filing document link | link_to_html | URL linking to the main HTML document of the company’s specific 10-K filing, containing financial statements, management analysis, and other key information submitted to the SEC. | url |
| 10-K filing index link | link_to_filing_details | URL linking to the index page of the company’s specific 10-K filing, which lists the main filing document, exhibits, and supplemental files submitted to the SEC. | url |
| Form type | form_type | Type of form that was filed by the company. In most cases the form type is 10-K. | string |
| File’s accession number | accession_number | Unique identifier for the file submitted by the company to the SEC, including the company’s CIK, the fiscal year of the filing, and the sequential number of the filing within that year. | string |
| Company’s data security breaches | company_data_security_breach | Text describing the company’s data security breaches. Insights extracted from publicly published reports. | array |
| Company’s market saturation | company_market_saturation | Text describing the company’s market saturation. Insights extracted from publicly published reports. | array |
| Form description | form_description | Summary of the filing, including the type of form submitted, the statutory authority requiring its submission, and details on whether specific disclosures are included or excluded. The filing is prepared and submitted by the company it pertains to, in compliance with SEC regulations. | string |
| Company name | company_name | Name of the company. | string |
| Company’s CIK | cik | Unique numeric identifier assigned by the SEC distinguishing a company in the EDGAR filing system. Typically consists of up to 10 digits and may include leading zeros. Used for retrieving financial filings and compliance documents. | string |
| Time of filing | filed_at | Date and time the filing was submitted, formatted YYYY-MM-DDTHH:MM:SS±HH:MM. | string |
| Company’s data security and privacy | company_data_security_privacy | Text describing the company’s data security and privacy approach. Insights extracted from publicly published reports. | array |
| Company’s competition | company_competition | Text describing the company’s competitive landscape. Insights extracted from publicly published reports. | array |
| Company’s customer adoption | company_customer_adoption | Text describing the company’s customer adoption. Insights extracted from publicly published reports. | array |
| Ticker symbol | ticker | Stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | string |
Competitive landscape of public companies
Competitive landscape of public companies
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Company’s CIK | cik | Unique numeric identifier assigned by the SEC distinguishing a company in the EDGAR filing system. Typically consists of up to 10 digits and may include leading zeros. Used for retrieving financial filings and compliance documents. | string |
| 10-K filing index link | link_to_filing_details | URL linking to the index page of the company’s specific 10-K filing, which lists the main filing document, exhibits, and supplemental files submitted to the SEC. | url |
| Form description | form_description | Summary of the filing, including the type of form submitted, the statutory authority requiring its submission, and details on whether specific disclosures are included or excluded. The filing is prepared and submitted by the company it pertains to, in compliance with SEC regulations. | string |
| Competitive differentiation | competitive_differentiation | Text describing the company’s unique value and differentiators from competitors. | array |
| Time of filing | filed_at | Date and time the filing was submitted, formatted YYYY-MM-DDTHH:MM:SS±HH:MM. | string |
| Company name | company_name | Name of the company. | string |
| 10-K filing document link | link_to_html | URL linking to the main HTML document of the company’s specific 10-K filing, containing financial statements, management analysis, and other key information submitted to the SEC. | url |
| Key competitors | key_competitors | List of the company’s competitors. | array |
| File’s accession number | accession_number | Unique identifier for the file submitted by the company to the SEC, including the company’s CIK, the fiscal year of the filing, and the sequential number of the filing within that year. | string |
| Form type | form_type | Type of form that was filed by the company. In most cases the form type is 10-K. | string |
| Ticker symbol | ticker | Stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | string |
Keyword search on websites
Keyword search on websites
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Keyword search result | text_results | JSON-formatted list of search results, indicating the location of the queried keywords within the snippet. Each result includes a snippet of text containing the keywords, the corresponding URL, and a numeric ranking of where the keyword is positioned within the snippet. | array |
| URL has keyword | keywords_indicator | True if the URL contains the queried keywords. | string |
| URL | url | Website associated with Explorium’s entity ID queried for the input keywords. | url |
Company’s website content changes
Company’s website content changes
Company’s website content changes
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Website page of detected change | url | URL from which the changes were derived | url |
| Type of content change | change_description | Text describing the content modification on the website as compared to the previous version. | string |
| Description of content change | change_implication | Text indicating the strategic significance of the content change on the website | string |
| Content change timestamp | date | Date the content change on the website occurred. | datetime |
Individual’s social media presence
Individual’s social media presence
Individual’s social media presence
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Time of posting | created_at | Timestamp of when the individual’s post was published. | datetime |
| Number of post likes | number_of_likes | Number of likes the individual’s post received by time of collection. | integer |
| LinkedIn® post URL | post_url | URL to the LinkedIn® post published by individual. | url |
| Number of post comments | number_of_comments | Number of comments on the individual’s post by time of collection. | integer |
| Days since post | days_since_posted | Number of days since the post was published by the individual. | integer |
| Post text content | post_text | Text content of the LinkedIn® post published by individual. | string |
| Display Name | display_name | Display Name | string |
Company’s social media presence
Company’s social media presence
Company’s social media presence
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Post text content | post_text | Text content of the LinkedIn® post published by company profile. | string |
| Days since post | days_since_posted | Number of days since the post was published by the company. | integer |
| LinkedIn® post URL | post_url | URL to the LinkedIn® post published by individual. | url |
| Number of post comments | number_of_comments | Number of comments on the company’s post by time of collection. | integer |
| Number of post likes | number_of_likes | Number of likes the company’s post received by time of collection. | integer |
| Time of posting | created_at | Timestamp of when the company’s post was published. | datetime |
| Display Name | display_name | Display Name | string |
Workforce trends by company department
Workforce trends by company department
Workforce trends by company department
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| QoQ real estate roles | change_in_real_estate_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in real estate related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| Percentage of design roles | perc_design_roles | Percentage out of employee profiles that disclose the employee’s role who listed a design related position. This calculation is relevant to the selected timeframe. Designer roles include product designers, web designers, and graphic designers. | float |
| Number of profiles | profiles_found_per_quarter | Number of detected profiles containing information on the employee | float |
| Percentage of sales roles | perc_sales_roles | Percentage out of employee profiles that disclose the employee’s role who listed a sales related position. This calculation is relevant to the selected quarter. | float |
| Percentage of human resources roles | perc_hr_roles | Percentage out of employee profiles that disclose the employee’s role who listed a human resources related position. This calculation refers to the selected quarter. Health related positions include sanitarians, nurses, and doctors. | float |
| Percentage of operations roles | perc_operations_roles | Percentage out of employee profiles that disclose the employee’s role who listed an operations position. This calculation is relevant to the selected quarter. | float |
| Percentage of public relations roles | perc_pr_roles | Percentage out of employee profiles that disclose the employee’s role who listed a PR position. This calculation is relevant to the selected quarter. | float |
| Percentage of health roles | perc_health_roles | Percentage out of employee profiles that disclose the employee’s role who listed a health related position. This calculation refers to the selected quarter. Health related positions include sanitarians, nurses, and doctors. | float |
| Percentage of professional trades roles | perc_trades_roles | Percentage out of employee profiles that disclose the employee’s role who listed a professional trades position. This calculation is relevant to the selected quarter. Professional trades roles include plumbers, construction workers, and electricians. | float |
| Percentage of engineering roles | perc_engineering_roles | Percentage out of employee profiles that disclose the employee’s role who listed an engineering related position. This calculation refers to the selected quarter. Engineering roles include data, devops, electrical, mechanical, network, information technology, project engineering, quality assurance, security, software, systems and web roles. This calculation refers to the selected quarter. | float |
| Percentage of finance roles | perc_finance_roles | Percentage out of employee profiles that disclose the employee’s role who listed a finance related position. This calculation refers to the selected quarter. | float |
| Percentage of customer service roles | perc_customer_service_roles | Percentage out of employee profiles that disclose the employee’s role who listed a customer service position. This calculation is relevant to the selected timeframe. | float |
| Percentage of legal roles | perc_legal_roles | Percentage out of employee profiles that disclose the employee’s role who listed a legal related position. This calculation refers to the selected quarter. | float |
| Percentage of media roles | perc_media_roles | Percentage out of employee profiles that disclose the employee’s role who listed a marketing position. This calculation is relevant to the selected quarter. | float |
| Percentage of marketing roles | perc_marketing_roles | Percentage out of employee profiles that disclose the employee’s role who listed a marketing position. This calculation is relevant to the selected quarter. | float |
| Percentage of real estate roles | change_in_real_estate_roles | Percentage out of employee profiles that disclose the employee’s role who listed a real estate position. This calculation is relevant to the selected quarter. | float |
| Percentage of education roles | perc_education_roles | The percentage out of employee profiles that disclose the employee’s role who listed an education related position. Education roles include teachers, researchers, professors, and education administrators. This calculation refers to the selected quarter. | float |
| QoQ design roles | change_in_design_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in design roles in the quarter prior to the selected quarter compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Designer roles include product designers, web designers, and graphic designers. | float |
| QoQ education roles | change_in_education_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in education related roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Education roles include teachers, researchers, professors, and education administrators. | float |
| QoQ public relation roles | change_in_pr_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in public relations related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ professional trades roles | change_in_trades_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in trades related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ customer service roles | change_in_customer_service_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in customer service roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ health roles | change_in_health_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in health roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Health roles include sanitarians, nurses, and doctors. | float |
| QoQ operations roles | change_in_operations_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in operations related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ sales roles | change_in_sales_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in sales related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ legal roles | change_in_legal_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in legal realted roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ profiles that disclose employee’s role | change_in_roles_divisor | QoQ stands for quarter over quarter and is the rate of change in the percentage of employee profiles that contain information about the employee’s role or position at the company in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ finance roles | change_in_finance_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in finance roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ media roles | change_in_media_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in media related roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ human resources roles | change_in_hr_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in human resources roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ marketing roles | change_in_marketing_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in marketing related roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | float |
| QoQ engineering roles | change_in_engineering_roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in engineering related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Engineering roles include data, devops, electrical, mechanical, network, information technology, project engineering, quality assurance, security, software, systems and web roles. | float |
| Quarter | quarters | Cutoff date of the data’s quarterly period, e.g. 01/01/2001. | datetime |
Company ratings by employees
Company ratings by employees
Company ratings by employees
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Company’s city | company_city | The city where the company’s headquarters are located. | string |
| Company’s country | company_country | The country where the company’s headquarters are located. | string |
| Company’s name | company_name | The name of the company. | string |
| Company’s region | company_region | The state region where the company’s headquarters are located. | string |
| Company’s street | company_street | The street name and number where the company’s headquarters are located. | string |
| Company’s URL | company_url | The URL of the website associated with the company. | url |
| Company Zip code | company_zip_code | The postal code where the company’s headquarters are located. | string |
| Negative experience | experience_negative | Percentage out of interviewees who published reviews that reported having a negative sentiment following a job interview. | float |
| Neutral experience | experience_neutral | Percentage out of interviewees who published reviews that reported having a neutral sentiment following a job interview. | float |
| Positive experience | experience_positive | Percentage out of interviewees who published reviews that reported having a positive sentiment following a job interview. | float |
| Number of ratings | ratings_all_reviews_count | Overall number of company ratings published by current and former employees. | float |
| Business outlook rating | ratings_business_outlook | The percentage out of current and former employees who published reviews that believe the company will succeed in the near future. | float |
| Career opportunities rating | ratings_career_opportunities | Current and former Employees rating between 1-5 of the personal career development opportunities at the company. | 1=low rating, 5=high rating | float |
| CEO approval rating | ratings_ceo_approval | The percent of current and former employees that published reviews who approved of the company’s CEO. | float |
| CEO approval ratings count | ratings_ceo_approval_count | Number of CEO approval ratings collected. | float |
| Compensation benefits rating | ratings_compensation_benefits | Compensation and benefits rating between 1-5 published by its current and former employees. | 1=low rating, 5=high rating | float |
| Culture values rating | ratings_cutlure_values | Culture values rating between 1-5 as rated by its current and former employees. | 1=low rating, 5=high rating | float |
| Diversity inclusion rating | ratings_diversity_inclusion | Diversity inclusion rating between 1-5 as viewed by the company’s current and former employees. | 1=low rating, 5=high rating | float |
| Overall Ratings | ratings_overall | A company’s overall score between 1-5 rated by its employees, interviewees and former employees. | 1=low rating, 5=high rating | float |
| Recommend to friend rating | ratings_recommend_to_friend | The chance that a current or former employee will recommend a friend to work in said company. | float |
| Senior management rating | ratings_senior_management | Rating between 1-5 of the senior management as viewed by its current and former employees. | 1=low rating, 5=high rating | float |
| Work life balance rating | ratings_work_life_balance | Work life balance rating between 1-5 as viewed by its current and former employees. | 1=low rating, 5=high rating | float |
| Total reviews count | total_reviews_count | Total number of company reviews published by current and former employees. | float |
| Trend of company rating by employees | company_score | A dictionary listing the overall company score rated by current and former employees over the recent year between 1-5. | 1=low rating, 5=high rating | array |
Funding and acquisitions for public and private companies
Funding and acquisitions for public and private companies
Funding and acquisitions for public and private companies
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Company’s domain | domain | Company’s domain | string |
| Company name | company_name | Company name | string |
| Company’s investors | investors | List of all company’s investors from all funding rounds. | array |
| Number of advisors | number_of_advisors | Number of the company”s listed advisors. If the advisor”s data is unavailable, returned value is ‘null’. | integer |
| Number of company’s news events | num_of_news | Selected company’s number of listed news appearances, articles, or events. | integer |
| Names and job titles of current advisors | current_advisors | List of advisors to the company. Includes the advisor name and job title. If the advisor’s data is unavailable, returned value is ‘null’. | array |
| IPO value, US dollars | ipo_size_usd | Amount of money raised in the IPO. If the company didn’t go public or the data is unavailable, returned value is ‘null’. | string |
| IPO date | ipo_date | Date the selected company’s IPO was announced, formatted YYYY-MM-DD. If the company didn’t go public or the data is unavailable, returned value is ‘null’. | datetime |
| Company had IPO | is_ipo | True if the company has gone public. | boolean |
| First funding round: number of investors | number_of_investors_for_first_funding_round | Number of investors involved in the company’s first funding round. If the company didn’t have a funding round, or the data is unavailable, returned value is ‘null’. | integer |
| First funding round: size | first_funding_round_value_usd | Amount of money raised in first funding round, displayed in US dollars (e.g. how many US dollars were raised by the selected company in a funding round). If the company didn’t have founding round, or the data is unavailable, returned value is ‘null’. | float |
| First funding round: details | first_funding_round_type | Type of capital raised during the selected company’s first funding round. E.g seed, venture, angel, round A, and more. If the company didn’t have a funding round, or the data is unavailable, returned value is ‘null’. | string |
| First funding round: date | first_funding_round_date | Date the selected company’s first funding round was announced, formatted YYYY-MM-DD. If the company didn’t have a funding round, or the data is unavailable, returned value is ‘null’. | datetime |
| Number of funding rounds | number_of_funding_rounds | Number of funding rounds listed for the company. | integer |
| Details of company’s acquisition by other company | acquired_by | Additional information regarding the company’s acquisition by another party, including: name of other party, price of acquisition in US dollars, and date of acquisition formatted YYYY-MM-DD. If acquisitions were not made or data is unavailable, returned value is ‘null’. | string |
| Change trend of company’s funding round size | latest_funding_increase_in_percents | Percent change in funding round size between the most recent funding round and the one that preceded it. Calculation: 100 * (( previous funding round size - last funding round size) / last funding round size) | string |
| Most recent funding round: date | last_funding_round_date | Date the selected company”s last funding round was announced, formatted YYYY-MM-DD. If the company didn”t have a funding round, or the data is unavailable, returned value is ‘null’. | datetime |
| Most recent funding round: size, US dollars | last_funding_round_value_usd | Amount of money raised in the selected company’s most recent funding round, displayed in US dollars. If the company didn’t have a funding round, or the data is unavailable, returned value is ‘null’. | string |
| Most recent funding round: details | last_funding_round_type | Type of capital raised during the selected company’s most recent funding round. E.g seed, venture, angel, round A, and more. If the company didn’t have a funding round, or the data is unavailable, returned value is ‘null’. | string |
| Most recent funding round: number of investors | number_of_investors_for_last_funding_round | Number of investors involved in the company’s last funding round. If the company didn’t have a funding round, or the data is unavailable, returned value is ‘null’. | integer |
| List of all funding rounds | funding_rounds_info | List of all of the company’s funding round events, including: announcement date formatted YYYY-MM-DD, names of lead investors, currency of the money raised, value of the money raised, and value of the money raised in US dollars. If the company didn’t have a funding round, or the data is unavailable, returned value is ‘null’. | array |
| Total funding value, US dollars | known_funding_total_value | Total amount of money raised in all of the company’s funding rounds. Calculated using all available data, displayed in US dollars. | float |
Financial metrics for public companies
Financial metrics for public companies
Financial metrics for public companies
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Asset turnover | asset_turnover | The company’s quarterly ratio between the total sales or revenue, and the average company assets. Numbers are displayed in the currency of the country where the company is legally registered. | float |
| Revenue CAGR | cagr | The company’s revenue compound annual growth rate. It is calculated by dividing the yearly fiscal revenue by the previous fiscal year revenue and subtracting by 1. Both figures appear on the company’s annual reports. This feature is calculated only per year, so it will not take into account the date that was specified in the input query. The calculations are based on the currency of the country where the company is legally registered. | float |
| COGS | cogs | Cost of goods sold (COGS) refers to the direct costs of producing the goods sold by a company. This amount includes the cost of the materials and labor directly used to create the good. Cost of goods sold is also referred to as ‘cost of sales.’ Formula: quarterly_revenue / gross_profit quarterly_revenue, gross_profit - taken from company’s quarterly report | float |
| Earning surprise | earnings_surprises | The company’s earning surprise occurs when a company reports figures that are drastically different from the stock market estimates, and is calculated per quarter. This feature will display both the estimated earning per share and the actual earning per share. Numbers are displayed in the currency of the country where the company is legally registered. | object |
| Quarterly EBITDA | ebitda | The company’s reported earnings before interest, taxes, depreciation, and amortization. Calculations are based on the currency of the country where the company is legally registered. | float |
| Quarterly valuation multiples (EV / EBITDA) | enterprise_value_over_ebdita | Enterprise multiple, also known as the EV-to-EBITDA multiple, is a ratio used to determine the value of a company. It is computed by dividing enterprise value by EBITDA. The enterprise multiple takes into account a company’s debt and cash levels in addition to its stock price and relates that value to the firm’s cash profitability. Enterprise multiples can vary depending on the industry. Higher enterprise multiples are expected in high-growth industries and lower multiples in industries with slow growth. Calculated based on quarter values. | float |
| Leadership | leadership | Key executives are the people at the top of a company who make critical decisions that affect the company. We keep track of who they are, what their titles are, and how much money they make. | array |
| Peer companies | peer_companies | A list of companies that are in the same industry or sector as the company. | object |
| Quarterly valuation multiples (P / E) | price_earnings_ratio | The price-to-earnings ratio (P/E ratio) is the ratio for valuing a company that measures its current share price relative to its earnings per share (EPS). The price-to-earnings ratio is also sometimes known as the price multiple or the earnings multiple. Calculated based on quarter values. | float |
| Annual revenue | revenue_yearly | Company’s yearly revenue. This feature is calculated only per fiscal year, so it will not take into account the date that was specified in the input query. The calculations are based on the currency of the country where the company is legally registered. | float |
| Quarterly ROA | roa | The company’s quarterly Return On Assets. It is calculated by dividing the company’s net income by the company’s total assets. The net income is reported in the company’s cash flow statement, and the company’s total assets are reported in the company’s balance statement. Numbers are displayed in the currency of the country where the company is legally registered. | float |
| Quarterly ROC | roc | Company’s quarterly Return On Capital is calculated in the following way: (net_income - dividends_paid) / (total_debt - total_equity). Both the dividends paid and net income figures were reported in the company’s cash flow statement. The total debt and total equity figures are from the company’s balance statements. The calculations are based on the currency of the country where the company is legally registered. | float |
| SG&A | sg_and_a | Quarterly Selling General & Administrative expenses is based on the company’s quarterly income report. Numbers are displayed in the currency of the country where the company is legally registered. | float |
| TSR (1-year) | tsr_1y | Total shareholder return (TSR) is a measure of financial performance, indicating the total amount an investor reaps from an investment—specifically, equities or shares of stock. Total shareholder return factors in capital gains and dividends when measuring the total return generated by a stock. TSR represents an easily understood figure of the overall financial benefits generated for stockholders. TSR is a good gauge of an investment’s long-term value, but it is limited to past performance, requires an investment to generate cash flows, and can be sensitive to stock market volatility. Formula: ((year_stock_price - previous_year_stock_price) + dividends) / previous_year_stock_price for example: query AAPL 2020-Q3 will be calculated with these values: year_stock_price = last stock price of AAPL in 2020 previous_year_stock_price = stock price of AAPL at the beginning of 2020 dividends = dividends given during 2020 | float |
| TSR (3-year) | tsr_3y | Total shareholder return (TSR) is a measure of financial performance, indicating the total amount an investor reaps from an investment—specifically, equities or shares of stock. Total shareholder return factors in capital gains and dividends when measuring the total return generated by a stock. TSR represents an easily understood figure of the overall financial benefits generated for stockholders. TSR is a good gauge of an investment’s long-term value, but it is limited to past performance, requires an investment to generate cash flows, and can be sensitive to stock market volatility. Formula: ((year_stock_price - 3_years_ago_stock_price) + dividends) / 3_years_ago_stock_price for example: query AAPL 2020-Q3 will be calculated with these values: year_stock_price = last stock price of AAPL in 2020 3_years_ago_stock_price = stock price of AAPL at the beginning of 2018 dividends = dividends given during 2018-2020 | float |
| TSR (5-years) | tsr_5y | Indication of the total amount an investor reaps from an investment—specifically, equities or shares of stock. Total shareholder return factors in capital gains and dividends when measuring the total return generated by a stock. TSR represents an easily understood figure of the overall financial benefits generated for stockholders. TSR is a good gauge of an investment’s long-term value, but it is limited to past performance, requires an investment to generate cash flows, and can be sensitive to stock market volatility. Formula: ((year_stock_price - 5_years_ago_stock_price) + dividends) / 5_years_ago_stock_price for example: query AAPL 2020-Q3 will be calculated with these values: year_stock_price = last stock price of AAPL in 2020 5_years_ago_stock_price = stock price of AAPL at the beginning of 2016 dividends = dividends given during 2016-2020 | float |
| Working capital | working_capital | Working capital, also known as net working capital (NWC), is the difference between a company’s current assets - such as cash, accounts receivable/customers’ unpaid bills, and inventories of raw materials and finished goods - and its current liabilities, such as accounts payable and debts. Calculated based on quarter values. | float |
cash_and_cash_equivalents | Cash and Cash Equivalents | Cash and highly liquid near-cash assets, which may be negative if overdrawn or short-term liabilities exceed liquidity. | float |
Lookalike Companies
Lookalike Companies
Lookalike Companies
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Comparable Business ID | comparable_business_id | The Explorium ID of the requested company. | string |
| Lookalike Business ID | lookalike_business_id | The Explorium ID of the lookalike company. | string |
| Lookalike Business Name | lookalike_business_name | Name of the lookalike company. | string |
| Lookalike Website | lookalike_website | Website URL of the lookalike. | string |
| Lookalike Description | lookalike_description | Description of the lookalike company. | string |
| Lookalike Number of Employees Range | lookalike_number_of_employees_range | Employee range for the lookalike. | string |
| Lookalike Revenue Range | lookalike_revenue_range | Revenue range for the lookalike. | string |
| Lookalike NAICS Description | lookalike_naics_description | NAICS (North American Industry Classification System) description for the lookalike. | string |
| Lookalike Country Location | lookalike_country_location | The country of operation for the lookalike. | string |
| Similarity Score | similarity_score | Similarity score of the lookalike to the requested company. Medium (0.95–0.975), High (0.975+) | string |
Webstack
Webstack
Webstack
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Website’s SKU product count | product_count | SKU Product Count is the number of unique products that an eCommerce website lists and sells. | integer |
| Website’s Transco page traffic rank | q_rank | Transco Page Traffic Rank between 1 and 1,000,000. The Tranco score combines the Alexa Internet Top 1 Million, Cisco Umbrella Popularity List, Majestic Million, Quantcast Top Sites creating an accurate representation of how popular websites are. | integer |
| Website’s Umbrella traffic rank | umbrella | Umbrella Global Router Traffic Rank between 1 and 1,000,000. Umbrella is based on net sum DNS queries across the globe. | integer |
| Number of pages on website’s sitemap | number_of_pages_on_sitemap | Number of pages listed on the website’s indexable sitemap. A sitemap is a file providing information about the pages, videos, other files, and the relationships between them. | integer |
| List of Shopify apps used by website | shopify_apps_in_use | List of Shopify apps detected on the website. Shopify apps are used to answer a variety of business needs. | string |
| Most recent website index date | latest_update | Website’s most recent date of index by the webstack collector, formatted YYYY-MM-DDTHH:mm:ss.SSSZ. | datetime |
| Website has live technologies | live_techs | True if any live technologies that are currently active were detected on the website. | boolean |
| Is DB indexed | db_indexed | True if the website is recorded in the databse. If false, the website may be suspect. | boolean |
| Website has affiliate links | affiliate_links | True if any affiliate program advertising systems were detected on the website. | boolean |
| Website is established | established | True if the website was established for at least 1 year prior to the webstack being indexed. | boolean |
| Technology sub-categories detected on website | technologies_sub_categories | Mapping of each technology detected on the website, to its assigned sub-category. | string |
| Website has parked technologies | parked | True if the site is using any parked domains, parked domain technology providers, or mentions parked domains. Parked domains are domain names that are not connected to a service provider or website. | boolean |
| Website risk status | status | Website’s trustworthiness status, based on factors such as the estimated amount of money spent on various technologies for the website, how long the website has existed, the domain‚Äö√Ñ√¥s relationship with other websites, and other undisclosed factors. | Suspect=according to the listed factors the domain has been determined as untrustworthy, OK=overall the domain has been determined as trustworthy, Can not determine=the trustworthiness was not determined, usually due to the domain being new | string |
| Domain’s number of social networks | number_of_social_networks | Number of social network profiles listed on the website that are associated with the company. | integer |
| Twitter profile | twitter_link | Link to the Twitter profile associated with the company. The link is listed on the company’s registered domain. | url |
| Earliest website index date | earliest_record | Website’s earliest date of index by the webstack collector, formatted YYYY-MM-DDTHH:mm:ss.SSSZ. | datetime |
| Technology categories detected on website | technologies_categories | List of the technology categories detected on the website. | string |
| Payment options available on website | payment_technologies_in_use | List of the detected currencies, technologies, and digital wallets that can be used for online payment on the website. | string |
| Domain’s contact phone number | contact_phone_number | Phone number listed under the ‘contact us’ section of the company’s website. | string |
| Number of premium technologies detected on website | premium_techs | Number of premium technologies detected on the website. Premium technologies are the technologies or tools in the webstack that cost money. | integer |
| Number of technologies detected on website | number_of_premium_technologies | Number of technologies detected on the company’s website. Technologies are tools used to build the website. | integer |
| Estimated average monthly spending on webstack | money_spend_on_website_technologies | Estimated monthly financial investment in the technologies used on the company’s website, displayed in USD. Calculation: sum of the average price point for each technology used on the website. | integer |
| Website has eCommerce technology | ecommerce | True if an eCommerce technology was detected on the website. Inluding links to a shopping cart or other ‘buy’ options. | boolean |
| Premium monthly spending | spend | Estimation of average monthly USD spent across the entire domain on all aspects. | integer |
| List of technologies detected on website | technologies_used_by_company_website | List of the technologies detected on the website. | string |
| Website has online payment option | payment_options | True if the website provides online payment options on the website, or mentions a payment provider by name. | datetime |
| Technologies detected on website mapped to categories | categories_to_technologies_tree | Mapping of each technology detected on the website to its assigned category. | object |
| Company vertical | company_vertical | The name of the industry associated with the company and mentioned on the website. | string |
| YouTube channel | youtube_link | Link to the YouTube channel associated with the company. The link is listed on the company’s registered domain. | URL |
| Domain’s country | country | Country listed under the ‘about us’ section of the company’s website. | COUNTRY |
| Domain’s city | city | The city listed under the ‘about us’ section of the company’s website. | CITY |
| Domain’s state | state | State listed under the ‘about us’ section of the company’s website. | US State |
| Domain’s ZIP code / post code | postcode | Company’s Zipcode listed under the ‘about us’ section of the website. | ZIP CODE |
| Facebook profile | facebook_link | A link to the Facebook profile associated with the company. The link is listed on the company’s registered domain. | URL |
| LinkedIn® link | linkedin_link | A link to the LinkedIn® profile associated with the company. The link is listed on the company’s registered domain. | URL |
| Domain emails | domain_email | List of the emails associated with the domain that are logged on the company’s website. | TEXT |
| Domain names | domain_name | Domain names of the company’s website. | TEXT |
| Generic emails | generic_email | List of emails associated with company employees who are listed on the website and have undeclared titles. | TEXT |
| error_code | error_code | CATEGORY | |
| error_message | error_message | TEXT | |
| Brand followers lower bound range | followers | Lower bound range of the website’s brand followers across social media platforms. Each number is bottom of the range e.g. returned value ‘1000’ is 1K-2K followers | ‘1000000’ is 1M-2M followers | NUMERIC |
| Analyst names | analyst_name | List of the names of the company’s analysts listed on the company’s website. | TEXT |
| Consultant names | consultant_name | List of the names of the company’s consultants listed on the company’s registered domain. | TEXT |
| Designer names | designer_name | List of the names of the company’s designer team listed on the company’s website. | TEXT |
| Engineer names | engineering_name | List of the names of the company’s engineering team listed on the company’s website. | TEXT |
| Generic names | generic_name | Names of people whose titles or association to the company are not stated on the company’s website. | TEXT |
| Software team names | software_name | List of the names of the company’s software team listed on the company’s website. | TEXT |
| Support names | support_name | List of the names of the company’s support team listed on the company’s registered domain. | TEXT |
| Web developer names | web_dev_name | List of the names of the company’s business development experts listed on the company’s website. | TEXT |
| Business development personnel names | bizdev_name | Indicate the names of the business development experts of the company as they appear on the business’ website. | TEXT |
| Consultant emails | consultant_email | The emails associated with the company’s consultants that are listed on the company’s website. | TEXT |
| Designer emails | designer_email | Email address of the company’s designer listed on the company’s website. | TEXT |
| Engineer emails | engineering_email | List of the emails associated with the engineering team listed on the company’s website. | TEXT |
| Pinterest profile | pinterest_link | Pinterest profile URL of the company as it appears on the website of the business. | URL |
| Sales team names | sales_name | The names of the company’s sales team listed on the website. | TEXT |
| Software emails | software_email | List of the emails associated with the software engineering team that are listed on the company’s website. | TEXT |
| Support emails | support_email | List of the emails associated with the company’s support team listed on the company’s website. | TEXT |
| Web developer emails | web_dev_email | List of the emails associated with the web developers that are listed on the company’s website. | TEXT |
| Bizdev emails | bizdev_email | List of the emails associated with the business development experts that are listed on the company’s website. | TEXT |
| Manager names | manager_name | Name of the company’s managers listed on the company’s website. | TEXT |
| Analyst emails | analyst_email | The emails associated with the company’s analysts that are listed on the company’s website. | TEXT |
| Marketing team names | marketing_name | A list of the names of the company’s marketing team listed on the company’s website. | TEXT |
| Founder names | founder_name | The founder of the company as it appears on the website of the business. | TEXT |
| Instagram link | instagram_link | Link to the Instagram profile associated with the company. The link is listed on the company’s registered domain. | URL |
| Sales emails | sales_email | The emails associated with the company’s sales team that are listed on the company’s website. | TEXT |
| Founder emails | founder_email | The emails associated with the company’s founders that are listed on the company’s website. | TEXT |
| Director names | director_name | List of the names of the company’s directors listed on the company’s website. | TEXT |
| C-suite names | c_suite_name | Names of the company’s executive-level managers as they appear on the company’s website. | TEXT |
| Marketing emails | marketing_email | List of the emails associated with the marketing team that are listed on the company’s website. | TEXT |
| C-suite emails | c_suite_email | List of the emails logged on the company’s website associated with the company’s executive-level managers. | TEXT |
| President emails | president_email | Email associated with the company’s president listed on the company’s website. | TEXT |
| President names | president_name | Name of the company’s president that is listed on the company’s website. | TEXT |
| Company name | company_name | The name of the company listed on the website. | COMPANY |
| Manager emails | manager_email | List of the emails associated with the company’s managers listed on the company’s website. | TEXT |
| Director emails | director_email | Email associated with the company’s director listed on the company’s registered domain. | TEXT |
| Contact email address | contact_email_address | The contact email address listed for the company under the ‘contact us’ section. | TEXT |
| Accountant emails | accounts_email | List of emails associated with the company’s accountants that are listed on the business’ website. | TEXT |
| Accountants names | accounts_name | List of the names of the company’s accountants listed on the company’s website. | TEXT |
| Board member emails | board_email | List of the emails associated with the board members that are listed on the company’s website. | TEXT |
| Board member names | board_name | List of the names of the company’s board members listed on the company’s website. | TEXT |
| Unknown emails | unknown_email | Email addresses of unknown professionals listed on the company’s website. | TEXT |
| Names with unknown category | unknown_name | Names listed on the domain that have an unknown | TEXT |
Company Hierarchy
Company Hierarchy
Company Hierarchy
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| Input company ID | input_company_id | The original business_id provided as input | EXPLORIUM_ID |
| Input company name | input_company_name | The name of the input company | COMPANY |
| Parent company ID | parent_company_id | Business ID of the immediate parent company | EXPLORIUM_ID |
| Parent company name | parent_company | The name of the immediate parent company | COMPANY |
| Ultimate parent ID | ultimate_parent_id | Business ID of the top-most company in the tree (level_0) | EXPLORIUM_ID |
| Ultimate parent name | ultimate_parent_name | The name of the top-most company in the tree (level_0) | COMPANY |
| Subsidiaries | subsidiaries | List of direct subsidiaries | JSON |
| Organization hierarchy Tree | org_tree_json | A JSON structure representing the full organizational tree from top to bottom | JSON |
Business Intent Topics (Bombora)
Business Intent Topics (Bombora)
Business Intent Topics (Bombora)
| Signal | API Name | Description | Data Type |
|---|---|---|---|
| level_of_intent | Level of Intent | Indicates how actively a company engaged with selected topics during the past week: >25% = In-Depth Research, 5–25% = Active Research, <5% = Early Research. Returns null when no input topics are available. | CATEGORY |
| topic_count | Topic Count | Shows the number of topics with a composite score above 60, relative to all topics evaluated (e.g., 5/5). When no input topics are provided, all topics are returned. | TEXT |
| intent_topics | Intent Topics | Contains an array of objects summarizing the company’s active interest in specific Bombora topics over a given week. Each object includes the topic name, category, composite score, and date. | TEXT |
| company_website | Company Website | The company’s primary website or domain URL. | URL |
| company_name | Company Name | The official or recognized name of the company. | LTEXT |
| date_stamp | date | The date of the most recent Bombora data file (weekly), in format YYYYMMDD | TEXT |