Manage Audience And Contextual Segments Using CSV Upload

Audience and contextual segment targeting adds depth to your product catalogue quickly and easily. Managing these segments is easy using our CSV upload system. You can quickly update segments in the same way.

Create an audience or contextual segment collection

The audience and contextual segments you offer your buyers need to be logically grouped into segment collections. Segments within a segment collection should be logically related to each other so that buyers can easily explore the segments you make available.

Examples:

• Age (audience segment collection) containing segments “18-24”, “25-34” etc.
• Section (contextual segment collection) containing segments “News”, “Sport”, “Finance” etc.
• Marital Status (audience segment collection) containing segments “Single”, “Married” etc. 

Steps to create a new segment collection:

1. Complete the form providing
1. Name: this should be distinct and will allow you to easily tell the difference between similar segment collections.
2. Label: this will a simple label that is shown to buyers and is likely similar to the name.
2. Select type “Contextual” or “Audience”
3. Download the Segment CSV template
4. Open the template using Microsoft Excel and add the segments you will offer in this segment collections.
5. Save the file and Upload

Please note when editing the segment collection CSV:

• You cannot create extra columns. Use the columns provided.
• CSV is the only upload format supported. We do not support XLS or XLSX format.

Uploading segments using the CSV template

Each row within the CSV represents one segment which can be applied as targeting to line items. You can add as many rows you like to quickly offer a large number of targeting options.

CSV Columns:

• Internal ID: This is used by Adslot to allow you to update existing segments. Leave this blank when creating new segments.
• Segment name: The name is shown to you and your media buyers when selecting segments to apply to line items. All information that needs to be communicated to the buyer about the segment should be included in the name. Maximum length 128 characters.
• Segment criteria: The targeting criteria describes how the segment will be applied to line items in your ad server. Segment criteria should be left blank for “Third Party Ad Server” segment collections. See information below on how on segment criteria.
• Loading: The loading will be applied on top of the products CPM or CPD rate. If left blank it will be treated as a $0 loading.
• Options: Support is currently limited to the ‘DEFAULT’ option. Segments with this option will automatically be added to new line items.

The segment criteria describes how targeting will be applied to the line item in your ad server. We support a number of standard logical operators to allow you to represent both simple and complex segment targeting requirements. Capabilities vary based on the capabilities of your ad server.

Google DFP segment targeting criteria

Adslot supports DFP’s key-value targeting (both predefined and free-form) and audience segment targeting. These can be combined to create simple or complex targeting criteria easily.

• Comparators ‘=’ (equal) and ‘!=’ (not equal) allow positive and negative targeting of key-values and audience segments. Note: the key (including ‘AudienceSegmentId’ must be on the left hand side of the comparator)
• Example: city=melbourne
• Example: make=”mercedes benz”
• Example: AudienceSegmentId=123456
• Logical operators ‘AND’ and ‘OR’ allow targeting to be combined
• Example: section=news AND section=finance AND section=technology
• Parenthesis ‘()’ may be used for creating more complex targeting criteria.
• Example: gender=female OR (AudienceSegmentId=123456 AND gender!=male)
• Comparators may be applied to a list of values or audience segment ids.
• Example: section=news,finance,technology
• Example: AudienceSegmentIds=123456,98765,2468024

SAS

Adslot supports SAS Targets as the primary form of targeting. This allows you to reuse complex targeting settings that you have already configured in your ad server for your sales and ad operations team.

• Comparator ‘=’ (equal) is the only supported comparator supported.
• Example: target=BMW
• Example: target=”News and Finance”
• In addition to supporting SAS Targets, Adslot also supports Site, Area and Tag targeting.
• Example: site=”NY Times”
• Example: area=Business
• Example: Suburb=port_melbourne
  In this example the tag is ‘Suburb’ and the value is ‘port_melbourne’

OpenX

Documentation coming soon. Please contact our support team for further information.

Updating segments or segment collection

Segment collections can be updated with new segments, remove existing segments or modify existing segments. To do this open the corresponding segment collection and download the CSV.

To add a new segment to a segment collection, add a new row to the bottom of the CSV. Remember to leave the ‘internal id’ column empty for new segments.

To remove a segment from a segment collection, delete the corresponding row.

To update the loading, name or targeting criteria of an existing segment, you can edit the corresponding row. Be careful not to change the ‘internal id’ as this will cause the old segment to be archived.