How to Bulk Import Ads

Updated 

Use the Ads Manager to bulk import ads and upload spreadsheets containing information on campaigns, ad set, and ad information.

Importing ad and campaign-related information is an effective way to speed up your campaign process and lets you run a large number of ads within a short period. This feature is highly convenient if you are managing large sets of assets and creatives.

Bulk Import is a direct response tool to increase return on ad spend (ROAS) in a time-efficient manner. It enables you to deliver the best results for your campaigns by testing multiple variations of creatives, audiences, and placements. It also allows you to scale the best-performing variation and gain better control of your campaigns.

In this article, we will guide you through the two different ways in which you can perform Bulk Import.

Use Cases of Ads Manager Bulk Import

Note:

Use of this feature requires that Sprinklr Marketing (Ads) be enabled in your environment. To learn more about Sprinklr Marketing (Ads), please work with your Success Manager.

How Bulk Import adds value

  • Efficiently set up campaigns and save time with the import sheet serving as a single source of truth across multiple teams for reviewing, approving, and publishing your campaigns.

  • Bulk Import has simplified creative and audience optimizations, allowing you to effortlessly scale the best performing variation across vast volumes of campaigns.

  • Bulk Import improves productivity for advertisers by allowing them to create ads using a single workflow and therefore avoiding further configurations. For example, Twitter Cards.

  • Bulk Import serves as a single touchpoint to manage the custom-defined properties for all your campaigns, allowing you to efficiently tag ads.

Learn more about the bulk import capabilities in Bulk Import: Enhancements.

To bulk import using standard templates

  1. Click the New Tab icon. Under the Sprinklr Marketing (Ads) tab, click Ads Manager within Analyze.

  2. Click the Options icon in the top right corner of the Ads Manager window and select Download Import Template.

  3. On the Bulk Import Template pop-up window, select the fields specific to which you want your Bulk Import standard template. For more information, see Bulk Import Template Options.

  4. Once you have provided the details, click Download Import Template in the bottom-right corner. You can then save the import template in your system.

  5. In the Bulk Import Template, provide all the campaign details that you want to import in bulk.

  6. Once you have updated the template with the campaign details, navigate to the Bulk Import window and click Upload to upload the updated file back into Sprinklr. For more information, see Upload Bulk Import Templates.

Bulk import template options

Terms
Description

Import Type

Select an import type from the following:

  • Ads

  • Partial Update

  • Creatives

  • Post

  • Twitter Cards

  • Keywords

  • Video

  • Business Location

Note — Partial Update:

Partial Update can be used to edit existing Ads as well as create new Ad Variants. However, you would need an entity ID to make any partial update.

Each row in an Ads Manager export file represents an Ad Variant.

  • If you select Partial Update and only update the custom fields, it will only edit those existing ad variant properties and not create any new Ads. This behavior is the same as editing an ad variant in Ads Manager.

  • However, if the change you are making involves the channel post details (i.e. URL or Headline), it will publish a new Outbound Post attached to that ad variant.

Using Partial Update, you can build new ads and/or outbound posts depending on what columns are filled out in your bulk import file.

  • Example - where Partial Update will publish a new Outbound Post

    Changing a URL or post Headline will keep the ad variant and ad structure the same but the channel will create a new Outbound Post Copy with the new changes that will be associated with the same parent ad variant.

  • Example - where Partial Update will publish a new Ad Variant and Outbound Post

    Copying an existing ad variant row but deleting/leaving the ad variant Name and ID cells empty.

Channel

Select a channel from the drop-down menu based on your import type. The available channels are Facebook, Twitter, LinkedIn, Pinterest, Snapchat, LINE, TikTok, Nextdoor, and Google.

The channels may vary based on your selected Import Type. For more information on the channels available for each import type, see Import Options.

Objective

Select one or more objective(s) for which you want the curated bulk import template.

Post Type

(only available for Facebook)

Select a post type option from the following for which you want the curated Facebook bulk import template:

  • All Posts (with PAC and Language Customization)

  • All Posts (without PAC and Language Customization)

To bulk import using exported templates

  1. Click the New Tab icon. Under the Sprinklr Marketing (Ads) tab, click Ads Manager within Analyze.

  2. Select the desired campaigns from the Ads Manager window.

  3. Hover over the Options icon in the top dashboard bar and select Export.

  4. On the Export Settings window, select Bulk Import Templates under Select Columns in Export Data Form.

  5. Select your campaign creation use case from the Select the Bulk Import use-case for which you want the columns to be exported drop-down menu. This will provide you with curated export sheets to configure your campaigns. For more information, see Bulk Import Templates — Descriptions.

  6. Click Export from the bottom to initiate the export.

  7. Once you have updated the export sheet with the campaign details, navigate to the Bulk Import window and click Upload to upload the updated file back into Sprinklr. For more information, see Upload Bulk Import Templates.

Bulk Import Templates — Descriptions

Note:

While importing the corresponding Bulk Import sheets using the Import workflow, note the following:

  • For the first option (Creating New Paid Initiiatives), you will need to use the full Ads workflow.

  • For the remaining three options, you will need to use the Partial Ads workflow.

Term
Description

Creating New Campaigns similar to filtered entities

All the relevant fields corresponding to the new Campaign creation will be exported in the template.

Additionally, you can choose to include columns for advanced features such as DCM, PAC, Language Customization, and Dynamic Creatives in the exported template.

