Question 1

Why does the number type matter for ad spend?

Accepted Answer

Because floating point addition does not reliably give the same answer twice. A number arriving without declared precision maps to DECIMAL(65,30) in MySQL, so summing a month of spend produces an exact total rather than one that drifts in the last few decimal places. Reconciling your numbers against LinkedIn's own reporting is considerably easier as a result.

Question 2

What can I load into MySQL?

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 3

Why do old rows get rewritten?

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 each execution.

Question 4

Is the lookback window adjustable?

Accepted Answer

Yes, anywhere from one to three hundred and sixty five days. A longer window costs more API calls and rewrites more rows on every run, so the sensible approach is to raise it if you actually observe numbers settling late, rather than setting it high as insurance against a problem you may not have.

Question 5

How large do the report tables get?

Accepted Answer

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

Sync LinkedIn Ads to MySQL

Sync LinkedIn Ads to MySQL with Polytomic

Exact spend totals

A lookback you control

Member company reporting

Or sync MySQL to LinkedIn Ads

Trusted by businesses worldwide

Step-by-step integration guide

Connect LinkedIn Ads in Polytomic

Connect MySQL in Polytomic

Create a sync between LinkedIn Ads and MySQL

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 MySQL?