Bing ads

Setting up the Bing ads connector

No	Item	Required	Example	Notes
1	Tenant ID	No		The Tenant ID of your Microsoft Advertising developer application. Set this to "common" unless you know you need a different value.
2	Client ID	Yes		The Client ID of your Microsoft Advertising developer application.
3	Client Secret	No		The Client Secret of your Microsoft Advertising developer application.
4	Refresh Token	Yes		Refresh Token to renew the expired Access Token.
5	Developer Token	Yes		Developer token associated with user. See more info in the docs.
6	Reports replication start date	Yes		The start date from which to begin replicating report data. Any data generated before this date will not be replicated in reports. This is a UTC date in YYYY-MM-DD format.

Tables in the Bing ads connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	keyword_performance_report	54
2	ad_groups	22		Full Refresh		API Reference
3	ads	18		Full Refresh		API Reference
4	campaigns	19		Full Refresh		API Reference
5	ad_group_performance_report	49
6	campaign_performance_report	55
7	ad_performance_report	44
8	budget_summary_report	9		Incremental, Full Refresh		API Reference
9	accounts	20		Full Refresh		API Reference
10	account_performance_report	35

Table: keyword_performance_report

No	Column Name	Type	Notes
1	Ctr	DOUBLE
2	AccountId	INTEGER
3	AllCostPerConversion	DOUBLE
4	AllConversionRate	DOUBLE
5	ViewThroughConversions	INTEGER
6	RevenuePerAssist	DOUBLE
7	MainlineBid	DOUBLE
8	AverageCpm	DOUBLE
9	AllConversions	INTEGER
10	CurrencyCode	VARCHAR
11	FirstPageBid	DOUBLE
12	AllRevenue	DOUBLE
13	Network	VARCHAR
14	BidMatchType	VARCHAR
15	CostPerConversion	DOUBLE
16	AveragePosition	DOUBLE
17	AdId	INTEGER
18	Impressions	INTEGER
19	QualityScore	DOUBLE
20	TimePeriod	VARCHAR
21	DeviceOS	VARCHAR
22	ConversionsQualified	DOUBLE
23	AllReturnOnAdSpend	DOUBLE
24	DeviceType	VARCHAR
25	Assists	INTEGER
26	TopVsOther	VARCHAR
27	Conversions	DOUBLE
28	AllRevenuePerConversion	DOUBLE
29	RevenuePerConversion	DOUBLE
30	AverageCpc	DOUBLE
31	ExpectedCtr	VARCHAR
32	Revenue	DOUBLE
33	AdGroupId	INTEGER
34	Mainline1Bid	DOUBLE
35	CurrentMaxCpc	DOUBLE
36	FinalAppUrl	VARCHAR
37	ViewThroughConversionsQualified	DOUBLE
38	DeliveredMatchType	VARCHAR
39	ReturnOnAdSpend	DOUBLE
40	KeywordStatus	VARCHAR
41	KeywordId	INTEGER
42	Language	VARCHAR
43	FinalUrlSuffix	VARCHAR
44	CampaignId	INTEGER
45	CustomParameters	VARCHAR
46	LandingPageExperience	DOUBLE
47	Keyword	VARCHAR
48	CostPerAssist	DOUBLE
49	ConversionRate	DOUBLE
50	AdDistribution	VARCHAR
51	Spend	DOUBLE
52	Clicks	INTEGER
53	AdRelevance	DOUBLE
54	QualityImpact	DOUBLE

Table: ad_groups

No	Column Name	Type	Notes
1	Status	VARCHAR
2	CpvBid	VARCHAR
3	BiddingScheme	VARCHAR
4	PrivacyStatus	VARCHAR
5	MultimediaAdsBidAdjustment	INTEGER
6	CpcBid	VARCHAR
7	CpmBid	VARCHAR
8	EndDate	VARCHAR
9	ForwardCompatibilityMap	VARCHAR
10	AdScheduleUseSearcherTimeZone	BOOLEAN
11	Name	VARCHAR
12	StartDate	VARCHAR
13	UrlCustomParameters	VARCHAR
14	AudienceAdsBidAdjustment	DOUBLE
15	FinalUrlSuffix	VARCHAR
16	Language	VARCHAR
17	AdRotation	VARCHAR
18	Network	VARCHAR
19	AdGroupType	VARCHAR
20	Id	INTEGER
21	TrackingUrlTemplate	VARCHAR
22	Settings	VARCHAR

