Kenshoo Skai Integration

Kenshoo Skai Integration

Objective

This guide provides step by step instructions for building a custom report in Kenshoo Skai. This custom report can then be sent as an automated daily extract for paid data integration into seoClarity.


Requirements

To complete this walkthrough you will need a Kenshoo Skai account. 

                    

Setup A New Report

1. In the top navigation menu, hover over the Reports dropdown

2. Select Scheduled Reports

3. On the Scheduled Reports page, click on the Add button, above the data table 

     

Report Details          

4. Report Scope: choose Multiple Profiles

5. Report Name: <Your Domain> - Kenshoo Skai report
Replace <Your Domain> with the domain being integrated. This is the email subject line and including the domain name is required for integration. 

6. Report Template: Fusion: Keywords

 

            

Report Parameters 

7. Aggregation: Daily

8. Time Range: Yesterday

9. Currency: USD$ 

10. Channels: All (pre-selected)

11. Dimension: Not Selected

12. Profiles: <Your Domain>  

      Replace <Your Domain> with the domain the report is based on.

13. Conversion Types: Not Selected

14. Show Revenue per conversion type: Do not click the checkbox  

                 

Report Content       

15. Output Format: Delimited Values (eg. CSV)

16. Columns:

  • Profile Name (pre-selected)
  • Campaign Name (pre-selected)
  • Channel (pre-selected)
  • Adgroup (pre-selected)
  • Keyword (pre-selected)
  • Search Term
  • Status
  • Quality Score (optional)
  • Date
  • Impressions
  • Clicks
  • Conversions
  • Cost
  • Avg. CPC
  • Avg. Pos.
  • Rev. (optional)
  • Land URL (optional)

     

Delivery Method

16. Delivery Method: FTP or SFTP

17. Enter ftp://upload.seoclarity.net into the FTP URL text box. SFTP Username and credentials can be found via the Integration tab on the Settings page.

18. Compression Condition: Always Compress 

19. Compression Format: ZIP

20. Add Report's Summary Info: Do not add

21. Add column titles to report file: Click the checkbox

22. Report Delimiter: , (comma) 

23. Remove delimiters from values: Do not click the checkbox

24. Custom filename for report: "<Your Domain>{CREATE_DATE:yyyy-MM-dd}". Replace <Your Domain> with the domain being integrated. 


        

Scheduling

26. Require yesterday's performance data: Click the checkbox

27. Run Report: Daily 

28. Create and send report now: Click the check box

29. Select the Create Report button

            

Summary    

Integrating Kenshoo Skai data into your seoClarity account allows you to see a side by side view of your organic data and paid data at the keyword level. Seeing this data will allow you to optimize your paid search campaigns.


    • Related Articles

    • Google Search Console Integration

      Google Search Console Integration Overview The objective of this integration is to authenticate a Google Search Console account within seoClarity. This integration takes the place of the previous Google Webmaster Tools integration. Background & ...

    • Custom PPC Integration

      Objective The following steps will show you how to integrate a custom PPC report, such as a system that is not currently documented, with seoClarity so your domain’s PPC data can be loaded into the platform. Requirements The most important ...

    • IBM Explore Analytics Integration

      Objective In your IBM Explore account, you are able to create and customize your own Explore report in order for you to see the data that is necessary for you analyze, monitor, manage, and optimize your SEO efforts. Explore reports are the preferred ...

    • Historical Ranking Data Integration

      Historical Ranking Data Integration Overview The following steps will show you how to integrate a historical rank data into seoClarity so your domain’s data can be loaded into the platform. Historical ranking data integration may incur an additional ...

    • Marin Software Integration

      Objective This guide will walkthrough how to setup a custom PPC report in Marin Software to send to the seoClarity team so that you are able to view the paid data in the platform along with all of your other SEO data. Requirements In order to ...