Get Amazon Sp Data via the 'Windsor.ai' API.

amazonspR

The goal of amazonspR is to help R users to access Amazon Sp digital marketing data via Windsor.aiAPI in a convenient way from R.

Windsor.ai allows to get marketing data from any platform. It beautifully simplifies the complexity of dealing with multiple platforms, unlocking unified, valuable information in a format that matters to you. For more details checkout onboard.windsor.ai.

Installation

You can install the development version of amazonspR from GitHub with:

# install.packages("devtools")
devtools::install_github("pablosanchezmart/amazonspR")

Usage

Registration

You need to get a free API key to access windsor.ai's APIs. Register your account first and add a data source like Amazon Sp and then get the API key. For more details check out our official API documentation and this article. Get the API key at https://onboard.windsor.ai. You have a 30 days trial for free.

Example

The package currently has only one function fetch_amazonspR which will return a data.frame provided that all of the arguments are supplied to it:

• your API key,
• date range, (starting and ending date)
• and fields you require.

Running:

library(amazonspR)

my_amazonsp_data <-
  fetch_amazonsp(api_key = "your api key",
           date_from = Sys.Date()-100,
           date_to = Sys.Date(),
           fields = c("campaign", "clicks",
                      "spend", "impressions", "date")) 

'data.frame':	14 obs. of  5 variables:
 $ campaign   : chr  "retageting APAC" "retargeting UK&CO" "retageting APAC" "retargeting UK&CO" ...
 $ clicks     : num  4 0 5 7 0 0 4 2 3 0 ...
 $ spend      : num  2.57 2.48 2.39 2.54 0.94 0.71 2.59 2.12 2.43 0.13 ...
 $ impressions: num  806 693 819 689 299 190 682 688 822 135 ...
 $ date       : chr  "2022-09-28" "2022-09-28" "2022-09-29" "2022-09-29" ...

Will return a data.frame with Amazon Sp marketing data.

For more details see the API documentation at https://windsor.ai//api-fields/.