MKT_SEM_CAMP_RESULTS

This table will be used to store the SEM Campaign Results. Total impressions, click and such other data about individual Search Engine Marketing campaigns will be stored in this table. This table will be updated on a regular basis.

Details

• Schema: FUSION

• Object owner: MKT

• Object type: TABLE

• Tablespace: USERS

Primary Key

Name	Columns
MKT_SEM_CAMP_RESULTS_PK	CAMPAIGNID, REPORTDATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONNECTIONID	NUMBER		18	Yes	Connection Id
CAMPAIGNID	NUMBER		18	Yes	Campaign Id
VENDOR_CAMPAIGNID	VARCHAR2	1000			Vendor Campaign Id
CAMPAIGNNAME	VARCHAR2	1000			Campaign Name
REPORTDATE	DATE			Yes	Report Date
CAMPAIGNSTATUS	VARCHAR2	1000			Campaign Status
IMPRESSIONS	NUMBER				Impressions
CLICKS	NUMBER				Clicks
CTR	NUMBER				Click Thru Rate
AVGCPC	NUMBER				Average CPC
COST	NUMBER				Cost
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.
CURRENCY	VARCHAR2	1000			Currency
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_CAMP_RESULTS	mkt_sem_campaigns	CAMPAIGNID

Indexes

Index	Uniqueness	Tablespace	Columns
MKT_SEM_CAMP_RESULTS_N1	Non Unique	Default	CONNECTIONID, CAMPAIGNID, REPORTDATE
MKT_SEM_CAMP_RESULTS_U1	Unique	Default	CAMPAIGNID, REPORTDATE