MKT_SEM_AD_RESULTS
This table will be used to store SEM Ad Results.Total impressions, click and such other data about individual Search Engine Marketing ads.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MKT_SEM_AD_RESULTS_PK |
AD_ID, REPORTDATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AD_ID | NUMBER | 18 | Yes | Ad ID generated on Fusion side. This is different than the vendor ad id. | |
| VENDOR_AD_ID | VARCHAR2 | 1000 | AD ID as provided by SEM Vendor | ||
| ADGROUP_ID | NUMBER | 18 | Ad group ID that this AD is associated with. | ||
| CONNECTIONID | NUMBER | 18 | Connection ID. This is the connection ID under which the AD is created. | ||
| CAMPAIGN_ID | NUMBER | 18 | Campaign ID to which this AD is associated to. | ||
| REPORTDATE | DATE | Yes | Report date for this particular ad against which the stats will be reported. | ||
| STATUS | VARCHAR2 | 1000 | Status of a given ad as provided by SEM Vendor. | ||
| IMPRESSIONS | NUMBER | Impressions for a ad on a given report date. | |||
| CLICKS | NUMBER | Clicks for a ad on a given report date. | |||
| CTR | NUMBER | Click Thru Rate for a ad on a given report date. | |||
| AVGCPC | NUMBER | Average cost per click for a ad on a given report date. | |||
| COST | NUMBER | Cost associated for a ad on a given report date. | |||
| AVGPOSITION | NUMBER | 'Average position' is a statistic attributed to each of your ad. It refers to the average position on a search result page that an ad appears in when it's triggered by that keyword. | |||
| CURRENCY | VARCHAR2 | 1000 | Currency associated with a given ad. | ||
| AVGCPM | NUMBER | It's your average cost of 1000 impressions for your ad group or search keyword. | |||
| DESCRIPTION_LINE1 | VARCHAR2 | 1000 | The text that will be included in line 1 of the advertisement. | ||
| DESCRIPTION_LINE2 | VARCHAR2 | 1000 | The text that will be included in line 2 of the advertisement. | ||
| DESCRIPTION_LINE3 | VARCHAR2 | 1000 | The text that will be included in line 3 of the advertisement. | ||
| DESTINATION_URL | VARCHAR2 | 1000 | Destination URL (if any) associated with a given ad. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MKT_SEM_AD_RESULTS | mkt_sem_campaign_ads | AD_ID |
| MKT_SEM_AD_RESULTS | mkt_sem_campaigns | CAMPAIGN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_SEM_AD_RESULTS_U1 | Unique | Default | AD_ID, REPORTDATE |