{"id":2032,"date":"2024-03-09T13:10:36","date_gmt":"2024-03-09T13:10:36","guid":{"rendered":"https:\/\/theoptimizer.io\/help\/?post_type=ht_kb&p=2032"},"modified":"2024-03-09T13:17:06","modified_gmt":"2024-03-09T13:17:06","slug":"revcontent-bulk-campaign-uploader-via-excel-file","status":"publish","type":"ht_kb","link":"https:\/\/theoptimizer.io\/help\/knowledge-base\/revcontent-bulk-campaign-uploader-via-excel-file\/","title":{"rendered":"RevContent Bulk Campaign Uploader via Excel file"},"content":{"rendered":"\n

The first step to get started with the RevContent Excel Uploader is to Clone the Google Sheets Template<\/a> we have prepared, into your personal google account. <\/p>\n\n\n\n

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.<\/p>\n\n\n\n

Column Notes<\/strong>
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<\/p>\n\n\n\n

Auxiliary Sheets<\/strong>
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<\/p>\n\n\n\n

Once you have build all campaigns that you want to launch, the next steps are:<\/strong><\/p>\n\n\n\n

    \n
  1. Export the Google Sheet to an excel file<\/li>\n\n\n\n
  2. Go to the Campaign Creator<\/a> on TheOptimizer, and from the menu chose Create from Excel<\/li>\n\n\n\n
  3. Follow the steps and submit your file<\/li>\n<\/ol>\n\n\n\n

    How to Create Multiple Ads on the same campaign?<\/strong>
    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<\/p>\n\n\n\n

    \u2705 Check your e-mail for Successfull File Upload confirmation<\/strong>
    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<\/a> page.

    \u26a0\ufe0f Check your email for Errors<\/strong>
    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.<\/p>\n\n\n\n

    Below you can find a description of all the RevContent template columns.<\/h2>\n\n\n\n
    <\/td><\/td><\/tr>
    Traffic Source Account ID<\/td>\ud83d\udea9 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.<\/td><\/tr>
    Campaign Name<\/td>\ud83d\udea9 REQUIRED
    The name of the campaign to be used during upload.<\/td><\/tr>
    Bid Type<\/td>\ud83d\udea9 REQUIRED
    Possible Values:cpc = pay per each click
    vcpm = pay per 1000 views<\/td><\/tr>
    Bid Amount<\/td>\ud83d\udea9 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)<\/td><\/tr>
    Budget Type<\/td>\ud83d\udea9 REQUIRED

    Possible Values:
    a) Unlimited
    b) Daily<\/td><\/tr>
    Pacing<\/td>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<\/td><\/tr>
    Budget<\/td>\ud83d\udea9 REQUIRED
    Minimum allowed budget is $100<\/td><\/tr>
    Conversion Tracking<\/td>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<\/td><\/tr>
    Start date<\/td>\ud83d\udea9 REQUIRED
    Choose when your campaign will startPossible values:
    a) immediately
    b) specific date in format “yyyy-mm-dd hh:mm:ss”<\/td><\/tr>
    End date<\/td>\ud83d\udea9 REQUIRED
    Choose when your campaign will stopPossible values:
    a) never
    b) specific date in format “yyyy-mm-dd hh:mm:ss”<\/td><\/tr>
    Traffic Types<\/td>\ud83d\udea9 REQUIRED
    Comma separated list of traffic types to target for this campaign.
    Possible values:
    a) Adblock
    b) Native
    c) PushNotifications<\/td><\/tr>
    Country Targeting<\/td>\ud83d\udea9 REQUIRED
    \ud83d\udc46Double 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<\/td><\/tr>
    Country Codes<\/td>\ud83d\udfe1 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.<\/td><\/tr>
    Region Targeting<\/td>\ud83d\udea9 REQUIRED
    \ud83d\udc46Double 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<\/td><\/tr>
    ZIP Code Targeting<\/td>\ud83d\udea9 REQUIRED
    \ud83d\udc46Double 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<\/td><\/tr>
    Region Names<\/td>\ud83d\udfe1 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<\/td><\/tr>
    Zip Codes<\/td>\ud83d\udfe1 Only required if Zip Code Targeting is INCLUDE or EXCLUDE
    Comma separated list of Zip Codes<\/td><\/tr>
    Device Targeting<\/td>\ud83d\udea9 REQUIRED
    Comma separated list of devices to target.
    Possible values are: Desktop, Mobile, Tablet<\/td><\/tr>
    Browser Targeting<\/td>\ud83d\udea9 REQUIRED
    Comma separated list of browsers to target.
    Possible values:
    Chrome, Firefox, Safari, Edge<\/td><\/tr>
    OS Targeting<\/td>\ud83d\udea9 REQUIRED
    Coma separated list of Operating Systems that you want to target for this campaign.<\/td><\/tr>
    Language Targeting<\/td>\ud83d\udea9 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.<\/td><\/tr>
    Tracking Code<\/td>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.<\/td><\/tr>
    Target URL<\/td>\ud83d\udea9 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).<\/td><\/tr>
    Image URL<\/td>\ud83d\udea9 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)<\/td><\/tr>
    Headline<\/td>\ud83d\udea9 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)<\/td><\/tr>
    Brand name<\/td>\ud83d\udea9 REQUIRED
    Brand name will appear below your Ad. Max 30 characters.<\/td><\/tr>
    Media Manager Ads<\/td>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”).<\/td><\/tr>
    Rules<\/td>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<\/td><\/tr>
    Rule Groups<\/td>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<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

    How to upload campaigns in bulk to RevContent by using an Excel<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[31],"ht-kb-tag":[],"class_list":["post-2032","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-csv-camapign-creator"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb\/2032","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/comments?post=2032"}],"version-history":[{"count":2,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb\/2032\/revisions"}],"predecessor-version":[{"id":2037,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb\/2032\/revisions\/2037"}],"wp:attachment":[{"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/media?parent=2032"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb-category?post=2032"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/theoptimizer.io\/help\/wp-json\/wp\/v2\/ht-kb-tag?post=2032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}