Instead of using separate bulksheets to upload and apply business data, you can download an editable bulksheet and use that bulksheet to both create and apply business data:
-
Navigate to the tab that contains engine accounts, campaigns, or other items you want to apply business data to.
For example, navigate to an advertiser and click the Campaigns tab. -
Optionally use a filter to display only the items you want to apply business data to.
For example, use a filter to display only active manual keyword campaigns with names that start with "US -" -
Add columns for all of the business data you want to upload:
-
Click the Columns button, which appears above the performance summary graph.
-
Under Available columns, click Business data.
You'll see a list of columns from all of your business data tables, including the ID columns. -
Click + next to all columns from the business data tables you want to upload.
For example, to upload Dealership data, click + next to Dealership.ID column, along with all of the columns in the Dealership table, such as Dealership.Address and Dealership.Name.
-
Click Apply.
-
- Click the download icon , which appears above the reporting table and make the following selections in the download panel:
- Scope: Current scope
- Columns: Editable columns (for re-upload)
- Include types: Engine accounts, campaigns, or other items that you can apply business data to. For example, to apply business data to campaigns, select Campaigns.
- Filters: Include rows with no impressions
- Click Download.
Search Ads 360 generates the report and either downloads the file to your browser's download directory or sends an email, depending on the delivery option you selected.
The downloaded bulksheet with Search Ads 360 items contains the following data:
- One row for each engine account, campaign, or other item you selected in the download settings.
- One column for editable settings, such as campaign name and status.
- All of the business data columns you added to the reporting table, plus Effective columns.
-
To add new business data:
- Add a row to the bulksheet.
- In the
Row type
column, enterc:table_name
, where table_name is the name of the business data table you're adding data to.
-
In the
Action
column, entercreate
. - Enter information in all of the business data columns.
- Add a row to the bulksheet.
- To apply business data, enter the ID for a row of business data in the corresponding ID column.
For example, the following bulksheet contains two rows. The first row creates a business data hotel. The second row applies the hotel to a campaign.
RowType |
Action |
Account |
Campaign |
c:Hotel.ID |
c:Location.ID |
c:Hotel.Avail |
---|---|---|---|---|---|---|
c:Hotel |
create |
|
|
Sleepwell |
Boston: Back Bay |
50 |
campaign | edit |
Hooper's - Google |
Brand_Search_Sleepwell |
Sleepwell |
|
|