Integracja Allegro z BigQuery
Dowiedz się, jak połączyć Allegro z Google BigQuery w WitCloud. Dane o zamówieniach, produktach i zwrotach trafiają do BigQuery automatycznie, a Ty analizujesz je i optymalizujesz sprzedaż.
Aktualizacja
Wprowadzenie
Ten moduł łączy się z API Allegro, pobiera dane z marketplace'u i zapisuje je w Google Cloud BigQuery. Dzięki temu lepiej poznasz swoje dane i zoptymalizujesz działania marketingowe.
Przewodnik konfiguracji
Wykonaj poniższe kroki, aby połączyć Allegro z BigQuery. Po zakończeniu konfiguracji dane z Allegro trafiają do Twojego projektu BigQuery automatycznie.
Zanim zaczniesz konfigurację, upewnij się, że masz dostęp administratora do swojego konta Allegro.
Konfiguracja modułu
Wejdź w menu w Integracje i kliknij Dodaj integrację.

Wybierz Allegro z listy dostępnych integracji.

Wpisz Nazwę źródła danych, np. Allegro PL. Czytelna nazwa pomoże Ci później rozpoznać źródło danych.

Autoryzacja
Jeśli wcześniej autoryzowałeś moduł Allegro i nie potrzebujesz dodatkowych uprawnień, możesz pominąć ten krok i wybrać istniejące konto z listy Wybierz konto Allegro.
Kliknij Autoryzuj.

Zaloguj się i nadaj wymagane uprawnienia.

Wybierz odpowiednie konto z listy Wybierz konto Allegro.

Ustawienia zaawansowane
Kliknij Pokaż ustawienia zaawansowane, aby zmienić dwa opcjonalne ustawienia:
- Odświeżanie danych (produkty): co ile godzin odświeżać tabele takie jak produkty. Wpisz wartość od 4 do 12.
- Tabele do pobrania: tabele, które chcesz pobierać. Domyślnie zaznaczone są wszystkie; usuń te, których nie potrzebujesz. Co najmniej jedna tabela musi pozostać zaznaczona.

Kliknij Dalej.
Dane historyczne i harmonogram
Wpisz liczbę dni historii w polu Dane historyczne. Możesz pobrać do 365 dni danych historycznych.

Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.
Kliknij Utwórz, aby zakończyć konfigurację.
Gotowe! Dane z Allegro będą teraz synchronizowane z BigQuery, a Ty zyskasz szczegółowy wgląd w wyniki swojego marketplace'u.
Schemat danych
Rozwiń poniższe tabele, aby zobaczyć pełny schemat danych pobieranych z Allegro.
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
Schemat danych tabeli 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 |
