This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 12771 | 12771 | ec3ac | 3491 3491 |
| 12772 | 12772 | aa8b2 | 3491 3491 |
| 12773 | 12773 | 5e075 | 3491 3491 |
| 12774 | 12774 | 59d75 | 3491 3491 |
| 12775 | 12775 | e6200 | 3491 3491 |
| 12776 | 12776 | 26bad | 3491 3491 |
| 12777 | 12777 | 56921 | 3491 3491 |
| 12778 | 12778 | 1bffd | 3491 3491 |
| 12779 | 12779 | b043e | 3491 3491 |
| 12780 | 12780 | 31a58 | 3491 3491 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)