Weekly Paid Search Data

Another key source of keywords will come from your paid search campaigns and analytic software, this will enable the co-optimization analysis. 

CSV Export

Using a CSV export allows you to get the most critical data into the application quickly and easily and is the typical method we use for pilots since it requires no interaction with and 3rd party vendors or technical resources.  

Sample Format

For paid search analysis we need the following data elements: 

Data file by Search Engine

Campaign

Ad Group

Keyword

Match Type

Keyword Status

Imp

Clicks

Cost

Conv

Revenue

Avg Position

CPC

H_1_New_States

Rajasthan

rajasthan hotel

Phrase

Active

27

0

0.00

0

0

5.37

0.00

 

Note:  The following are all of the Paid Search Variables we can store.  The above CSV format reflects those which are required but you may submit any of the optional data points listed below.

Description

Data

Format

Search Engine Name

Required

bigint(20)

Keyword Status (active/paused)

Required

varchar(200)

Campaign Name

Required

varchar(200)

Ad Group Name

Required

varchar(200)

Match Type

Required

varchar(200)

PPC Impressions

Required

bigint(20)

PPC Total Clicks

Required

bigint(20)

Media Spend

Required

decimal(24,12)

Average Cost Per Click

Required

decimal(24,12)

Total Purchases/Conversions

Required

decimal(24,12)

Total Revenue

Required

decimal(24,12)

Average Position of PPC Ad

Required

decimal(24,12)

Keyword ID (source tool)

Optional

bigint(20)

Campaign Owner

Optional

bigint(20)

PPC Share of Voice

Optional

decimal(24,12)

Average Click Rate

Optional

decimal(24,12)

Leads Generate

Optional

bigint(20)

Leads Generated Percentage

Optional

decimal(24,12)

Lead Conversion Percentage

Optional

decimal(24,12)

Cost Per Action Percentage

Optional

decimal(24,12)

Average Cost Per Order

Optional

bigint(20)

Total Conversions

Optional

bigint(20)

Total Percent of Conversions

Optional

decimal(24,12)

Total Conv. - Cost Per Order

Optional

bigint(20)

Average Order Size

Optional

decimal(24,12)

Return on Investment (ROI)

Optional

decimal(24,12)

Return on Ad Spend (ROAS)

Optional

decimal(24,12)

Profit

Optional

decimal(24,12)

Average Order Profit

Optional

decimal(24,12)

Keyword Last Modified Time

Optional

timestamp

Keyword Last Modified User

Optional

bigint(20)

Total Cost Per Action

Optional

bigint(20)

Keyword/Campaign Start Date

Optional

date

Keyword/Campaign End Date

Optional

date

Active Status of Keyword

Optional

char(1)

If you prefer, you can give us access to your paid search account and we can import the data via the API.   For this we need to get your account ID and we will send a request via the AdWords System. Once you receive the API connection request simply approve it and we can import the campaign data.