Loading you PPC Search Query Report CSV file into Bob’s Keywords

Bob's Keywords - Brain Image

To upload your PPC Search Query Report file into Bob’s Keywords, click on the “Add your PPC Search Query Report” button, option available on the Initial Project Screen. The upload screen will be shown.

Click on the “Click here to upload your file” button, then select your CSV file. The option “The uploaded file has a header line” is checked by default. Uncheck it ONLY IF your file does not have a header line. We encourage you to use files that include a header.

PPC Search Query Report - Upload your File

The upload process may take a few seconds, depending on the file size. The message “File has been uploaded” will be shown close to the file name when the upload process has finished.

After the upload process, click on the “Start Discovery Process” button. Bob’s will read your file and show you a list of all the fields present on it. In this screen, you will select your relevant fields.

Among all your fields, you need to select:

  • your Phrase Field, which must represent your Search Term (or Search Query)
  • your Numeric Fields, maximum of 6.

Please ensure you’re selecting the most relevant Numeric Fields that represent these data:

  • Clicks
  • Cost per Click
  • Impressions
  • Conversions
  • Cost Per Conversion
  • Conversion Rate

The example below shows the discovery process for a file extracted from a Google Ads account using the method described here. The Search Term field is selected as the Phrase Field, and the other fields are set as Numeric Fields.

PPC Search Query Report - Select your relevant fields

After finishing the field selection, press the Next button. On this screen, change the Numeric Fields label’s for shorter or more meaningful names if you want, then press Next again.

PPC Search Query Report - Change field labels

The final step is to inform Bob’s what data each field represents. The available types are Clicks, Impressions, Conversions, Cost per Click, Cost Per Conversion and Conversion Rates. Bob’s Keywords will try to guess the field contents for you. Please double-check the suggestions and fix the field types suggestion, if needed.

The next screen shows the selection of field contents for our previously loaded file.

PPC Search Query Report - Inform fields content

When you finish informing the content for each of your selected fields, press Next. Bob’s will then process your whole file, loading your data according to the selected fields and making the initial calculations. This process may take a bit of time, depending on the number of lines in your file. A confirmation message will notify you when the loading process is completed.

PPC Search Query Report - Search Query Report Loaded Successfully