Integracja Bing Ads z BigQuery
Dowiedz się, jak połączyć Bing Ads z Google BigQuery w WitCloud i automatycznie pobierać dane o skuteczności kont, kampanii i produktów.
Aktualizacja
Wprowadzenie
Ta integracja łączy Bing Ads (Microsoft Advertising) z Google Cloud BigQuery. Pobiera raporty skuteczności kont, kampanii i produktów, dzięki czemu możesz analizować wyniki swoich kampanii w Bing obok pozostałych danych w WitCloud.
Przewodnik konfiguracji
Wykonaj poniższe kroki, aby połączyć Bing Ads z BigQuery. Po zakończeniu konfiguracji dane z Bing Ads będą przesyłane do Twojego projektu BigQuery.
Zanim zaczniesz konfigurację, upewnij się, że masz dostęp administratora do swojego konta Bing Ads.
Konfiguracja modułu
Przejdź do Integracje w menu i kliknij Dodaj integrację.

Wybierz Bing Ads z listy dostępnych integracji.

Wpisz Nazwę źródła danych, np. „Bing Ads PL".

Autoryzacja
Jeśli moduł Bing był już wcześniej autoryzowany i nie potrzebujesz dodatkowych uprawnień, możesz pominąć ten krok i wybrać istniejącą autoryzację z listy Wybierz autoryzację Bing.
Jeśli masz problem z nadaniem dostępu do Microsoft Advertising (Bing) w środowisku Azure, poproś administratora IT o udzielenie zgody administratora dla całej dzierżawy (tenant) dla Microsoft Advertising API w Azure AD. Doda to wymagane uprawnienia delegowane. Po udzieleniu zgody każdy użytkownik z co najmniej rolą Viewer w Microsoft Advertising będzie mógł połączyć swoje konto w WitCloud bez dodatkowej akceptacji.
Kliknij Autoryzuj.

Zaloguj się na swoje konto Microsoft i nadaj wymagane uprawnienia.
Po powrocie do WitCloud otwórz Wybierz konta i wybierz konta Bing Ads, które chcesz pobierać.

