← Back to Queue

AutoMax Pre-Owned

unknown

Dealership Info

Fortellis Connection

Dealer Group:Capitol Auto Group
Subscription ID:sim-sub-004
Connection ID:sim-conn-004
Fortellis Org:sim-org-004
Connection Status:pending
Departments:[{"id":"D_SIM_AM_004","name":"Used-FI","dmsType":"Finance"}]
Connected:Apr 16, 2026, 10:21 PM
Sync Schedule:manual_only
Subscription Created:

Onboarding Actions

2. House Account:
3. History Dump:
4. Analysis:
5. Sync Schedule:
6. Go Live:

Scrub Data (1646 deals)

Deal Summary

SourceStatusDeal TypeSale TypeCount
fi_v4_bulkDUsedFinance32
fi_v4_bulkFUsedFinance73
fi_v4_bulkFUsedCash11
fi_v4_bulkBUsedFinance23
fi_v4_bulkDUsedCash8
fi_v4_bulkUUsedFinance2
fi_v4_bulkPUsedFinance20
fi_v4_bulkBUsedCash4
fi_v4_bulkUUsedCash2
fi_v4_bulkPUsedCash2
fi_v3_history_p1FUsedFinance604
fi_v3_history_p1FUsedCash165
fi_v3_history_p2FUsedCash9
fi_v3_history_p2FUsedFinance45

Dealer Profile Report

════════════════════════════════════════════════════════════
  DEALER PROFILE: AutoMax Pre-Owned
  ID: e6b79ce7-24a6-4250-9639-47675ba019fd
  Total Deals Analyzed: 1,000
════════════════════════════════════════════════════════════

  F&I PRODUCTS SOLD
────────────────────────────────────────────────────────────
  Vehicle Service Contract
    CDK Location: Insurance Slot 1 (insurance.insurance1.name)
    Penetration:  58.5% of deals
    Avg Retail:   $2,409.49  |  Avg Cost: $505.24  |  Avg Income: $1,904.25

  GAP Insurance
    CDK Location: Insurance Slot 2 (insurance.insurance2.name)
    Penetration:  51.3% of deals
    Avg Retail:   $852.61  |  Avg Cost: $247.89  |  Avg Income: $604.72

  Wheel & Tire Protection
    CDK Location: Insurance Slot 3 (insurance.insurance3.name)
    Penetration:  27.5% of deals
    Avg Retail:   $696.23  |  Avg Cost: $151.83  |  Avg Income: $544.39

  MBI
    CDK Location: MBI (insurance.mbi.name)
    Penetration:  55.5% of deals
    Avg Retail:   $2,127.21  |  Avg Cost: $646.15  |  Avg Income: $1,481.06

  Doc Fee
    CDK Location: Fee Option Slot 0 (fees.feeOption[0])
    Penetration:  100% of deals
    Fixed Amount:  $699  |  Fixed Cost: N/A

  Reconditioning Fee
    CDK Location: Fee Option Slot 1 (fees.feeOption[1])
    Penetration:  90.1% of deals
    Avg Amount:  $1,745.32  |  Fixed Cost: $800


  FINANCE INSTITUTIONS / LENDERS
────────────────────────────────────────────────────────────
  Capital One Auto
    212 deals (27% of financed)
  Ally Financial
    149 deals (19% of financed)
  Metro Credit Union
    145 deals (18% of financed)
  First Investors Financial
    81 deals (10% of financed)
  DT Acceptance
    76 deals (10% of financed)
  Westlake Financial
    75 deals (9% of financed)
  Chase Auto Finance
    61 deals (8% of financed)
    Total financed: 799 of 1000 deals (79.9%)


  LEAD SOURCES
────────────────────────────────────────────────────────────
  Internet: 471 deals (47%)
  Walk-In: 317 deals (32%)
  Referral: 147 deals (15%)
  Repeat: 65 deals (7%)


  DEALER-DEFINED FIELDS
────────────────────────────────────────────────────────────
  dealerDefined1: categorical (100% populated, 3 distinct)
    Values: AUCTION, WHOLESALE, RETAIL
  dealerDefined6: calculated_amount (100% populated, 949 distinct)
    Values: 1019, 5312, 4671, 5486, 7427, 7433, 1311, 7567, 4387, 2172
  dealerDefined7: categorical (100% populated, 3 distinct)
    Values: CLEAN, ROUGH, AVG


  AUXILIARY FIELDS (fiAux) IN USE
────────────────────────────────────────────────────────────
  fiAux6: currency, avg $95.71, range $1.27 – $179.88 (90.7% of deals)
  fiAux5: currency, avg $2,582.03, range $200.97 – $4,998.19 (84.7% of deals)


  WE-OWE ACTIVITY
