Pricemania SK extractor for Keboola

KBC Docker app for extracting data from Pricemania SK (http://pricemania.sk)

The Extractor gets list of campaign stats for previous day and saves the data to Storage API. Date of downloaded stats can be changed in configuration.

Configuration

• parameters:

  • username - Username to pricemania.sk
  • password - Password to pricemania.sk
  • bucket - Name of bucket where the data will be saved
  • since (optional) - start date of downloaded stats (default is "-1 day")
  • until (optional) - end date of downloaded stats (default is "-1 day")

• Example configuration:

      {
          "username": "email@example.sk",
          "#password": "secret_password",
          "bucket": "in.c-ex-pricemania-sk",
          "since": "-35 day"
      }

Output

Data are saved into table incrementally:

stats - contains marketing stats, columns are:

• date
• visits
• cpc
• spend
• conversion_rates
• orders
• aov
• transaction_revenue
• pno

NOTICE!

• Data can change for last 30 days

Installation

If you want to run this app standalone:

1. Clone the repository: git@bitbucket.org:matla/pricemania-sk-extractor.git ex-pricemania-sk

2. Go to the directory: cd ex-pricemania-sk

3. Install composer: curl -s http://getcomposer.org/installer | php

4. Install packages: php composer.phar install

5. Create folder data

6. Create file data/config.yml with configuration, e.g.:

   parameters:
     username:
     password:
     bucket: in.c-pricemania-sk
   

7. Run: php src/run.php --data=./data

8. Data tables will be saved to directory data/out/tables