Data Dictionary

25min

Contains explanations and examples of all data fields available in the Trustpilot Companies dataset.
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
Data points by category
﻿Metadata﻿
﻿Firmographics﻿
﻿Review counts, ratings, and sources﻿
﻿Review counts by source﻿
﻿New review counts by star rating﻿
The data points in the example snippets have been rearranged for better grouping. To see where a specific data point stands, check the full data sample here.
﻿
Metadata
Record metadata
Data point
Description
Data type
meta
Contains metadata about the record
Object
created_at_date
Date when the record was initially scraped
Array of numbers
created_at_timestamp
Unix timestamp for when the record was first scraped
Number
updated_at_date
Date when the record was last updated
Array of numbers
updated_at_timestamp
Unix timestamp for when the record was last updated
Number
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 Trustpilot
Boolean
See a snippet of the dataset for reference:
Metadata
		"_meta": {
			"created_at_date": [
				2024,
				2,
				6
			],
			"created_at_timestamp": 1707250806.955289,
			"updated_at_date": [
				2024,
				4,
				14
			],
			"updated_at_timestamp": 1713116259.680527,
			"version_id": "cbd44e6f",
			"source": "trustpilot",
			"object": "company",
			"is_deleted": false
		},
		"_meta": {
			"created_at_date": [
				2024,
				2,
				6
			],
			"created_at_timestamp": 1707250806.955289,
			"updated_at_date": [
				2024,
				4,
				14
			],
			"updated_at_timestamp": 1713116259.680527,
			"version_id": "cbd44e6f",
			"source": "trustpilot",
			"object": "company",
			"is_deleted": false
		},
﻿
Company profile metadata
Data point
Description
Data type
id
Record identifier in our database
String
source_id
Record identifier on Trustpilot 
String
url
Trustpilot review page of the record company
String
See a snippet of the dataset for reference:
Company profile metadata
"id": "trustpilot_company_book-shop",
"source_id": "book-shop",
"url": "https://www.trustpilot.com/review/book-shop",
"id": "trustpilot_company_book-shop",
"source_id": "book-shop",
"url": "https://www.trustpilot.com/review/book-shop",
﻿
Firmographics
Data point
Description
Data point
name
Name
String
location
Location
String
website
Website URL
String
contact_info
Public contact information for the company
Object
email
Public email address
String
image
Logo URL
String
category
Category assigned to the company on Trustpilot
Array of strings
category_tree
Other categories assigned to the company profile 
Object
category_tier_1
Top-level category of the company
String
category_tier_2
Second-level category of the company
String
category_tier_3
Third-level category of the company
String
See a snippet of the dataset for reference:
Firmographics
"name": "Book Shop",
"location": "SK",
"website": "http://book-shop",
"contact_info": {
                "email": "info@book-shop"
            },
"image": "https://consumersiteimages.trustpilot.net/business-units/637deca24cfb29693de4454443456764568d09c-198x149-1x.jpg",
 "category": [
                "Comic Book Store"
            ],
"category_tree": {
                "category_tier_1": "Media & Publishing",
                "category_tier_2": "Books & Magazines",
                "category_tier_3": "Comic Book Store"
            },
"name": "Book Shop",
"location": "SK",
"website": "http://book-shop",
"contact_info": {
                "email": "info@book-shop"
            },
"image": "https://consumersiteimages.trustpilot.net/business-units/637deca24cfb29693de4454443456764568d09c-198x149-1x.jpg",
 "category": [
                "Comic Book Store"
            ],
"category_tree": {
                "category_tier_1": "Media & Publishing",
                "category_tier_2": "Books & Magazines",
                "category_tier_3": "Comic Book Store"
            },
﻿
Review counts, ratings, and sources
Ratings
Data point
Description
Data type
review_rating
Detailed review information from the company's Trustpilot page
Object
1
1-star rating count
Integer
2
2-star rating count
Integer
3
3-star rating count
Integer
4
4-star rating count
Integer
5
5-star rating count
Integer
count
Total number of reviews
Integer
overall
Overall rating based on reviews
Float
total_reviews_past_12_months
Total number of reviews in the past 12 months
Integer
See a snippet of the dataset for reference:
Ratings
"review_rating": {
				"1": 0,
				"2": 0,
				"3": 0,
				"4": 4,
				"5": 132,
				"count": 136,
				"overall": 4.9,
				"total_reviews_past_12_months": 136
			},
"review_rating": {
				"1": 0,
				"2": 0,
				"3": 0,
				"4": 4,
				"5": 132,
				"count": 136,
				"overall": 4.9,
				"total_reviews_past_12_months": 136
			},
