# FranConnect datasets and fields

> The 3 datasets Maven lands from FranConnect, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/franconnect

Maven lands 3 datasets from FranConnect in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [FranConnect integration page](https://mavendata.ai/integrations/franconnect).

## Connection and sync

You connect FranConnect with API credentials from the FranConnect account. Maven stores them encrypted.

Each FranConnect sync takes a fresh copy of the current records, so the workspace always reflects what is in FranConnect now.

## Datasets

### Leads

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| reference ID | Text |
| title | Text |
| lead first name | Text |
| lead last name | Text |
| company name | Text |
| email IDs | Text |
| alternate email | Text |
| phone numbers | Text |
| mobile numbers | Text |
| fax numbers | Text |
| extn | Text |
| address | Text |
| city | Text |
| state | Text |
| zipcode | Text |
| country | Text |
| cm lead status ID | Text |
| cm lead type ID | Text |
| cm rating ID | Text |
| cm source1 ID | Text |
| cm source2 ID | Text |
| cm source3 ID | Text |
| lead source category | Text |
| lead source detail | Text |
| web form URL | Text |
| primary contact method | Text |
| best time to contact | Text |
| lead owner ID | Text |
| lead owner reference ID | Text |
| lead added by | Text |
| lead added by reference ID | Text |
| franchisee no | Text |
| franchisee reference ID | Text |
| division ID | Text |
| division reference ID | Text |
| area ID | Text |
| area reference ID | Text |
| owner type | Text |
| comments | Text |
| service ID | Text |
| position | Text |
| suffix | Text |
| birthdate | Text |
| anniversarydate | Text |
| unsubscribe | Text |
| unsubscribe date | Text |
| unsubscribe reason | Text |
| unsubscribe reason detail | Text |
| SMS unsubscribe | Text |
| SMS unsubscribe date | Text |
| bounce email status | Text |
| bounce reason | Text |
| spam email status | Text |
| last contacted field | Text |
| converted by | Text |
| converted on | Text |
| contact reference ID | Text |
| contact first name | Text |
| contact last name | Text |
| opportunity reference ID | Text |
| opportunity ID | Text |
| opportunity name | Text |
| custom fields | Text |
| lead add date | Timestamp |
| lead modify date | Timestamp |
| date | Date |
| approximate liquidity572468853 | Text |
| approximate net worth774922666 | Text |
| area of interest788307126 | Text |
| areas of interest1896012510 | Text |
| how did you hear about us298060735 | Text |
| how soon do you envision opening your first fra1317554752 | Text |
| UTM source1564589214 | Text |
| variant1147564334 | Text |
| address2 | Text |
| background | Text |
| broker first name | Text |
| broker last name | Text |
| browser type | Text |
| co applicant relationship ID | Text |
| county ID | Text |
| date of open | Text |
| division | Text |
| email ID | Text |
| fax | Text |
| first contacted | Text |
| first name | Text |
| forecast closure date | Text |
| forecast rating | Text |
| forecast revenue | Text |
| franchise awarded | Text |
| home phone | Text |
| home phone ext | Text |
| invest timeframe | Text |
| ip address | Text |
| last attended | Text |
| last name | Text |
| last update | Text |
| lead killed reason | Text |
| lead killed reason comment | Text |
| lead rating ID | Text |
| lead source2 ID | Text |
| lead source3 ID | Text |
| lead status ID | Text |
| lead transaction type ID | Text |
| liquid capital max | Text |
| liquid capital min | Text |
| location id1 | Text |
| location id1b | Text |
| location id2 | Text |
| marketing code ID | Text |
| merged parent IDs | Text |
| mobile | Text |
| next call date | Text |
| no of field sold | Text |
| no of unit req | Text |
| other lead source detail | Text |
| phone | Text |
| phone ext | Text |
| preferred city1 | Text |
| preferred city2 | Text |
| preferred country1 | Text |
| preferred country2 | Text |
| preferred state id1 | Text |
| preferred state id2 | Text |
| primary phone to call | Text |
| probability | Text |
| request date | Text |
| salutation | Text |
| source of funding | Text |
| state ID | Text |
| status change date | Text |
| UTM content | Text |
| web site lead | Text |
| zip | Text |

### Fields

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| system name | Text |
| label | Text |
| data type | Text |
| is custom | True/false |
| is required | True/false |
| date | Date |

### Franchisees

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| reference ID | Text |
| franchisee ID | Text |
| franchisee no | Text |
| center ID | Text |
| center name | Text |
| franchisee name | Text |
| legal name | Text |
| owner name | Text |
| email IDs | Text |
| phone numbers | Text |
| address | Text |
| city | Text |
| state | Text |
| zipcode | Text |
| country | Text |
| status | Text |
| center type | Text |
| franchisee type | Text |
| region | Text |
| area | Text |
| division | Text |
| agreement date | Text |
| opening date | Text |
| grand opening date | Text |
| termination date | Text |
| franchisee add date | Timestamp |
| franchisee modify date | Timestamp |
| date | Date |
| store audits1452640683 | Text |
| address2 | Text |
| alt phone | Text |
| area ID | Text |
| business category | Text |
| business type | Text |
| common business name | Text |
| competitor | Text |
| contact first name | Text |
| contact last name | Text |
| contact title | Text |
| description | Text |
| email ID | Text |
| fax | Text |
| fbc | Text |
| fbcreference ID | Text |
| fim entity entity reference ID | Text |
| fim entity entity status | Text |
| fim entity fim cb country of formation | Text |
| fim entity fim cb entity type | Text |
| fim entity fim cb state of formation | Text |
| fim entity fim tt entity name | Text |
| fim entity fim tt taxpayer | Text |
| fim entity reference ID | Text |
| fim entity | Text |
| fim custom profile | Text |
| fim custom profile display name | Text |
| fim custom profile is mandatory | Text |
| fim custom profile reference ID | Text |
| fim custom profile user ID | Text |
| fim custom profile user name | Text |
| fim owner first name | Text |
| fim owner last name | Text |
| fim owner muid value | Text |
| fim owner owner title | Text |
| fim owner reference ID | Text |
| fim reference dates | Text |
| franchisee status | Text |
| grand store opening date | Text |
| key business person | Text |
| last attended | Text |
| last update | Text |
| latitude | Text |
| legal notice address | Text |
| legal notice city | Text |
| legal notice country | Text |
| legal notice email | Text |
| legal notice fax | Text |
| legal notice first name | Text |
| legal notice last name | Text |
| legal notice mobile | Text |
| legal notice phone | Text |
| legal notice phone extn | Text |
| legal notice state | Text |
| legal notice title | Text |
| legal notice zipcode | Text |
| license no | Text |
| lifecycle stage | Text |
| longitude | Text |
| mobile | Text |
| payment type | Text |
| phone1 | Text |
| phone1 extn | Text |
| report period start date | Text |
| service category | Text |
| social URL link title | Text |
| social URL link URL | Text |
| social URL reference ID | Text |
| store email | Text |
| store fax | Text |
| store hours closing time | Text |
| store hours opening time | Text |
| store hours operating day | Text |
| store hours reference ID | Text |
| store mobile | Text |
| store phone | Text |
| store phone extn | Text |
| store status | Text |
| store type ID | Text |
| store website | Text |
| tag line | Text |
| transaction type | Text |
| transfer date | Text |
| twitter search | Text |
| website | Text |
