Use your business data to manage campaigns

Upload business events

After business-event columns have been added to your business table, use a bulksheet to upload past and future events into Search Ads 360.

The overall process for adding or editing business events is as follows (the details are in the sections below):

  1. Download an editable bulksheet that contains business data tables.

  2. In the downloaded bulksheet, add or edit business events.
  3. Upload the bulksheet.

Download a bulksheet with business data tables

  1. Navigate to an advertiser.
    Steps for navigating to an advertiser
    1. Click the navigation bar to display navigation options.

    2. In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    3. In the "Advertiser" list, click on the advertiser.

    4. Click Apply or press the Enter key.

    Search Ads 360 displays the advertiser page, which contains data for all of the advertiser’s engine accounts.

  2. In the left navigation panel, click Business data.
     
  3. Click the download icon 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 tables: Select one or more tables to download.
      To select a table, click >> in the All tables list.
  4. 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 contains the following for each business data table you selected on the Search Ads 360 download page:

  • One bulksheet column for each business data column.
  • All of the rows that have already been defined for the business data tables.
    If all of the tables you selected are empty, you'll see one empty row.

Add business events to existing rows in the tables

To add business events:

  1. In the downloaded bulksheet, find an item you want to add an event to.
    Continuing the previous example, find the row that specified "Comfy Walkers" in the c:Brand.ID column.

  2. Copy the item's row and paste it at the end of the bulksheet.

  3. Enter information in all of the business event columns.
    You can leave the other columns in the row just as they are. In a row that specifies an event, Search Ads 360 will ignore columns that aren't defined as event variables or event start and end times.

Edit or remove events

Existing events can't be edited. Instead, you can remove an existing event and create a new one with the changed values.

To remove an event, set the “Action” column to remove. Keep all other values (i.e. Event start time, Event end time, and event variable columns) the same as downloaded from Search Ads 360. If you change any other value, Search Ads 360 won't recognize the event.

Example of removing an existing event and adding a new one with a changed variable value:

Row type

Action

Event start time

Event end time

c:Brand.ID

c:Brand.Discount %

c:Brand

remove

2016-06-01

2016-07-01

Speedy Shoes

.10

c:Brand

append

2016-06-01

2016-07-01

Speedy Shoes

.15

Business event columns

The required columns are:

  • Row type: c:<business data table name>, where <business data table name> is the name of the table that includes business-event columns.

  • Action: append for adding new events, remove for removing events

    • When removing events, be sure to specify all columns exactly as they were in the download

  • Event start time: the event start date, written as YYYY-MM-DD

    • Each event requires a distinct start and end time. Overlapping events are not supported.
      Search Ads 360 automatically adds this column to downloaded bulksheets that contain event variable columns.

  • Event end time: the event end date (inclusive), written as YYYY-MM-DD

    • Each event requires a distinct start and end time. Overlapping events are not supported.
      Search Ads 360 automatically adds this column to downloaded bulksheets that contain business event columns.

  • c:<business data table name>.ID: the item from your business data to which the event is scoped. Make sure this matches an ID you’ve previously uploaded.

  • Event variable columns:

Here's an example of adding 4 business events to the "Speedy Shoes" and "Comfy Walkers" rows in the Brand business data table:

Table name: Brand

Row type

Action

Event start time

Event end time

c:Brand.ID

c:Brand.Discount %

c:Brand

append

2016-06-01

2016-07-01

Speedy Shoes

.10

c:Brand

append

2016-06-07

2016-06-15

Comfy Walkers

.20

c:Brand

append

2016-07-02

2016-07-09

Speedy Shoes

.40

c:Brand

append

2016-07-02

2016-07-09

Comfy Walkers

.30

How to set event times

Events start at 12:00 am on the specified start date and end at 11:59 pm on the specified end date. (All times are in the time zone of the Search Ads 360 advertiser, which is set by the Campaign Manager advertiser associated with Search Ads 360).

For example, if “Event start time” is 2016-06-01 and “Event end time” is 2016-07-01, then the event will apply from 12:00 am, June 1 to 11:59 pm, July 1.

You can upload past or future events.

Events cannot overlap

Event dates for a single row of business data cannot overlap. For example, you cannot have both a 10% and 15% sale on the same brand at the same time.

Search Ads 360 automatically merges events under the following conditions:

  • Events have adjacent dates (where the end date of one event is the day before the start date of the other event)

  • Events have the same values of event variables

For example, these two rows:

Row type

Action

Event start time

Event end time

c:Brand.ID

c:Brand.Discount %

c:Brand

append

2016-06-01

2016-06-15

Speedy Shoes

.10

c:Brand

append

2016-06-16

2016-06-30

Speedy Shoes

.10

Will be merged into this one:

Row type

Action

Event start time

Event end time

c:Brand.ID

c:Brand.Discount %

c:Brand

append

2016-06-01

2016-06-30

Speedy Shoes

.10

The following two rows are invalid because the date ranges June 1 - July 1 and June 2 - July 2 overlap:

Row type

Action

Event start time

Event end time

c:Brand.ID

c:Brand.Discount %

c:Brand

append

2016-06-01

2016-07-01

Speedy Shoes

.10

c:Brand

append

2016-06-02

2016-07-02

Speedy Shoes

.15

If you tried to upload these two events, Search Ads 360 would report an upload error.

Was this helpful?
How can we improve it?