# Data Dictionary: Glassdoor Companies

Dictionary contains explanations and examples of all data fields available in the **Glassdoor** **Companies** dataset.

{% hint style="info" %}
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
{% endhint %}

{% tabs %}
{% tab title="Data fields by category" %}

1. [Metadata](#metadata)
2. [Company profile details](#company-profile-details)
3. [Firmographics](#firmographics)
4. [Related posts](#related-posts)
5. [Ratings](#ratings)
   {% endtab %}
   {% endtabs %}

{% hint style="info" %}
The data fields in the example snippets have been rearranged for better grouping. To see where a specific data field stands, check the full data sample [here](https://docs.coresignal.com/additional-sources/glassdoor/glassdoor-companies/data-sample).
{% endhint %}

***

## Metadata

### Record metadata

| Data field             | Description                                          | Data type                  |
| ---------------------- | ---------------------------------------------------- | -------------------------- |
| `meta`                 | Contains metadata about the record                   | Object                     |
| `created_at_date`      | Date when the record was initially scraped           | Array of numbers (integer) |
| `created_at_timestamp` | Unix timestamp for when the record was first scraped | Float                      |
| `updated_at_date`      | Date when the record was last updated                | Array of numbers (integer) |
| `updated_at_timestamp` | Unix timestamp for when the record was last updated  | Float                      |
| `version_id`           | Identifier for the dataset version                   | String                     |
| `source`               | Source from which the record was obtained            | String                     |
| `object`               | Data object type                                     | String                     |
| `is_deleted`           | Indicates if the record is available on Glassdoor    | Boolean                    |

**See a snippet of the dataset for reference:**

{% code title="Record metadata" %}

```json
"_meta": {
	"source": "glassdoor",
	"object": "company",
	"created_at_date": [
		2021,
		1,
		22
	],
	"created_at_timestamp": 1611290232.696056,
	"updated_at_date": [
		2024,
		11,
		1
	],
	"updated_at_timestamp": 1714561033.173981,
	"version_id": "28ff7dfe",
	"is_deleted": false
```

{% endcode %}

### Profile metadata

| Data field       | Description                                                                                           | Data type |
| ---------------- | ----------------------------------------------------------------------------------------------------- | --------- |
| `doc`            | Dataset starting point                                                                                | Object    |
| `source_id`      | Record identifier on Glassdoor                                                                        | String    |
| `main_source_id` | Indicates the primary company profile when there are multiple profiles for different company branches | String    |
| `id`             | Record identifier in our database                                                                     | String    |

**See a snippet of the dataset for reference:**

{% code title="Meta information" %}

```json
"doc": {
      "source_id": "1144661",
      "main_source_id": "6036",
      "id": "glassdoor_company_1144661",
```

{% endcode %}

## Company profile details

| Data field    | Description                                                              | Data type |
| ------------- | ------------------------------------------------------------------------ | --------- |
| `url`         | Profile URL                                                              | String    |
| `image`       | Logo URL                                                                 | String    |
| `description` | <p>Description<br><strong>Note:</strong> contains control characters</p> | String    |
| `mission`     | Mission statement                                                        | String    |

**See a snippet of the dataset for reference:**

{% code title="Company profile details" %}

```json
"url": "https://www.glassdoor.com.au/Overview/Working-at-example-company-EI_IE97866566655556416.htm?countryPickerRedirect=true",
"image": "https://media.glassdoor.com/sql/978416/example-company-squarelogo-1545395085457.png",
"description": "Example Company is a cutting-edge IT company specializing in innovative software development, cloud computing services, and cybersecurity solutions for businesses worldwide.",
"mission": "Our mission is to empower businesses with innovative and reliable IT solutions, driving growth and efficiency through technology.",
```

{% endcode %}

## Firmographics

| Data field       | Description           | Data type |
| ---------------- | --------------------- | --------- |
| `location`       | Headquarters location | String    |
| `name`           | Name                  | String    |
| `type`           | Type                  | String    |
| `founded`        | Founding year         | Integer   |
| `industry`       | Associated industry   | String    |
| `employee_count` | Size                  | String    |

**See a snippet of the dataset for reference:**

{% code title="Company details" %}

```json
"location": "Indianapolis, IN",
"name": "Example Company",
"type": "Company - Public",
"founded": 2011,
"industry": "Security & Protective",
"employee_count": "1 to 50 Employees",
```

{% endcode %}

### CEO

| Data field           | Description                    | Data type |
| -------------------- | ------------------------------ | --------- |
| `ceo`                | Full name of the company's CEO | String    |
| `ceo_approval_count` | Approval rate of the CEO       | Float     |

**See a snippet of the dataset for reference:**

{% code title="CEO" %}

```json
"ceo": "John Doe",
"ceo_approval_count": -1.0,
```

{% endcode %}

### Revenue

| Data field | Description | Data type |
| ---------- | ----------- | --------- |
| `revenue`  | Revenue     | String    |

**See a snippet of the dataset for reference:**

{% code title="Revenue" %}

```json
"revenue": "$2 to $5 billion (USD)",
```

{% endcode %}

### Website

| Data field | Description | Data type |
| ---------- | ----------- | --------- |
| `website`  | Website URL | String    |

**See a snippet of the dataset for reference:**

{% code title="Social media presence" %}

```json
"website": "https://example-company.io",
```

{% endcode %}

### Affiliated companies

| Data field             | Description                                  | Data type        |
| ---------------------- | -------------------------------------------- | ---------------- |
| `affiliated_companies` | List of affiliated companies                 | Array of objects |
| `url`                  | Company profile URL                          | String           |
| `name`                 | Company name                                 | String           |
| `is_parent`            | Indicates if the company is a parent company | Boolean          |

**See a snippet of the dataset for reference:**

{% code title="Affiliated companies" %}

```json
"affiliated_companies": [
    {
      "url": "https://www.glassdoor.com/Overview/Working-at-field-work-EI_IE444334.11,21.htm",
      "name": "Example Company",
      "is_parent": true
    },
    {
      "url": "https://www.glassdoor.com/Overview/Working-at-EI_IEddd35r434433ccc55818.htm",
      "name": "Other Company",
      "is_parent": false
    }
  ]
```

{% endcode %}

## Related posts

| Data field        | Description                                                 | Data type |
| ----------------- | ----------------------------------------------------------- | --------- |
| `job_count`       | Number of active job postings                               | Integer   |
| `salary_count`    | Number of company salary posts                              | Integer   |
| `benefit_count`   | Number of employee comments/ratings on the company benefits | Integer   |
| `review_count`    | Number of employee reviews                                  | Integer   |
| `interview_count` | Number of employee comments on job interviews               | Integer   |

**See a snippet of the dataset for reference:**

{% code title="Related posts" %}

```json
"job_count": 239,
"salary_count": 716,
"benefit_count": 172,
"review_count": 568,
"interview_count": 93,
```

{% endcode %}

## Ratings

### Overall rating

| Data field   | Description          | Data type |
| ------------ | -------------------- | --------- |
| `rating`     | Ratings on Glassdoor | Object    |
| `aggregated` | Overall rating       | Float     |

**See a snippet of the dataset for reference:**

{% code title="Rating" %}

```json
"rating": {
          "aggregated": 3.8,
        },
```

{% endcode %}

### Rating distribution

| Data field                | Description                                                               | Data type |
| ------------------------- | ------------------------------------------------------------------------- | --------- |
| `star_distribution`       | Count of each star rating given in the reviews                            | Object    |
| `1` - `5`                 | Number of reviews that gave one to five stars to the company              | Integer   |
| `percentage_distribution` | Percentage distribution of each star rating in the reviews                | Object    |
| `1` - `5`                 | Percentage distribution by the total number of stars given in the reviews | Float     |

**See a snippet of the dataset for reference:**

{% code title="Stars" %}

```json
"star_distribution": {
            "1": 13,
            "2": 23,
            "3": 52,
            "4": 64,
            "5": 60
          },
          "percentage_distribution": {
            "1": 6.13,
            "2": 10.85,
            "3": 24.53,
            "4": 30.19,
            "5": 28.3
          }
```

{% endcode %}

### Detailed ratings

| Data field              | Description                                                                                               | Data type |
| ----------------------- | --------------------------------------------------------------------------------------------------------- | --------- |
| `rating`                | <p>Detailed ratings<br><strong>Note</strong>: optional ratings that might not be visible in the data.</p> | Object    |
| `culture_values`        | Average rating for the company's culture and values                                                       | Float     |
| `career_opportunities`  | Average rating for the career opportunities in the company                                                | Float     |
| `compensation_benefits` | Average rating for the compensation and benefits in the company                                           | Float     |
| `senior_management`     | Average rating for the company's senior management                                                        | Float     |
| `work_life_balance`     | Average rating for the work-life balance in the company                                                   | Float     |
| `diversity_inclusion`   | Average rating for diversity and inclusion in the company                                                 | Float     |
| `biz_outlook`           | Percentage of employee reviews indicating a `positive business outlook`                                   | Float     |
| `ceo`                   | Percentage of employee reviews that `approve of CEO`                                                      | Float     |
| `recommend`             | Percentage of employee reviews that `recommend to a friend`                                               | Float     |

**See a snippet of the dataset for reference:**

{% code title="Detailed rating" %}

```json
"rating": {
        "culture_values": 3.9,
        "career_opportunities": 3.7,
        "compensation_benefits": 3.5,
        "senior_management": 3.3,
        "work_life_balance": 3.6,
        "diversity_inclusion": 3.9,
        "biz_outlook": 61,
        "ceo": 87.0,
        "recommend": 73
            }
```

{% endcode %}