Table: ads

No	Column Name	Type	Notes
1	Status	VARCHAR
2	EditorialStatus	VARCHAR
3	AdFormatPreference	VARCHAR
4	FinalUrls	VARCHAR
5	Headlines	VARCHAR
6	FinalMobileUrls	VARCHAR
7	FinalAppUrls	VARCHAR
8	ForwardCompatibilityMap	VARCHAR
9	Descriptions	VARCHAR
10	Type	VARCHAR
11	UrlCustomParameters	VARCHAR
12	FinalUrlSuffix	VARCHAR
13	DevicePreference	INTEGER
14	Path2	VARCHAR
15	Path1	VARCHAR
16	Id	INTEGER
17	Domain	VARCHAR
18	TrackingUrlTemplate	VARCHAR

Table: campaigns

No	Column Name	Type	Notes
1	Status	VARCHAR
2	SubType	VARCHAR
3	BiddingScheme	VARCHAR
4	BudgetId	DOUBLE
5	Languages	VARCHAR
6	DailyBudget	DOUBLE
7	ForwardCompatibilityMap	VARCHAR
8	AdScheduleUseSearcherTimeZone	BOOLEAN
9	BudgetType	VARCHAR
10	Name	VARCHAR
11	TimeZone	VARCHAR
12	UrlCustomParameters	VARCHAR
13	AudienceAdsBidAdjustment	DOUBLE
14	FinalUrlSuffix	VARCHAR
15	ExperimentId	DOUBLE
16	Id	DOUBLE
17	TrackingUrlTemplate	VARCHAR
18	Settings	VARCHAR
19	CampaignType	VARCHAR

Table: ad_group_performance_report

No	Column Name	Type	Notes
1	Ctr	DOUBLE
2	HistoricalAdRelevance	DOUBLE
3	AccountId	INTEGER
4	AllCostPerConversion	DOUBLE
5	AllConversionRate	DOUBLE
6	ViewThroughConversions	INTEGER
7	RevenuePerAssist	DOUBLE
8	AllConversions	INTEGER
9	AverageCpm	DOUBLE
10	CurrencyCode	VARCHAR
11	AllRevenue	DOUBLE
12	Network	VARCHAR
13	BidMatchType	VARCHAR
14	CostPerConversion	DOUBLE
15	AveragePosition	DOUBLE
16	PhoneCalls	INTEGER
17	Impressions	INTEGER
18	QualityScore	DOUBLE
19	TimePeriod	VARCHAR
20	HistoricalQualityScore	DOUBLE
21	DeviceOS	VARCHAR
22	ConversionsQualified	DOUBLE
23	AllReturnOnAdSpend	DOUBLE
24	DeviceType	VARCHAR
25	Assists	INTEGER
26	TopVsOther	VARCHAR
27	AllRevenuePerConversion	DOUBLE
28	Conversions	DOUBLE
29	RevenuePerConversion	DOUBLE
30	AverageCpc	DOUBLE
31	ExpectedCtr	VARCHAR
32	Revenue	DOUBLE
33	AdGroupId	INTEGER
34	PhoneImpressions	INTEGER
35	Ptr	DOUBLE
36	DeliveredMatchType	VARCHAR
37	Language	VARCHAR
38	FinalUrlSuffix	VARCHAR
39	CampaignId	INTEGER
40	CustomParameters	VARCHAR
41	LandingPageExperience	DOUBLE
42	HistoricalLandingPageExperience	DOUBLE
43	HistoricalExpectedCtr	DOUBLE
44	CostPerAssist	DOUBLE
45	ConversionRate	DOUBLE
46	AdDistribution	VARCHAR
47	Spend	DOUBLE
48	Clicks	INTEGER
49	AdRelevance	DOUBLE