Możesz wybrać kilka kont naraz — WitCloud utworzy osobne źródło danych dla każdego z nich, nazwane od Nazwy źródła danych i nazwy konta (na przykład „Bing Ads PL - Demo Store PL").

Opcjonalnie kliknij Pokaż ustawienia zaawansowane. Pole Tabele do pobrania pozwala zawęzić listę tabel, które chcesz pobierać; domyślnie zaznaczone są wszystkie, a co najmniej jedna tabela jest wymagana.

Kliknij Dalej.
Dane historyczne i harmonogram
W polu Dane historyczne wpisz liczbę dni, z których chcesz pobrać dane historyczne. Możesz podać maksymalnie 365 dni.

Harmonogram synchronizacji danych zostanie utworzony automatycznie. Więcej informacji na ten temat znajdziesz tutaj.
Kliknij Utwórz, aby zakończyć konfigurację.

Gotowe! Dane z Bing Ads będą teraz synchronizowane z BigQuery.
Schemat danych
Rozwiń poniższe tabele, aby zobaczyć pełny schemat danych pobieranych z Bing Ads.
Schemat danych tabeli bing_account_performance
| Nazwa pola | Tryb | Typ |
|---|---|---|
| Date | NULLABLE | DATE |
| AccountName | NULLABLE | STRING |
| AccountId | NULLABLE | STRING |
| AccountNumber | NULLABLE | STRING |
| CurrencyCode | NULLABLE | STRING |
| Impressions | NULLABLE | INTEGER |
| Clicks | NULLABLE | INTEGER |
| Ctr | NULLABLE | FLOAT |
| AverageCpc | NULLABLE | FLOAT |
| Spend | NULLABLE | FLOAT |
| AveragePosition | NULLABLE | FLOAT |
| Conversions | NULLABLE | INTEGER |
| ConversionRate | NULLABLE | FLOAT |
| CostPerConversion | NULLABLE | FLOAT |
| LowQualityClicks | NULLABLE | INTEGER |
| LowQualityClicksPercent | NULLABLE | FLOAT |
| LowQualityImpressions | NULLABLE | INTEGER |
| LowQualityImpressionsPercent | NULLABLE | FLOAT |
| LowQualityConversions | NULLABLE | INTEGER |
| LowQualityConversionRate | NULLABLE | FLOAT |
| DeviceType | NULLABLE | STRING |
| DeviceOS | NULLABLE | STRING |
| PhoneImpressions | NULLABLE | INTEGER |
| PhoneCalls | NULLABLE | INTEGER |
| Ptr | NULLABLE | FLOAT |
| Network | NULLABLE | STRING |
| TopVsOther | NULLABLE | STRING |
| BidMatchType | NULLABLE | STRING |
| DeliveredMatchType | NULLABLE | STRING |
| Assists | NULLABLE | INTEGER |
| Revenue | NULLABLE | FLOAT |
| ReturnOnAdSpend | NULLABLE | FLOAT |
| CostPerAssist | NULLABLE | FLOAT |
| RevenuePerConversion | NULLABLE | FLOAT |
| RevenuePerAssist | NULLABLE | FLOAT |
| AccountStatus | NULLABLE | STRING |
| LowQualityGeneralClicks | NULLABLE | INTEGER |
| LowQualitySophisticatedClicks | NULLABLE | INTEGER |
| CustomerId | NULLABLE | STRING |
| CustomerName | NULLABLE | STRING |
| AllConversions | NULLABLE | INTEGER |
| AllRevenue | NULLABLE | FLOAT |
| AllConversionRate | NULLABLE | FLOAT |
| AllCostPerConversion | NULLABLE | FLOAT |
| AllReturnOnAdSpend | NULLABLE | FLOAT |
| AllRevenuePerConversion | NULLABLE | FLOAT |
| ViewThroughConversions | NULLABLE | INTEGER |
| AverageCpm | NULLABLE | FLOAT |
| ConversionsQualified | NULLABLE | FLOAT |
| LowQualityConversionsQualified | NULLABLE | FLOAT |
| AllConversionsQualified | NULLABLE | FLOAT |
| ViewThroughConversionsQualified | NULLABLE | FLOAT |
| ViewThroughRevenue | NULLABLE | FLOAT |
| VideoViews | NULLABLE | INTEGER |
| ViewThroughRate | NULLABLE | FLOAT |
| AverageCPV | NULLABLE | FLOAT |
| VideoViewsAt25Percent | NULLABLE | INTEGER |
| VideoViewsAt50Percent | NULLABLE | INTEGER |
| VideoViewsAt75Percent | NULLABLE | INTEGER |
| CompletedVideoViews | NULLABLE | INTEGER |
| VideoCompletionRate | NULLABLE | FLOAT |
| TotalWatchTimeInMS | NULLABLE | INTEGER |
| AverageWatchTimePerVideoView | NULLABLE | FLOAT |
| AverageWatchTimePerImpression | NULLABLE | FLOAT |
Schemat danych tabeli bing_campaign_performance
| Nazwa pola | Tryb | Typ |
|---|---|---|
| Date | NULLABLE | DATE |
| AccountName | NULLABLE | STRING |
| AccountId | NULLABLE | STRING |
| AccountNumber | NULLABLE | STRING |
| CampaignName | NULLABLE | STRING |
| CampaignId | NULLABLE | STRING |
| CampaignStatus | NULLABLE | STRING |
| BaseCampaignId | NULLABLE | STRING |
| CampaignType | NULLABLE | STRING |
| CampaignLabels | NULLABLE | STRING |
| CurrencyCode | NULLABLE | STRING |
| Impressions | NULLABLE | INTEGER |
| Clicks | NULLABLE | INTEGER |
| Ctr | NULLABLE | FLOAT |
| AverageCpc | NULLABLE | FLOAT |
| Spend | NULLABLE | FLOAT |
| AveragePosition | NULLABLE | FLOAT |
| Conversions | NULLABLE | INTEGER |
| ConversionRate | NULLABLE | FLOAT |
| CostPerConversion | NULLABLE | FLOAT |
| LowQualityClicks | NULLABLE | INTEGER |
| LowQualityClicksPercent | NULLABLE | FLOAT |
| LowQualityImpressions | NULLABLE | INTEGER |
| LowQualityImpressionsPercent | NULLABLE | FLOAT |
| LowQualityConversions | NULLABLE | INTEGER |
| LowQualityConversionRate | NULLABLE | FLOAT |
| DeviceType | NULLABLE | STRING |
| DeviceOS | NULLABLE | STRING |
| PhoneImpressions | NULLABLE | INTEGER |
| PhoneCalls | NULLABLE | INTEGER |
| Ptr | NULLABLE | FLOAT |
| Network | NULLABLE | STRING |
| TopVsOther | NULLABLE | STRING |
| BidMatchType | NULLABLE | STRING |
| DeliveredMatchType | NULLABLE | STRING |
| Assists | NULLABLE | INTEGER |
| Revenue | NULLABLE | FLOAT |
| ReturnOnAdSpend | NULLABLE | FLOAT |
| CostPerAssist | NULLABLE | FLOAT |
| RevenuePerConversion | NULLABLE | FLOAT |
| RevenuePerAssist | NULLABLE | FLOAT |
| AccountStatus | NULLABLE | STRING |
| LowQualityGeneralClicks | NULLABLE | INTEGER |
| LowQualitySophisticatedClicks | NULLABLE | INTEGER |
| CustomerId | NULLABLE | STRING |
| CustomerName | NULLABLE | STRING |
| AllConversions | NULLABLE | INTEGER |
| AllRevenue | NULLABLE | FLOAT |
| AllConversionRate | NULLABLE | FLOAT |
| AllCostPerConversion | NULLABLE | FLOAT |
| AllReturnOnAdSpend | NULLABLE | FLOAT |
| AllRevenuePerConversion | NULLABLE | FLOAT |
| ViewThroughConversions | NULLABLE | INTEGER |
| AverageCpm | NULLABLE | FLOAT |
| ConversionsQualified | NULLABLE | FLOAT |
| LowQualityConversionsQualified | NULLABLE | FLOAT |
| AllConversionsQualified | NULLABLE | FLOAT |
| ViewThroughConversionsQualified | NULLABLE | FLOAT |
| ViewThroughRevenue | NULLABLE | FLOAT |
| VideoViews | NULLABLE | INTEGER |
| ViewThroughRate | NULLABLE | FLOAT |
| AverageCPV | NULLABLE | FLOAT |
| VideoViewsAt25Percent | NULLABLE | INTEGER |
| VideoViewsAt50Percent | NULLABLE | INTEGER |
| VideoViewsAt75Percent | NULLABLE | INTEGER |
| CompletedVideoViews | NULLABLE | INTEGER |
| VideoCompletionRate | NULLABLE | FLOAT |
| TotalWatchTimeInMS | NULLABLE | INTEGER |
| AverageWatchTimePerVideoView | NULLABLE | FLOAT |
| AverageWatchTimePerImpression | NULLABLE | FLOAT |
Schemat danych tabeli bing_product_dimension_performance
| Nazwa pola | Tryb | Typ |
|---|---|---|
| Date | NULLABLE | DATE |
| AccountName | NULLABLE | STRING |
| AccountNumber | NULLABLE | STRING |
| AdGroupName | NULLABLE | STRING |
| AdGroupId | NULLABLE | STRING |
| CampaignStatus | NULLABLE | STRING |
| AccountStatus | NULLABLE | STRING |
| AdGroupStatus | NULLABLE | STRING |
| Network | NULLABLE | STRING |
| AdId | NULLABLE | STRING |
| CampaignId | NULLABLE | STRING |
| CampaignName | NULLABLE | STRING |
| CurrencyCode | NULLABLE | STRING |
| DeviceType | NULLABLE | STRING |
| Language | NULLABLE | STRING |
| MerchantProductId | NULLABLE | STRING |
| Title | NULLABLE | STRING |
| Condition | NULLABLE | STRING |
| Brand | NULLABLE | STRING |
| Price | NULLABLE | FLOAT |
| CustomLabel0 | NULLABLE | STRING |
| CustomLabel1 | NULLABLE | STRING |
| CustomLabel2 | NULLABLE | STRING |
| CustomLabel3 | NULLABLE | STRING |
| CustomLabel4 | NULLABLE | STRING |
| ProductType1 | NULLABLE | STRING |
| ProductType2 | NULLABLE | STRING |
| ProductType3 | NULLABLE | STRING |
| ProductType4 | NULLABLE | STRING |
| ProductType5 | NULLABLE | STRING |
| ProductCategory1 | NULLABLE | STRING |
| ProductCategory2 | NULLABLE | STRING |
| ProductCategory3 | NULLABLE | STRING |
| ProductCategory4 | NULLABLE | STRING |
| ProductCategory5 | NULLABLE | STRING |
| Impressions | NULLABLE | INTEGER |
| Clicks | NULLABLE | INTEGER |
| Ctr | NULLABLE | FLOAT |
| AverageCpc | NULLABLE | FLOAT |
| Spend | NULLABLE | FLOAT |
| Conversions | NULLABLE | INTEGER |
| ConversionRate | NULLABLE | FLOAT |
| Revenue | NULLABLE | FLOAT |
| RevenuePerConversion | NULLABLE | FLOAT |
| SellerName | NULLABLE | STRING |
| OfferLanguage | NULLABLE | STRING |
| CountryOfSale | NULLABLE | STRING |
| AdStatus | NULLABLE | STRING |
| TopVsOther | NULLABLE | STRING |
| AdDistribution | NULLABLE | STRING |
| ClickTypeId | NULLABLE | STRING |
| TotalClicksOnAdElements | NULLABLE | INTEGER |
| ClickType | NULLABLE | STRING |
| ReturnOnAdSpend | NULLABLE | FLOAT |
| BidStrategyType | NULLABLE | STRING |
| LocalStoreCode | NULLABLE | STRING |
| StoreId | NULLABLE | STRING |
| AssistedImpressions | NULLABLE | INTEGER |
| AssistedClicks | NULLABLE | INTEGER |
| AssistedConversions | NULLABLE | INTEGER |
| AllConversions | NULLABLE | INTEGER |
| AllRevenue | NULLABLE | FLOAT |
| AllConversionRate | NULLABLE | FLOAT |
| AllCostPerConversion | NULLABLE | FLOAT |
| AllReturnOnAdSpend | NULLABLE | FLOAT |
| AllRevenuePerConversion | NULLABLE | FLOAT |
| CostPerConversion | NULLABLE | FLOAT |
| ViewThroughConversions | NULLABLE | INTEGER |
| ProductBought | NULLABLE | STRING |
| QuantityBought | NULLABLE | INTEGER |
| AbsoluteTopImpressionRatePercent | NULLABLE | FLOAT |
| AverageCpm | NULLABLE | FLOAT |
| ConversionsQualified | NULLABLE | FLOAT |
| AssistedConversionsQualified | NULLABLE | FLOAT |
| AllConversionsQualified | NULLABLE | FLOAT |
| ViewThroughConversionsQualified | NULLABLE | FLOAT |
| ProductBoughtTitle | NULLABLE | STRING |
| GTIN | NULLABLE | STRING |
| MPN | NULLABLE | STRING |
| ViewThroughRevenue | NULLABLE | FLOAT |
