A franchise dealer ad has two owners, and the trick is to stop them from editing the same pixels. The manufacturer owns the logo, the colors, the legal line and the end card. The dealer owns the name, the address, the phone number and this week’s offer. If you build the video so each owner can only touch their own layers, brand standards and local messaging stop fighting.
This article is for the person in the middle. You might run marketing for a dealer group, or work at the agency that builds spring service and inventory spots for a dozen rooftops. Somebody upstream sends a brand guide and somebody downstream wants their own phone number on the screen. You are the one who has to make both of them happy without re-cutting the same ad forty times.
Two kinds of content that should never share a layer
Start by sorting everything in the ad into two piles. This is general practice, not a Dataclay feature, and it is the step most teams skip.
The first pile is locked. It is the stuff that must look the same in every dealer’s version, because the manufacturer’s brand standards say so or because your own group has decided it should. Think of the logo lockup and its clear space, the brand colors, the typeface used for headlines, the music bed, the transition style, the end card layout and the required legal or disclosure line. Nobody at a dealership should be able to nudge any of it, and nobody should have to remember the rules, because the rules are already baked into the file.
The second pile is local. It is what makes the ad belong to one store. The dealer name, the street address, the phone number, the hours, the name of the service manager, a photo of the actual showroom, and the offer text for this month. Local content changes from row to row, and it changes more often than the locked content ever does.
The mistake is to treat the whole ad as one editable thing and then try to police it with a PDF of rules. A rules document works only as well as the least careful person who opens the project. A template works differently. It removes the choice. If the logo layer is not connected to any data, there is no field a dealer can type into that would change it.
There is a third pile worth naming, because it causes the most arguments. Some items are locked in form but vary in value. The legal line is the classic case. The wording might be fixed, but the state, the dates or the disclosure details change by market. Treat these as a controlled list. They live in the data, but only as a short set of approved values that someone with authority maintains, not as a free text box that a dealer fills in.
Once you have the three piles, you have the whole design brief for the template. The locked pile gets built into the After Effects project and never appears in a spreadsheet. The local pile becomes columns. The controlled pile becomes a lookup the dealer picks from, not something they type.
How the split works inside Templater
Templater is the After Effects plugin we make. A designer rigs a composition, which means they choose which layers will accept data and map each one to a column or key in a data source. Everything the designer does not rig stays exactly as drawn. That is the mechanism that does the policing for you.
Here is what a rigged dealer spot looks like in practice. The designer builds the master composition once, following the manufacturer’s guide. The logo, the background treatment, the lower-third styling and the end card are ordinary layers with no connection to data. Then the designer marks the layers that should change. The dealer name layer is mapped to a column. So are the address, the phone number, the offer line and the showroom photo. Templater lets you customize text, images, branding, graphic elements, colors and embedded footage, one layer or every layer, so the designer decides exactly where the line falls.
The data source is a spreadsheet. Templater has built-in integrations for Google Sheets, tab-separated value files, and JSON files or feeds. QUE, our JSON-based data tool, is built to work with it too. Each row is one dealer version. Fifty dealers means fifty rows, and every row becomes its own finished video.
Several features exist for exactly the problems a franchise ad runs into.
Layout rules. Dealer names are not the same length. “Smith Motors” and “Northeast Regional Auto Group of Springfield” will not fit the same box. Templater applies spatial layout rules, so dynamic layers adjust relative to their containing composition and sibling layers. You do not have to hand-align every version. The designer sets how a long name should behave once, and the logic runs on every row. This is worth testing with your longest and shortest real dealer names before anyone sees the template, because a layout rule is only as good as the extremes you tried it on.
Time Sculpting. If a dealer supplies their own clip, the footage will not be the same length as the placeholder. Templater’s patented Time Sculpting feature crops, trims, shifts and stretches layers by rule, so the rest of the design holds together while footage of different lengths goes in. For a manufacturer ad with a locked end card, this matters, because the end card has to arrive on time whether the local clip is five seconds or eight.
Switching projects from data. If your group works with more than one manufacturer, or one manufacturer supplies a truck template and a car template, you can keep the projects separate and let the data choose. Templater can switch between After Effects project templates on a per-row basis within the same data source. One sheet can drive a Brand A spot for one row and a Brand B spot for the next, each built to its own guide.
Output naming. You can set a custom output file name for each render job from inside the data source. For a group with a lot of stores that sounds minor until you are looking at forty files that all say “spring-service-final”. Put the store number or market in the name column and each file arrives labeled.
Text styling limits. One thing to know before you promise anything. A single text layer must use one font, one size, one weight and one style. You cannot mark up a dealer’s offer line so half of it is bold and half is not. The workaround is to position separate text layers side by side, each with its own attributes, and map each to its own column. If your brand standard wants a bold price inside a regular sentence, build it that way from the start.
If you do not have a designer with the time to rig a template from nothing, Autografs are worth a look. These are pre-built After Effects compositions that arrive already rigged with Templater, in categories that include automotive. They are a starting point, not a finished brand-compliant ad. Someone still has to bring the manufacturer’s guide to the file.
It helps to see one row end to end. Say the sheet has these columns: store number, dealer name, address, phone, offer line, showroom photo and output name. Row seven is a store in a smaller market. Templater reads the row, puts the dealer name into the name layer, the offer line into the offer layer and the photo into the footage layer, then applies the layout rules so the name sits inside its safe area. The output name column tells it to save the finished file under that store’s number. The logo, the end card and the legal line were never part of the row, so they come out identical to row one and row forty. Row eight might carry a different photo and a shorter name, and the same rules run again without anyone touching the project.
Notice what that gives your approver. They do not have to review the whole ad forty times with fresh eyes. They review the template once, which is where every brand decision lives, and then they review the data, which is where every local decision lives. Two review points replace forty, and each one is a smaller job. That is the real saving, more than the render time.
Where people still have to decide
A template guarantees that locked layers stay locked. It does not guarantee that a dealer types a sensible offer or that the manufacturer approves the result. Those are separate problems, and treating them as one is how teams end up with a beautiful system that nobody trusts.
Picture a group with twenty-two stores. The marketing lead builds the template, locks the brand layers and sends the sheet to each store manager to fill in. Within a day the sheet comes back with a phone number in three different formats, one offer line that is four times longer than the others, and a dealer name spelled with a different abbreviation than the one on the building. The brand standards were never violated. The data was still wrong.
So the sheet is where the discipline lives. A few habits help, and all of them are general practice.
Give the local fields a single owner. If twenty-two people can edit the sheet, you will get twenty-two styles. If a regional marketing person owns it and stores submit requests, you get one.
Keep the offer text short on purpose. The shorter the field, the less the layout has to absorb. Decide the longest line a template can carry and say so at the top of the sheet.
Use the controlled list for anything with legal weight. A dropdown of approved disclosures is easier to defend to the manufacturer than a free text cell that someone retyped from memory.
Then check the output. Templater lets you preview compositions with your data before you render or replicate. You step through the jobs and see how each row treats the text, the footage and the colors, which is where a too-long name or a missing photo shows itself. In the Pro and Bot editions you can also generate spot checks, which are stills or short clips of chosen frames from the data-merged compositions. Name the timeline markers for the frames you care about, such as the frame where the legal line is on screen and the end card, and Templater exports those. If you name none, it samples evenly across the duration. Spot checks are a fast way to send a manufacturer’s reviewer a handful of frames rather than fifty complete videos.
Which edition you need depends on who does what. Rig is for the artist who sets the project up. Pro lets you batch render or replicate the versions from your data. Bot watches the data source and starts renders without a person, which suits a group where stores request their own version through a form. Different people on your team may need different editions. You can read more about batching in our post on making hundreds of personalized videos from data.
There are honest limits here. Templater can only pull from one data source, and it maps to a single worksheet, so you cannot spread the dealer fields across three tabs. If your approval process requires a human at the manufacturer to sign off each local version, automation will speed up making the videos but it will not remove that review. And if each dealer wants truly different creative, a different story, a different structure, then a template is the wrong tool. A template is for one design with many versions. If you have many designs, you have many templates.
Human review also deserves its place for a reason beyond the rules. A study cited on our blog looked at automated news video and found that partly automated videos, which humans edited after the automation step, were liked about as much as human-made ones, while highly automated videos were liked significantly less. That was news video, not dealer advertising, so we would not stretch the finding. It does support the habit of having a person look at the output before it goes out. Our post on automated video with a human touch has the details.
For delivery, Projector renders several customized videos at once, based on the number of cores in the machine, and can send finished files on to Vimeo, JW Player, Frame.io or AWS S3. It works from Google Sheets or QUE. If your stores need to see a status for each job, QUE’s dashboard shows each job’s status and how busy the rendering machines are. Both are optional. A small group can run on Templater alone and a spreadsheet for a long time.
If you want to see the pieces in one place, start with Templater, read how QUE handles the data side, and use our licensing guide to match editions to roles. The learn section and the post on layout rules are the best next reads if long dealer names are your biggest worry.
The bottom line is simple. Brand standards and local messaging only collide when they share a layer. Lock what the manufacturer owns inside the template, put what the dealer owns in a controlled sheet, test the extremes, and keep a person looking at the output. You will not get zero review, and you should not want it. You will get a system where a dealer can change their phone number and cannot change the logo, which is the arrangement everyone was asking for in the first place.
Those are the pieces. Here are the questions dealer marketers ask us most when they start planning a shared template.
Frequently Asked Questions
Can a dealer change the logo or legal line if they have the spreadsheet?
No, as long as those layers are not mapped to a column. Templater only changes the layers a designer rigs to the data source. Anything left unrigged stays exactly as drawn, so there is no cell a dealer could type into that reaches it. If a legal line has to vary by market, make it a short list of approved values that one person maintains, and let dealers pick from it instead of typing their own wording.
What happens when a dealer name is much longer than the others?
Templater applies spatial layout rules, so dynamic layers adjust relative to their containing composition and neighboring layers. A designer sets how long text should behave once, and it runs on every row. Test the template with your longest and shortest real names before anyone sees it, because a layout rule is only as good as the extremes you tried it on. Preview the compositions with real data to catch the rest.
Can one sheet drive ads for more than one manufacturer?
Yes. Templater can switch between After Effects project templates on a per-row basis within the same data source. Each project is built to its own manufacturer’s guide, and a column in the row tells Templater which one to use. One thing to remember is that Templater pulls from a single data source and a single worksheet, so keep the fields for all brands in that one sheet.
Can I put part of an offer line in bold and the rest in regular type?
Not inside one text layer. A single text layer uses one font, size, weight and style, so Templater cannot mark up words within it. The partial workaround is to place separate text layers next to each other, give each its own attributes, and map each to its own column. If your brand standard requires a bold price inside a sentence, build the template that way from the start.
Do we still need manufacturer approval if the template is locked?
A locked template keeps the brand layers consistent, but it does not replace whatever approval process your manufacturer or group requires. Automation makes the versions faster to produce. It does not decide who signs off. Spot checks, which are stills or short clips of chosen frames from the merged compositions in Pro and Bot, give a reviewer a small set of frames to look at instead of every full video.
Which Templater edition does a dealer group need?
It depends on who does which job. Rig is for the artist who prepares the project and previews data. Pro adds batch rendering and replicating from a data source, and suits someone who starts each batch. Bot adds automatic processing when new data arrives and command line control, which suits stores requesting their own version through a form. Different people on your team may need different editions. The 30-day trial includes Bot features.