Table: campaign_performance_report

No	Column Name	Type	Notes
1	Ctr	DOUBLE
2	HistoricalAdRelevance	DOUBLE
3	AccountId	INTEGER
4	AllCostPerConversion	DOUBLE
5	AllConversionRate	DOUBLE
6	ViewThroughConversions	INTEGER
7	RevenuePerAssist	DOUBLE
8	AllConversions	INTEGER
9	AverageCpm	DOUBLE
10	CurrencyCode	VARCHAR
11	AllRevenue	DOUBLE
12	Network	VARCHAR
13	BidMatchType	VARCHAR
14	CostPerConversion	DOUBLE
15	AveragePosition	DOUBLE
16	PhoneCalls	INTEGER
17	Impressions	INTEGER
18	QualityScore	DOUBLE
19	TimePeriod	VARCHAR
20	HistoricalQualityScore	DOUBLE
21	BudgetAssociationStatus	VARCHAR
22	DeviceOS	VARCHAR
23	AllReturnOnAdSpend	DOUBLE
24	DeviceType	VARCHAR
25	Assists	INTEGER
26	TopVsOther	VARCHAR
27	AllRevenuePerConversion	DOUBLE
28	Conversions	DOUBLE
29	LowQualityClicksPercent	DOUBLE
30	RevenuePerConversion	DOUBLE
31	AverageCpc	DOUBLE
32	Revenue	DOUBLE
33	BudgetName	VARCHAR
34	LowQualitySophisticatedClicks	INTEGER
35	LowQualityClicks	INTEGER
36	CampaignStatus	VARCHAR
37	PhoneImpressions	INTEGER
38	Ptr	DOUBLE
39	DeliveredMatchType	VARCHAR
40	BudgetStatus	VARCHAR
41	ReturnOnAdSpend	DOUBLE
42	CampaignId	INTEGER
43	LowQualityImpressions	INTEGER
44	CustomParameters	VARCHAR
45	LandingPageExperience	DOUBLE
46	HistoricalLandingPageExperience	DOUBLE
47	HistoricalExpectedCtr	DOUBLE
48	LowQualityConversions	INTEGER
49	CostPerAssist	DOUBLE
50	ConversionRate	DOUBLE
51	AdDistribution	VARCHAR
52	LowQualityConversionRate	DOUBLE
53	Spend	DOUBLE
54	Clicks	INTEGER
55	AdRelevance	DOUBLE

Table: ad_performance_report

No	Column Name	Type	Notes
1	Ctr	DOUBLE
2	AccountId	INTEGER
3	AllCostPerConversion	DOUBLE
4	FinalAppUrl	VARCHAR
5	ViewThroughConversionsQualified	DOUBLE
6	AllConversionRate	DOUBLE
7	ViewThroughConversions	INTEGER
8	RevenuePerAssist	DOUBLE
9	AverageCpm	DOUBLE
10	AllConversions	INTEGER
11	CurrencyCode	VARCHAR
12	DeliveredMatchType	VARCHAR
13	DestinationUrl	VARCHAR
14	ReturnOnAdSpend	DOUBLE
15	AllRevenue	DOUBLE
16	Language	VARCHAR
17	CampaignId	INTEGER
18	Network	VARCHAR
19	BidMatchType	VARCHAR
20	CostPerConversion	DOUBLE
21	AveragePosition	DOUBLE
22	AdDescription2	VARCHAR
23	CustomParameters	VARCHAR
24	AdId	INTEGER
25	Impressions	INTEGER
26	TimePeriod	VARCHAR
27	DeviceOS	VARCHAR
28	ConversionsQualified	DOUBLE
29	AllReturnOnAdSpend	DOUBLE
30	DeviceType	VARCHAR
31	AdDescription	VARCHAR
32	Assists	INTEGER
33	TopVsOther	VARCHAR
34	CostPerAssist	DOUBLE
35	Conversions	DOUBLE
36	ConversionRate	DOUBLE
37	AllRevenuePerConversion	DOUBLE
38	AdDistribution	VARCHAR
39	RevenuePerConversion	DOUBLE
40	AverageCpc	DOUBLE
41	Spend	DOUBLE
42	Revenue	DOUBLE
43	AdGroupId	INTEGER
44	Clicks	INTEGER

