- query
- What you submitted for this row - a reviews URL or a bare product slug - echoed back on every row it produced.
- product_name
- The product the review belongs to. In our sample this arrived as G2's page heading rather than a bare name, in the form <Product> Reviews & Product Details, so strip the suffix if you want just the product.
- product_url
- The product's reviews page on G2.
- review_title
- The review's headline. Short - five to thirty-four characters across our fifty-nine.
- rating
- The review's rating, as a string rather than a number. Every value we saw was
'5.0' or '4.5' - but that is what the default sort surfaced, so treat it as a fact about our sample rather than about G2's scale. - review_text
- The full review body. Substantial on this site: six hundred to nearly five thousand characters in our sample.
- pros
- What the reviewer said they liked, as its own column - G2 asks this as a separate question.
- cons
- What the reviewer said they disliked, likewise its own column. This is the one to read first.
- reviewer_name
- The reviewer, as the review is credited.
- reviewer_title
- Presumably the reviewer's job title.
- company_size
- The reviewer's company size band. A closed vocabulary: in our sample always Small-Business (50 or fewer emp.), Mid-Market (51-1000 emp.) or Enterprise (> 1000 emp.).
- date
- When the review was posted. An ISO calendar date -
2025-03-16 - on all fifty-nine rows, never a relative phrase. Confirm it on your own run before you build a parser on it: four products is a narrow basis for a format claim. - helpful_count
- Presumably how many people marked the review helpful. Never once populated in anything we hold.
- verified
- Whether the review is verified. Every row we have says
Yes - we have never seen another value, so we cannot tell you what an unverified review looks like here. - review_link
- Presumably a permalink to the individual review.
- position
- The order the review came back in, restarting at 1 for each run. The only way to preserve G2's ordering once the file is sorted.