Article updated: December 21, 2023
Create Facebook ad campaigns in bulk
You can use the Legacy Hootsuite Ads aggregated campaign builder to create Facebook ad campaigns in bulk.
Upload a spreadsheet of ad creative and audience targeting combinations and let the builder create your ads and split testing variations for you. You can upload as many or as few parameters as you like, and add the remaining creative and targeting information in Legacy Hootsuite Ads as usual.
You can create aggregated campaigns for External Website and Local Awareness campaign types. Aggregated campaigns have the same limits as any other campaigns (50 ads per adset, and 250 ads in total).
Prepare an aggregated campaign asset spreadsheet
For your first aggregated campaign, download and fill in the sample template from Legacy Hootsuite Ads. The parameters in the template are the same parameters you use when creating a campaign in Legacy Hootsuite Ads.
- On the Legacy Hootsuite Ads home page, select New campaign.
- In the How do you want to create your campaign?, select Aggregated campaign.
- Select a campaign type (External Website or Local Awareness).
- Go to the Upload the Spreadsheet section and select Download the template spreadsheet.
- Enter the information for your ad creative and target audience. The template spreadsheet contains columns for all of the parameters available for your chosen campaign type. If you do not want to include a parameter, delete the heading from the spreadsheet.
The Call to Action and CTA Phone Number or CTA Address are required for Local Awareness campaigns. - Enter variations for each parameter in a new row to create split tests for them.
- Save the spreadsheet as an XLSX or CSV file (maximum 20 MB in size).
Custom parameters
You can include customer parameters for your ad campaign assets in your spreadsheet. Add any custom parameters to the first row, and all corresponding variable values in the rows below it. You can use these parameters as placeholder values in the creative fields of the campaign builder.
For example, by adding the custom parameter StoreName, with values LA Magic Burger and LA Big Burger, Hootsuite can insert these variations with a placeholder into creative fields like the Headline: Visit our store {StoreName}, and create two ad variations with the headlines: Visit our store LA Magic Burger and Visit our store LA Big Burger.
Create an aggregated campaign
- In Legacy Hootsuite Ads, select New campaign, then a campaign name and select an ad account.
- In the How do you want to create your campaign? section, select Aggregated campaign.
- In the What do you want to promote? section, select your campaign type.
- Select Select your spreadsheet to upload your file, and then select Proceed.
The import may take a minute to complete.
- If Legacy Hootsuite Ads detects any errors in the uploaded file, those parameters will be highlighted in red. Select Edit to view the explanation and fix the error before proceeding.
Empty parameter values in the spreadsheet may be identified as errors. To exclude a parameter, delete the heading from your spreadsheet, and upload the file again.
When Hootsuite uploads the aggregated parameters successfully, those fields are grayed out in the campaign builder and display Value from your preset combinations.
If your spreadsheet included custom placeholders, click the aggregated file icon next to any fields that support placeholder content to insert one. - In the Placement and Previews section, preview all the ad variations created from your uploaded spreadsheet.
- Proceed through the campaign builder to complete and publish your campaign.
Learn more
Can't find what you're looking for? We're here to help