Taboola: Bulk upload campaigns via Excel file

The first step to get started with the Excel Uploader is to Clone the Google Sheets Template we have prepared, into your personal google account.

In the Google Sheets template you will find everything you need to build your campaigns and export them into an Excel file which you can then upload into TheOptimizer.

Column Notes
Each column in the Google Sheets document comes with a note explaining its functionality, the possible values you can use and the format of the values you can use. Hold the mouse over the column name to see the note

Extra Sheets
There are also extra sheets in the main Google Sheets document which you can use to access other values necessary to build your campaigns. For example: Countries, Regions, Browsers, Timezones, etc

Once you have build all campaigns that you want to launch, the next steps are:

  1. Export the Google Sheet to an excel file
  2. Go to the Campaign Creator on TheOptimizer, and from the menu chose Create from Excel
  3. Follow the steps and submit your file

How to Create Multiple Ads on the same campaign?
To create multiple ads for the same campaign, simply add more rows to the document having all the other campaign data exactly as the original row, and update the ad related columns (image url, headline, CTA etc). This will create the same campaign with multiple ads

βœ… Check your e-mail for Successfull File Upload confirmation
If all the information in the excel file was correct, the upload process will be completed successfully and you will receive a confirmation email. At this point your campaigns are queued for being created on Taboola, and you can follow the progress from the Campaign Creator page.

⚠️ Check your email for Errors
If there are incorrect or incorrectly formatted values in the Excel file you just submitted, the upload process will fail and you will get back an email with a new excel file which highlights all the cells containing errors.
Download the file, fix the errors and re-upload.

Below you can find a description of all the Google Sheets columns.

