> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/advertising/google-my-business-v2/schema-information.md).

# Schema Information

## Tables/APIs 

The following is the table associated with the Google My Business v2 connector:

* [MonthlySearchKeywords](#monthlysearchkeywords)
* [LocationReviews](#locationreviews)
* [DailyMetrics](#dailymetrics)

#### MonthlySearchKeywords

Returns the search keywords used to find a business in search or maps. For more information, see [Method: locations.searchkeywords.impressions.monthly.list](https://developers.google.com/my-business/reference/performance/rest/v1/locations.searchkeywords.impressions.monthly/list).

**Fields**

<table><thead><tr><th width="340">Field Name</th><th width="244">Data Type</th></tr></thead><tbody><tr><td>searchKeyword</td><td>STRING</td></tr><tr><td>insightsValue</td><td>RECORD</td></tr></tbody></table>

#### LocationReviews

Represents a review for a location. For more information, see [REST Resource: accounts.locations.reviews](https://developers.google.com/my-business/reference/rest/v4/accounts.locations.reviews).

**Fields**

<table><thead><tr><th width="340">Field Name</th><th width="244">Data Type</th></tr></thead><tbody><tr><td>reviewId</td><td>STRING</td></tr><tr><td>reviewer</td><td>RECORD</td></tr><tr><td>starRating</td><td>STRING</td></tr><tr><td>comment</td><td>STRING</td></tr><tr><td>createTime</td><td>TIMESTAMP</td></tr><tr><td>updateTime</td><td>TIMESTAMP</td></tr><tr><td>name</td><td>STRING</td></tr></tbody></table>

#### DailyMetrics

Returns the values for each date from a given time range that are associated with the specific daily metric. For more information, see [Method: locations.getDailyMetricsTimeSeries](https://developers.google.com/my-business/reference/performance/rest/v1/locations/getDailyMetricsTimeSeries).

**Fields**

<table><thead><tr><th width="340">Field Name</th><th width="244">Data Type</th></tr></thead><tbody><tr><td>dailyMetric</td><td>STRING</td></tr><tr><td>datedValues</td><td>RECORD</td></tr></tbody></table>