The following tables outline the requirements for some of the most popular types of bulk uploads. You can use these to look up the relevant column headers you're using in your bulk sheet, then cross-reference the relevant values you can use.
In the tables below, columns with a Header that is in square brackets [ ] are optional, while those without brackets are required.
If you'd like to learn more about bulk uploads, check out our dedicated article.
|
Header |
Value |
Note |
|
Account |
Publisher Account Name that is shown at Channel tab |
|
|
Campaign |
Campaign name |
|
|
Group |
Group name |
|
|
Keyword |
Keyword |
|
|
[Match Type] |
Broad, Exact, Phrase |
While this column is not required, it is recommended for most keyword-level bulk uploads. If no Match Type is specified in the bulk sheet, default Match Type will be used, which is Broad. |
|
[Status] |
Active, Paused, Deleted |
|
|
[Search Bid] |
Max CPC value |
|
|
[Landing Page] |
Google / Microsoft's Final URL |
Google / Microsoft |
|
[Mobile Landing Page] |
Google's Final URL for mobile |
Google only |
|
[Destination URL] |
Destination URL for keyword |
|
|
[Tracking Template] |
Template URL for tracking solutions and extra parameters |
Google / Microsoft |
|
[Custom Parameters] |
User-defined ValueTrack parameters |
Google / Microsoft |
|
[Bid Override] |
On, Off |
|
|
[Override Until] |
YYYY/MM/DD |
|
|
[Bid Override Target Position Range] |
1.0-10.0 |
|
|
[Click Through URL] |
If URL is Redirect |
|
|
Header |
|
Microsoft |
Yahoo! Japan |
Note |
|
Account |
Publisher Account Name that is shown at Channel tab |
Publisher Account Name that is shown at Channel tab |
Publisher Account Name that is shown at Channel tab |
|
|
Campaign |
Campaign name |
Campaign name |
Campaign name |
|
|
Group |
Group name |
Group name |
Group name |
|
|
[Creative ID] |
N/A |
N/A |
N/A |
Used to edit an existing creative and included in any Creative reports. |
|
[Headline] |
Ad Text Headline |
Ad Text Headline |
Ad Text Headline |
|
|
[Description Line 1] |
Ad Text Description Line 1 |
Ad Text Description Line 1 |
Ad Text Description Line 1 |
|
|
[Description Line 2] |
Ad Text Description Line 2. Used for ETAs and RSAs. For ETAs, this field is optional and can show if there is enough ad real estate, but is not guaranteed to always show. For RSAs, this field is required. |
Ad Text Description Line 2. Used for ETAs and RSAs. For ETAs, this field is optional and can show if there is enough ad real estate, but is not guaranteed to always show. For RSAs, this field is required. |
|
|
|
[Creative Type] |
Specify the type of creative being uploaded |
Specify the type of creative being uploaded |
Text Ad App A |
|
|
[Status] |
Active, Paused, Deleted |
Active, Paused, Deleted |
Active, Paused, Deleted |
|
|
[Display URL] |
Visible URL |
Visible URL |
Visible URL |
|
|
[Landing Page] |
Google's Final URL |
N/A |
N/A |
|
|
[Mobile Landing Page] |
Google's Final URL for mobile |
N/A |
N/A |
|
|
[Destination URL] |
N/A |
destination URL for creative |
N/A |
|
|
[Click Through URL] |
N/A |
If URL is Redirect |
If URL is Redirect |
|
|
[Tracking Template] |
Template URL for tracking solutions and extra parameters |
Template URL for tracking solutions and extra parameters |
N/A |
|
|
[Custom Parameters] |
User-defined ValueTrack parameters |
N/A |
N/A |
|
|
[Image] |
File name of image ad file |
File name of image ad file |
N/A |
|
|
[Creative Name] |
Ad name of image ad |
Ad name of image ad |
N/A |
|
|
[Policy Name] |
the specific editorial policy that caused a keyword or creative to be rejected by the publisher |
the specific editorial policy that caused a keyword or creative to be rejected by the publisher |
N/A |
|
|
[Violating Text] |
the specific word or words that broke the publisher editorial policy |
the specific word or words that broke the publisher editorial policy |
N/A |
|
|
[Device Preference] |
Mobile preferred |
Mobile preferred |
Mobile preferred (In the platform, the value is shown as "Smart phone preferred") |
Yahoo! Japan: When using "Mobile preferred", make sure to use "Text2 (15-19-19)" in [Creative Type] |
|
[Ad Name (Yahoo Japan)] |
N/A |
N/A |
Ad Name (Any name you want) |
|
|
[Carriers] |
N/A |
N/A |
Docomo, KDDI, Softbank |
|
|
[Display URL Nav 1] |
An ETA and ETA++ field that is equivalent to Google's Path 1 field. |
An ETA field that is equivalent to Microsoft's Path 1 field |
An ETA field that is equivalent to Yahoo Japan's Directory 1 field |
|
|
[Display URL Nav 2] |
An ETA and ETA++ field that is equivalent to Google's Path 2 field |
An ETA field that is equivalent to Microsoft's Path 2 field |
An ETA field that is equivalent to Yahoo Japan's Directory 2 field |
|
|
[Headline 2] |
Used for ETAs and RSAs. Required for both |
Used for ETAs and RSAs. Required for both |
N/A |
|
|
[Headline 3] |
Used for ETAs and RSAs. For ETAs, this field is optional and can show if there is enough ad real estate, but is not guaranteed to always show. For RSAs, this field is required. |
Used for ETAs and RSAs. For ETAs, this field is optional and can show if there is enough ad real estate, but is not guaranteed to always show. For RSAs, this field is required. |
N/A | |
|
[Headline 4] through [Headline 15] |
Used for RSAs (optional) |
N/A |
N/A |
|
|
[Description Line 3] |
Used for RSAs (optional) |
N/A |
N/A |
|
|
[Description Line 4] |
Used for RSAs (optional) |
N/A |
N/A |
|
|
[Headline Pinned to Position 1] through [Headline Pinned to Position 3] |
Used for RSAs (optional) |
N/A |
N/A |
|
|
[Description Pinned to Position 1] |
Used for RSAs (optional) |
N/A |
N/A |
|
|
[Description Pinned to Position 2] |
Used for RSAs (optional) |
N/A |
N/A |
|
Header |
|
Microsoft |
Yahoo! Japan |
Note |
|
Account |
Publisher Account Name that is shown at Channel tab |
Publisher Account Name that is shown at Channel tab |
Publisher Account Name that is shown at Channel tab |
|
|
Campaign |
Campaign name |
Campaign name |
Campaign name |
|
|
[Status] |
Active, Paused, Deleted |
Active, Paused, Deleted |
Active, Paused, Deleted |
|
|
[Strategy] |
Strategy name |
Strategy name |
Strategy name |
|
|
[Mobile Bid Adjustment] |
-100, 90 to 900 |
-100 to 300 |
-100 to 300 |
|
|
[Mobile Bid Adj. Exclusion] |
On |
N/A |
On |
|
|
[Tablet Bid Adjustment] |
N/A |
N/A |
N/A |
|
|
[Desktop Bid Adjustment] |
N/A |
N/A |
N/A |
|
|
[Native Bid Adjustment] |
N/A |
-100 to 900 |
N/A |
This is Marin's version of Microsoft's "Audience Bid Adjustment" and works in the same way |
|
[Tracking Template] |
Template URL for tracking solutions and extra parameters |
Template URL for tracking solutions and extra parameters |
On |
|
|
[Custom Parameters] |
User-defined ValueTrack parameters |
N/A |
N/A |
|
|
[Unified (Yahoo Japan)] |
N/A |
N/A |
Legacy, Enhanced |
|
|
[Smart Phone Bid Adjustment (Yahoo Japan)] |
N/A |
N/A |
-100 to 300 |
|
|
[Start Date] |
MM/DD/YY |
MM/DD/YY |
MM/DD/YY |
The value can be submitted in your locale format, for example for UK locale, it is DD/MM/YYYY |
|
[Campaign End Date] |
MM/DD/YY |
MM/DD/YY |
MM/DD/YY |
The value can be submitted in your locale format, for example for UK locale, it is DD/MM/YYYY |
|
[Subtype] |
Determines which settings and options are available, such as the types of ads |
N/A | N/A |
To create a Mobile App Install campaign, you will need to specify the subtype field as "mobile app install" |
|
[Daily Budget] |
value for campaign daily budget |
value for campaign daily budget |
Minimum campaign daily budget is 100 yen |
|
|
[Network] |
Search, Search Network, Content (or a combination of these) |
Search, Search Network, Content (or a combination of these) |
N/A |
|
|
[Devices] |
N/A |
N/A |
N/A |
PC, Mobile (Microsoft Only after enhanced upgrade) |
|
[Final URL Suffix] |
URL Suffix for tracking sollutions and extra parameters |
N/A |
N/A |
|
|
[Campaign ID] |
N/A |
N/A |
N/A |
Use to edit an existing creative and included in any Creative reports |
