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:
- Export the Google Sheet to an excel file
- Go to the Campaign Creator on TheOptimizer, and from the menu chose Create from Excel
- 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 Name | REQUIRED 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 Date | Choose 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 Date | Choose 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 Days | Specify 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 Hour | This 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 Hour | This 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 Timezone | Taboola 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 |
| Regions | If 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 Versions | Further 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 Sites | Specify 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 Segments | Specify a list of Brand Safety Segments where you do not want your ads to appear |
| Brand Safety Risk Level | Select 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 Cap | An 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 Limit | This 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 Date | When 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 Code | This code will be added to your landing page URLs so you will be able to track the campaign performance on other analytics platforms. |
| Comments | Comments 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 |
| Description | Maximum 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 Ads | You 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”). |
| Rules | A 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 Groups | A 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 |