MKT_SEM_CAMPAIGN_KEYWORD
This table will be used to store SEM Campaign Keywords. Search Engine Marketing campaign adgroups are triggered by one or many keywords. These keywords will be stored in this table. This table is associated with Adgroups table. For a given AdGroup, there can be multiple keywords.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: USERS
Primary Key
| Name | Columns |
|---|---|
|
MKT_SEM_CAMPAIGN_KEYWORD_PK |
KEYWORDID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| KEYWORDID | NUMBER | 18 | Yes | Keyword Id | |
| VENDOR_KW_ID | VARCHAR2 | 1000 | Vendor Keyword Id | ||
| ADGROUPID | NUMBER | 18 | AD group Id | ||
| CAMPAIGNID | NUMBER | 18 | Campaign Id | ||
| SEM_VENDOR | VARCHAR2 | 1000 | SEM Vendor | ||
| CURRENTSTATUS | VARCHAR2 | 1000 | Current Status | ||
| CURRENTBUDGET | NUMBER | Current Budget | |||
| CURRENTBUDGETCURRENCY | VARCHAR2 | 1000 | Current Budget Currency | ||
| CLICKS | NUMBER | Clicks | |||
| IMPRESSIONS | NUMBER | Impressions | |||
| CTR | NUMBER | Click Thru Rate | |||
| AVGCPC | NUMBER | Average CPC | |||
| AVGPOSITION | NUMBER | 'Average position' is a statistic attributed to each of your keywords. It refers to the average position on a search result page that an ad appears in when it's triggered by that keyword. | |||
| AVGCPM | NUMBER | It's your average cost of 1000 impressions for your ad group or search keyword. | |||
| COST | NUMBER | Cost | |||
| CONNECTIONID | NUMBER | 18 | Connection Id | ||
| KEYWORD_TEXT | VARCHAR2 | 1000 | Keyword Text | ||
| STARTDAY | DATE | Start Date | |||
| ENDDAY | DATE | End Date | |||
| CRITERIONTYPE | VARCHAR2 | 1000 | Criterion Type | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MKT_SEM_CAMPAIGN_KEYWORD | mkt_sem_camp_adgroups | ADGROUPID |
| mkt_sem_keyword_results | mkt_sem_campaign_keyword | KEYWORDID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_SEM_CAMP_KEYWORD_N1 | Non Unique | Default | CAMPAIGNID, ADGROUPID |
| MKT_SEM_CAMP_KEYWORD_PK1 | Unique | Default | KEYWORDID |