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 to Kelkoo.
-
Add Kelkoo as a Web Connect datastream.
Create a Web Connect to Kelkoo
-
Go to the page.
-
In the top right corner, click + Create Authorization.
-
Search for and click Web Connect.
-
Click Next.
-
Click Setup a new Authorization.
-
Click Next.
-
In Authorization method, select Bearer Token.
-
In Authorization token, enter the authorization token generated in the Kelkoo user interface.
-
Click Authorize.
As a result, you have created a Web Connect to Kelkoo to use in a datastream.
Adding Kelkoo as a Web Connect datastream
To add Kelkoo as a datastream, follow these steps:
-
Go to the Datastreams page.
-
In the top right corner, click + Create datastream.
-
Search for and click Web Connect.
-
Select the Kelkoo Web Connect you created earlier.
-
Click Next.
-
Under Request, in the URL field, enter the request URL of the report on which you want to collect data.
-
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.
-
In Request Method, select GET.
-
In Parser, select JSON.
-
In Encoding, select UTF-8.
-
Click Next.
Collecting initial data
To collect the initial data, follow these steps:
-
Choose the time period for which data is collected. This auto-populates the date placeholders in the previous step with the dates you choose.
-
Click Run fetch.
Choosing where to load your data
To choose where to load your data, follow these steps:
-
To assign destinations to your datastream, select their checkboxes. For more information on destinations and their configuration settings, see Loading data into destinations.
-
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:
-
In the All tasks tab, find the task at the top of the list, and click Show extracts.
-
Click the top hyperlink.
-
The data extract is displayed in a table containing the data that you have fetched.
What's next?
-
Apply Data Mapping to your collected data to harmonize data collected from different sources in Adverity.
-
Transform your data to meet your needs by creating and applying enrichments to your datastream.
-
Load your data into Explore & Present to visualize your data in Adverity
-
Load your data into an external destination of your choice