CREATE TABLE mkt_sem_ad_results (
    AD_ID                NUMBER(18, 0) ,
    VENDOR_AD_ID         VARCHAR2(4000),
    ADGROUP_ID           NUMBER(18, 0) ,
    CONNECTIONID         NUMBER(18, 0) ,
    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        ,
    DESCRIPTION_LINE1    VARCHAR2(4000),
    DESCRIPTION_LINE2    VARCHAR2(4000),
    DESCRIPTION_LINE3    VARCHAR2(4000),
    DESTINATION_URL      VARCHAR2(4000),
    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) ,
    AD_ID                NUMBER(18, 0) ,
    VENDOR_AD_ID         VARCHAR2(4000),
    ADGROUP_ID           NUMBER(18, 0) ,
    CONNECTIONID         NUMBER(18, 0) ,
    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        ,
    DESCRIPTION_LINE1    VARCHAR2(4000),
    DESCRIPTION_LINE2    VARCHAR2(4000),
    DESCRIPTION_LINE3    VARCHAR2(4000),
    DESTINATION_URL      VARCHAR2(4000),
    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_ad_results PRIMARY KEY (AD_ID, REPORTDATE, AD_ID, REPORTDATE)
);
