This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13728 | 13728 | 508a5 | 1707 1707 |
| 31427 | 31427 | 508a5 | 302 302 |
| 32071 | 32071 | 508a5 | 57 57 |
| 32430 | 32430 | 508a5 | 303 303 |
| 34611 | 34611 | 508a5 | 1910 1910 |
| 35297 | 35297 | 508a5 | 32 32 |
| 35411 | 35411 | 508a5 | 1911 1911 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)