· Home    · License/Purchase    · Online help    · FAQ    · Contact    · Download    · PAD    · AliaWeb   
 Personal finance » On-line Shop » Advertise server » OnLine help

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

Copyright © 1998 - 2018 Aliaweb, s.r.o.
All Rights Reserved