You make hundreds of video ad variations from one After Effects template by separating the design from the differences. The design lives in a single rigged project. The differences live in a spreadsheet, one row per ad, and Templater merges the two and renders or replicates every row.
That sounds simple, and the idea is. The work is in the setup. A template that was built for one ad will not survive a spreadsheet of three hundred rows unless you build it with the rows in mind. This guide covers how to plan the sheet, how to rig the template so it holds together when the copy changes, how to handle sizes and languages, how to name the files that come out, and where this approach is the wrong tool.
Start with the spreadsheet, not the timeline
Most people open After Effects first. Try opening a blank sheet first instead. Every ad variation is a combination of things that change, and the sheet is where you decide what those things are before you spend a day animating something that cannot flex.
Take a concrete case. A shoe retailer wants a short sale ad. The marketer has a list of products, each with a name, a photo, and a sale line. The retailer sells in more than one language. The media buyer wants the ad in a wide format for one placement and a tall format for another. None of this is exotic. It is simply the usual pile of requests that arrives the week before a campaign.
If you made these by hand, you would duplicate the project, swap the photo, retype the headline, change the language, resize the composition, export, rename the file, and repeat. Each step is easy. The count is what hurts. Every new product multiplies against every language and every size, so a short list of each becomes a long list of finished ads very quickly.
Now think of the same job as a table. Each row is one finished ad. Each column is one thing that changes. You might have a column for the product name, one for the photo, one for the sale line, one for the language, one for which template to use, and one for the file name. Templater treats each row of your data source as a separate render job, so the table is also the work order.
Be strict about what earns a column. If the same thing is true in every ad, keep it in the template and leave it out of the sheet. A logo that never moves does not need a column. A column should exist only when a human would otherwise have to open the project and change something. The shorter the sheet, the fewer ways it can go wrong.
Where the sheet can live
Templater reads Google Sheets, tab-separated files, and JSON files or feeds. It also works with QUE, our cloud data source built around JSON. For most marketing teams the choice is easy. Use Google Sheets if several people write copy, because everyone can edit the same file and Templater previews the data straight from it. Use a tab-separated file if the data comes out of a database export.
A note on Excel, since people ask. Templater cannot read an Excel file directly. Export it to a tab-delimited file first, or paste it into a Google Sheet. We also have a post on the data sources we have tested with Templater if you want to compare them before you commit.
Two limits are worth knowing now, because they shape how you lay out the sheet. Templater maps to one worksheet and one data source at a time, so you cannot spread a campaign across several tabs and expect it to merge them. Put everything for the batch on a single tab. And a single text layer takes one font, one size, one weight, and one style, so a headline with one bold word in the middle needs two layers, not one marked-up string.
Where the translations come from
Localization is usually the column that slows a campaign down, because it depends on other people. Your translator hands back a document, someone pastes it into place, and a typo slips in. Putting the translated copy in the same sheet keeps it from drifting. Each language is a row, or each language is a pair of columns your template reads, whichever fits how you think.
Templater accepts characters from any language in the spreadsheet, and it reads the text as it appears, so commas, quotes, apostrophes, and line breaks come through. Right-to-left scripts are supported as well. The one thing you must check is the font. Installed fonts need the glyphs for the language, or the text will not draw correctly. A typeface that looks wonderful in English may have nothing to offer a different alphabet. Test every language against the font before you commit to the design.
Templater can also control the font face and text direction from the data source, which matters if one language needs a different typeface or runs the other way. Our localization walkthrough goes through the setup for multilingual batches in more detail.
If your team likes to start from machine translation, a Google Sheet can pull in data from Google’s translation service, so a first pass can fill the cells automatically. Treat it as a first pass. A person who reads the language should look at it before anything goes out, because an ad is a promise made in public.
Rig the template so copy can change without breaking it
Rigging is the step where you tell Templater which layers in your project are dynamic and which columns feed them. You map your data to composition layers, and then you preview how those layers change as each row is processed. Text, images, brand colors, graphic elements, and embedded footage can all be driven this way. You can control one layer or every layer.
The preview matters more than it first seems. Templater lets you step through your render jobs with the data merged in, so you see how each row treats the text, the footage, and the colors before anything renders. This is where you find the product name that is twice as long as the others, the photo with a dark corner that swallows a white logo, and the cell somebody left blank. Fixing those in the sheet takes seconds. Finding them after four hundred renders takes an afternoon.
Let the layout rules do the nudging
Here is the practical problem with variable copy. A headline of two words fits one way, and a headline of nine words fits another. If you built the design around the short version, the long one runs into the logo. If you build it by hand each time, you are back to doing the work Templater was supposed to remove.
Spatial layout rules exist for exactly this. When Templater updates a composition with your data, it adjusts the dynamic layers relative to their containing composition and to the sibling layers around them. You set the relationships once, such as a price tag that always sits below the product name, and Templater keeps them true as the text changes length. Our write-up on layout rules shows how the rules are set up.
Layout rules do not replace design judgment. They keep a design intact when the content moves, but they cannot invent a layout that was never sound. Give the text a generous box. Decide in advance what the longest acceptable headline is, and tell your copywriters. The best-behaved templates we see have a clear rule on the sheet itself, even something as plain as a note in the header row.
Video layers have the same problem in the time dimension. If one product comes with a five second clip and another with a longer one, a fixed timeline either cuts the long one or leaves dead air on the short one. Time Sculpting, our patented feature, crops, trims, shifts, and stretches layers by rule, so the design holds its shape when the footage lengths differ. If your ads carry product clips and not just stills, this is the feature to learn first.
Sizes: one template per shape
Aspect ratio is the part where honesty helps. A wide composition and a tall composition are two different layouts. Elements that sit side by side in one will stack in the other. A layout rule can keep a price below a name, but it will not decide that a wide design should become a tall one. Plan on a master composition for each shape, designed on purpose.
Templater gives you a clean way to run them together. It can switch projects from data, so if you have two or more template project files that use the same data, a column in your sheet can choose which one a given row uses. One sheet then drives a wide project and a tall project at once. The copy stays in one place, the layouts stay separate, and a change to a sale line is made once.
Whether you keep sizes as separate project files or as separate master compositions inside one project is a matter of taste and project size. Separate files make it easier for two artists to work at the same time. A single file is simpler to hand over. Pick the one your team will actually keep tidy.
Flags and the small switches
Real campaigns always have exceptions. One product gets a badge and the rest do not. One market needs a legal line and the others do not. Our post on using flags in Templater data sources covers how to carry switches like these in the sheet, so exceptions are a cell in a row and not a separate copy of the project. Read it before you design the sheet, because it changes how many columns you end up needing.
Who builds what
Somebody has to build the template in After Effects, and that is a motion designer’s job. Templater does not design for you. If you do not have that person, our Autografs are pre-built compositions already rigged with Templater, and we offer custom development for teams that want us to build the rig. The marketer’s role is the sheet and the copy. The designer’s role is the template and the rules. Keeping those two roles apart is a large part of why the approach scales.
The editions follow the same split. Rig is for the person setting up the project. It maps data to layers and previews the result, and it renders single jobs using After Effects’ built-in options. Rig cannot batch output. Pro adds batch render and batch replicate, so it suits whoever starts the large runs. Bot adds the automated side, such as checking for new data and starting renders without a person at the keyboard. A team often mixes them. A designer on Rig can test the template against the real sheet while the producer on Pro runs the batch.
Render, replicate, name, and check
With the sheet written and the template rigged, you have two ways to produce the ads. Render takes each row and exports a finished file. Replicate takes the project, inserts the data, and saves a version of the composition for each row, kept in a tidy folder structure. You can then send the replicated compositions to the After Effects render queue or to Adobe Media Encoder.
Replicate is the better choice when you want to touch a few of the results by hand before rendering. Maybe one ad needs a custom flourish for a key product. Replicate lets you open that single composition, adjust it, and render the whole set afterward. Media Encoder is also how you get output codecs that After Effects does not include. In the Templater panel it is a checkbox that swaps Render for Replicate. Both functions are in Pro and Bot. Rig does not have either. Our guide to batch rendering in After Effects goes deeper on the choice.
Name the files before you need them
Three hundred files called “final” are no use to anybody. Templater lets you set a custom output file name for each render job or replicated composition from within your data source. That turns naming into another column. Build the name from the pieces that identify the ad, such as the product, the language, and the size, so that anyone can sort the output folder and find what they need without opening a file.
Decide the pattern with the people who will receive the files. If your media buyer uploads by placement, put the size first. If your localization lead reviews by language, put the language first. A good name saves more time than most rendering optimizations, and it is free.
Check before you commit the machine
Before the full run, check a sample. Templater’s spot checks export stills or short clips from individual frames of the data-merged compositions, in Pro and Bot. Name your timeline markers to choose which frames to capture. If you do not set markers, Templater samples frames at even intervals across the composition. A contact sheet of spot checks across the whole batch shows you the clipped words and the empty slots at a glance. We cover the feature in our spot checks post.
If you see a render queue item fail with “Failed at N/A,” After Effects did not find an asset, a clip, or a font where the project expected it. The usual cause is that files were moved or deleted. Keep references to your assets stored in the project, and keep the footage folder where the project can find it. Project presets can hold the data source, the footage folder, and the output folder inside the project file, so a teammate who opens it starts from the same settings.
Estimating time
Do not guess how long a big batch will take. Render one video, or a small batch, on a machine comparable to the one you will use. Make that video similar to the rest. Multiply the time by the number of videos. That is a fair estimate for a sequential queue. Length, resolution, hardware, the ratio of dynamic frames to static ones, and how heavy your effects are all change the answer, which is why measuring one real render beats any rule of thumb we could give you.
For large runs you can spread the work. Several machines running Templater Bot in parallel cut the time to half with two, to a third with three, and so on. Projector is our rendering and distribution app. It uses the After Effects engine in parallel, based on the number of cores in your machine, and it can transcode and send the finished files to destinations such as Vimeo or AWS S3.
The template itself also affects the clock. Templater evaluates every layer in your project, so delete unused layers, effects, and compositions. If a layer is scaled far down, pre-compose it and crop it to the size that shows. A lean template renders faster on every row, and the savings multiply by the size of the batch.
When the sheet keeps changing
Some campaigns are finished once. Others never are. A retailer that adds products every week, or a team that takes requests through a form, needs the ads to appear as the data arrives. Bot checks for incoming data and starts the renders on its own. It also has a command line interface, and it can process extremely large data sets. If the data is coming from other software, QUE gives you a cloud JSON data source with an API, and you do not need to know JSON to use its dashboard.
Where this approach is the wrong choice
It is worth saying plainly when you should not do this.
If you only need a handful of versions, the setup costs more than the saving. Rigging a template and building a sheet is real work. Below a certain number of ads, you will finish sooner by duplicating the project and editing it. Templater Rig can render single jobs, so even a small amount of data-driven work is possible, but you should not build a pipeline around ten ads.
If every ad needs a fresh creative idea, a template is the wrong shape. This method is built for variations on a fixed design. It is not a way to generate new concepts. The motion designer still decides what the ad is. The spreadsheet decides which version of it each person sees.
If you do not use After Effects, other tools make sense. Some platforms build videos from templates in a browser editor and send them to a cloud renderer, and for a team with no After Effects skills that can be the faster road. Plainly, for example, runs After Effects templates on cloud infrastructure, and Creatomate builds templates in its own online editor. See their sites and pricing pages for what they offer. We built Templater for people who already work in After Effects and want to keep their craft and their own machines. If that is you, it fits. If it is not, one of those may fit better.
If your rows are not clean, automation will make the mess faster. A sheet full of inconsistent copy produces hundreds of inconsistent ads. The preview step catches a lot, but it cannot fix a bad brief.
The short version of the bottom line
One template and one sheet can produce hundreds of ad variations, and the quality depends on three decisions made early. Write the sheet around the things that really change. Rig the template with layout rules, Time Sculpting, and a master design for each shape so it bends without breaking. And put the file name in the data so you can find everything afterward. Build that foundation, preview before you render, spot check before you trust the batch, and the hundredth ad costs you almost nothing more than the first. If you are making a few versions, skip all of it and export by hand. If you are making a few hundred, this is the way to do it, and the Dataclay learning pages are the place to start.
We cover the questions people ask us most about this setup below.
Frequently Asked Questions
What do I need to make video ad variations from one After Effects template?
You need After Effects, a template built in it, a data source with one row per ad, and Templater. Pro lets you batch render or batch replicate, and Bot adds automation for data that keeps arriving. Rig is the entry edition for rigging and previewing. Someone has to build the template, and our Autografs are pre-built compositions already rigged with Templater if you would rather not start from scratch.
Can I make different sizes of the same ad from one spreadsheet?
Yes, with separate layouts for each shape. A wide ad and a tall ad are different designs, so plan a master for each. Templater can switch projects from data, so a column in your sheet can choose which template project a row uses. One sheet then drives every size. The copy is written once and each layout stays designed on purpose.
How do I handle several languages in one batch?
Put the translated copy in the same data source and have each row carry its language. Templater accepts characters from any language and supports right-to-left scripts. Check that your installed fonts include the glyphs for each language. Templater can also control font face and text direction from the data, which helps when one language needs a different typeface than the rest.
What happens when one headline is much longer than the others?
Spatial layout rules adjust dynamic layers relative to their composition and to nearby layers, so related elements stay in their intended positions as text changes length. They cannot fix a design with no room for the copy. Give the text a generous box, decide the longest acceptable headline up front, and use the preview to step through every row before rendering.
How do I name hundreds of output files?
Add a column to your data source and set the custom output file name for each render job or replicated composition from there. Build the name from the facts that identify the ad, such as product, language, and size. Agree on the order with the people who receive the files, so sorting the folder gives each of them what they need.
Should I render directly or replicate first?
Render when you trust the template and want finished files. Replicate when you want to adjust a few compositions by hand first, or when you need an output codec After Effects does not include, since Replicate can hand the versions to Adobe Media Encoder. Both are in Pro and Bot. Rig has neither, so check your edition before you plan the run.
How long will a large batch of ad variations take?
Render one video, or a small batch, on a machine comparable to your production one, then multiply by the number of videos. Length, resolution, hardware, effect weight, and how the template is built all change the result. Running Bot on two machines halves the total, and three machines cut it to a third. Removing unused layers from the template also helps.
Can I try this before I buy?
Yes. Templater has a 30-day free trial, and the trial is a fully featured Bot, so every button is available while you test. If you later buy Rig, the Render and Replicate functions will not be there, so choose your edition with that in mind. Build a small sheet of real rows and run it through the preview and a spot check first.