Traffic Source Account ID🚩 REQUIRED
The Taboola account ID from TheOptimizer, where these campaigns will be uploaded.
You Can find the account ID in the Traffic Sources menu on the left.
Campaign Name🚩 REQUIRED
The name of the campaign to be used during upload.
Marketing Objective🚩 REQUIRED
Based on your marketing objective, Taboola will optimize your campaign for the best possible results.
Possible values are:
LEADS_GENERATION – drive leads, such as email signups.
ONLINE_PURCHASES – get people to buy your products.
DRIVE_WEBSITE_TRAFFIC – increase user engagement and pageviews.
BRAND_AWARENESS – increase awareness of your brand.
Brand NameREQUIRED
The name of your product, brand or website (without “www” or “http”).This name will appear in your ad, below the title.Read Taboola’s Branding Text Guidelines for more details
Start DateChoose when your campaign will start.You have 2 options:a) Leave empty to Start running as soon as approved.b) Specify a start date
End DateChoose when your campaign will end.You have 2 options:a) Leave empty to continue until the budget is depleted.b) Specify an end date.
Campaign Status🚩 REQUIRED
The status of the campaign after creation.Possible values are:
ACTIVE – campaign will be created as active and will be running as soon as approved.
PAUSED – campaign will be created with status paused. Once the campaign is approved you need to start the campaign manually.
Campaign Schedule DaysSpecify which days of the week you want your campaign to be active.
Leave empty to run 24/7.
Specify a list of days in this format:Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday
For example, to run from Monday to Friday enter:Monday, Tuesday, Wednesday, Thursday, Friday
Campaign Schedule Start HourThis field specifies when your campaign will start activity on a given day.
For example if you have set the scheduling days to Monday, Tuesday, Thursday, you should also enter a start hour for each day.
If you enter 11, 8, 23 it will translate to
Monday β†’ 11am
Tuesday β†’ 8am
Thursday β†’ 11pm
Campaign Schedule End HourThis field specifies when your campaign will end activity on a given day.
For example if you have set the scheduling days to Monday, Tuesday, Thursday, you should also enter an end hour for each day.
If you enter 11, 8, 23 it will translate to
Monday β†’ 11am
Tuesday β†’ 8am
Thursday β†’ 11pm
Campaign Schedule TimezoneTaboola will schedule your campaign to run based on the selected time zone. By default your Taboola account time zone is selected.
Country Targeting
Specify the type of country targeting that you are going to apply to this campaign.
ALL – target all countries
INCLUDE – target only the countries specified in the Countries column
EXCLUDE – target all countries except for those specified in the Countries column
Countries🟑 Only required if Country Targeting is INCLUDE or EXCLUDE
Specify a list of country names that you want to include or exclude in your targeting.
Example: United States, Italy
Check the “Countries” sheet in the Google Sheet template for a full list of country names
RegionsIf you want to be more specific with your location targeting, you can also choose specific regions to target.
You can specify a comma separated list of reagions.
For example if your country targeting includes Italy, United Kingdom and France, you can target only Rome, London and Paris by entering:Rome, London, Paris
⚠️ You can only target regions if Country Targeting is set to β€œINCLUDEβ€œ.
πŸ‘‡ Check the Regions sheet in the Google Sheet template  for a full list of supported Regions
Platforms Targeting🚩 REQUIRED
Specify the type of platform targeting to use for this campaign.
ALL – all platforms will be targeted
INCLUDE – only a specific list of platforms will be targeted
EXCLUDE – all platforms except a specific list will be targeted.
Platforms🟑 Only required if Platforms Targeting is INCLUDE or EXCLUDE
Choose the platforms on which your ads will appear.
Possible values are:PHON, DESK,TBLT
For example, if you’re offering a mobile app, it would make sense to target mobile devices only.
Multiple platforms can be specified separated by comma.
Tip:consider setting up a separate campaign for each platform. This allows you to compare results and optimize performance.
Operating System Targeting🚩 REQUIRED
Specify the type of operating system targeting to use for this campaign.
ALL – all operating systems will be targeted
INCLUDE – only a specific list of operating systems will be targeted
EXCLUDE – all platforms except a specific list will be targeted.
Operating Systems🟑 Only required if Operating System Targeting is INCLUDE or EXCLUDE
Specify a comma separated list of operating systems you want to include or exclude from the targeting.
Possible values are:Mac OS X, Linux, Windows, iOS, iPadOS, Android
Operating System VersionsFurther narrow down the Operating System targeting, by specifying a list of Operating System versions to include or exclude.
Check the “OS Versions” sheet in the Google Sheet template  for a full list of supported Operating System versions
Browsers Targeting🚩 REQUIRED
Specify the type of Browser targeting to use for this campaign.
ALL – all browsers will be targeted
INCLUDE – only a specific list of browsers will be targeted
EXCLUDE – all browsersexcept a specific list will be targeted.
Browsers🟑 Only required if Browser Targeting is INCLUDE or EXCLUDE
Multiple browsers can be specified, separated by comma.
Check the Browsers sheet in the Google Sheet template  for a full list of supported browsers.
Connection Type🚩 REQUIRED
The connection type to include in the campaign targeting.
Possible values are:
ALL – target all connection types
WIFI – target only wifi connection
Block SitesSpecify a comma separated list of Sites that you want to block for this campaign.
Sites will be blocked at campaign level, not account level.
🟑 The correct site format to use in the block list, is the format you get with the {site} macro from Taboola.
For example:the correct site format for “MSN – Home – Network” is msn-home-network.
Brand Safety Type🚩 REQUIRED
Taboola has partnered with DoubleVerify (DV) and Integral Ad Science (IAS) to offer marketers brand safety and brand suitability pre-bid targeting and avoidance capabilities.
These third parties scan Taboola’s network of publisher sites and apps, assigning brand safety risk tiers and brand suitability avoidance capabilities across a variety of topics.
By applying brand safety and brand suitability pre-bid targeting/avoidance, Taboola will prevent your ad from serving on all sites and apps which fail to meet the brand safety and suitability criteria you selected.
Possible values are:NONE – do not use brand safetyIAS – Use Integral Ad Science serviceDV – Use DoubleVefify service
Brand Safety SegmentsSpecify a list of Brand Safety Segments where you do not want your ads to appear
Brand Safety Risk LevelSelect tiers that align with your Brand Safety and Suitability tolerance for certain content.
I.e. A food brand may want to avoid a user-forum that includes a discussion about “alcohol abuse” (high risk), but may be comfortable appearing alongside content that discusses a “recipe for alcoholic cocktails” (low risk).
Selecting High Risk only will give your campaign the most scale.
Possible values:HIGH – block high risk sites onlyMEDIUM – block high and medium risk sitesLOW – block high, medium and low risk sites
Bid Strategy🚩 REQUIRED
Possible values:
MAX_CONVERSIONS – get the most conversions under a given budget or at your target cost
TARGET_CPA – get the most conversions, with a specific target CPA goal.
FIXED – fllows you to retain full control over the bid at all times. Set your CPC manually
SMART – automatically optimize baseline bid to maximize the performance
Cost Per Click🟑 Only required if Bid Strategy is SMART or FIXED
The Cost Per Click you are willing to pay.
Minimum cost per clicks is 0.01
CPA Goal🟑 Only required if Bid Strategy is TARGET_CPA
Daily CapAn average, daily amount to spend on this campaign. Depending on available opportunities, you might spend less, or up to twice as much, on a given day.
Spending Limit Model🚩 REQUIRED
MONTHLY β†’ The spending limit is set for the entier month and it will reset each month.
ENTIRE β†’ This means the amount entered is the budget for the whole campaign, and will not reset at any time.
NONE β†’ Campaigns with no spending limit are available for eligible accounts only
Spending LimitThis is the budget for your campaign.
It is the maximum you are willing to spend within the set timeframe for your campaign, either monthly or for the entire campaign.
Make sure your Spending Limit is sufficient considering your Daily Budget
Daily Ad Delivery Model🚩 REQUIRED
This is how your campaign will spend its budget on a daily basis. There are three options:
BALANCED β†’ this means your campaign will pace as evenly as possible throughout the month
STRICT β†’ this means you do not want your campaign to exceed a specific amount of spend on a daily basis.
Traffic Allocation Mode🚩REQUIRED
OPTIMIZED – (Recommended option) The traffic distribution for your campaign items will be determined by our algorithm, and your most engaging campaign will get more traffic than others.
EVEN – The traffic for your campaign will be distributed evenly among your campaign items.
Traffic Allocation AB Test End DateWhen Traffic Allocation Mode is EVEN (or A/B Test) – Ads will receive equal opportunities across Taboola’s network by allocating impressions more evenly than Optimized, regardless of performance.
When the A/B test reaches the end-date, the campaign will switch to Optimized ad delivery.
End date should be in the format:YYYY-MM-DD
Tracking CodeThis code will be added to your landing page URLs so you will be able to track the campaign performance on other analytics platforms.
CommentsComments to add to this campaign.
Target URL🚩 REQUIRED if not using Media Manager Ads
Target URL of the Ad.
Leave empty if you are using Media Manager Ads to create Ads (see Media Manager Ads column).
Image URL🚩 REQUIRED if not using Media Manager Ads
The image url to be used with this Ad.
Leave empty if you are using Ads from Media Manager (see Media Manager Ads column)
Image file: 1MB maximum, jpeg preferred. (Accepted types: JPEG, BMP, PNG, WBMP and GIF)
1000 x 600 px minimum – smaller images will serve in fewer placements.
Aspect Ratios: 16:9 (preferred), 4:3, 1:1
Headline🚩 REQUIRED if not using Media Manager Ads
The Headline to be used during Ad creation. Max 100 characters.For best results, 60 characters or less is recommended.
Leave empty if you are using Ads from Media Manager (see Media Manager Ads column)
CTA🚩 REQUIRED
Call-to-Action of your Ad
DescriptionMaximum length of the text is 250 characters.
The description offers advertisers storytelling opportunities to highlight details about their product or service.Must-see details about your ad should be written in the title.
Based on the specific environment and publishers, Taboola will auto-optimize between your ad with and without description to show the best ad for achieving strong performance.
The visible length of the description depends on the placement it appears on. If shortened, the description will end with ellipses.
Media Manager AdsYou can create a bundle of Ads, in Media Manager, and re-use them every time you launch campaigns.
In order to use Ads from Media Manager, follow the steps below:
1. Select an existing group of Ads in Media Manager or upload new Ads
2. Group the selected Ads by tagging them in Media Manager
3. Use the Tags you have created in the “Media Manager Ads column
Example:Lets say you have selected 10 existing ads and tagged them as “My Best Taboola Ads”.All you need to do now is list this and other tags in the “Media Manager Ads” column and TheOptimizer will automatically use these ads when creating your campaigns.
Multiple tags can be specified, comma-separated values (e.g., “My Best Taboola Ads,My Old Taboola Ads2,tag3”).
RulesA list of Rule IDs from TheOptimizer to add to the campaign after the campaign is created (comma separated).
Rule IDs can be found under the Rules menu in TheOptimizer
Rule GroupsA list of rule groups from TheOptimizer, to add to the campaign (comma separated).
All rules in the specified rule groups will be added to the campaign, once the campaign is created
Updated on March 9, 2024

Was this article helpful?

Related Articles