﻿
Review sources
Data type
Description
Data type
review_source
Number of reviews from different sources
Object
organic
Number of organic reviews
Integer
automatic_invitations
Number of reviews from automatic review invitations 
Integer
manual_invitations
Number of reviews from manual review invitations
Integer
redirected
Number of reviews generated from external redirects to Trustpilot
Integer
See a snippet of the dataset for reference:
Review sources
"review_source": {
				"organic": 7,
				"automatic_invitations": 129,
				"manual_invitations": 0,
				"redirected": 0
			},
"review_source": {
				"organic": 7,
				"automatic_invitations": 129,
				"manual_invitations": 0,
				"redirected": 0
			},
﻿
Review statistics by source
Organic review counts
Data type
Description
Data type
organic_reviews_over_time
Number of organic reviews over time (up to the update month).

Written independently without using Trustpilot-supported invitation methods
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count
Integer
See a snippet of the dataset for reference:
Organic review counts
"organic_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 2
				},
				{
					"date": "July 2023",
					"count": 1
				},
				{
					"date": "August 2023",
					"count": 0
				}
			],
"organic_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 2
				},
				{
					"date": "July 2023",
					"count": 1
				},
				{
					"date": "August 2023",
					"count": 0
				}
			],
﻿
Reviews from invitations
Data point
Description
Data type
automated_invitations_reviews_over_time
Number of invitation-based reviews over time (up to the update month).

Written in response to automated invitations supported by Trustpilot
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
Reviews from invitations
"automated_invitations_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 17
				},
				{
					"date": "July 2023",
					"count": 24
				},
				{
					"date": "August 2023",
					"count": 19
				}
			],
"automated_invitations_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 17
				},
				{
					"date": "July 2023",
					"count": 24
				},
				{
					"date": "August 2023",
					"count": 19
				}
			],
﻿
Data point
Description
Data type
manual_invitations_reviews_over_time
Number of invitation-based reviews over time (up to the update month). 

Written in response to manual invitations supported by Trustpilot.
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
Reviews from invitations
"manual_invitations_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 0
				},
				{
					"date": "July 2023",
					"count": 3				},
				{
					"date": "August 2023",
					"count": 10
				}
			],
"manual_invitations_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 0
				},
				{
					"date": "July 2023",
					"count": 3				},
				{
					"date": "August 2023",
					"count": 10
				}
			],
﻿
Reviews from external redirects
Data point
Description
Data type
redirected_reviews_over_time
Number of reviews generated from external redirects to Trustpilot (up to the update month)
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
Reviews from external redirects
"redirected_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 5
				},
				{
					"date": "July 2023",
					"count": 3				
			    },
				{
					"date": "August 2023",
					"count": 2
				}
			],
"redirected_reviews_over_time": [
				{
					"date": "June 2023",
					"count": 5
				},
				{
					"date": "July 2023",
					"count": 3				
			    },
				{
					"date": "August 2023",
					"count": 2
				}
			],
﻿
New review counts by star rating
One star reviews
Data point
Description
Data type
new_reviews_by_rating
Counts of new reviews by star rating, ranging from one to five stars
Object
1
Total number of one-star reviews and the date they were recorded on the company's page


Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
New review counts
			"new_reviews_by_rating": {
				"1": [
				    {
						"date": "June 2023",
						"count": 0
					},
					{
						"date": "July 2023",
						"count": 0
					},
					{
						"date": "August 2023",
						"count": 0
					}
				],
			"new_reviews_by_rating": {
				"1": [
				    {
						"date": "June 2023",
						"count": 0
					},
					{
						"date": "July 2023",
						"count": 0
					},
					{
						"date": "August 2023",
						"count": 0
					}
				],
﻿
Two-star reviews
Data point
Description
Data type
new_reviews_by_rating
Counts of new reviews by star rating, ranging from one to five stars
Object
2
Total number of two-star reviews and the date they were recorded on the company's page
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
New review counts
			"new_reviews_by_rating": {
				"2": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 0
					},
					{
						"date": "August 2023",
						"count": 3
					}
				],
			"new_reviews_by_rating": {
				"2": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 0
					},
					{
						"date": "August 2023",
						"count": 3
					}
				],
﻿
Three-star reviews
Data point
Description
Data type
new_reviews_by_rating
Counts of new reviews by star rating, ranging from one to five stars
Object
3
Total number of three-star reviews and the date they were recorded on the company's page
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
New review counts
			"new_reviews_by_rating": {
				"3": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 0
					},
					{
						"date": "August 2023",
						"count": 5
					}
				],
			"new_reviews_by_rating": {
				"3": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 0
					},
					{
						"date": "August 2023",
						"count": 5
					}
				],
