# Yelp datasets and fields

> The 2 datasets Maven lands from Yelp, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/yelp

Maven lands 2 datasets from Yelp in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [Yelp integration page](https://mavendata.ai/integrations/yelp).

## Connection and sync

You connect Yelp with API credentials from the Yelp account. Maven stores them encrypted.

Each Yelp sync takes a fresh copy of the current records, so the workspace always reflects what is in Yelp now.

## Datasets

### Businesses

Yelp business details and aggregate rating snapshot.

| Field | Type |
| --- | --- |
| business ID | Text |
| categories json | Text |
| location json | Text |
| name | Text |
| rating | Text |
| review count | Text |

### Reviews

Yelp public review excerpts; the public Fusion endpoint returns a bounded set of excerpts.

| Field | Type |
| --- | --- |
| business ID | Text |
| company reply date | Text |
| company reply text | Text |
| consumer location | Text |
| consumer name | Text |
| content | Text |
| date | Date |
| is verified | Text |
| language | Text |
| rating | Text |
| review ID | Text |
| title | Text |
