Create Bulk Contact Spreadsheet to Upload to Google

Google My Business concern is the key listing that every location needs, just when you're managing tens, hundreds, or even thousands of Google My Business listings, y'all've got a big job on your easily unless you exercise list upload and verification in bulk. Here, correspondent Krystal Taing explains how to add together multiple locations to Google My Business and verify them in bulk.

When it comes to business listings, Google is the one place you lot really want to focus your efforts. Four in five consumers utilise search engines to find local information, and the vast majority turn to Google to do information technology; in fact, over 92% of mobile searches conducted worldwide happen on Google.

Your business presence across Google Search and Maps is managed from within a single Google My Business platform. Information technology's a great organisation for small-scale businesses, but how can you ensure consistency, accurateness and the greatest degree of optimization across hundreds or even thousands of locations? Multi-location businesses, including franchises, corporate chains and service-area businesses, face up unique challenges when it comes to local listings management.

Over the last few years, Google has added more features and back up for enterprise brands and users to manage locations in bulk. Most recently, they rolled out an agency dashboard that makes information technology easier to manage multiple brands and locations in a simpler interface. In this guide, we'll explore some of Google My Business' majority features and provide tips on how to maximize efficiency and manage locations at scale.

The Basics of Google My Business concern Majority Import: Step-past-Step

While information technology'southward helpful to use both bulk importing and bulk verification, y'all tin use i without the other.

Bulk importing your location data is a elementary way to make updates to existing locations, or create new ones, in bulk. For enterprise brands that are managing dozens, hundreds, or thousands of locations at a time, bulk importing data and updates based on your internal arrangement or CMS is likely the most efficient method. This gives you lot the ability to bear on a large number of locations in a relatively short period of time, rather than clicking through each location manually within the dashboard.

1. Yous accept ii choices for getting started

You can either create a new template for uploading, or download your existing locations. To download existing locations to build or edit your bulk template, only click on 'Download Locations' located underneath your business relationship summary within the Google My Business dashboard.

This gives you the option to download all 'downloadable' locations in an excel or .csv format. Locations ineligible for downloading have errors or are not published (east.g. duplicates, request access, etc.). Once these errors have been resolved, these tin can be included in your downloads.

Google My Business concern will too requite you the option to 'include Google Updates' in your export. Including this data is helpful if you lot want to review Google and user-suggested updates alongside your current data. If y'all chose to include the updates, when available, they will be in a neighboring column for each field prefaced with '[UPDATED]'.

The consign provides your list of locations, as well as a summary of Google Updates and each location's condition. This is helpful for auditing your locations, as you tin can focus on just those locations that may need attention or that users have suggested changing.

Outside of the bones location elements, you'll besides see your list of attributes included in the consign. Continue in heed that because you accept majority-exported all locations (which may be split up brands and take varying categories), all available attributes will show. Even so, if a particular attribute is not bachelor for that location or category, y'all will run across '[Not APPLICABLE]' in the column for that location.

2. Edit your attributes in keeping with Google My Business organisation formatting guidelines

When editing attributes, you can export the Aspect Reference Spreadsheet to see which values are accustomed for each attribute. These tin merely be included when the field is bare and does not show the [NOT APPLICABLE] notice.

Be sure to follow all Google My Business concern formatting guidelines for the bulk import spreadsheet. Once you've reviewed any errors and made the necessary changes, you lot are fix to import your corrected file. Call back, if y'all are making a change to a single or a modest number of fields, it is not necessary to include all columns in your import. If yous are but making updates and not creating new locations, the merely column required is Store Code.

In order to bulk edit, each location is required to have a unique store code. Considering this is the required association field, it's also the ane field y'all are unable to change in bulk. When creating new locations, you must include the Shop Code, all address fields, and principal category.

3. Import your corrected file

Next, to import your file, click the blue plus sign button and select 'import locations from file'.

This is also where you lot'll discover the template and sample file to download for building files from scratch.

4. Verify your changes in the Import Summary

In one case you've loaded your file, there is one last step earlier the changes are published to your locations. Google will review your spreadsheet and provide a summary of changes that volition be made to your listings, so you tin can review before you lot import.

The Import Summary lets you know how many locations and changes you are making by completing the import, and flags potential errors or missing locations. If your summary includes changes yous weren't anticipating, yous can select the 'Download Details' option which volition download a summary past location for you to validate before continuing. You lot tin also 'Abolish' the import if yous do not want to continue.

When all changes are correct, click the submit button to process your file. From here, as long as your changes are valid, your information will save and publish to Google. If there are any errors with your data (such as address formatting), these locations volition be flagged in red as formatting errors and require a manual update in order to salve changes.

While many changes publish in a matter of minutes, some larger changes to fields like name, address, and URL may take up to 48 hours to publish. Additionally, if you do not have majority verification, some of these larger changes tin can trigger a re-verification flag.

