Detailed instructions to help you set up the data source for Targeting Gates
First of all, you need a valid Targeting Gates account in advance.
If yes, please move to Adriel's Connections page.
1. Type "Targeting Gates" into the search bar.
2. Enter a connection name. 
3. For data source settings, enter below four fields that are required and click the "Submit" button.
- Name: Enter data source name - any readable name is sufficient.
- URL to CSV: Input the URL form of API to this field. In the URL, replace the actual date with "$date".
- Replace the underlined part to date=$date and input the full URL to the field as below example.
- Before - https://rest/reportapi/performance-report?key=192938293ai&date=20230328&type=csv
- After - https://rest/reportapi/performance-report?key=192938293ai&date=$date&type=csv
- Replace the underlined part to date=$date and input the full URL to the field as below example.
How to find on Targeting Gates UI
[1] The above URL can be found here: Targeting Gates Platform.
Home → Client Admin → Ad Performance API → API URL → CSV Format
[2] Please set the 'Status' option to "Use(사용)".
[3] Please whitelist Adriel's IPs to allow access to your CSV URL.
- IP list can be found on this page.
[4] Don't forget to click the "Save" button at the bottom.
- Date format: How to format the date when sending a request
- Here, enter "yyyyMMdd" as an input.
- Unique key: Column name that will be used as the key
- Here, enter "캠페인 ID" as an input.
4. You are done! Please wait, your data will arrive soon.