CREATE TABLE mkt_sem_adgroup_results (
    CONNECTIONID         NUMBER(18, 0) ,
    ADGROUP_ID           NUMBER(18, 0) ,
    VENDOR_ADGROUP_ID    VARCHAR2(4000),
    ADGROUP              VARCHAR2(4000),
    CAMPAIGN_ID          NUMBER(18, 0) ,
    REPORTDATE           DATE          ,
    STATUS               VARCHAR2(4000),
    IMPRESSIONS          NUMBER        ,
    CLICKS               NUMBER        ,
    CTR                  NUMBER        ,
    AVGCPC               NUMBER        ,
    COST                 NUMBER        ,
    AVGPOSITION          NUMBER        ,
    CURRENCY             VARCHAR2(4000),
    AVGCPM               NUMBER        ,
    CREATED_BY           VARCHAR2(256)     NOT NULL,
    CREATION_DATE        TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128) ,
    CONNECTIONID         NUMBER(18, 0) ,
    ADGROUP_ID           NUMBER(18, 0) ,
    VENDOR_ADGROUP_ID    VARCHAR2(4000),
    ADGROUP              VARCHAR2(4000),
    CAMPAIGN_ID          NUMBER(18, 0) ,
    REPORTDATE           DATE          ,
    STATUS               VARCHAR2(4000),
    IMPRESSIONS          NUMBER        ,
    CLICKS               NUMBER        ,
    CTR                  NUMBER        ,
    AVGCPC               NUMBER        ,
    COST                 NUMBER        ,
    AVGPOSITION          NUMBER        ,
    CURRENCY             VARCHAR2(4000),
    AVGCPM               NUMBER        ,
    CREATED_BY           VARCHAR2(256)     NOT NULL,
    CREATION_DATE        TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY      VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE     TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN    VARCHAR2(128) ,
    CONSTRAINT pk_mkt_sem_adgroup_results PRIMARY KEY (ADGROUP_ID, REPORTDATE, ADGROUP_ID, REPORTDATE)
);
