ManPageW WebAdManagement
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Contents
Window: Web Ad Management
Description : Content Management Ad Management defines the needed categories and items
Help : Ad Management is used to create and manage advertisements in your conten management
Tab: Advertisement Category
Description : Defines the categories to group Ads
Help :
Table Name : CM_Ad_Cat
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Web Project | A web project is the main data container for Containers, URLs, Ads, Media etc. | A web project is the meta definition which will contain later on all data within the Web Content Management Project. | CM_WebProject_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Tab: Advertisement
Description : The Advertisement
Help :
Table Name : CM_Ad
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Advertisement Category | Advertisement Category like Banner Homepage | The advertisement category defines a container for ad's like for example all banners used on the homepage in rotation are stored in a category "Banner Homepage" etc. | CM_Ad_Cat_ID
NUMBER(10) TableDir |
Media Item | Contains media content like images, flash movies etc. | This table contains all the media content like images, flas movies etc. | CM_Media_ID
NUMBER(10) TableDir |
Actual Click Count | How many clicks have been counted | Contains info on the actual click count until now | ActualClick
NUMBER(10) Integer |
Max Click Count | Maximum Click Count until banner is deactivated | A banner has a maximum number of clicks after which it will get deactivated | MaxClick
NUMBER(10) Integer |
Actual Impression Count | How many impressions have been counted | Contains info on the actual impression count until now | ActualImpression
NUMBER(10) Integer |
Max Impression Count | Maximum Impression Count until banner is deactivated | A banner has a maximum number of impressions after which it will get deactivated | MaxImpression
NUMBER(10) Integer |
Start Count Impression | For rotation we need a start count | If we run banners in rotation we always show the one with the min of impressions, so if a new banner is added to impressions we don't want it to show up so often we set a startimpressions value. StartImpression+ActualImpression=CurrentImpression | StartImpression
NUMBER(10) Integer |
Start Date | First effective day (inclusive) | The Start Date indicates the first or starting date | StartDate
DATE DateTime |
End Date | Last effective date (inclusive) | The End Date indicates the last date in this range. | EndDate
DATE DateTime |
Content HTML | Contains the content itself | Contains the content itself as HTML code. Should normally only use basic tags, no real layouting | ContentHTML
NVARCHAR2(2000) Text |
Logging | Do we need to log the banner impressions and clicks? (needs much performance) | As of performance we should only log banners if really necessary, as this takes a lot of performance | IsLogged
CHAR(1) YesNo |
Special AD Flag | Do we need to specially mention this ad? | If we have a block in content where anounce content and also sponsored links we should mention the sponsored ones | IsAdFlag
CHAR(1) YesNo |
Target URL | URL for the Target | URL of the Target Site | TargetURL
NVARCHAR2(120) String |
Target Frame | Which target should be used if user clicks? | Do we want the content to stay in same window, to open up a new one or to place it in a special frame? | Target_Frame
NVARCHAR2(20) String |
Tab: Ad Cat Template
Description : Advertisement Category link to Template
Help :
Table Name : CM_Template_Ad_Cat
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Advertisement Category | Advertisement Category like Banner Homepage | The advertisement category defines a container for ad's like for example all banners used on the homepage in rotation are stored in a category "Banner Homepage" etc. | CM_Ad_Cat_ID
NUMBER(10) TableDir |
Template | Template defines how content is displayed | A template describes how content should get displayed, it contains layout and maybe also scripts on how to handle the content | CM_Template_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |