Sending Custom Places to Factual
In some situations, you may request that Factual work with a set of custom places for a particular opportunity (e.g., for a specific campaign being serviced by Measurement). This document describes how to format the custom places file that you send to Factual.
File Naming
For the filename, please include your company name, the name of the chain or locations being measured, and the phrase “CustomPlaces” in the file name, separated by dashes (“-”). Use the following format: [CompanyName]-[ChainName]-CustomPlaces.tsv
Do not include any non-alphanumeric characters (spaces, underscores, apostrophes, etc.) in the chain name. As an example, if your company name is MarketerX and you are sending Factual the locations of Amy’s Back-to-Basics Hardware stores, the filename should be: MarketerX-AmysBacktoBasicsHardware-CustomPlaces.tsv
File Format
Your file should be a tab-separated value (TSV) file containing the fields described in the table below.
Individual records should be delimited by a newline.
Field | Type | Description | Example |
---|---|---|---|
Store ID | String; required | A unique identifier for a specific store or location. | A275 |
Name | String; optional | The name of the specific store or location. | BurgerChain |
Street Address | String; optional | Street address of the specific store or location. | 123 Main St |
City | String; optional | City of the specific store or location. | Burbank |
Region | String; optional | State or region of the specific store or location. | CA |
Latitude | String; required | Latitude of the store or location. Factual strongly recommends at least 6 decimal places of precision. | 34.181072 |
Longitude | String; required | Longitude of the store or location. Factual strongly recommends at least 6 decimal places of precision. | -118.311543 |
Note: Do not include headers in any file submitted directly to Factual. Please send your Factual account representative the ordered list of fields as described below to ensure correct processing of your file. For example, if your file contains Store ID, Latitude and Longitude (in that exact order), but no other fields, then tell your Factual account representative prior to submitting your places file.
Examples
The following are two examples of compliant files. The first file has the following fields: Store ID, Latitude, Longitude
6C9 34.181072 -118.311543
3H4 34.181046 -118.311511
HWE 34.181100 -118.311545
The second file has the following fields: Store ID, Name, Street Address, City, Region, Latitude, Longitude
6C9 BurgerChain LA 123 Sunset Blvd Los Angeles CA 34.181072 -118.311543
3H4 BurgerChain OC 12 Jeffrey Road Irvine CA 34.181046 -118.311511
HWE BurgerChain Valley 41 Ventura Blvd Sherman Oaks CA 34.181100 -118.311545
Updated over 3 years ago