Google My Business

Google My Business ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v4
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	GoogleMyBusiness Email GoogleMyBusiness password
Replication Type	Key based Replication Full Replication
Replication Key	DATE NA
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Accounts	Locations
LocationReviews	MediaCustomerLists
Questions	ReportInsights

Integrate Google My Business with Daton

1. Sign in to Daton

2. Select Google My Business from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your Email and Password associated with Google My Business.

5. After providing the Email,password to authorize Daton to periodically extract data from Google My Business.

6. Post successful authentication in the second step, is designed in such a way that it contains static tables(Accounts,Locations,Location reviews,Questions) which you will be prompted to configure, and it also contains the custom tables(reportInsights) and metrics , metric options which you will be prompted to configure.

7. Then select all required fields for each table (You will not have an option to configure fields for custom tables(Report Insights))

8. Submit the integration.

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

GoogleMyBusiness Data

Accounts

Purpose: Lists all the accounts for the authenticated user. This includes all accounts that the user owns, as well as any accounts for which the user has management rights.

Source API Documentation https://developers.google.com/my-business/reference/accountmanagement/rest/v1/accounts/list

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
name	STRING
accountName	STRING
type	STRING
verificationState	STRING
vettedState	STRING
accountNumber	NUMERIC
permissionLevel	STRING
role	STRING

Locations

Purpose: Lists the locations for the specified account.

Source API Documentation https://developers.google.com/my-business/reference/rest/v4/accounts.locations/list

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
name	STRING
storeCode	STRING
locationName	STRING
primaryPhone	STRING
primaryCategory	RECORD
websiteUrl	STRING
regularHours	RECORD
locationKey	RECORD
latlng	RECORD
openInfo	RECORD
locationState	RECORD
metaData	RECORD
languageCode	STRING
address	RECORD

LocationReviews

Purpose:Returns the paginated list of reviews for the specified location. This operation is only valid if the specified location is verified.

Source API Documentation https://developers.google.com/my-business/reference/rest/v4/accounts.locations.reviews/list

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
reviewId	STRING
reviewer	RECORD
starRating	STRING
comment	STRING
createTime	TIMESTAMP
updateTime	TIMESTAMP
name	STRING

MediaCustomerLists

Purpose: Returns a list of media items associated with a location that have been contributed by customers.

Source API Documentation https://developers.google.com/my-business/reference/rest/v4/accounts.locations.media.customers/list

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
name	STRING
mediaFormat	STRING
googleUrl	STRING
thumbnailUrl	STRING
createTime	TIMESTAMP
dimensions	RECORD
insights	RECORD
attribution	RECORD

Questions

Purpose:Returns the paginated list of questions and some of its answers for a specified location.

Source API Documentation https://developers.google.com/my-business/reference/rest/v4/accounts.locations.questions/list

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
accountId	STRING
locationId	STRING
name	STRING
author	RECORD
text	STRING
createTime	TIMESTAMP
updateTime	TIMESTAMP
topAnswers	RECORD
totalAnswersCount	NUMERIC

ReportInsights

Purpose: Returns a report containing insights on one or more metrics by location.

Source API Documentation https://developers.google.com/my-business/reference/rest/v4/accounts.locations/reportInsights

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
locationName	STRING
metricValues	RECORD
timezone	STRING