Home Knowledge Base FAQ - Connecting Services How do I set up and connect Kenshoo?

Frequently Asked Questions

Connecting Services

General Questions

Services

Data Discrepancy

How do I set up and connect Kenshoo?


To set up and connect to Kenshoo in TapClicks, you will need to take a couple of steps first. You will need to set up four reports in Kenshoo with the following settings, be sure to write down the Report IDs for reference as we will need them for the Manage Services page when connecting. 
  • First Report is a Mapping List 
    • Frequency - Daily
    • Date Range - Last 30 Days
    • Roll Up - Aggregate for the whole date range
    • Columns and Order
      • 'Currency'
      • 'Profile Name'
      • 'Profile ID'
      • 'Campaign ID in Kenshoo'
      • 'Campaign Name'
      • 'Impressions'
  • Second Report is Campaign Level Data
    • Frequency - Daily
    • Date Range - Last 30 Days
    • Roll Up - By Day (meaning, separate rows in the file for each day in the last 30 days)
    • Columns and Order
      • 'Currency'
      • 'Date'
      • 'Profile Name'
      • 'Profile ID'
      • 'Campaign Id in Kenshoo'
      • 'Status'
      • 'Channel'
      • 'Campaign Name'
      • 'Impressions'
      • 'Clicks'
      • 'CTR'
      • 'Avg CPC'
      • 'Avg Pos.'
      • 'Calls'
      • 'Conversions'
      • 'Conv. Rate'
      • 'Cost/Conv.'
      • 'Cost'
      • 'Profit'
      • 'Rev.'
      • 'Rev./Conv.'
      • 'ROI'
  • Third is AdGroup Level Data
    • Frequency - Daily
    • Date Range - Last 30 Days
    • Roll Up - By Day (meaning, separate rows in the file for each day in the last 30 days)
    • Columns and Order
      • 'Currency'
      • 'Date'
      • 'Profile Name'
      • 'Profile ID'
      • 'Campaign Id in Kenshoo'
      • 'Status'
      • 'Channel'
      • 'Campaign Name'
      • 'AdGroup'
      • 'AdGroup ID in Kenshoo'
      • 'Impressions'
      • 'Clicks'
      • 'CTR'
      • 'Avg CPC'
      • 'Avg Pos.'
      • 'Calls'
      • 'Conversions'
      • 'Conv. Rate'
      • 'Cost/Conv.'
      • 'Cost'
      • 'Profit'
      • 'Rev.'
      • 'Rev./Conv.'
      • 'ROI'
  • Forth Report is the Data File
    • Frequency - Daily
    • Date Range - Last 30 Days
    • Roll Up - By Day (meaning, separate rows in the file for each day in the last 30 days)
    • Columns and Order
      • 'Currency'
      • 'Date'
      • 'Profile Name'
      • 'Profile ID'
      • 'Campaign Id in Kenshoo'
      • 'Status'
      • 'Channel'
      • 'Campaign Name'
      • 'AdGroup'
      • 'AdGroup ID in Kenshoo'
      • 'Keyword'
      • 'Keyword Id in Kenshoo'
      • 'Impressions'
      • 'Clicks'
      • 'CTR'
      • 'Avg CPC'
      • 'Avg Pos.'
      • 'Calls'
      • 'Conversions'
      • 'Conv. Rate'
      • 'Cost/Conv.'
      • 'Cost'
      • 'Profit'
      • 'Rev.'
      • 'Rev./Conv.'
      • 'ROI'
  • IS File
    • Note that this file is not required - if you opt to not create it you can leave the cell in Manage Services blank
    • If blank, the fields that are sourced by this file in the Reporting Profile will be empty if they are turned on
    • Frequency - Daily
    • Date Range - Last 30 Days
    • Roll Up - By Day (meaning, separate rows in the file for each day in the last 30 days)
    • Columns and Order
      • 'Currency'
      • 'From'
      • 'To'
      • 'Profile Name'
      • 'Profile ID'
      • 'Campaign ID in Kenshoo'
      • 'Status'
      • 'Channel'
      • 'Campaign Name'
      • 'Imp. Share'
      • 'Lost IS-rank'
  • No special file name is needed
  • The file format should be set to .csv
  • In the Delivery Format section the option to Compress Files should be set for only files greater than 40mb in size