Appendix - Required bulksheet data for Naver accounts

Last update: 2023-09-29
  • Created for:
  • User

Populate your Naver accounts in Search, Social, & Commerce by generating a bulksheet file within Naver, and then uploading it to Search, Social, & Commerce.

Each bulksheet must include the header fields and corresponding data fields required for the specific operations you want to perform (such as creating an ad). When a field isn’t required, you can omit it from the header and data rows. All custom columns are deleted when you upload the bulk sheet file.

The following are the available header fields and descriptions of the corresponding data fields, as well as more information about which are required to add, edit, or delete data.

Available data fields

The following table shows which fields are required, optional, or not applicable when you add, edit, or delete each type of component record. When a field isn’t applicable to the action, any value entered in the field is ignored.

NOTE
  • The values in all text columns are case-sensitive.
  • When you create a new record and don’t include values for all required data fields, then some of those fields are assigned the specified default values.
  • For fields that aren’t specified below, the default value for the ad network is used.
  • For a list of available bulksheet rows in the Download Bulksheet dialog, see “Bulksheet rows by ad network.”
Field Campaign Ad Group Keyword Description
Platform n/a n/a n/a (Included in generated bulksheets for information purposes) The ad platform. Required unless each row includes an AMO ID for the entity.
Acct Name Required/Optional Required/Optional Required/Optional The unique name that identifies an ad network account. Required unless each row includes an AMO ID for the entity.
Campaign Name Required Required Required The unique name that identifies a campaign for an account.
Ad Group Name n/a Required Required The unique name that identifies an ad group.
Keyword n/a n/a Required The keyword string.
Base URL n/a n/a Optional The landing page URL to which end users are taken when they click your ad, including any append parameters configured for the campaign or account.

Base/final URLs at the keyword level override URLs at the ad level and higher.
Destination URL n/a n/a n/a (Included in generated bulksheets for information purposes; not posted to the ad network) For accounts with destination URLs, this value is the URL that links an ad to a base URL/landing page on the advertiser’s website (sometimes via another site that tracks the click and then redirects the user to the landing page). It includes any append parameters configured for the Search, Social, & Commerce campaign or account. If you generated tracking URLs, this value is based on the tracking parameters in your account settings and campaign settings. If you appended ad network-specific parameters, they may be replaced with the equivalent parameters for Search, Social, & Commerce.

For accounts with final URLs, this column shows the same value as the Base URL/Final URL column.
[Advertiser-specific Label Classification] Optional Optional Optional (Named for an advertiser-specific label classification, such as “Color” for a label classification called Color) A value for the specified classification that is associated with the entity. You can include only one value per classification per entity (such as “red” for the “Color” label classification for Campaign A). The maximum length is 100 characters, and the value can include ASCII and non-ASCII characters.

Label classifications and their label values are applied to all child components; new components that are added later are automatically associated with the label. Label classifications for product groups are applied to the unit (most granular) level.

The classification name and the classification value aren’t case-sensitive.
Constraints Optional Optional Optional A constraint that’s assigned to the entity. You can assign only one constraint per entity.

Constraints are inherited by child entities, so you don’t need to enter values for child entities unless you want to override the inherited values.
Campaign Status Optional: Create or edit
Required: Delete
n/a n/a The display status of the campaign: *Active, Paused, or Deleted (existing campaigns only). The default for new campaigns is Active. To delete an active or paused campaign, enter the value “Deleted”.
Ad Group Status n/a Optional: Create or edit
Required: Delete
n/a The display status of the ad group: *Active, Paused, or Deleted (existing ad groups only). The default for new ad groups is Active. To delete an active or paused ad group, enter the value “Deleted”.
Keyword Status n/a n/a Optional: Create or edit
Required: Delete
The display status of the keyword: *Active, Paused, or Deleted (existing keywords only). The default for new keywords is Active. To delete an active or paused keyword, enter the value “Deleted”.
Campaign ID n/a: Create
Required/Optional: Edit or delete
Optional Optional The unique ID that identifies an existing campaign. In CSV and TSV files, it must be preceded by a single quote (').[1] Required only when you change the campaign name, unless the row includes an AMO ID for the campaign.
Ad Group ID n/a n/a: Create
Required/Optional: Edit or delete
Optional The unique ID that identifies an existing ad group. In CSV and TSV files, it must be preceded by a single quote (').[1:1] Required only when you change the ad group name, unless the row includes an AMO ID for the ad group.
Keyword ID n/a n/a n/a: Create
Required/Optional: Edit
Required: Delete
The unique ID that identifies an existing keyword. In CSV and TSV files, it must be preceded by a single quote (').[1:2] Required only when you change the keyword name, unless the row includes a) sufficient property columns to identify the keyword or b) an AMO ID.
AMO ID n/a: Create
Optional: Edit or delete
n/a: Create
Optional: Edit or delete
n/a: Create
Optional: Edit or delete
(In generated bulksheets) An Adobe-generated unique identifier for a synced entity. For responsive search ads, the AMO ID is required to edit or delete ads unless you include the Ad ID. To edit data for all other entity types with an AMO ID, the AMO ID is required to edit or delete the data unless you include the entity ID and parent entity ID.

Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post the ID to the ad network.
EF Error Message n/a n/a n/a (Included in generated bulksheets for information purposes) Placeholder for displaying error messages from Search, Social, & Commerce regarding data in the row; error messages are included in EF Errors files. This value isn’t posted to the ad network.
SE Error Message n/a n/a n/a (Included in generated bulksheets for information purposes) Placeholder for displaying error messages from the ad network regarding data in the row; error messages are included in SE Errors files. This value isn’t posted to the ad network.

  1. Excel converts large numbers to scientific notation (such as 2.12E+09 for 2115585666) when it opens the file. To view digits in the standard notation, select any cell in the column and click inside the formula bar. ↩︎ ↩︎ ↩︎

On this page