Campaigns (Table)

campaigns (Table)

Campaigns table contains most important data about how advertising campaign will be viewed.

Applies To

AdServer Database

Parameters

Parameter Name	Description
camp_id	A Long unique campaign autonumber
zone_id	A Long variable containing reference to zone
order_id	A Long variable containing reference to order
camp_type_id	A Byte variable containing campaign type
camp_sub_zones_active	A Boolean variable determining if campaign will viewed also in sub zones
camp_from_dt	A Date variable containing date from whitch campaign will be viewed
camp_to_dt	A Date variable containing date to whitch campaign will be viewed
camp_from_tm	A Time variable containing time from whitch campaign will be viewed
camp_to_tm	A Time variable containing time to whitch campaign will be viewed
camp_weekday	A Byte variable containing binary sum of weekday type values
camp_client_max_count	A Integer variable used to targeting advertising to client max. count
camp_client_period_count	A Integer variable used to targeting advertising to client period count
camp_client_period_time	A Integer variable used to targeting advertising to client period time
camp_impr_count	A Long variable containing count of page-view, click-through, procent,...
camp_priority	A Long variable containing campaign priority
camp_desc	A Text variable containing campaign description
writer_id	A Long variable containing writer
write_dt	A Date variable containing date of write
change_dt	A Date variable containing date of change

Remarks

Parameter zone_id specify relationship to zones table.

Parameter order_id specify relationship to orders table.

Parameter camp_sub_zones_active determining if campaign will viewed also in sub zones. If value of the parameter is -1 (True, Yes), than the campaign will be viewed also in sub zones.

If there is at least one Free type campaign, defined on the higher page tree level, whitch can by resolved also in sub zones, and there is at least one Free type campaign on the zone, whitch belongs in sub set of the sub zones, then Free type campaign, whitch belongs exactly to the zone has higher priority, then that one, whitch comes from higher page tree level. Free type campaign defined on the higher level will be never viewed on the zone, because Free type campaign, defined exactly on the zone will use 100% of remaining advertising time space. This rule applies for all campaigns of the same types from different page tree levels, whitch meets on the same zone.

Example

Following example shows default campaign definition:

Parameter Name	Default value
camp_id	0
zone_id	0
order_id	0
camp_type_id	50
camp_sub_zones_active	-1
camp_from_dt	Null
camp_to_dt	Null
camp_from_tm	Null
camp_to_tm	Null
camp_weekday	Null
camp_client_max_count	Null
camp_client_period_count	Null
camp_client_period_time	Null
camp_impr_count	0
camp_priority	Null
camp_desc	""
writer_id	-2
write_dt	Now()
change_dt	Null

See Also

campaign_types, campaign_zones, orders, zones