Including blank rows or columns in bulk sheets can lead to unexpected results. Therefore, it is a good idea to be aware of the effects of blank rows and columns before including them in an upload.

Blank Rows In Bulk Sheets

A completely blank row in a bulk sheet will cause that upload to fail. Therefore, blank rows should always be removed.

Blank Columns In Bulk Sheets

The results of a blank column (a column that has a header but no data in one or more of the cells) will depend on the heading of the column. Here are some general guidelines:

• For some column headers, a blank is taken as an instruction to apply the default for that column. For example, if you upload a keyword bulk sheet with blanks under the Match Type column, in the absence of a specific instruction, the match type broad would be applied because broad is the default match type in Marin.
• Other column headers will take a blank as an instruction to overwrite the current value with nothing. An example of this is the Destination URL column. If there’s a blank entry underneath this header, Marin will replace the current destination URL (if there is one) with nothing.  

A list of default values is listed in the table below. This should help you to understand the impact blank columns may have on various columns when creating or editing in bulk.

Generally speaking, it is best to not have blanks in your bulk sheets unless you are confident they will produce the results you want. If you are unsure about the effect a blank entry will have, please reach out to your Marin account representative.

Important Information

• Please note that you cannot edit the match type of a keyword; instead, a new keyword will be created with the match type specified. If match type is omitted and there is only one (undeleted) matching keyword in the group, any changes will be made to that keyword. Marin sees a keyword with a new match type as a different keyword. This is the same behavior that is used within the publishers' UIs -- if you edit a keyword match type within the publisher's interface, the original keyword will be deleted in Marin and a new keyword with a new match type will be created. 
• Keyword text cannot be modified. This will always create new keywords. This is true in Marin as well as on the publisher side.
• Note that bulk files can use the header Ad Group instead of Group, which is useful when using AWE exports.

Bulk Upload Default Values

The following table explains the default values (for both create and edit operations) that will be inserted if these fields are left blank during an upload.