Creating New Ad Sets under filtered Campaigns

As the Campaign is pre-built, only the Ad Set and Ad Variant level fields corresponding to the new Ad Set creation will be exported in the template along with the Campaign ID.

Additionally, you can choose to include columns for advanced features such as DCM, PAC, Language Customization, and Dynamic Creatives in the exported template.

Note:

If you are using both Targeting ID as well as creating new target fields for the above two options, then it will use the targeting ID to select from the existing target audiences.

Creating New Ads under filtered Ad Sets

As the Campaign and Ad Set are pre-built, only the Ad Variant level fields corresponding to new Ad creation will be exported in the template along with the Campaign ID and Ad Set ID.

Additionally, you can choose to include columns for advanced features such as DCM, PAC, Language Customization, and Dynamic Creatives in the exported template.

Note:

If you are using both Story ID and new Creative fields for the above option, then it will prioritize the Story ID and create the Ad from an existing creative.

Modifying the existing campaigns (Partial update)

You can custom select the fields that would want to modify for existing campaigns. All the dependent columns for your desired fields will be automatically exported.

Click Add Custom Columns to customize your column export template.

Note:

For Google Ads, you can only select the Modifying the existing campaigns (Partial update) use case.

Advanced Configuration

Advanced Capabilities

Select from the following Advanced Capabilities for which you want the columns to be exported:

  • Language Asset Customization

  • Double Click Tracking

  • Dynamic Creative

  • Carousel Ads

  • Dynamic Product Ads

  • Placement Asset Customization

  • LinkedIn Carousel Ads

  • Facebook Carousel Ads

  • Snapchat Story Tiles

To upload bulk import templates

On bulk importing ads for Facebook, you can input city along with the country code to avoid confusion or error. The system will pick the cities based on the country code mentioned in the import sheet.

For example:

  • “Delhi” - System will pic any Delhi

  • “Delhi C:IN” - System will pic India -Delhi

  • “Delhi C:IN; Mumbai; London C:UK” - System will pic, India - Delhi, Mumbai (Auto), UK London

Note: System will automatically select a country if no country code is specified.

  1. Click the New Tab icon. Under the Sprinklr Marketing (Ads) tab, click Ads Manager within Analyze.

  2. Click the Options icon in the top right corner of the Ads Manager window and select Import.

  3. On the Bulk Import window, select an option you would like to import from the Import drop-down menu. For more information, see Import Options.

  4. Select the Channel for which you would like to import based on the bulk import template.

  5. Click Upload to upload the updated bulk import file with the asset details from your system.

  6. In the Import Images/Video section, you can upload your images/videos from a Zip file by simply clicking Upload. You can also drag and drop your Zip file here. This will create the Image or Video ads in bulk as per the details given in the bulk import file.

  7. Click Advanced Configuration to further configure your import using the following options:

    Auto-play Ads on Import

    Check this box to set the Ads live on import. This option ensures that Ads don't go live unintended.

    If the bulk import file is imported with this option unchecked, the Ads created via bulk will get uploaded in the draft state irrespective of the status you have set.

    Set Naming Convention

    Select a Naming Convention for your Ads from the drop-down menu.

    This will dynamically generate the names for different entities based on the provided placeholders. You can define new Naming Conventions within Ad Settings.

    Set Audience Naming Convention

    Select a Naming Convention for your Audience from the drop-down menu.

    This will dynamically generate the names for different entities based on the provided placeholders. You can define new Naming Conventions within Ad Settings.

    Set Creative Naming Convention

    Select a Naming Convention for your Creative from the drop-down menu.

    This will dynamically generate the names for different entities based on the provided placeholders. You can define new Naming Conventions within Ad Settings.

    Send for Approval

    Check this box to send the Ads for approval before pushing the Ads live. Select the Approval Type and/or Approval Path from the respective drop-down menus.

    The box alongside Publish as active once approved will be checked by default to ensure that your ad is published as Active after being approved. You can, however, uncheck the box to ensure that your ad is being published as Paused after approval. This will make sure that your campaigns are not going active before the intended schedule and avoid any governance issues.

    Language

    Select a language to Import the Ads in from the following:

    • English

    • Japanese

  8. Once you have finalized your configuration, click Import in the bottom-right corner.

Import options

Term
Supported Channels
Ads

Facebook, Twitter, LinkedIn, Yahoo, Yahoo Native, Snapchat, Pinterest, LINE, Nextdoor, TikTok

Note:

Limitations of Ads Bulk Import:

  • Paid Initiative - No limitation.

  • Ad Sets - 50 Ad Sets per Campaign.

  • Ad Variants - 50 Ad Variants per Ad Set.

Partial Update

Facebook, Twitter, LinkedIn, Yahoo, Snapchat, Pinterest, LINE, Nextdoor, TikTok, Google

Note:

For Google Ads, you can successfully update Custom fields, Sprinklr Campaign, Strategy Groups, Benchmark, and Pacing Groups using Partial Update.

Posts

Facebook, Twitter, Pinterest, LINE

Twitter Cards

Twitter

Note:

On applying a Web Analytics Profile while creating new Twitter Posts with Cards in bulk,

Sprinklr will extract the Website URL information and append the web analytics parameters. This will publish a new instance of the card, keeping the original card unchanged.

Appending web analytics to an existing Twitter Post (published) with Cards using Bulk Import is not possible.

Keywords

Pinterest

Video

Facebook, Snapchat, Pinterest, LINE