# 220+ dealers. 10,500+ vehicles. Live on Google every day.

> Hundreds of dealer feeds in different formats, cleaned into one inventory model and published to Google automatically.

Canonical: https://datakeelai.com/case-studies/dealer-inventory-google-vehicle-ads/
Updated: 2026-11-03

Industry: Automotive · Service: Data integration

One ingestion platform turned every dealer's stock feed, whatever its format, into accurate Google Vehicle Ads, refreshed twice a day.

## Before

Every dealer sent stock differently: a web link, a file uploaded to our SFTP, or files we had to collect from theirs. Each used its own column names, and key details like registration dates were often missing. Onboarding a new dealer was slow and messy, and keeping Google Merchant Center accurate got harder as the dealer list grew.

## What we built

One ingestion platform that accepts every format (CSV, XML, JSON, APIs, webhooks, SFTP) and turns it into a single inventory model. It matches each dealer correctly, fills in missing details through an API, applies business rules automatically (minimum stock, custom labels, finance pricing) and publishes to Google Vehicle Ads through the Merchant API. Every dealer refreshes twice a day.

## What we found

The hard part wasn't volume. It was variety: the same field had many different names, and important details were often missing. Fixing that once, in one model, made every new dealer easier.

## After

- 10,500+ vehicles from 220+ dealers live on Google every day.
- Dealers' ads match their real stock, refreshed automatically twice a day.
- New dealers plug into the same model instead of needing a custom build.

## In numbers

- 220+ dealers live on Google
- 10,500+ vehicles live on Google every day
- 2× a day, every dealer’s stock refreshed

## Stack

- Azure Data Factory
- Azure Functions
- .NET
- Google Merchant API
- Auto Trader API
