Linkedin ads

Tables in the Linkedin ads connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	campaigns	25		Incremental	lastModified	API Reference
2	ad_creative_analytics	62		Incremental	end_date
3	ad_campaign_analytics	62		Incremental	end_date
4	campaign_groups	11		Incremental	lastModified
5	creatives	12		Incremental	lastModified	API Reference
6	account_users	5		Incremental	lastModified
7	ad_direct_sponsored_contents	8		Incremental	lastModified
8	accounts	15		Full Refresh	``	API Reference

Table: campaigns

No	Column Name	Type	Notes
1	storyDeliveryEnabled	BOOLEAN
2	targetingCriteria	VARCHAR
3	type	VARCHAR
4	locale	VARCHAR
5	pacingStrategy	VARCHAR
6	runSchedule	VARCHAR
7	optimizationTargetType	VARCHAR
8	creativeSelection	VARCHAR
9	costType	VARCHAR
10	offsiteDeliveryEnabled	BOOLEAN
11	id	INTEGER
12	audienceExpansionEnabled	BOOLEAN
13	created	VARCHAR
14	format	VARCHAR
15	servingStatuses	VARCHAR
16	version	VARCHAR
17	objectiveType	VARCHAR
18	associatedEntity	VARCHAR
19	campaignGroup	VARCHAR
20	dailyBudget	VARCHAR
21	unitCost	VARCHAR
22	name	VARCHAR
23	lastModified	VARCHAR	Incremental sync key
24	account	VARCHAR
25	status	VARCHAR

Table: ad_creative_analytics

No	Column Name	Type	Notes
1	externalWebsitePostClickConversions	DOUBLE
2	adUnitClicks	DOUBLE
3	companyPageClicks	DOUBLE
4	videoFirstQuartileCompletions	DOUBLE
5	viralOneClickLeads	DOUBLE
6	textUrlClicks	DOUBLE
7	viralCommentLikes	DOUBLE
8	videoStarts	DOUBLE
9	viralExternalWebsiteConversions	DOUBLE
10	videoThirdQuartileCompletions	DOUBLE
11	likes	DOUBLE
12	viralComments	DOUBLE
13	viralVideoThirdQuartileCompletions	DOUBLE
14	oneClickLeads	DOUBLE
15	fullScreenPlays	DOUBLE
16	follows	DOUBLE
17	viralOneClickLeadFormOpens	DOUBLE
18	conversionValueInLocalCurrency	VARCHAR
19	viralFollows	DOUBLE
20	otherEngagements	DOUBLE
21	viralVideoCompletions	DOUBLE
22	leadGenerationMailInterestedClicks	DOUBLE
23	opens	DOUBLE
24	totalEngagements	DOUBLE
25	viralReactions	DOUBLE
26	_pivot	VARCHAR
27	videoViews	DOUBLE
28	end_date	VARCHAR	Incremental sync key
29	viralImpressions	DOUBLE
30	viralVideoViews	DOUBLE
31	costInLocalCurrency	VARCHAR
32	viralLikes	DOUBLE
33	viralOtherEngagements	DOUBLE
34	viralVideoMidpointCompletions	DOUBLE
35	shares	DOUBLE
36	viralFullScreenPlays	DOUBLE
37	videoMidpointCompletions	DOUBLE
38	viralExternalWebsitePostViewConversions	DOUBLE
39	viralTotalEngagements	DOUBLE
40	viralCompanyPageClicks	DOUBLE
41	start_date	VARCHAR
42	actionClicks	DOUBLE
43	viralShares	DOUBLE
44	pivotValue	VARCHAR
45	videoCompletions	DOUBLE
46	comments	DOUBLE
47	externalWebsitePostViewConversions	DOUBLE
48	viralVideoStarts	DOUBLE
49	costInUsd	VARCHAR
50	landingPageClicks	DOUBLE
51	oneClickLeadFormOpens	DOUBLE
52	impressions	DOUBLE
53	sends	DOUBLE
54	viralLandingPageClicks	DOUBLE
55	viralExternalWebsitePostClickConversions	DOUBLE
56	externalWebsiteConversions	DOUBLE
57	viralVideoFirstQuartileCompletions	DOUBLE
58	leadGenerationMailContactInfoShares	DOUBLE
59	clicks	DOUBLE
60	reactions	DOUBLE
61	viralClicks	DOUBLE
62	pivotValues	VARCHAR

Table: ad_campaign_analytics

