/
/
Find incomplete Geotab customer records in one pass
For teams who keep Geotab MyAdmin customer data clean for billing and support.
On this page
Connector
Connect Geotab MyAdmin, pick your AI tool and paste the prompt.
The problem
Customer records drift until an invoice bounces
Customer records in MyAdmin drift: a contact with no email, a missing tax id, an address without a country, the same company entered twice. Nobody checks until an invoice bounces or the wrong account gets the call.
Without PopdockAI
- Export customer records from MyAdmin
- Scan for blank emails, phones and tax ids
- Compare company names for near duplicates
- Fix problems only when something fails
With PopdockAI
- Customer records are read, active only by default
- Each is checked for missing contacts, address parts and tax id
- Near duplicate legal names are flagged
- Counts and a per account table are reported, and nothing is edited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Audit customer records (only active ones unless {active-only} is false; limited to country {country} if given) and list the ones with missing or inconsistent details.
**Step 1: Pull customers**
Call `geotab-myadmin-get-customer` with active = true (unless {active-only} is false) and, if given, country = {country}. Use max-records 500.
**Step 2: Check each record**
Flag a customer when:
* primary contact email or phone is empty
* primary contact first or last name is empty
* city, state or country is empty
* tax ID is empty
* legal name is empty or differs from company name only by case or punctuation (likely duplicate entry)
**Step 3: Report**
Counts per rule, then a table: account, company name, issues found. Also list customers whose company names look like duplicates of each other.
**Rules & Guidelines:**
* This is a read-only job. Do NOT call any write tool: no `geotab-myadmin-change-device-billing-plan`, `geotab-myadmin-terminate-device-billing`, `geotab-myadmin-share-device`, `geotab-myadmin-update-device-contracts`, `geotab-myadmin-enroll-device-from-add-in`, `geotab-myadmin-unenroll-device-from-add-in` or any other action tool.
* Do not call `geotab-myadmin-add-edit-customer`; use the `update-customer-record` prompt to fix records.
**Validation:**
* If the read hits max-records, say the audit is partial.Who it's for
One answer, three teams that use it
Reseller operations
Clean up customer records
A table of accounts and their issues gives you a clear clean up list.
Audit all active Geotab customers for missing contact emails and tax ids.
Billing teams
Stop invoices bouncing
Customers with no contact email or address country are flagged before the next invoice run.
Which Geotab customers in the United States are missing a billing contact email or address?
Account managers
Find duplicate customer accounts
Legal names that differ only by case or punctuation are listed as likely duplicates.
Are there any likely duplicate Geotab customer accounts, including inactive ones?
How it works
What PopdockAI does when you ask
You choose active or all customers and optionally a country, and your AI assistant runs every data quality rule. It never edits a customer.
01
Ask
You choose active customers or all, and optionally a country.
02
Read
It pulls the customer records.
03
Check
It applies each data quality rule to every record.
04
Report
You get counts, the issues per account and likely duplicates.
What PopdockAI provides
The tools behind the answer
Ready made tools for Geotab MyAdmin and one secure connection to your AI tool. No code, no exports.
geotab-myadmin-get-customer
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Incomplete and duplicate customers in one pass
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
