Integration of Allegro with BigQuery
Learn how to integrate Allegro with Google BigQuery using WitCloud. Automatically fetch orders, products, and customer data, analyze it in real-time, and optimize your sales performance
Updated
Introduction
This module integrates with the Allegro API, enabling you to collect marketplace data and store it in Google Cloud BigQuery. Gain deeper insights into your data and optimize the performance of your marketing efforts.
Configuration guide
Follow the steps below to connect Allegro with BigQuery. Once the setup is complete, your Allegro data is transferred to your BigQuery project automatically.
Make sure you have admin access to your Allegro account before starting the configuration.
Module setup
Go to Integrations in the menu and click Add integration.

Select Allegro from the list of available integrations.

Enter the Collect name, e.g., Allegro PL. A clear name helps you recognise the data source later.

Authorization
If you have previously authorized the Allegro module and do not require additional permissions, you can skip this step and pick the existing account from the Select Allegro account drop-down.
Click Authorize.

Log in and grant the necessary permissions.

Select the appropriate account from the Select Allegro account drop-down list.

Advanced settings
Click Show advanced settings to change two optional settings:
- Data freshness (products): how often, in hours, tables like products are refreshed. Enter a value from 4 to 12.
- Tables to collect: the tables you want to collect. All tables are selected by default; remove the ones you do not need. At least one table must stay selected.

Click Next.
Historical data and scheduling
Enter the number of days of history in the Historical Data field. You can fetch up to 365 days of historical data.

