# Data Dictionary: Chrome Store Reviews

Dictionary contains explanations and examples for all data fields available in the **Chrome Store Reviews** 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 per category" %}

1. [Metadata](#metadata)
2. [Review and author](#review-and-author)
3. [Vendor's answer](#vendors-answer)
   {% 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/chrome-store/chrome-store-reviews/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 (integers) |
| `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 (integers) |
| `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`               | Type of data object or entity described                  | String                      |
| `is_deleted`           | Indicates if the record is available on the Chrome Store | Boolean                     |

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

{% code title="Record metadata" %}

```json
		"_meta": {
			"created_at_date": [
				2024,
				1,
				22
			],
			"created_at_timestamp": 1705926396.259961,
			"updated_at_date": [
				2024,
				5,
				14
			],
			"updated_at_timestamp": 1715670609.077114,
			"version_id": "b8897d35",
			"source": "chromestore",
			"object": "review",
			"is_deleted": false
		},
```

{% endcode %}

### Review metadata

| Data field   | Description                                      | Data type |
| ------------ | ------------------------------------------------ | --------- |
| `id`         | Review record identification key in our database | String    |
| `source_id`  | Record identification key on Chrome Store        | String    |
| `url`        | Review URL                                       | String    |
| `company_id` | Company identification key                       | String    |
| `image_url`  | Reviewer's image URL                             | String    |

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

{% code title="Review metadata" %}

```json
"id": "chromestore_review_877b1af6-db08-9d95-5697-f6601d1cd3c8",
"source_id": "877b1af6-db08-9d95-5697-f6601d1cd3c8",
"url": "https://chromewebstore.google.com/detail/chatgptbox/eobbhoofkanlmddnplfhnmkfbnlhpbbo/reviews",
"company_id": "chatgptbox/eobbhoofkanlmddnplfhnmkfbnlhpbbo",
"image_url": "https://lh3.googleusercontent.com/a-/ALV-UjXwkkVyLTIP2m_nXEApOlxnhamcEt32EErAS4L21Hm16S6X=s32",
```

{% endcode %}

## Review and author

| Data field | Description                                                   | Data type     |
| ---------- | ------------------------------------------------------------- | ------------- |
| `name`     | Reviewer's name                                               | String        |
| `review`   | Review content                                                | String        |
| `date`     | Date and time when the review was posted in `ISO 8601` format | String (date) |
| `rating`   | Reviewer's numerical rating (from 1 to 5 stars)               | Integer       |

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

{% code title="Review and author" %}

```json
"name": "John Doe",
"review": "Have been following this extension since it first forked on GitHub and the author really put time and effort into it and the results are great. Easily one of my most used extensions now.",
"date": "2023-03-19 20:36:44",
"rating": 5,
```

{% endcode %}

## Vendor's answer

| Data field           | Description                                                     | Data type     |
| -------------------- | --------------------------------------------------------------- | ------------- |
| `answerer_id`        | Identifier of extension author                                  | String        |
| `answerer_name`      | Extension author                                                | String        |
| `answerer_image_url` | Extension author's avatar URL                                   | String        |
| `answer`             | Review response                                                 | String        |
| `answer_date`        | Date and time when the response was posted in `ISO 8601` format | String (date) |

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

{% code title="Vendor" %}

```json
"answerer_id": "5077cd38-7b0c-f9d0-52bf-112d44b70f79",
"answerer_name": "Robert Roe",
"answerer_image_url": "https://lh3.googleusercontent.com/a-/ALV-UjWWICg2TzkEbn0JY3hPi1FYz7ummS4nSU-Po5r2ShfcCw=s32",
"answer": "Thank you for your continuous support and contribution.\ud83d\ude0a",
"answer_date": "2023-03-20 00:41:02"
```

{% endcode %}