﻿
Four-star reviews
Data point
Description
Data type
new_reviews_by_rating
Counts of new reviews by star rating, ranging from one to five stars
Object
4
Total number of four-star reviews and the date they were recorded on the company's page
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
New review counts
			"new_reviews_by_rating": {
				"4": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 5
					},
					{
						"date": "August 2023",
						"count": 3
					}
				],
			"new_reviews_by_rating": {
				"4": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 5
					},
					{
						"date": "August 2023",
						"count": 3
					}
				],
﻿
Five-star reviews
Data point
Description
Data type
new_reviews_by_rating
Counts of new reviews by star rating, ranging from one to five stars
Object
5
Total number of five-star reviews and the date they were recorded on the company's page
Array of objects
date
Review count record date, formatted as month YYYY
String (date)
count
Review count 
Integer
See a snippet of the dataset for reference:
New review counts
			"new_reviews_by_rating": {
				"5": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 5
					},
					{
						"date": "August 2023",
						"count": 3
					}
				]
			"new_reviews_by_rating": {
				"5": [
				    {
						"date": "June 2023",
						"count": 2
					},
					{
						"date": "July 2023",
						"count": 5
					},
					{
						"date": "August 2023",
						"count": 3
					}
				]
﻿
﻿

Data point	Description	Data type
meta	Contains metadata about the record	Object
created_at_date	Date when the record was initially scraped	Array of numbers
created_at_timestamp	Unix timestamp for when the record was first scraped	Number
updated_at_date	Date when the record was last updated	Array of numbers
updated_at_timestamp	Unix timestamp for when the record was last updated	Number
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 Trustpilot	Boolean

Data point	Description	Data type
id	Record identifier in our database	String
source_id	Record identifier on Trustpilot	String
url	Trustpilot review page of the record company	String

Data point	Description	Data point
name	Name	String
location	Location	String
website	Website URL	String
contact_info	Public contact information for the company	Object
email	Public email address	String
image	Logo URL	String
category	Category assigned to the company on Trustpilot	Array of strings
category_tree	Other categories assigned to the company profile	Object
category_tier_1	Top-level category of the company	String
category_tier_2	Second-level category of the company	String
category_tier_3	Third-level category of the company	String

Data point	Description	Data type
review_rating	Detailed review information from the company's Trustpilot page	Object
1	1-star rating count	Integer
2	2-star rating count	Integer
3	3-star rating count	Integer
4	4-star rating count	Integer
5	5-star rating count	Integer
count	Total number of reviews	Integer
overall	Overall rating based on reviews	Float
total_reviews_past_12_months	Total number of reviews in the past 12 months	Integer

Data type	Description	Data type
review_source	Number of reviews from different sources	Object
organic	Number of organic reviews	Integer
automatic_invitations	Number of reviews from automatic review invitations	Integer
manual_invitations	Number of reviews from manual review invitations	Integer
redirected	Number of reviews generated from external redirects to Trustpilot	Integer

Data type	Description	Data type
organic_reviews_over_time	Number of organic reviews over time (up to the update month). Written independently without using Trustpilot-supported invitation methods	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
automated_invitations_reviews_over_time	Number of invitation-based reviews over time (up to the update month). Written in response to automated invitations supported by Trustpilot	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
manual_invitations_reviews_over_time	Number of invitation-based reviews over time (up to the update month). Written in response to manual invitations supported by Trustpilot.	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
redirected_reviews_over_time	Number of reviews generated from external redirects to Trustpilot (up to the update month)	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
new_reviews_by_rating	Counts of new reviews by star rating, ranging from one to five stars	Object
1	Total number of one-star reviews and the date they were recorded on the company's page	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
new_reviews_by_rating	Counts of new reviews by star rating, ranging from one to five stars	Object
2	Total number of two-star reviews and the date they were recorded on the company's page	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
new_reviews_by_rating	Counts of new reviews by star rating, ranging from one to five stars	Object
3	Total number of three-star reviews and the date they were recorded on the company's page	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
new_reviews_by_rating	Counts of new reviews by star rating, ranging from one to five stars	Object
4	Total number of four-star reviews and the date they were recorded on the company's page	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Data point	Description	Data type
new_reviews_by_rating	Counts of new reviews by star rating, ranging from one to five stars	Object
5	Total number of five-star reviews and the date they were recorded on the company's page	Array of objects
date	Review count record date, formatted as month YYYY	String (date)
count	Review count	Integer

Updated 01 Jul 2024

Did this page help you?

Trustpilot Companies

Data Sample