Collecting data from Kelkoo

Follow this guide to collect data from Kelkoo and preview the data.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Generate an authorization token in the Kelkoo user interface. This token must be in the form of JWT (JSON Web Token). For more information, see the Kelkoo documentation.

  • Get the request URL of the report on which you want to collect data. For more information on how to create these URLs, see the Kelkoo documentation.

Connecting to Kelkoo

To collect data from Kelkoo, complete the following:

  • Create a Web Connect authorization to Kelkoo.

  • Add Kelkoo as a Web Connect datastream.

Create a Web Connect authorization to Kelkoo

  1. Go to the Authorizations page.

  2. In the top right corner, click + Create Authorization.

  3. Search for and click Web Connect.

  1. Click Next.

  1. Click Setup a new Authorization.

  1. Click Next.

  1. In Authorization method, select Bearer Token.

  2. In Authorization token, enter the authorization token generated in the Kelkoo user interface.

  3. Click Authorize.

As a result, you have created a Web Connect authorization to Kelkoo to use in a datastream.

Adding Kelkoo as a Web Connect datastream

To add Kelkoo as a datastream, follow these steps:

  1. Go to the Datastreams page.

  2. In the top right corner, click + Create datastream.

  3. Search for and click Web Connect.

  4. Select the Kelkoo Web Connect authorization you created earlier.

  1. Click Next.

  1. Under Request, in the URL field, enter the request URL of the report on which you want to collect data.

  2. To add date range metadata to the data extract, replace the date configuration at the end of the URL with the following placeholders:

    ?startDate={start}&endDate={end}

    The start and end dates are automatically updated with the date range for the data fetch, which you select in the next step. For example, updating the date configuration to the end of the URL would look like this:

    https://api.kelkoogroup.net/merchant/statistics/v1/product/CAMPAIGN_ID?startDate={start}&endDate={end}

    Replace CAMPAIGN_ID with ID of the campaign on which to collect data.

    One account may contain multiple campaign IDs. To collect data on multiple campaigns at once, add a value table that contains the campaign IDs to the URL. For more information, see the Request section of the Web Connect guide.

  3. In Request Method, select GET.

  4. In Parser, select JSON.

  5. In Encoding, select UTF-8.

  1. Click Next.

Collecting initial data

To collect the initial data, follow these steps:

  1. Choose the time period for which data is collected. This auto-populates the date placeholders in the previous step with the dates you choose.

  1. Click Run fetch.

Choosing where to load your data

To choose where to load your data, follow these steps:

  1. To assign destinations to your datastream, select their checkboxes. For more information on destinations and their configuration settings, see Loading data into destinations.

  1. Click Next.

Previewing data collected from Kelkoo

The fetch collects data from Kelkoo which takes some time. The Overview page of the newly created datastream is now displayed. To preview the collected data, follow these steps:

  1. In the All tasks tab, find the task at the top of the list, and click Show extracts.

  2. Click the top hyperlink.

  3. The data extract is displayed in a table containing the data that you have fetched.

What's next?