This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 13564 | 13564 | 1a7f8 | 753 753 |
| 14017 | 14017 | 1a7f8 | 714 714 |
| 34711 | 34711 | 1a7f8 | 703 703 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)