Question 1

What can I load into Postgres?

Accepted Answer

Accounts, account users, audiences, campaign groups, campaigns and creatives on the object side. On the reporting side, ad analytics by campaign, by campaign and country, by creative, by member company, and by campaign and member company.

Question 2

Does it reread old data?

Accepted Answer

Report tables do, deliberately. They checkpoint incrementally but reread a trailing window so numbers LinkedIn restates later are corrected on the next ETL run. The default window is two days, and member company reports enforce a minimum of four. Regular objects like campaigns and creatives are simply reread on each execution.

Question 3

Can I change the lookback?

Accepted Answer

Yes, through the lookback period for reports setting, anywhere from one to three hundred and sixty five days. A longer window costs more API calls and rewrites more rows every run, so the sensible approach is to raise it if you actually see numbers settling late, rather than setting it high as a precaution.

Question 4

Will the report tables get big?

Accepted Answer

They can. A report table is roughly date times account times campaign or creative times the cardinality of the breakdown. Member company reports grow fastest, because they multiply by every company LinkedIn matched. In a transactional Postgres, index the report date and the natural keys, and consider a retention policy rather than keeping every day forever.

Question 5

Why put ad data in Postgres rather than a data warehouse?

Accepted Answer

Usually because pipeline is already there. If your CRM records are being replicated into the same database, joining spend to closed revenue is one query away with nothing federated across systems. Plenty of teams start here and move to a data warehouse only once report volume makes the move worth paying for.

Sync LinkedIn Ads to PostgreSQL

Sync LinkedIn Ads to PostgreSQL with Polytomic

Member company reporting

A lookback you control

Objects and reports

Or sync PostgreSQL to LinkedIn Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect LinkedIn Ads in Polytomic

Connect PostgreSQL in Polytomic

Create a sync between LinkedIn Ads and PostgreSQL

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect LinkedIn Ads with PostgreSQL?