ManPageW WebAdManagement

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

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

Contributions

Personal tools