────────────────────────────────────────────────────────────
  Front we-owes: 145 deals with charges
  Back we-owes:  38 deals with charges

════════════════════════════════════════════════════════════
  Report generated: 2026-04-16T23:40:43.494Z
════════════════════════════════════════════════════════════
Field Usage (45 fields)
FieldCategoryUsage %ClassHint
weOwes.frontWeOweswe_owe100.0%calculated_amount
deal.dealerDefined1dealer_defined100.0%categorical
deal.dealerDefined6dealer_defined100.0%calculated_amount
deal.dealerDefined7dealer_defined100.0%categorical
deal.dealSourcedeal_source100.0%lead_source
deal.paymentStyledeal_meta100.0%categorical
fees.feeOption[0].namefee_option100.0%fixed_defaultDoc Fee
fees.feeOption[0].amountfee_option100.0%fixed_default
fees.feeOption[0].costAmountfee_option100.0%fixed_default
fees.feeOption[0].profitTypefee_option100.0%fixed_default
weOwes.backWeOweswe_owe100.0%calculated_amount
dealAuxiliary.fiAux6aux90.7%calculated_amount
fees.feeOption[1].namefee_option90.1%fixed_defaultReconditioning Fee
fees.feeOption[1].amountfee_option90.1%calculated_amount
fees.feeOption[1].costAmountfee_option90.1%fixed_default
fees.feeOption[1].profitTypefee_option90.1%fixed_default
dealAuxiliary.fiAux5aux84.7%calculated_amount
deal.financeSourcefinance_institution79.9%active_lender_slotCapital One Auto
deal.lienHolderNamefinance_institution79.9%active_lender_slotCapital One Auto
insurance.insurance1.costinsurance58.5%calculated_amount
insurance.insurance1.feeinsurance58.5%calculated_amount
insurance.insurance1.incomeinsurance58.5%calculated_amount
insurance.insurance1.nameinsurance58.5%active_product_slotVehicle Service Contract
insurance.mbi.incomeinsurance55.5%calculated_amount
insurance.mbi.nameinsurance55.5%active_product_slotMechanical Breakdown Insurance
insurance.mbi.costinsurance55.5%calculated_amount
insurance.mbi.feeinsurance55.5%calculated_amount
insurance.mbi.purchaseCostinsurance55.5%calculated_amount
insurance.insurance2.costinsurance51.3%calculated_amount
insurance.insurance2.nameinsurance51.3%active_product_slotGAP Insurance
insurance.insurance2.feeinsurance51.3%calculated_amount
insurance.insurance2.incomeinsurance51.3%calculated_amount
insurance.insurance3.feeinsurance27.5%calculated_amount
insurance.insurance3.incomeinsurance27.5%calculated_amount
insurance.insurance3.nameinsurance27.5%active_product_slotWheel & Tire Protection
insurance.insurance3.costinsurance27.5%calculated_amount
weOwes.weOweSaleHardTotalwe_owe14.5%occasional
weOwes.frontWeOwesGrossCostwe_owe14.5%occasional
weOwes.weOweSaleSoftTotalwe_owe14.5%occasional
weOwes.frontWeOwesGrossSaleswe_owe14.5%occasional
weOwes.weOweBackCostTotalwe_owe14.5%occasional
weOwes.weOweBackSaleTotalwe_owe14.5%occasional
weOwes.weOweFrontGrossSaleswe_owe14.5%occasional
weOwes.weOweResidualTableTotalwe_owe14.5%occasional
weOwes.weOweResidualTotalwe_owe14.5%occasional

Employee Mapping (12 employees)

12 unmapped employees
CDK #NameRole HintDealsAction
400401Lorraine Eatonclosing_manager1000
400301Grant Pearsonsales_manager1000
400201Carl Hendersonfi_manager600
400202Rita Alvarezfi_manager400
400101Victor Delgadosalesperson244
400102Tanya Marshallsalesperson193
400103Jerome Bankssalesperson170
400104Crystal Webbsalesperson160
400105Marcus Pricesalesperson106
400106Vanessa Ruizsalesperson93
400107Derek Simmonssalesperson93
400108Monica Sharpsalesperson82

Onboarding Template

Loading template...

Recent Sync Logs

TypeStatusFetchedInsertedUpdatedStartedError
onboarding_fi_v3_history_p2success7007000Apr 16, 2026, 11:39 PM
onboarding_fi_v3_history_p1success7697690Apr 16, 2026, 11:38 PM
onboarding_bulksuccess1771770Apr 16, 2026, 11:37 PM