Integrations
FranConnect datasets and fields
The 3 datasets Maven lands from FranConnect, every field in them, and how the connection syncs.
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.
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 |