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