Skip to main content

  Article updated: December 21, 2023

Create Facebook ad campaigns in bulk

You can use the 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 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 Hootsuite Ads. The parameters in the template are the same parameters you use when creating a campaign in Hootsuite Ads.

  1. On the Hootsuite Ads home page, select New campaign.
  2. In the How do you want to create your campaign?, select Aggregated campaign.
    How do you want to create your campaign with aggregated campaign selected.
  3. Select a campaign type (External Website or Local Awareness).
  4. Go to the Upload the Spreadsheet section and select Download the template spreadsheet.
    Upload the spreadsheet section with download the template spreadsheet link highlighted.
  5. 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.
  6. Enter variations for each parameter in a new row to create split tests for them.
    Example spreadsheet.
  7. 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

  1. In Hootsuite Ads, select New campaign, then a campaign name and select an ad account.
  2. In the How do you want to create your campaign? section, select Aggregated campaign.
  3. In the What do you want to promote? section, select your campaign type.
  4. Select Select your spreadsheet to upload your file, and then select Proceed.
    The import may take a minute to complete.
    How do you want to create your campaign with local awareness selected showing select your spreadsheet.
  5. If 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.
    Ads design with grayed out fields.
    If your spreadsheet included custom placeholders, click the aggregated file icon next to any fields that support placeholder content to insert one.
  6. In the Placement and Previews section, preview all the ad variations created from your uploaded spreadsheet.
  7. Proceed through the campaign builder to complete and publish your campaign.


Can't find what you're looking for? We're here to help