MKT_SEM_KEYWORD_RESULTS

This table will be used to store SEM Keyword Results.Total impressions, click and such other data about individual Search Engine Marketing keywords.

Details

• Schema: FUSION

• Object owner: MKT

• Object type: TABLE

• Tablespace: USERS

Primary Key

Name	Columns
MKT_SEM_KEYWORD_RESULTS_PK	KEYWORDID, REPORTDATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONNECTIONID	NUMBER		18	Yes	Connection Id
KEYWORDID	NUMBER		18	Yes	Keyword Id
VENDOR_KW_ID	VARCHAR2	1000			Vendor Keyword Id
KEYWORD	VARCHAR2	1000			Keyword
REPORTDATE	DATE			Yes	Report Date
STATUS	VARCHAR2	1000			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_KEYWORD_RESULTS	mkt_sem_campaign_keyword	KEYWORDID

Indexes

Index	Uniqueness	Tablespace	Columns
MKT_SEM_KEYWORD_RESULTS_U1	Unique	Default	KEYWORDID, REPORTDATE
MKT_SEM_KEY_RESULTS_N1	Non Unique	Default	CONNECTIONID, KEYWORDID, REPORTDATE