A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.
Done! Your Allegro data will now be synchronized with BigQuery, providing you with detailed insights into the performance of your marketplace.
Data schema
Expand the tables below to view the full data schema collected from Allegro.
Data schema for allegro_billing_entries
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| occurredAt | NULLABLE | TIMESTAMP |
| type | NULLABLE | RECORD |
| โโ type.id | NULLABLE | STRING |
| โโ type.name | NULLABLE | STRING |
| value | NULLABLE | RECORD |
| โโ value.amount | NULLABLE | FLOAT |
| โโ value.currency | NULLABLE | STRING |
| tax | NULLABLE | RECORD |
| โโ tax.percentage | NULLABLE | FLOAT |
| balance | NULLABLE | RECORD |
| โโ balance.amount | NULLABLE | FLOAT |
| โโ balance.currency | NULLABLE | STRING |
| offer | NULLABLE | RECORD |
| โโ offer.id | NULLABLE | STRING |
| โโ offer.name | NULLABLE | STRING |
| order | NULLABLE | RECORD |
| โโ order.id | NULLABLE | STRING |
Data schema for allegro_categories
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| leaf | NULLABLE | BOOLEAN |
| name | NULLABLE | STRING |
| options | NULLABLE | RECORD |
| โโ options.advertisement | NULLABLE | BOOLEAN |
| โโ options.advertisementPriceOptional | NULLABLE | BOOLEAN |
| โโ options.variantsByColorPatternAllowed | NULLABLE | BOOLEAN |
| โโ options.offersWithProductPublicationEnabled | NULLABLE | BOOLEAN |
| โโ options.productCreationEnabled | NULLABLE | BOOLEAN |
| โโ options.customParametersEnabled | NULLABLE | BOOLEAN |
| โโ options.sellerCanRequirePurchaseComments | NULLABLE | BOOLEAN |
| parent | NULLABLE | RECORD |
| โโ parent.id | NULLABLE | STRING |
Data schema for allegro_orders
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| messageToSeller | NULLABLE | STRING |
| buyer | NULLABLE | RECORD |
| โโ buyer.id | NULLABLE | STRING |
| โโ buyer.email | NULLABLE | STRING |
| โโ buyer.login | NULLABLE | STRING |
| โโ buyer.firstName | NULLABLE | STRING |
| โโ buyer.lastName | NULLABLE | STRING |
| โโ buyer.companyName | NULLABLE | STRING |
| โโ buyer.guest | NULLABLE | BOOLEAN |
| โโ buyer.personalIdentity | NULLABLE | STRING |
| โโ buyer.phoneNumber | NULLABLE | STRING |
| โโ buyer.preferences | NULLABLE | RECORD |
| โ โโ buyer.preferences.language | NULLABLE | STRING |
| โโ buyer.address | NULLABLE | RECORD |
| โ โโ buyer.address.street | NULLABLE | STRING |
| โ โโ buyer.address.city | NULLABLE | STRING |
| โ โโ buyer.address.postCode | NULLABLE | STRING |
| โ โโ buyer.address.countryCode | NULLABLE | STRING |
| payment | NULLABLE | RECORD |
| โโ payment.id | NULLABLE | STRING |
| โโ payment.type | NULLABLE | STRING |
| โโ payment.provider | NULLABLE | STRING |
| โโ payment.finishedAt | NULLABLE | TIMESTAMP |
| โโ payment.paidAmount | NULLABLE | RECORD |
| โ โโ payment.paidAmount.amount | NULLABLE | FLOAT |
| โ โโ payment.paidAmount.currency | NULLABLE | STRING |
| โโ payment.reconciliation | NULLABLE | RECORD |
| โ โโ payment.reconciliation.amount | NULLABLE | FLOAT |
| โ โโ payment.reconciliation.currency | NULLABLE | STRING |
| โโ payment.features | REPEATED | STRING |
| status | NULLABLE | STRING |
| fulfillment | NULLABLE | RECORD |
| โโ fulfillment.status | NULLABLE | STRING |
| โโ fulfillment.shipmentSummary | NULLABLE | RECORD |
| โ โโ fulfillment.shipmentSummary.lineItemsSent | NULLABLE | STRING |
| delivery | NULLABLE | RECORD |
| โโ delivery.address | NULLABLE | RECORD |
| โ โโ delivery.address.firstName | NULLABLE | STRING |
| โ โโ delivery.address.lastName | NULLABLE | STRING |
| โ โโ delivery.address.street | NULLABLE | STRING |
| โ โโ delivery.address.city | NULLABLE | STRING |
| โ โโ delivery.address.zipCode | NULLABLE | STRING |
| โ โโ delivery.address.countryCode | NULLABLE | STRING |
| โ โโ delivery.address.companyName | NULLABLE | STRING |
| โ โโ delivery.address.phoneNumber | NULLABLE | STRING |
| โ โโ delivery.address.modifiedAt | NULLABLE | TIMESTAMP |
| โโ delivery.method | NULLABLE | RECORD |
| โ โโ delivery.method.id | NULLABLE | STRING |
| โ โโ delivery.method.name | NULLABLE | STRING |
| โโ delivery.pickupPoint | NULLABLE | RECORD |
| โ โโ delivery.pickupPoint.id | NULLABLE | STRING |
| โ โโ delivery.pickupPoint.name | NULLABLE | STRING |
| โ โโ delivery.pickupPoint.description | NULLABLE | STRING |
| โ โโ delivery.pickupPoint.address | NULLABLE | RECORD |
| โ โ โโ delivery.pickupPoint.address.street | NULLABLE | STRING |
| โ โ โโ delivery.pickupPoint.address.zipCode | NULLABLE | STRING |
| โ โ โโ delivery.pickupPoint.address.city | NULLABLE | STRING |
| โ โ โโ delivery.pickupPoint.address.countryCode | NULLABLE | STRING |
| โโ delivery.cost | NULLABLE | RECORD |
| โ โโ delivery.cost.amount | NULLABLE | FLOAT |
| โ โโ delivery.cost.currency | NULLABLE | STRING |
| โโ delivery.time | NULLABLE | RECORD |
| โ โโ delivery.time.from | NULLABLE | TIMESTAMP |
| โ โโ delivery.time.to | NULLABLE | TIMESTAMP |
| โ โโ delivery.time.guaranteed | NULLABLE | RECORD |
| โ โ โโ delivery.time.guaranteed.from | NULLABLE | TIMESTAMP |
| โ โ โโ delivery.time.guaranteed.to | NULLABLE | TIMESTAMP |
| โ โโ delivery.time.dispatch | NULLABLE | RECORD |
| โ โ โโ delivery.time.dispatch.from | NULLABLE | TIMESTAMP |
| โ โ โโ delivery.time.dispatch.to | NULLABLE | TIMESTAMP |
| โโ delivery.smart | NULLABLE | BOOLEAN |
| โโ delivery.calculatedNumberOfPackages | NULLABLE | INTEGER |
| invoice | NULLABLE | RECORD |
| โโ invoice.required | NULLABLE | BOOLEAN |
| โโ invoice.address | NULLABLE | RECORD |
| โ โโ invoice.address.street | NULLABLE | STRING |
| โ โโ invoice.address.city | NULLABLE | STRING |
| โ โโ invoice.address.zipCode | NULLABLE | STRING |
| โ โโ invoice.address.countryCode | NULLABLE | STRING |
| โ โโ invoice.address.company | NULLABLE | RECORD |
| โ โ โโ invoice.address.company.name | NULLABLE | STRING |
| โ โ โโ invoice.address.company.ids | REPEATED | RECORD |
| โ โ โ โโ invoice.address.company.ids.type | NULLABLE | STRING |
| โ โ โ โโ invoice.address.company.ids.value | NULLABLE | STRING |
| โ โ โโ invoice.address.company.vatPayerStatus | NULLABLE | STRING |
| โ โ โโ invoice.address.company.taxId | NULLABLE | STRING |
| โ โโ invoice.address.naturalPerson | NULLABLE | RECORD |
| โ โ โโ invoice.address.naturalPerson.firstName | NULLABLE | STRING |
| โ โ โโ invoice.address.naturalPerson.lastName | NULLABLE | STRING |
| โโ invoice.dueDate | NULLABLE | DATE |
| lineItems | REPEATED | RECORD |
| โโ lineItems.id | NULLABLE | STRING |
| โโ lineItems.offer | NULLABLE | RECORD |
| โ โโ lineItems.offer.id | NULLABLE | STRING |
| โ โโ lineItems.offer.name | NULLABLE | STRING |
| โ โโ lineItems.offer.external | NULLABLE | RECORD |
| โ โ โโ lineItems.offer.external.id | NULLABLE | STRING |
| โ โโ lineItems.offer.productSet | NULLABLE | RECORD |
| โ โ โโ lineItems.offer.productSet.products | REPEATED | RECORD |
| โ โ โ โโ lineItems.offer.productSet.products.id | NULLABLE | STRING |
| โ โ โ โโ lineItems.offer.productSet.products.quantity | NULLABLE | INTEGER |
| โโ lineItems.quantity | NULLABLE | INTEGER |
| โโ lineItems.originalPrice | NULLABLE | RECORD |
| โ โโ lineItems.originalPrice.amount | NULLABLE | FLOAT |
| โ โโ lineItems.originalPrice.currency | NULLABLE | STRING |
| โโ lineItems.price | NULLABLE | RECORD |
| โ โโ lineItems.price.amount | NULLABLE | FLOAT |
| โ โโ lineItems.price.currency | NULLABLE | STRING |
| โโ lineItems.reconciliation | NULLABLE | RECORD |
| โ โโ lineItems.reconciliation.value | NULLABLE | RECORD |
| โ โ โโ lineItems.reconciliation.value.amount | NULLABLE | FLOAT |
| โ โ โโ lineItems.reconciliation.value.currency | NULLABLE | STRING |
| โ โโ lineItems.reconciliation.type | NULLABLE | STRING |
| โ โโ lineItems.reconciliation.quantity | NULLABLE | INTEGER |
| โโ lineItems.selectedAdditionalServices | REPEATED | RECORD |
| โ โโ lineItems.selectedAdditionalServices.definitionId | NULLABLE | STRING |
| โ โโ lineItems.selectedAdditionalServices.name | NULLABLE | STRING |
| โ โโ lineItems.selectedAdditionalServices.price | NULLABLE | RECORD |
| โ โ โโ lineItems.selectedAdditionalServices.price.amount | NULLABLE | FLOAT |
| โ โ โโ lineItems.selectedAdditionalServices.price.currency | NULLABLE | STRING |
| โ โโ lineItems.selectedAdditionalServices.quantity | NULLABLE | INTEGER |
| โโ lineItems.vouchers | REPEATED | RECORD |
| โ โโ lineItems.vouchers.code | NULLABLE | STRING |
| โ โโ lineItems.vouchers.type | NULLABLE | STRING |
| โ โโ lineItems.vouchers.status | NULLABLE | STRING |
| โ โโ lineItems.vouchers.externalTransactionId | NULLABLE | STRING |
| โ โโ lineItems.vouchers.value | NULLABLE | RECORD |
| โ โ โโ lineItems.vouchers.value.amount | NULLABLE | FLOAT |
| โ โ โโ lineItems.vouchers.value.currency | NULLABLE | STRING |
| โโ lineItems.tax | NULLABLE | RECORD |
| โ โโ lineItems.tax.rate | NULLABLE | FLOAT |
| โ โโ lineItems.tax.subject | NULLABLE | STRING |
| โ โโ lineItems.tax.exemption | NULLABLE | STRING |
| โโ lineItems.boughtAt | NULLABLE | TIMESTAMP |
| surcharges | REPEATED | RECORD |
| โโ surcharges.id | NULLABLE | STRING |
| โโ surcharges.type | NULLABLE | STRING |
| โโ surcharges.provider | NULLABLE | STRING |
| โโ surcharges.finishedAt | NULLABLE | TIMESTAMP |
| โโ surcharges.paidAmount | NULLABLE | RECORD |
| โ โโ surcharges.paidAmount.amount | NULLABLE | FLOAT |
| โ โโ surcharges.paidAmount.currency | NULLABLE | STRING |
| โโ surcharges.reconciliation | NULLABLE | RECORD |
| โ โโ surcharges.reconciliation.amount | NULLABLE | FLOAT |
| โ โโ surcharges.reconciliation.currency | NULLABLE | STRING |
| โโ surcharges.features | REPEATED | STRING |
| discounts | REPEATED | RECORD |
| โโ discounts.type | NULLABLE | STRING |
| note | NULLABLE | RECORD |
| โโ note.text | NULLABLE | STRING |
| marketplace | NULLABLE | RECORD |
| โโ marketplace.id | NULLABLE | STRING |
| summary | NULLABLE | RECORD |
| โโ summary.totalToPay | NULLABLE | RECORD |
| โ โโ summary.totalToPay.amount | NULLABLE | FLOAT |
| โ โโ summary.totalToPay.currency | NULLABLE | STRING |
| updatedAt | NULLABLE | TIMESTAMP |
| revision | NULLABLE | STRING |
Data schema for allegro_products
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| name | NULLABLE | STRING |
| category | NULLABLE | RECORD |
| โโ category.id | NULLABLE | STRING |
| primaryImage | NULLABLE | RECORD |
| โโ primaryImage.url | NULLABLE | STRING |
| sellingMode | NULLABLE | RECORD |
| โโ sellingMode.format | NULLABLE | STRING |
| โโ sellingMode.price | NULLABLE | RECORD |
| โ โโ sellingMode.price.amount | NULLABLE | FLOAT |
| โ โโ sellingMode.price.currency | NULLABLE | STRING |
| โโ sellingMode.minimalPrice | NULLABLE | RECORD |
| โ โโ sellingMode.minimalPrice.amount | NULLABLE | FLOAT |
| โ โโ sellingMode.minimalPrice.currency | NULLABLE | STRING |
| โโ sellingMode.startingPrice | NULLABLE | RECORD |
| โ โโ sellingMode.startingPrice.amount | NULLABLE | FLOAT |
| โ โโ sellingMode.startingPrice.currency | NULLABLE | STRING |
| saleInfo | NULLABLE | RECORD |
| โโ saleInfo.currentPrice | NULLABLE | RECORD |
| โ โโ saleInfo.currentPrice.amount | NULLABLE | FLOAT |
| โ โโ saleInfo.currentPrice.currency | NULLABLE | STRING |
| โโ saleInfo.biddersCount | NULLABLE | INTEGER |
| stock | NULLABLE | RECORD |
| โโ stock.available | NULLABLE | INTEGER |
| โโ stock.sold | NULLABLE | INTEGER |
| stats | NULLABLE | RECORD |
| โโ stats.watchersCount | NULLABLE | INTEGER |
| โโ stats.visitsCount | NULLABLE | INTEGER |
| publication | NULLABLE | RECORD |
| โโ publication.status | NULLABLE | STRING |
| โโ publication.startingAt | NULLABLE | TIMESTAMP |
| โโ publication.startedAt | NULLABLE | TIMESTAMP |
| โโ publication.endingAt | NULLABLE | TIMESTAMP |
| โโ publication.endedAt | NULLABLE | TIMESTAMP |
| โโ publication.marketplaces | NULLABLE | RECORD |
| โ โโ publication.marketplaces.base | NULLABLE | RECORD |
| โ โ โโ publication.marketplaces.base.id | NULLABLE | STRING |
| โ โโ publication.marketplaces.additional | REPEATED | RECORD |
| โ โ โโ publication.marketplaces.additional.id | NULLABLE | STRING |
| afterSalesServices | NULLABLE | RECORD |
| โโ afterSalesServices.impliedWarranty | NULLABLE | RECORD |
| โ โโ afterSalesServices.impliedWarranty.id | NULLABLE | STRING |
| โโ afterSalesServices.returnPolicy | NULLABLE | RECORD |
| โ โโ afterSalesServices.returnPolicy.id | NULLABLE | STRING |
| โโ afterSalesServices.warranty | NULLABLE | RECORD |
| โ โโ afterSalesServices.warranty.id | NULLABLE | STRING |
| additionalServices | NULLABLE | RECORD |
| โโ additionalServices.id | NULLABLE | STRING |
| external | NULLABLE | RECORD |
| โโ external.id | NULLABLE | STRING |
| delivery | NULLABLE | RECORD |
| โโ delivery.shippingRates | NULLABLE | RECORD |
| โ โโ delivery.shippingRates.id | NULLABLE | STRING |
| b2b | NULLABLE | RECORD |
| โโ b2b.buyableOnlyByBusiness | NULLABLE | BOOLEAN |
| fundraisingCampaign | NULLABLE | RECORD |
| โโ fundraisingCampaign.id | NULLABLE | STRING |
| additionalMarketplaces | NULLABLE | RECORD |
| โโ additionalMarketplaces.allegro-cz | NULLABLE | RECORD |
| โ โโ additionalMarketplaces.allegro-cz.publication | NULLABLE | RECORD |
| โ โ โโ additionalMarketplaces.allegro-cz.publication.state | NULLABLE | STRING |
| โ โโ additionalMarketplaces.allegro-cz.sellingMode | NULLABLE | RECORD |
| โ โ โโ additionalMarketplaces.allegro-cz.sellingMode.price | NULLABLE | RECORD |
| โ โ โ โโ additionalMarketplaces.allegro-cz.sellingMode.price.amount | NULLABLE | FLOAT |
| โ โ โ โโ additionalMarketplaces.allegro-cz.sellingMode.price.currency | NULLABLE | STRING |
| โ โโ additionalMarketplaces.allegro-cz.stats | NULLABLE | RECORD |
| โ โ โโ additionalMarketplaces.allegro-cz.stats.watchersCount | NULLABLE | INTEGER |
| โ โ โโ additionalMarketplaces.allegro-cz.stats.visitsCount | NULLABLE | INTEGER |
| โ โโ additionalMarketplaces.allegro-cz.stock | NULLABLE | RECORD |
| โ โ โโ additionalMarketplaces.allegro-cz.stock.sold | NULLABLE | INTEGER |
Data schema for allegro_returns
| Field Name | Mode | Type |
|---|---|---|
| id | NULLABLE | STRING |
| createdAt | NULLABLE | TIMESTAMP |
| referenceNumber | NULLABLE | STRING |
| orderId | NULLABLE | STRING |
| buyer | NULLABLE | RECORD |
| โโ buyer.email | NULLABLE | STRING |
| โโ buyer.login | NULLABLE | STRING |
| items | REPEATED | RECORD |
| โโ items.offerId | NULLABLE | STRING |
| โโ items.quantity | NULLABLE | INTEGER |
| โโ items.name | NULLABLE | STRING |
| โโ items.price | NULLABLE | RECORD |
| โ โโ items.price.amount | NULLABLE | FLOAT |
| โ โโ items.price.currency | NULLABLE | STRING |
| โโ items.url | NULLABLE | STRING |
| โโ items.reason | NULLABLE | RECORD |
| โ โโ items.reason.type | NULLABLE | STRING |
| โ โโ items.reason.userComment | NULLABLE | STRING |
| refund | NULLABLE | RECORD |
| โโ refund.bankAccount | NULLABLE | RECORD |
| โ โโ refund.bankAccount.owner | NULLABLE | STRING |
| โ โโ refund.bankAccount.accountNumber | NULLABLE | STRING |
| โ โโ refund.bankAccount.swift | NULLABLE | STRING |
| โ โโ refund.bankAccount.address | NULLABLE | RECORD |
| โ โ โโ refund.bankAccount.address.street | NULLABLE | STRING |
| โ โ โโ refund.bankAccount.address.city | NULLABLE | STRING |
| โ โ โโ refund.bankAccount.address.postCode | NULLABLE | STRING |
| โ โ โโ refund.bankAccount.address.countryCode | NULLABLE | STRING |
| โ โโ refund.bankAccount.iban | NULLABLE | STRING |
| rejection | NULLABLE | RECORD |
| โโ rejection.reason | NULLABLE | STRING |
| โโ rejection.code | NULLABLE | STRING |
| โโ rejection.createdAt | NULLABLE | TIMESTAMP |
| parcels | REPEATED | RECORD |
| โโ parcels.createdAt | NULLABLE | TIMESTAMP |
| โโ parcels.waybill | NULLABLE | STRING |
| โโ parcels.transportingWaybill | NULLABLE | STRING |
| โโ parcels.carrierId | NULLABLE | STRING |
| โโ parcels.transportingCarrierId | NULLABLE | STRING |
| โโ parcels.sender | NULLABLE | RECORD |
| โ โโ parcels.sender.phoneNumber | NULLABLE | STRING |
| marketplaceId | NULLABLE | STRING |
| status | NULLABLE | STRING |