No	Column Name	Type	Notes
1	externalWebsitePostClickConversions	DOUBLE
2	adUnitClicks	DOUBLE
3	companyPageClicks	DOUBLE
4	videoFirstQuartileCompletions	DOUBLE
5	viralOneClickLeads	DOUBLE
6	textUrlClicks	DOUBLE
7	viralCommentLikes	DOUBLE
8	videoStarts	DOUBLE
9	viralExternalWebsiteConversions	DOUBLE
10	videoThirdQuartileCompletions	DOUBLE
11	likes	DOUBLE
12	viralComments	DOUBLE
13	viralVideoThirdQuartileCompletions	DOUBLE
14	oneClickLeads	DOUBLE
15	fullScreenPlays	DOUBLE
16	follows	DOUBLE
17	viralOneClickLeadFormOpens	DOUBLE
18	conversionValueInLocalCurrency	VARCHAR
19	viralFollows	DOUBLE
20	otherEngagements	DOUBLE
21	viralVideoCompletions	DOUBLE
22	leadGenerationMailInterestedClicks	DOUBLE
23	opens	DOUBLE
24	totalEngagements	DOUBLE
25	viralReactions	DOUBLE
26	_pivot	VARCHAR
27	videoViews	DOUBLE
28	end_date	VARCHAR	Incremental sync key
29	viralImpressions	DOUBLE
30	viralVideoViews	DOUBLE
31	costInLocalCurrency	VARCHAR
32	viralLikes	DOUBLE
33	viralOtherEngagements	DOUBLE
34	viralVideoMidpointCompletions	DOUBLE
35	shares	DOUBLE
36	viralFullScreenPlays	DOUBLE
37	videoMidpointCompletions	DOUBLE
38	viralExternalWebsitePostViewConversions	DOUBLE
39	viralTotalEngagements	DOUBLE
40	viralCompanyPageClicks	DOUBLE
41	start_date	VARCHAR
42	actionClicks	DOUBLE
43	viralShares	DOUBLE
44	pivotValue	VARCHAR
45	videoCompletions	DOUBLE
46	comments	DOUBLE
47	externalWebsitePostViewConversions	DOUBLE
48	viralVideoStarts	DOUBLE
49	costInUsd	VARCHAR
50	landingPageClicks	DOUBLE
51	oneClickLeadFormOpens	DOUBLE
52	impressions	DOUBLE
53	sends	DOUBLE
54	viralLandingPageClicks	DOUBLE
55	viralExternalWebsitePostClickConversions	DOUBLE
56	externalWebsiteConversions	DOUBLE
57	viralVideoFirstQuartileCompletions	DOUBLE
58	leadGenerationMailContactInfoShares	DOUBLE
59	clicks	DOUBLE
60	reactions	DOUBLE
61	viralClicks	DOUBLE
62	pivotValues	VARCHAR

Table: campaign_groups

No	Column Name	Type	Notes
1	runSchedule	VARCHAR
2	test	BOOLEAN
3	created	VARCHAR
4	name	VARCHAR
5	servingStatuses	VARCHAR
6	backfilled	BOOLEAN
7	lastModified	VARCHAR	Incremental sync key
8	id	INTEGER
9	allowedCampaignTypes	VARCHAR
10	account	VARCHAR
11	status	VARCHAR

Table: creatives

No	Column Name	Type	Notes
1	reference	VARCHAR
2	variables	VARCHAR
3	test	BOOLEAN
4	created	VARCHAR
5	review	VARCHAR
6	campaign	VARCHAR
7	servingStatuses	VARCHAR
8	lastModified	VARCHAR	Incremental sync key
9	id	INTEGER
10	type	VARCHAR
11	version	VARCHAR
12	status	VARCHAR

Table: account_users

No	Column Name	Type	Notes
1	role	VARCHAR
2	created	VARCHAR
3	lastModified	VARCHAR	Incremental sync key
4	user	VARCHAR
5	account	VARCHAR

Table: ad_direct_sponsored_contents

No	Column Name	Type	Notes
1	owner	VARCHAR
2	contentReference	VARCHAR
3	created	VARCHAR
4	name	VARCHAR
5	lastModified	VARCHAR	Incremental sync key
6	type	VARCHAR
7	account	VARCHAR
8	status	VARCHAR

Table: accounts

No	Column Name	Type	Notes
1	test	BOOLEAN
2	created	VARCHAR
3	notifiedOnCreativeRejection	BOOLEAN
4	notifiedOnEndOfCampaign	BOOLEAN
5	servingStatuses	VARCHAR
6	notifiedOnCampaignOptimization	BOOLEAN
7	type	VARCHAR
8	version	VARCHAR
9	reference	VARCHAR
10	notifiedOnCreativeApproval	BOOLEAN
11	name	VARCHAR
12	currency	VARCHAR
13	lastModified	VARCHAR
14	id	INTEGER
15	status	VARCHAR

External Resources

• Login To Linkedin
• Use Here
• These Instructions
• Account Users
• Campaign Groups
• Ad Direct Sponsored Contents
• Ad Analytics By Campaign
• Ad Analytics By Creative
• More Information Here
• On This Page

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.