This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12333 | 12333 | b07dd | 1937 1937 |
| 15252 | 15252 | b07dd | 16 16 |
| 34648 | 34648 | b07dd | 1784 1784 |
| 34752 | 34752 | b07dd | 1840 1840 |
| 34866 | 34866 | b07dd | 1838 1838 |
| 34896 | 34896 | b07dd | 1837 1837 |
| 34909 | 34909 | b07dd | 1839 1839 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)