Skip to main content

How can we help?

All Categories > What Is Example GeoCoder Spreadsheet And How To Work With It

What Is Example GeoCoder Spreadsheet And How To Work With It

Introduction to the Example GeoCoder Spreadsheet

The GeoCoder Spreadsheet is an essential component within our software. It is made to simplify the process of creating your geo-targeted landing pages.

This guide will walk you through the steps of using the GeoCoder Spreadsheet effectively to personalize your landing pages.

Using the Example GeoCoder Spreadsheet

Step 1: Accessing the Spreadsheet

While creating a new GeoCoder project within our software, you’ll have access to the Example GeoCoder Spreadsheet.

This spreadsheet contains pre-defined variables which will be used in the process of creation your landing pages.

After you upload your images and GeoCoder Spreadsheet made by our example and save the project, the set of images will be formed for all Geos from the spreadsheet and other information will be added to image exif data.

Step 2: Filling in Your Information

Your task is simple: populate the Example GeoCoder Spreadsheet with your project-specific data.

Simply make a copy of example GeoCoder spreadsheet and replace the placeholders with your actual data for as much pages as you need, ensuring accuracy and completeness.

Step 3: Variable-Value Mapping

Each variable in the Example GeoCoder Spreadsheet corresponds to a specific exif data of the image.

Ensure that the values you input align with the intended purpose of each variable. This ensures that the generated landing pages accurately reflect your desired content and messaging.

  • Geo City
  • geo-city
  • geo-exif-gps
  • geo-exif-title
  • geo-exif-keywords
  • geo-exif-description

Step 4: Saving Your Changes

Once you’ve filled in your information, save the changes made to your spreadsheet.

This ensures that your input is securely stored and readily accessible for the automated content personalization process.

Step 5: Add this Google Sheet to your project

Once you`ve saved the spreadsheet, you can now add it in Google Sheet Link input or insert Header and Data Rows from Spreadsheet.

And don`t forget to upload the images you’d like to bulk geocode. Make sure the file names for each of your images include the geo-city variable (i.e. local-seo-geo-city.jpg)

Step 6: Automated Content Personalization

Our software using the GeoCoder Spreadsheet to automate the process of replacing placeholders with your specified information.

Sit back and relax as your landing pages are dynamically generated.