Table: budget_summary_report

No	Column Name	Type	Notes
1	AccountId	INTEGER
2	CampaignId	INTEGER
3	CampaignName	VARCHAR
4	DailySpend	DOUBLE
5	MonthlyBudget	DOUBLE
6	MonthToDateSpend	DOUBLE
7	Date	VARCHAR
8	AccountName	VARCHAR
9	AccountNumber	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	BillToCustomerId	DOUBLE
2	PauseReason	DOUBLE
3	LastModifiedByUserId	DOUBLE
4	PaymentMethodId	DOUBLE
5	AccountLifeCycleStatus	VARCHAR
6	AccountFinancialStatus	VARCHAR
7	BackUpPaymentInstrumentId	DOUBLE
8	SoldToPaymentInstrumentId	DOUBLE
9	AutoTagType	VARCHAR
10	BusinessAddress	VARCHAR
11	TimeStamp	VARCHAR
12	Name	VARCHAR
13	Number	VARCHAR
14	ParentCustomerId	DOUBLE
15	SalesHouseCustomerId	DOUBLE
16	AccountMode	VARCHAR
17	LastModifiedTime	VARCHAR
18	Id	DOUBLE
19	BillingThresholdAmount	DOUBLE
20	PrimaryUserId	DOUBLE

Table: account_performance_report

No	Column Name	Type	Notes
1	Ctr	DOUBLE
2	LowQualityClicks	INTEGER
3	AccountId	INTEGER
4	RevenuePerAssist	DOUBLE
5	PhoneImpressions	INTEGER
6	AverageCpm	DOUBLE
7	Ptr	DOUBLE
8	CurrencyCode	VARCHAR
9	DeliveredMatchType	VARCHAR
10	ReturnOnAdSpend	DOUBLE
11	Network	VARCHAR
12	BidMatchType	VARCHAR
13	CostPerConversion	DOUBLE
14	AveragePosition	DOUBLE
15	LowQualityImpressions	INTEGER
16	PhoneCalls	INTEGER
17	Impressions	INTEGER
18	TimePeriod	VARCHAR
19	DeviceOS	VARCHAR
20	DeviceType	VARCHAR
21	Assists	INTEGER
22	LowQualityConversions	INTEGER
23	TopVsOther	VARCHAR
24	CostPerAssist	DOUBLE
25	Conversions	DOUBLE
26	ConversionRate	DOUBLE
27	AdDistribution	VARCHAR
28	LowQualityClicksPercent	DOUBLE
29	LowQualityConversionRate	DOUBLE
30	RevenuePerConversion	DOUBLE
31	AverageCpc	DOUBLE
32	Spend	DOUBLE
33	Revenue	DOUBLE
34	Clicks	INTEGER
35	LowQualitySophisticatedClicks	INTEGER

External Resources

• Register Your Application
• Request User Consent
• Get A Refresh Token
• Here
• Microsoft Developer Token
• Bing Ads Api
• Account_performance_report_hourly
• Account_performance_report_daily
• Account_performance_report_weekly
• Account_performance_report_monthly
• Ad_group_performance_report_hourly
• Ad_group_performance_report_daily
• Ad_group_performance_report_weekly
• Ad_group_performance_report_monthly
• Ad_performance_report_hourly
• Ad_performance_report_daily
• Ad_performance_report_weekly
• Ad_performance_report_monthly
• Campaign_performance_report_hourly
• Campaign_performance_report_daily
• Campaign_performance_report_weekly
• Campaign_performance_report_monthly
• Keyword_performance_report_hourly
• Keyword_performance_report_daily
• Keyword_performance_report_weekly
• Keyword_performance_report_monthly
• Aggregated

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.