The first step to get started with the Mgid 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 Mgid template columns.
| Traffic Source Account ID | 🚩 REQUIRED The Mgid account ID from TheOptimizer, where these campaigns will be uploaded. |
| Campaign Name | 🚩 REQUIRED The name of the campaign to be used during upload. The name must be unique within your account |
| Campaign Type | 🚩 REQUIRED 👆 Double click on the cell to select a campaign type from the list. |
| Campaign Category | 🚩 REQUIRED Select the type of website you’d like to promote. If you want to advertise any service or product, you need to select Product promotions. If you want to advertise websites that contain articles, select Content promotions. |
| Campaign Keyword | Only Required if Campaign Type is SEARCH_FEED |
| Campaign Language | 🚩 REQUIRED Specify the language that will be used for the creatives of this campaign. All creatives in other languages will be rejected. See Languages tab for a full list of supported languages |
| Start Date | Campaign Start Date The start date of the campaign. If the date is not specified the campaign will start as soon as it is approved. E.g: 2023-10-10 19:00:00 |
| Geo Targeting | 🚩 REQUIRED 👆Double click on the cell to select a targeting option. Specify the type of geo 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 list of country codes that you want to include or exclude in your targeting. Example: US, IT Check the “Countries” sheet for a full list of country codes |
| 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 regions. 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 Check the Regions sheet for a full list of supported Regions |
| Browser Targeting | 🚩 REQUIRED 👆Double click on the cell to select a targeting type. Specify the type of browser targeting to use for this campaign. ALL – all browsers will be targeted INCLUDE – only a specific list of browser will be targeted EXCLUDE – all browsers except a specific list will be targeted. |
| Browsers | 🟡 Only required if Browser Targeting is INCLUDE or EXCLUDE Specify a comma separated list of browsers you want to include or exclude from the targeting. |
| OS Targeting | 👆Double click on the cell to select a targeting type. 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. |
| OS | 🟡 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. Check the “Operating Systems” sheet for a full list of supported Operating System versions |
| Limit Type | 🚩 REQUIRED Specify the type of limit you want to use for this campaign. Budget Limit: will keep the campaign running until the selected budget is depleted. Clicks Limit: will keep the campaign running until the amount of clicks is reached. |
| Daily Limit | The daily limit of the campaign. If type is set to “BUDGET_LIMIT“, the daily limit should be at least $50.If it is set to “CLICK_LIMIT“ it should be at least 500 |
| Overall Limit | Overall limit should always be greater than the Daily Limit |
| Split Budget | Splits the budget evenly throughout the day. Only applicable if Limit Type is set to “CLICK_LIMIT”. Possible values are: 0 or 1 0 = don’t split budget 1 = split budget. |
| UTM Source | Specify the value that you want to pass to Google Analytics tracking via the utm_source macro. |
| UMT Medium | Specify the value that you want to pass to Google Analytics tracking via the utm_medium macro. |
| UTM Campaign | Specify the value that you want to pass to Google Analytics tracking via the utm_campaign macro. |
| UTM Custom | Custom tracking code to append to your content URLs. If you are using a 3-rd party tracker to track your campaigns performance, and it requires you to use a tracking code, then this is the right place to enter it |
| Target URL | 🚩 REQUIRED if not using Media Manager Ads. Target URL when you are creating a teaser.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 for this teaser.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 this teaser creation. Leave empty if you are using Ads from Media Manager (see Media Manager Ads column)* for content/product campaign type – up to 65 characters* for push campaign type – up to 30 characters |
| Cost Per Click | 🚩 REQUIRED The Cost Per Click for this teaser. The value is in US cents. Example: 20 means $0.2 |
| Advert Text | Advertisment Text for you Teaser * for content/product campaign type – up to 75 characters (optional) * for push campaign type – up to 40 characters (required) |
| Content Category | Content Category is available only for certain type of campaigns. (Content, Push, Product) |
| 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 Mgid 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 Mgid 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 |