This data as json, CSV (advanced)
| Link | rowid | target_id | ad_id |
|---|---|---|---|
| 11286 | 11286 | 63e96 | 897 897 |
| 11379 | 11379 | 63e96 | 837 837 |
| 31586 | 31586 | 63e96 | 832 832 |
| 33442 | 33442 | 63e96 | 921 921 |
| 33668 | 33668 | 63e96 | 918 918 |
| 33697 | 33697 | 63e96 | 922 922 |
| 33742 | 33742 | 63e96 | 923 923 |
| 33785 | 33785 | 63e96 | 817 817 |
| 33828 | 33828 | 63e96 | 831 831 |
| 33871 | 33871 | 63e96 | 778 778 |
| 33984 | 33984 | 63e96 | 911 911 |
| 34003 | 34003 | 63e96 | 915 915 |
| 34260 | 34260 | 63e96 | 791 791 |
| 34316 | 34316 | 63e96 | 783 783 |
JSON shape: default, array, newline-delimited
CREATE TABLE ad_targets (
target_id TEXT REFERENCES [targets]([id]),
ad_id INTEGER REFERENCES [ads]([id])
)