This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 21081 | 21081 | cc5ed | 2830 2830 |
| 21082 | 21082 | 3da9b | 2830 2830 |
| 21083 | 21083 | 371f0 | 2830 2830 |
| 21084 | 21084 | 5e075 | 2830 2830 |
| 21085 | 21085 | 59d75 | 2830 2830 |
| 21086 | 21086 | e6200 | 2830 2830 |
| 21087 | 21087 | b1201 | 2830 2830 |
| 21088 | 21088 | 8a7ee | 2830 2830 |
| 21089 | 21089 | 862ed | 2830 2830 |
| 21090 | 21090 | f788a | 2830 2830 |
| 21091 | 21091 | 9848a | 2830 2830 |
| 21092 | 21092 | abb72 | 2830 2830 |
| 21093 | 21093 | 27369 | 2830 2830 |
| 21094 | 21094 | e128e | 2830 2830 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)