Skip to main content

Documentation Index

Fetch the complete documentation index at: https://theoptimizer.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

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.