Integration of Domodi & Allani with BigQuery

Learn how to connect Domodi and Allani to Google BigQuery using WitCloud. Collect daily category statistics of your shops - clicks, transactions, revenue and cost - and analyze them next to the rest of your data.

Updated

Introduction

This integration connects the Domodi and Allani fashion platforms to Google Cloud BigQuery. For every day it collects the category statistics of your shops: clicks, transactions, average basket, revenue, cost, COS and conversion rate. Domodi and Allani data land in separate tables.

Configuration guide

Follow the steps below to connect Domodi & Allani with BigQuery. Once the setup is complete, your data will be transferred to your BigQuery project.

Module setup

Go to Integrations in the menu and click Add integration.

Integrations list with the Add integration button

Select Domodi & Allani from the list of available integrations.

Integration catalog with Domodi & Allani selected

Enter the Collect name, e.g., "Domodi PL".

Collect name field filled in with the example name Domodi PL

Authorization

If you have previously authorized the Domodi & Allani module, you can skip this step and pick the existing authorization from the Select Domodi authorization drop-down.

WitCloud connects to Domodi with an API token. To generate it, open the API integration page of the Domodi panel using this link, set the date the token is valid until and click Generuj (Generate). The token expires on that date or when the user's password is reset - then generate a new one.

Domodi API integration page with the Valid until field and the Generate button

Copy the generated token, go back to WitCloud and click Authorize.

Authorize button next to the Select Domodi authorization field

Paste the token into the Access token field of the Authorize form and click Create.

Authorize pop-up with the Access token field filled with a placeholder value

Once an authorization is selected, the button changes to Re-authorize. Use it when your token has expired: paste the new token and it replaces the old one.

Shop selection

Select one or more shops from the Select shops drop-down. Each selected shop becomes its own data collect, named after the collect name and the shop, e.g. "Domodi PL - demo-shop.pl".

Select shops drop-down open with two example shops

Optionally, click Show advanced settings. Tables to collect lets you filter the tables you want to collect: domodi_category_statistics and allani_category_statistics. By default both are selected, and at least one table is required.

Advanced settings open with the Tables to collect field showing both tables

Click Next.

Historical data and scheduling

In Historical Data, enter the number of days for which you want to fetch historical data. You can enter up to 365 days.

Historical Data field filled in with 365 days

A data synchronization schedule will be created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

Done! Your Domodi and Allani data will now be synchronized with BigQuery.

Data schema

Expand the tables below to view the full data schema collected from Domodi & Allani. Both tables have the same schema: one row is one category of one shop on a given day.

Data schema for domodi_category_statistics
Field NameModeType
dateNULLABLEDATE
categoryNULLABLESTRING
shopNameNULLABLESTRING
clicksNULLABLEINTEGER
transactionsNULLABLEINTEGER
averageBasketNULLABLEFLOAT
transactionRevenueNULLABLEFLOAT
costNULLABLEFLOAT
COSNULLABLESTRING
CRNULLABLESTRING
Data schema for allani_category_statistics
Field NameModeType
dateNULLABLEDATE
categoryNULLABLESTRING
shopNameNULLABLESTRING
clicksNULLABLEINTEGER
transactionsNULLABLEINTEGER
averageBasketNULLABLEFLOAT
transactionRevenueNULLABLEFLOAT
costNULLABLEFLOAT
COSNULLABLESTRING
CRNULLABLESTRING