Skip to main content
The MGID Excel Uploader lets you prepare and launch multiple campaigns at once without going through the UI one by one. You define everything — targeting, budget, bidding, and creatives — in a structured Google Sheets template, export it to Excel, and submit it through TheOptimizer.

​
How It Works

1

Clone the Google Sheets Template

Start by making a copy of the MGID Excel template into your own Google account:Clone the MGID Google Sheets Template →The template contains:
  • A main sheet with one row per ad (campaign settings + creative in each row)
  • Auxiliary sheets with reference data: Languages, Countries, Regions, Operating Systems, and more
  • Column notes on every column header — hover over the column name to see the accepted values and format
2

Fill in Your Campaigns

Each row in the main sheet represents one ad. To create a campaign with multiple ads, add one row per ad keeping all campaign-level columns identical, and vary only the ad-level columns (image URL, headline, etc.).Key things to note:
  • Columns marked 🚩 REQUIRED must be filled in — the upload will fail if they’re missing
  • Columns marked 🟡 are conditionally required (e.g. Countries is only needed if Geo Targeting is set to INCLUDE or EXCLUDE)
  • Use the auxiliary sheets to look up valid values for countries, regions, languages, operating systems, etc.
3

Export to Excel and Upload

Once your sheet is ready:
  1. In Google Sheets, go to File → Download → Microsoft Excel (.xlsx)
  2. Open Campaign Creator in TheOptimizer
  3. From the menu, select Create from Excel
  4. Follow the on-screen steps and submit your file
4

Check Your Email for Confirmation

After submitting, TheOptimizer processes the file and sends you an email:
  • ✅ Successful upload — your campaigns are queued and being created on MGID. Track progress from the Campaign Creator page.
  • ⚠️ Upload failed — the email will include a new Excel file with all error cells highlighted. Download it, fix the issues, and re-upload.

​
Column Reference

The table below describes every column in the MGID Excel template.
ColumnDescription
Traffic Source Account ID🚩 REQUIRED. The MGID account ID from TheOptimizer where campaigns will be uploaded.
Campaign Name🚩 REQUIRED. The name of the campaign. Must be unique within your account.
Campaign Type🚩 REQUIRED. Double-click the cell to select a campaign type from the list.
Campaign Category🚩 REQUIRED. Type of website being promoted. Product promotions for products/services. Content promotions for article-based sites.
Campaign KeywordRequired only if Campaign Type is SEARCH_FEED.
Campaign Language🚩 REQUIRED. Language for the campaign creatives. Creatives in other languages will be rejected. See Languages sheet.
Start DateCampaign start date. If not specified, the campaign starts once approved. Format: 2023-10-10 19:00:00.
Geo Targeting🚩 REQUIRED. ALL, INCLUDE, or EXCLUDE.
Countries🟡 Required if Geo Targeting is INCLUDE or EXCLUDE. Comma-separated country codes (e.g. US, IT). See Countries sheet.
RegionsSpecific regions within targeted countries. Comma-separated. See Regions sheet.
Browser Targeting🚩 REQUIRED. ALL, INCLUDE, or EXCLUDE.
Browsers🟡 Required if Browser Targeting is INCLUDE or EXCLUDE. Comma-separated list of browsers.
OS TargetingALL, INCLUDE, or EXCLUDE.
OS🟡 Required if OS Targeting is INCLUDE or EXCLUDE. Comma-separated OS names. See Operating Systems sheet.
Limit Type🚩 REQUIRED. BUDGET_LIMIT — campaign runs until budget is spent. CLICK_LIMIT — campaign runs until click count is reached.
Daily LimitDaily spend or click limit. Minimum $50 for BUDGET_LIMIT; minimum 500 for CLICK_LIMIT.
Overall LimitTotal campaign limit. Must be greater than Daily Limit.
Split BudgetSplits budget evenly throughout the day. Only for CLICK_LIMIT. Values: 0 (off) or 1 (on).
UTM SourceValue passed via utm_source for Google Analytics tracking.
UTM MediumValue passed via utm_medium for Google Analytics tracking.
UTM CampaignValue passed via utm_campaign for Google Analytics tracking.
UTM CustomCustom tracking code appended to content URLs for third-party trackers.
Target URL🚩 REQUIRED (unless using Media Manager Ads). Landing page URL for the teaser.
Image URL🚩 REQUIRED (unless using Media Manager Ads). Ad image URL.
Headline🚩 REQUIRED (unless using Media Manager Ads). Ad headline. For content/product campaigns: up to 75 characters.
Cost Per Click🚩 REQUIRED. CPC in US cents. Example: 20 means $0.20.
Advert TextAd description text. For content/product: up to 75 characters (optional). For push: up to 40 characters (required).
Content CategoryAvailable for Content, Push, and Product campaign types.
Media Manager AdsReference a saved Ad group from MGID’s Media Manager instead of providing individual image/headline/URL fields.
RulesComma-separated Rule IDs from TheOptimizer to attach to the campaign after creation.
Rule GroupsComma-separated rule group names from TheOptimizer to attach after creation.