Skip to main content

Add longitude and latitude data with the Geolocation data service

Add longitude and latitude data to your feeds with the Geolocation data service in Productsup.

Introduction

If you have location information in your product feed, you can use the Geolocation data service to enhance it with latitude and longitude data.

Note

The Geolocation data service is available for the import and intermediate stages.

The Geolocation data service scans your address column and creates four (4) new columns to add latitude and longitude data to your feed:

  1. The ___geolocation_title column is a duplicate of your address column.

  2. The ___geolocation_latitude column contains your latitude data.

  3. The ___geolocation_longitude column contains your longitude data.

  4. The ___geolocation_next_try_date column determines when the platform should send the next request to the Geolocation API in case an address returned an error in the previous run.

Prerequisites

To use the Geolocation data service, you need:

  1. An API Key for the Google Geolocation API.

  2. Location data in the correct format. Your addresses must use the same format as the national postal service of the country in question. Separate your street address elements with spaces and, if applicable, avoid providing such info as business names and floor numbers. For example, here is a German address using the German postal service format delimited by spaces: Alex-Wedding-Straße 5 10178 Berlin.

    See Geocoding request and response for more information.

  3. A product identifier. See Set a product identifier for more information.

Add the Geolocation data service

  1. Go to Data Services from your site's main menu and select ADD SERVICE.

  2. Search for Geolocation, select Add, and give it a desired name and column prefix.

    By default, ___geolocation is the column prefix.

    geolocation.png
  3. Choose the stage where you have your location data in Service Data Level and select Add.

  4. Add your authentication data for the Google Geolocation API in API Key.

  5. Choose the column in your feed that contains your address data in Address column.

    Note

    If you chose Import in Step 3, the Address column drop-down list displays the columns of your import stage. If you chose Intermediate in that field, the drop-down list contains your intermediate-stage columns.

  6. If you want the platform to run the Geolocation data service every time there is a refresh in Data View, select the checkmark icon () in Trigger during a refresh of the Data View.

  7. Select Save.

  8. For the platform to process a new data service, select Run in the top-right corner of your site's view.

    Note

    If you can't see your new geolocation data in Data View, ensure the platform hasn't hidden it:

    1. Go to Data View from your site's main menu and choose Import or Intermediate in the drop-down list on your left.

    2. Select the menu icon on the right and then select the eye icon.

    3. Find the following attributes in the list and select the eye icon next to each attribute you want Data View to display: ___geolocation_latitude, ___geolocation_longitude, ___geolocation_title, and ___geolocation_next_try_date.

    4. Close the pop-up menu.

    The naming of the attributes created by the Geolocation data service depends on the column prefix you choose in Step 2. The attribute names the data service generates always start with three underscores (___), which means the platform doesn't send such attributes to your export channels.

Edit the Geolocation data service

  1. Go to Data Services from your site's main menu.

  2. To deactivate a data service, choose the pause icon next to the desired data service.

  3. Select the cogwheel icon () next to the desired data service to edit other settings.

  4. Once ready with new settings, select Save.

Delete the Geolocation data service

  1. Go to Data Services from your site's main menu.

  2. Select the cogwheel icon () next to the desired data service.

  3. In the Danger Area panel, select Remove this service.

  4. Select Yes.