MKT_SEM_ADGROUP_RESULTS
This table will be used to store SEM Ad group Results.Total impressions, click and such other data about individual Search Engine Marketing ad groups.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MKT_SEM_ADGROUP_RESULTS_PK |
ADGROUP_ID, REPORTDATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONNECTIONID | NUMBER | 18 | Connection ID. This is the connection ID under which the adgroup is created. | ||
| ADGROUP_ID | NUMBER | 18 | Yes | Ad Group ID (as generated on Fusion side) | |
| VENDOR_ADGROUP_ID | VARCHAR2 | 1000 | Vendor's Ad group ID as assigned on the vendor side. | ||
| ADGROUP | VARCHAR2 | 1000 | the name/description associated with an ad group. | ||
| CAMPAIGN_ID | NUMBER | 18 | Campaign ID that is associated with this ad group | ||
| REPORTDATE | DATE | Yes | Report Date. this is the date against which the activity of a given ad group will be noted. | ||
| STATUS | VARCHAR2 | 1000 | Status of the ad group as provided by SEM vendor. | ||
| IMPRESSIONS | NUMBER | Impressions for a given ad group on a given day. | |||
| CLICKS | NUMBER | Clicks for a given ad group on a given day. | |||
| CTR | NUMBER | Click Thru Rate for a given ad group on a given day. | |||
| AVGCPC | NUMBER | Average Cost per click for a given ad group on a given day. | |||
| COST | NUMBER | Cost for a given ad group on a given day. | |||
| AVGPOSITION | NUMBER | 'Average position' is a statistic attributed to each of your adgroups. It refers to the average position on a search result page that an ad appears in when it's triggered by that ad group. | |||
| CURRENCY | VARCHAR2 | 1000 | Currency associated with a given ad group | ||
| AVGCPM | NUMBER | It's your average cost of 1000 impressions for your ad group or search keyword. | |||
| 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_ADGROUP_RESULTS | mkt_sem_camp_adgroups | ADGROUP_ID |
| MKT_SEM_ADGROUP_RESULTS | mkt_sem_campaigns | CAMPAIGN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_SEM_ADGROUP_RESULTS_U1 | Unique | Default | ADGROUP_ID, REPORTDATE |