The first step to get started with the RevContent 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 template 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 for more details
Auxiliary Sheets
There are also some auxiliary sheets in the main Google Sheets document which contain various information you can use to build your campaigns. For example: Languages, Countries, Regions, Traffic Types, 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 RevContent template columns.
| Traffic Source Account ID | 🚩 REQUIRED The RevContent 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. |
| Bid Type | 🚩 REQUIRED Possible Values:cpc = pay per each click vcpm = pay per 1000 views |
| Bid Amount | 🚩 REQUIRED If Bid Type = cpc then specify the amount you are willing to pay per each click (e.g $0.15 )If Bid Type = cpv then specify the amount you are willing to pay per 1000 views (e.g $1.5) |
| Budget Type | 🚩 REQUIRED Possible Values: a) Unlimited b) Daily |
| Pacing | Pacing is available for all campaigns with a limited budget. Enabling pacing forces your budget to spend evenly throughout the day rather than spending as quickly as possible |
| Budget | 🚩 REQUIRED Minimum allowed budget is $100 |
| Conversion Tracking | Specify a comma separated list of conversion names to use with this Campaign. The name should be the same as your existing conversions in RevContent dashboard |
| Start date | 🚩 REQUIRED Choose when your campaign will startPossible values: a) immediately b) specific date in format “yyyy-mm-dd hh:mm:ss” |
| End date | 🚩 REQUIRED Choose when your campaign will stopPossible values: a) never b) specific date in format “yyyy-mm-dd hh:mm:ss” |
| Traffic Types | 🚩 REQUIRED Comma separated list of traffic types to target for this campaign. Possible values: a) Adblock b) Native c) PushNotifications |
| Country Targeting | 🚩 REQUIRED 👆Double click on the cell to select a targeting option. 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 |
| Country Codes | 🟡 Only required if Country Targeting is INCLUDE or EXCLUDE Comma separated list of country codes to target. See Countries tab for full list of supported country codes. |
| Region Targeting | 🚩 REQUIRED 👆Double click on the cell to select a targeting option. Specify the type of region targeting that you are going to apply to this campaign. ALL – target all regions INCLUDE – target only the regions specified EXCLUDE – target all countries except for those specified |
| ZIP Code Targeting | 🚩 REQUIRED 👆Double click on the cell to select a targeting option. Specify the type of zip code targeting that you are going to apply to this campaign. ALL – target all zip codes INCLUDE – target only the zip codes specified in the Zip Codes Targeting column EXCLUDE – target all zip codes except for those specified in the Zip Codes Targeting column |
| Region Names | 🟡 Only required if Region Targeting is INCLUDE or EXCLUDE Comma separated list of regions, refer to the Regions Tab in this document for the available regions list to use |
| Zip Codes | 🟡 Only required if Zip Code Targeting is INCLUDE or EXCLUDE Comma separated list of Zip Codes |
| Device Targeting | 🚩 REQUIRED Comma separated list of devices to target. Possible values are: Desktop, Mobile, Tablet |
| Browser Targeting | 🚩 REQUIRED Comma separated list of browsers to target. Possible values: Chrome, Firefox, Safari, Edge |
| OS Targeting | 🚩 REQUIRED Coma separated list of Operating Systems that you want to target for this campaign. |
| Language Targeting | 🚩 REQUIRED List of comma separated languages that will be targeted for this campaign. For example: English,French,Italian. For full list of supported languages check the Languages tab in the Google Sheet. |
| 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.The exact tracking code format depends on the tracking system that you are using to track your camapigns’ performance. |
| 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) |
| Headline | 🚩 REQUIRED if not using Media Manager Ads. The Headline to be used during Ad creation. Max 80 characters. Leave empty if you are using Ads from Media Manager (see Media Manager Ads column) |
| Brand name | 🚩 REQUIRED Brand name will appear below your Ad. Max 30 characters. |
| Media Manager Ads | You can create 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 RevContent 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 RevContent Ads, My Old 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 |