Google periodically adds and changes fields, adequate values, categories and attributes, and then it'southward important to review available options for your locations by downloading your existing locations.

The Route to Google My Business Bulk Verification

In order to manage your multiple locations on Google, you beginning have to claim and verify your business locations. This process exists to ensure that y'all are associated with the business organisation and accept the say-so to manage location updates. Standard business organization verification requires that the user receives a postcard, e-mail, or phone call with the verification code. In one case yous've completed the verification procedure, y'all tin make location updates to your listing. This process must be repeated for each boosted location you're managing.

Majority verification in Google My Business organisation differs from standard verification in that it was created for brands with 10 or more than locations. With bulk verification, you don't need to manually verify each new location.

Who is eligible for bulk verification in Google My Business organization?

Google'south published eligibility guidelines are adequately simple: y'all must have 10 or more locations belonging to the aforementioned business organization. All the same, there a few other things yous should know earlier applying for bulk verification:

1. All of the locations for the brand should be loaded to your business relationship. Your location statuses tin show published or not published.
2. You should non accept whatever duplicate or access-needed locations in your account when requesting bulk verification.
3. You can still asking bulk verification if you've previously manually verified some of your locations.
4. You will still be able to benefit from bulk verification for future changes or locations.

To prepare for bulk verification, ensure that all business details (primarily proper noun, address, website, and categories) are as accurate every bit possible and lucifer what is published on real-earth signage and marketing textile. If your listings are all of the same brand, then the name, domain, and categories should all match.

Verifying locations with proper name or category variations

If your make has variations of names and categories (example: banks with ATMs, or flat communities), they can still exist bulk-verified as long as Google can bear witness they are all managed nether the same concern/company. Some things you should take prepared for these types of businesses in particular are:

1. A corporate website showing all location details as you have in Google My Business organization
2. Electric current storefront images of at least 5 locations. These images should show the business proper name and address number and street name, if possible. It's also helpful if you can see surrounding businesses in your images, and so Google can reference their information. If Google has trouble verifying your locations via Street View or other methods, they may asking this data for a sample set of your locations.

Ensure that you have a corporate domain e-mail business relationship bachelor to admission, equally Google requires a response from a corporate domain in guild to approve your business relationship. You can sign up for bulk verification with a generic email address (such as Gmail), merely the corporate domain needs to respond to a Google asking. When applying for bulk verification, continue in mind that the email address you verify tin can non be changed.

Yous should not register an employee's personal e-mail for this verification, as there is a hazard they may move on and that would interfere with the visitor'southward admission to the Majority Verified Google My Business account. Additionally, if at whatsoever point in time you transfer ownership of locations that were bulk verified, they will lose verification if transferred to a non-bulk verified account.

Of course, at that place are other potential delays and issues when applying for bulk verification. About importantly, Google wants to ensure that the data y'all are publishing is correct and representative of the business in the real world, and that y'all are authorized past the business to manage these updates.

Google My Business Bulk Direction FAQs

Which fields cannot be edited in bulk?

You cannot edit store codes or map pin location/coordinates in majority. You also tin can't add together or edit Google Posts via the bulk import function.

Can you apply for bulk verification for Service Area Businesses?

No, because Google requires that Service Area Businesses are manually verified. If y'all have a majority-verified account that includes brick-and-mortar locations and try to change a location to a service area or add a new location that is a service expanse, it volition revert to 'manual verification required'.

Practise you need to be bulk-verified in lodge to bulk upload your locations?

No, all Google My Business users accept access to bulk-import their data.

How do I add managers to my locations in bulk?

But location owners can add managers. While you lot can add unmarried managers in bulk, if you take different managers you will want to add together by location, and it must be washed manually (or via API).

If you have a manager that you want to add to all or a set of your locations, you simply demand to motion these locations to a subfolder in Google My Business organisation. This doesn't impact whatever location data or verification. Once your locations are in a subfolder, edit the subfolder and 'manage users', calculation the Google My Business e-mail address of the desired manager.

Can you shut locations in bulk?

Aye, but not via import. Y'all can multi-select a group of locations that you wish to close and 'marker as permanently closed'. From here, you can either go on or remove the locations from your account. Yous tin can ever shop the airtight locations in a subfolder divide from active locations, to avoid publishing wrong data.

I hope I've been able to explicate the ins and outs of Google My Business bulk verification and bulk upload in a way that makes this process much easier. Have any questions or have your own tips to share? Let me know in the comments below!

Krystal Taing leads local listing management strategy for global enterprise brands at Rio SEO across a variety of industries, from retail to hospitality, to healthcare to finance and beyond. Krystal has spent the better part of the last decade in SEO and e-commerce, with a focus on local search since 2014.

giordanomalley1969.blogspot.com

Source: https://www.brightlocal.com/blog/how-to-bulk-upload-and-bulk-verify-gmb-listings/

Share this post