01Jobs it does
Each one is a real command line. Copy it, or open it in the builder below to change it.
realtime traffic
Also: realtime clicks, live traffic, live clicks, watch clicks, watch traffic, tail clicks, stream clicks, monitor traffic, clicks as they arrive, clicks as they come in, incoming clicks
p202 click list --followvisitor log
Also: recent clicks, click history, individual clicks
p202 click list02What you get
Captured from the real binary, run against a demo store with 30 days of traffic. Switch tabs to see the same run as JSON, the shape scripts and agents parse.
$ p202 click list --limit 8 --period last7 --fields click_id,click_time,aff_campaign_name,ppc_account_name,country_name,device_type,click_lead,click_payout click_id click_time aff_campaign_name ppc_account_name country_name device_type click_lead click_payout -------- ---------- ------------------------- ------------------------ -------------- ----------- ---------- ------------ 625 1792621861 Standing Desk Launch / UK Search Ads - Shopping United Kingdom Desktop 0 480 1192 1792621535 Bakery Pre-orders / Local Newsletter United States Desktop 1 141 1084 1792621483 Spring Collection / US Social Ads - Prospecting United States Mobile 0 86 108 1792621110 Spring Collection / US Social Ads - Prospecting United States Mobile 0 86 1601 1792620784 Free Trial to Paid / CA Social Ads - Prospecting Canada Desktop 0 29 743 1792620739 Bakery Pre-orders / Local Social Ads - Prospecting United States Mobile 0 24 2084 1792620331 Free Trial to Paid / CA Social Ads - Prospecting United States Mobile 0 29 272 1792620291 Standing Desk Launch / UK Search Ads - Shopping United Kingdom Desktop 0 480 Total: 1024 | Limit: 8 | Offset: 0 Warning: Showing 8 of 1024 results. Use --all to fetch all.
$ p202 click list --limit 8 --period last7 --fields click_id,click_time,aff_campaign_name,ppc_account_name,country_name,device_type,click_lead,click_payout --json { "data": [ { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 2, "browser_name": "Chrome", "city_id": 218, "city_name": "Rochdale", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 625, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792621861, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "203.0.113.110", "ip_id": 618, "isp_id": 0, "isp_name": null, "keyword": "standing desk uk", "keyword_id": 1, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=standing+desk+uk", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 71, "region_name": "Rochdale", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 2, "browser_name": "Chrome", "city_id": 177, "city_name": "Plainfield", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1192, "click_id_public": 0, "click_in": 1, "click_lead": 1, "click_out": 1, "click_payout": 141, "click_time": 1792621535, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.145", "ip_id": 1161, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=316509108\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=bakery-q4\u0026utm_content=friday-bake-list\u0026c1=friday-bake-list\u0026c2=us", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 23, "region_name": "New Jersey", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 214, "city_name": "Columbia", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 1084, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792621483, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.42", "ip_id": 1058, "isp_id": 0, "isp_name": null, "keyword": "spring outfits", "keyword_id": 3, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=video-15s\u0026c1=carousel-lookbook\u0026c2=us\u0026t202kw=spring+outfits", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 24, "region_name": "Maryland", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 89, "city_name": "Harrisburg", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 108, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792621110, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "192.0.2.108", "ip_id": 108, "isp_id": 0, "isp_name": null, "keyword": "wrap dress", "keyword_id": 10, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=carousel-lookbook\u0026c1=static-model\u0026c2=us\u0026t202kw=wrap+dress", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 4, "browser_name": "Edge", "city_id": 55, "city_name": "Toronto", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.95, "click_filtered": 0, "click_id": 1601, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792620784, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.31", "ip_id": 1555, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=67532231\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=trial-q4\u0026utm_content=static-template\u0026c1=static-template\u0026c2=ca", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 2, "region_name": "Ontario", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 321, "city_name": "York", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 743, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792620739, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "203.0.113.224", "ip_id": 732, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=975957852\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=cake-preorder\u0026c1=cake-preorder\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 109, "city_name": "Washington", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.95, "click_filtered": 0, "click_id": 2084, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792620331, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.233", "ip_id": 2011, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=67532231\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=trial-q4\u0026utm_content=video-demo-30s\u0026c1=video-demo-30s\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 48, "region_name": "District of Columbia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 4, "browser_name": "Edge", "city_id": 203, "city_name": "London", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 272, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792620291, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.16", "ip_id": 270, "isp_id": 0, "isp_name": null, "keyword": "standing desk uk", "keyword_id": 1, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=standing+desk+uk", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 66, "region_name": "England", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null } ], "pagination": { "limit": 8, "offset": 0, "total": 1024 } }
$ p202 click list --limit 10 --period last7 keyword aff_campaign_id aff_campaign_name browser_id browser_name city_id city_name click_alp click_bot click_cloaking click_cpc click_filtered click_id click_id_public click_in click_lead click_out click_payout click_time country_code country_id country_name device_id device_name device_type ip_address ip_id isp_id isp_name keyword_id landing landing_page_id landing_page_nickname outbound platform_id platform_name ppc_account_id ppc_account_name ppc_network_name referer region_id region_name rotator_id rule_id rule_redirect_id text_ad_id text_ad_name --------------------------- --------------- ---------------------------- ---------- ------------- ------- ------------- --------- --------- -------------- --------- -------------- -------- --------------- -------- ---------- --------- ------------ ---------- ------------ ---------- -------------- --------- ----------- ----------- -------------- ----- ------ -------- ---------- ------- --------------- --------------------- ------------------------------------------ ----------- ------------- -------------- ------------------------ ---------------- ------- --------- -------------------- ---------- ------- ---------------- ---------- ------------ standing desk uk 3 Standing Desk Launch / UK 2 Chrome 218 Rochdale 0 0 0 1.10 0 625 0 1 0 1 480 1792621861 GB 4 United Kingdom 3 Desktop Desktop 203.0.113.110 618 0 1 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 71 Rochdale 0 6 Bakery Pre-orders / Local 2 Chrome 177 Plainfield 0 0 0 0 0 1192 0 1 1 1 141 1792621535 US 2 United States 3 Desktop Desktop 198.51.100.145 1161 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 5 Newsletter Owned Media 23 New Jersey 0 spring outfits 1 Spring Collection / US 1 Mobile Safari 214 Columbia 0 0 0 0.42 0 1084 0 1 0 1 86 1792621483 US 2 United States 1 iPhone Mobile 198.51.100.42 1058 0 3 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 24 Maryland 0 wrap dress 1 Spring Collection / US 5 Chrome Mobile 89 Harrisburg 0 0 0 0.42 0 108 0 1 0 1 86 1792621110 US 2 United States 4 Pixel 8 Mobile 192.0.2.108 108 0 10 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 1 Pennsylvania 0 5 Free Trial to Paid / CA 4 Edge 55 Toronto 0 0 0 0.95 0 1601 0 1 0 1 29 1792620784 CA 1 Canada 3 Desktop Desktop 192.0.2.31 1555 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 3 Social Ads - Prospecting Social 2 Ontario 0 6 Bakery Pre-orders / Local 1 Mobile Safari 321 York 0 0 0 0.18 0 743 0 1 0 1 24 1792620739 US 2 United States 1 iPhone Mobile 203.0.113.224 732 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 1 Pennsylvania 0 5 Free Trial to Paid / CA 1 Mobile Safari 109 Washington 0 0 0 0.95 0 2084 0 1 0 1 29 1792620331 US 2 United States 1 iPhone Mobile 198.51.100.233 2011 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 48 District of Columbia 0 standing desk uk 3 Standing Desk Launch / UK 4 Edge 203 London 0 0 0 1.10 0 272 0 1 0 1 480 1792620291 GB 4 United Kingdom 3 Desktop Desktop 198.51.100.16 270 0 1 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 66 England 0 whole bean coffee delivery 2 Coffee Subscription / US 2 Chrome 35 Chicago 0 0 0 0.38 0 442 0 1 0 1 32 1792620285 US 2 United States 3 Desktop Desktop 198.51.100.184 438 0 12 0 https://track.example.com/tracking202/redirec… 2 Windows 1 Search Ads - Brand Search 12 Illinois 0 project management software 4 Project Tool Pro Annual / US 2 Chrome 845 Bad Bruckenau 0 0 0 2.40 0 1913 0 1 0 1 348 1792620117 DE 5 Germany 3 Desktop Desktop 198.51.100.70 1848 0 13 0 https://track.example.com/tracking202/redirec… 2 Windows 1 Search Ads - Brand Search 61 Bavaria 0 Total: 1024 | Limit: 10 | Offset: 0 Warning: Showing 10 of 1024 results. Use --all to fetch all.
$ p202 click list --limit 10 --period last7 --json { "data": [ { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 2, "browser_name": "Chrome", "city_id": 218, "city_name": "Rochdale", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 625, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792621861, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "203.0.113.110", "ip_id": 618, "isp_id": 0, "isp_name": null, "keyword": "standing desk uk", "keyword_id": 1, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=standing+desk+uk", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 71, "region_name": "Rochdale", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 2, "browser_name": "Chrome", "city_id": 177, "city_name": "Plainfield", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1192, "click_id_public": 0, "click_in": 1, "click_lead": 1, "click_out": 1, "click_payout": 141, "click_time": 1792621535, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.145", "ip_id": 1161, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=316509108\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=bakery-q4\u0026utm_content=friday-bake-list\u0026c1=friday-bake-list\u0026c2=us", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 23, "region_name": "New Jersey", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 214, "city_name": "Columbia", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 1084, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792621483, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.42", "ip_id": 1058, "isp_id": 0, "isp_name": null, "keyword": "spring outfits", "keyword_id": 3, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=video-15s\u0026c1=carousel-lookbook\u0026c2=us\u0026t202kw=spring+outfits", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 24, "region_name": "Maryland", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 89, "city_name": "Harrisburg", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 108, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792621110, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "192.0.2.108", "ip_id": 108, "isp_id": 0, "isp_name": null, "keyword": "wrap dress", "keyword_id": 10, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=carousel-lookbook\u0026c1=static-model\u0026c2=us\u0026t202kw=wrap+dress", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 4, "browser_name": "Edge", "city_id": 55, "city_name": "Toronto", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.95, "click_filtered": 0, "click_id": 1601, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792620784, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.31", "ip_id": 1555, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=67532231\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=trial-q4\u0026utm_content=static-template\u0026c1=static-template\u0026c2=ca", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 2, "region_name": "Ontario", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 321, "city_name": "York", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 743, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792620739, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "203.0.113.224", "ip_id": 732, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=975957852\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=cake-preorder\u0026c1=cake-preorder\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 109, "city_name": "Washington", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.95, "click_filtered": 0, "click_id": 2084, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792620331, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.233", "ip_id": 2011, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=67532231\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=trial-q4\u0026utm_content=video-demo-30s\u0026c1=video-demo-30s\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 48, "region_name": "District of Columbia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 4, "browser_name": "Edge", "city_id": 203, "city_name": "London", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 272, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792620291, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.16", "ip_id": 270, "isp_id": 0, "isp_name": null, "keyword": "standing desk uk", "keyword_id": 1, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=standing+desk+uk", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 66, "region_name": "England", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 35, "city_name": "Chicago", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 442, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792620285, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.184", "ip_id": 438, "isp_id": 0, "isp_name": null, "keyword": "whole bean coffee delivery", "keyword_id": 12, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=153609338\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=coffee-q4\u0026utm_content=brand-sitelinks\u0026c1=brand-sitelinks\u0026c2=us\u0026t202kw=whole+bean+coffee+delivery", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 12, "region_name": "Illinois", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 4, "aff_campaign_name": "Project Tool Pro Annual / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 845, "city_name": "Bad Bruckenau", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 2.4, "click_filtered": 0, "click_id": 1913, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1792620117, "country_code": "DE", "country_id": 5, "country_name": "Germany", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.70", "ip_id": 1848, "isp_id": 0, "isp_name": null, "keyword": "project management software", "keyword_id": 13, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=556134205\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=pro-q4\u0026utm_content=brand-exact\u0026c1=brand-exact\u0026c2=de\u0026t202kw=project+management+software", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 61, "region_name": "Bavaria", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null } ], "pagination": { "limit": 10, "offset": 0, "total": 1024 } }
$ p202 click list keyword aff_campaign_id aff_campaign_name browser_id browser_name city_id city_name click_alp click_bot click_cloaking click_cpc click_filtered click_id click_id_public click_in click_lead click_out click_payout click_time country_code country_id country_name device_id device_name device_type ip_address ip_id isp_id isp_name keyword_id landing landing_page_id landing_page_nickname outbound platform_id platform_name ppc_account_id ppc_account_name ppc_network_name referer region_id region_name rotator_id rule_id rule_redirect_id text_ad_id text_ad_name --------------------------- --------------- ---------------------------- ---------- ---------------- ------- --------------- --------- --------- -------------- --------- -------------- -------- --------------- -------- ---------- --------- ------------ ---------- ------------ ---------- -------------- --------- ---------------- ----------- -------------- ----- ------ -------- ---------- ------- --------------- --------------------- ------------------------------------------ ----------- ------------- -------------- ------------------------ ---------------- ------- --------- -------------------- ---------- ------- ---------------- ---------- ------------ standing desk uk 3 Standing Desk Launch / UK 2 Chrome 218 Rochdale 0 0 0 1.10 0 625 0 1 0 1 480 1792621861 GB 4 United Kingdom 3 Desktop Desktop 203.0.113.110 618 0 1 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 71 Rochdale 0 6 Bakery Pre-orders / Local 2 Chrome 177 Plainfield 0 0 0 0 0 1192 0 1 1 1 141 1792621535 US 2 United States 3 Desktop Desktop 198.51.100.145 1161 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 5 Newsletter Owned Media 23 New Jersey 0 spring outfits 1 Spring Collection / US 1 Mobile Safari 214 Columbia 0 0 0 0.42 0 1084 0 1 0 1 86 1792621483 US 2 United States 1 iPhone Mobile 198.51.100.42 1058 0 3 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 24 Maryland 0 wrap dress 1 Spring Collection / US 5 Chrome Mobile 89 Harrisburg 0 0 0 0.42 0 108 0 1 0 1 86 1792621110 US 2 United States 4 Pixel 8 Mobile 192.0.2.108 108 0 10 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 1 Pennsylvania 0 5 Free Trial to Paid / CA 4 Edge 55 Toronto 0 0 0 0.95 0 1601 0 1 0 1 29 1792620784 CA 1 Canada 3 Desktop Desktop 192.0.2.31 1555 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 3 Social Ads - Prospecting Social 2 Ontario 0 6 Bakery Pre-orders / Local 1 Mobile Safari 321 York 0 0 0 0.18 0 743 0 1 0 1 24 1792620739 US 2 United States 1 iPhone Mobile 203.0.113.224 732 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 1 Pennsylvania 0 5 Free Trial to Paid / CA 1 Mobile Safari 109 Washington 0 0 0 0.95 0 2084 0 1 0 1 29 1792620331 US 2 United States 1 iPhone Mobile 198.51.100.233 2011 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 48 District of Columbia 0 standing desk uk 3 Standing Desk Launch / UK 4 Edge 203 London 0 0 0 1.10 0 272 0 1 0 1 480 1792620291 GB 4 United Kingdom 3 Desktop Desktop 198.51.100.16 270 0 1 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 66 England 0 whole bean coffee delivery 2 Coffee Subscription / US 2 Chrome 35 Chicago 0 0 0 0.38 0 442 0 1 0 1 32 1792620285 US 2 United States 3 Desktop Desktop 198.51.100.184 438 0 12 0 https://track.example.com/tracking202/redirec… 2 Windows 1 Search Ads - Brand Search 12 Illinois 0 project management software 4 Project Tool Pro Annual / US 2 Chrome 845 Bad Bruckenau 0 0 0 2.40 0 1913 0 1 0 1 348 1792620117 DE 5 Germany 3 Desktop Desktop 198.51.100.70 1848 0 13 0 https://track.example.com/tracking202/redirec… 2 Windows 1 Search Ads - Brand Search 61 Bavaria 0 coffee subscription 2 Coffee Subscription / US 4 Edge 193 Norcross 0 0 0 0.38 0 257 0 1 0 1 32 1792619882 US 2 United States 3 Desktop Desktop 198.51.100.2 256 0 16 0 https://track.example.com/tracking202/redirec… 2 Windows 1 Search Ads - Brand Search 13 Georgia 0 6 Bakery Pre-orders / Local 5 Chrome Mobile 27 Mechanicsville 0 0 0 0 0 1871 0 1 0 1 24 1792619661 US 2 United States 4 Pixel 8 Mobile 198.51.100.31 1809 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 5 Newsletter Owned Media 24 Maryland 0 free project planner 5 Free Trial to Paid / CA 7 Firefox 266 London 0 0 0 1.80 0 2765 0 1 0 1 29 1792619605 CA 1 Canada 3 Desktop Desktop 198.51.100.94 2634 0 19 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 1 Search Ads - Brand Search 2 Ontario 0 6 Bakery Pre-orders / Local 5 Chrome Mobile 626 Mt. Pleasant 0 0 0 0.18 0 1210 0 1 0 1 24 1792619559 US 2 United States 4 Pixel 8 Mobile 198.51.100.162 1178 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 93 South Carolina 0 1 Spring Collection / US 2 Chrome 848 Rosharon 0 0 0 0 0 2838 0 1 0 1 86 1792619486 US 2 United States 3 Desktop Desktop 198.51.100.158 2698 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 5 Newsletter Owned Media 11 Texas 0 gift cards australia 7 Holiday Gift Cards / AU 1 Mobile Safari 11 Unknown city 0 0 0 0.48 0 734 0 1 0 1 50 1792619481 AU 3 Australia 1 iPhone Mobile 203.0.113.215 723 0 2 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 10 Unknown region 0 2 Coffee Subscription / US 1 Mobile Safari 615 Groveland 0 0 0 0.29 1 2004 0 1 0 1 32 1792619472 US 2 United States 1 iPhone Mobile 198.51.100.130 1146 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 4 Social Ads - Retargeting Social 17 Massachusetts 0 2 Coffee Subscription / US 1 Mobile Safari 22 Unknown city 0 0 0 0.29 0 1381 0 1 0 1 32 1792619193 US 2 United States 1 iPhone Mobile 203.0.113.73 1343 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 4 Social Ads - Retargeting Social 19 Unknown region 0 last minute gift 7 Holiday Gift Cards / AU 1 Mobile Safari 234 Perth 0 0 0 0.48 0 331 0 1 0 1 50 1792619064 AU 3 Australia 1 iPhone Mobile 198.51.100.75 329 0 4 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 26 Western Australia 0 linen shirt men 1 Spring Collection / US 2 Chrome 17 Oakland 0 0 0 0.65 0 1398 0 1 0 1 86 1792618954 US 2 United States 3 Desktop Desktop 203.0.113.88 1358 0 18 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 15 California 0 2 Coffee Subscription / US 5 Chrome Mobile 105 Philadelphia 0 0 0 0.55 0 945 0 1 0 1 32 1792618789 US 2 United States 4 Pixel 8 Mobile 192.0.2.165 927 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 6 Podcast Sponsorship Owned Media 1 Pennsylvania 0 wrap dress 1 Spring Collection / US 2 Chrome 41 Baltimore 0 0 0 0.42 0 853 0 1 0 1 86 1792618783 US 2 United States 3 Desktop Desktop 192.0.2.75 837 0 10 0 https://track.example.com/tracking202/redirec… 2 Windows 3 Social Ads - Prospecting Social 24 Maryland 0 6 Bakery Pre-orders / Local 5 Chrome Mobile 60 Boston 0 0 0 0 0 2378 0 1 0 1 24 1792618775 US 2 United States 4 Pixel 8 Mobile 203.0.113.249 2281 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 5 Newsletter Owned Media 17 Massachusetts 0 2 Coffee Subscription / US 2 Chrome 206 Woodbridge 0 0 0 0.29 0 1906 0 1 0 1 32 1792618622 US 2 United States 3 Desktop Desktop 198.51.100.63 1841 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 4 Social Ads - Retargeting Social 21 Virginia 0 2 Coffee Subscription / US 3 Safari 39 West Palm Beach 0 0 0 0.55 0 1212 0 1 0 1 32 1792618257 US 2 United States 3 Desktop Desktop 198.51.100.164 1180 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 6 Podcast Sponsorship Owned Media 8 Florida 0 wrap dress midi 1 Spring Collection / US 4 Edge 155 Punta Gorda 0 0 0 0.65 0 698 0 1 0 1 86 1792618159 US 2 United States 3 Desktop Desktop 203.0.113.181 689 0 7 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 8 Florida 0 whole bean coffee delivery 2 Coffee Subscription / US 1 Mobile Safari 166 Miami 0 0 0 0.38 0 2574 0 1 0 1 32 1792618029 US 2 United States 1 iPhone Mobile 192.0.2.182 2468 0 12 0 https://track.example.com/tracking202/redirec… 1 iOS 1 Search Ads - Brand Search 8 Florida 0 4 Project Tool Pro Annual / US 3 Safari 479 Sanger 0 0 0 1.20 0 832 0 1 0 1 348 1792617955 US 2 United States 3 Desktop Desktop 192.0.2.55 817 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 6 Podcast Sponsorship Owned Media 15 California 0 2 Coffee Subscription / US 6 Samsung Internet 278 Portland 0 0 0 0.29 0 1521 0 1 0 1 32 1792617861 US 2 United States 5 Samsung SM-S921B Mobile 203.0.113.207 1477 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 30 Oregon 0 linen shirt men 1 Spring Collection / US 2 Chrome 12 Houston 0 0 0 0.65 0 2307 0 1 0 1 86 1792617735 US 2 United States 3 Desktop Desktop 203.0.113.182 2214 0 18 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 11 Texas 0 spring collection 1 Spring Collection / US 1 Mobile Safari 112 Reading 0 0 0 0.65 0 268 0 1 0 1 86 1792617422 US 2 United States 2 iPad Tablet 198.51.100.13 267 0 6 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 1 Pennsylvania 0 wrap dress midi 1 Spring Collection / US 1 Mobile Safari 205 Stockton 0 0 0 0.65 0 2253 0 1 0 1 86 1792617401 US 2 United States 1 iPhone Mobile 203.0.113.133 2165 0 7 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 15 California 0 6 Bakery Pre-orders / Local 5 Chrome Mobile 52 Bloomington 0 0 0 0.18 0 56 0 1 0 1 24 1792617330 US 2 United States 4 Pixel 8 Mobile 192.0.2.56 56 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 12 Illinois 0 4 Project Tool Pro Annual / US 5 Chrome Mobile 148 Fairfield 0 0 0 1.20 0 320 0 1 0 1 348 1792617264 US 2 United States 4 Pixel 8 Mobile 198.51.100.64 318 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 6 Podcast Sponsorship Owned Media 1 Pennsylvania 0 7 Holiday Gift Cards / AU 3 Safari 11 Unknown city 0 0 0 0.31 1 2641 0 1 0 1 50 1792616939 AU 3 Australia 3 Desktop Desktop 192.0.2.228 228 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 4 Social Ads - Retargeting Social 10 Unknown region 0 project management software 4 Project Tool Pro Annual / US 2 Chrome 55 Toronto 0 0 0 2.40 0 1786 0 1 0 1 348 1792616767 CA 1 Canada 3 Desktop Desktop 192.0.2.203 1727 0 13 0 https://track.example.com/tracking202/redirec… 2 Windows 1 Search Ads - Brand Search 2 Ontario 0 digital gift card 7 Holiday Gift Cards / AU 1 Mobile Safari 521 Jane Brook 0 0 0 0.48 0 924 0 1 0 1 50 1792616533 AU 3 Australia 2 iPad Tablet 192.0.2.145 907 0 20 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 26 Western Australia 0 wrap dress 1 Spring Collection / US 6 Samsung Internet 401 Terryville 0 0 0 0.42 0 649 0 1 0 1 86 1792616393 US 2 United States 5 Samsung SM-S921B Mobile 203.0.113.133 641 0 10 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 34 Connecticut 0 6 Bakery Pre-orders / Local 1 Mobile Safari 437 East Brunswick 0 0 0 0.18 0 1164 0 1 0 1 24 1792616222 US 2 United States 1 iPhone Mobile 198.51.100.118 1134 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 23 New Jersey 0 standing desk uk 3 Standing Desk Launch / UK 3 Safari 861 Colne 0 0 0 1.10 0 1986 0 1 0 1 480 1792616177 GB 4 United Kingdom 3 Desktop Desktop 198.51.100.140 1918 0 1 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 2 Search Ads - Shopping Search 78 Lancashire 0 height adjustable desk 3 Standing Desk Launch / UK 7 Firefox 70 Unknown city 0 0 0 1.10 0 296 0 1 0 1 480 1792616113 GB 4 United Kingdom 3 Desktop Desktop 198.51.100.40 294 0 5 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 2 Search Ads - Shopping Search 35 Unknown region 0 1 Spring Collection / US 2 Chrome 367 Naples 0 0 0 0 0 789 0 1 0 1 86 1792615797 US 2 United States 3 Desktop Desktop 192.0.2.16 778 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 5 Newsletter Owned Media 8 Florida 0 1 Spring Collection / US 3 Safari 22 Unknown city 0 0 0 0 0 1228 0 1 0 1 86 1792615514 US 2 United States 3 Desktop Desktop 198.51.100.179 1195 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 5 Newsletter Owned Media 19 Unknown region 0 7 Holiday Gift Cards / AU 5 Chrome Mobile 11 Unknown city 0 0 0 0.31 0 2303 0 1 0 1 50 1792614812 AU 3 Australia 4 Pixel 8 Mobile 203.0.113.178 2210 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 10 Unknown region 0 project management software 4 Project Tool Pro Annual / US 3 Safari 339 Manchester 0 0 0 2.40 0 1493 0 1 0 1 348 1792614558 GB 4 United Kingdom 3 Desktop Desktop 203.0.113.179 1449 0 13 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 1 Search Ads - Brand Search 91 Manchester 0 spring outfits 1 Spring Collection / US 5 Chrome Mobile 169 Lake Worth 0 0 0 0.42 0 1973 0 1 0 1 86 1792614507 US 2 United States 4 Pixel 8 Mobile 198.51.100.130 1908 0 3 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 8 Florida 0 2 Coffee Subscription / US 1 Mobile Safari 100 Montrose 0 0 0 0.55 0 122 0 1 0 1 32 1792614413 US 2 United States 1 iPhone Mobile 192.0.2.122 122 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 6 Podcast Sponsorship Owned Media 40 Minnesota 0 project tool free trial 5 Free Trial to Paid / CA 2 Chrome 607 Amesbury 0 0 0 1.80 0 1154 0 1 0 1 29 1792613849 US 2 United States 3 Desktop Desktop 198.51.100.109 1125 0 17 0 https://track.example.com/tracking202/redirec… 2 Windows 1 Search Ads - Brand Search 17 Massachusetts 0 2 Coffee Subscription / US 2 Chrome 172 Windsor 0 0 0 0.55 0 1274 0 1 0 1 32 1792613626 US 2 United States 3 Desktop Desktop 198.51.100.225 1241 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 6 Podcast Sponsorship Owned Media 15 California 0 wrap dress midi 1 Spring Collection / US 1 Mobile Safari 324 Cambridge 0 0 0 0.65 0 497 0 1 0 1 86 1792612823 US 2 United States 1 iPhone Mobile 198.51.100.239 493 0 7 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 17 Massachusetts 0 Total: 2900 | Limit: 50 | Offset: 0 Warning: Showing 50 of 2900 results. Use --all to fetch all.
$ p202 click list --json { "data": [ { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 2, "browser_name": "Chrome", "city_id": 218, "city_name": "Rochdale", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 625, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792621861, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "203.0.113.110", "ip_id": 618, "isp_id": 0, "isp_name": null, "keyword": "standing desk uk", "keyword_id": 1, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=standing+desk+uk", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 71, "region_name": "Rochdale", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 2, "browser_name": "Chrome", "city_id": 177, "city_name": "Plainfield", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1192, "click_id_public": 0, "click_in": 1, "click_lead": 1, "click_out": 1, "click_payout": 141, "click_time": 1792621535, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.145", "ip_id": 1161, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=316509108\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=bakery-q4\u0026utm_content=friday-bake-list\u0026c1=friday-bake-list\u0026c2=us", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 23, "region_name": "New Jersey", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 214, "city_name": "Columbia", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 1084, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792621483, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.42", "ip_id": 1058, "isp_id": 0, "isp_name": null, "keyword": "spring outfits", "keyword_id": 3, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=video-15s\u0026c1=carousel-lookbook\u0026c2=us\u0026t202kw=spring+outfits", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 24, "region_name": "Maryland", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 89, "city_name": "Harrisburg", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 108, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792621110, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "192.0.2.108", "ip_id": 108, "isp_id": 0, "isp_name": null, "keyword": "wrap dress", "keyword_id": 10, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=carousel-lookbook\u0026c1=static-model\u0026c2=us\u0026t202kw=wrap+dress", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 4, "browser_name": "Edge", "city_id": 55, "city_name": "Toronto", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.95, "click_filtered": 0, "click_id": 1601, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792620784, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.31", "ip_id": 1555, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=67532231\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=trial-q4\u0026utm_content=static-template\u0026c1=static-template\u0026c2=ca", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 2, "region_name": "Ontario", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 321, "city_name": "York", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 743, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792620739, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "203.0.113.224", "ip_id": 732, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=975957852\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=cake-preorder\u0026c1=cake-preorder\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 109, "city_name": "Washington", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.95, "click_filtered": 0, "click_id": 2084, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792620331, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.233", "ip_id": 2011, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=67532231\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=trial-q4\u0026utm_content=video-demo-30s\u0026c1=video-demo-30s\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 48, "region_name": "District of Columbia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 4, "browser_name": "Edge", "city_id": 203, "city_name": "London", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 272, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792620291, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.16", "ip_id": 270, "isp_id": 0, "isp_name": null, "keyword": "standing desk uk", "keyword_id": 1, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=standing+desk+uk", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 66, "region_name": "England", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 35, "city_name": "Chicago", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 442, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792620285, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.184", "ip_id": 438, "isp_id": 0, "isp_name": null, "keyword": "whole bean coffee delivery", "keyword_id": 12, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=153609338\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=coffee-q4\u0026utm_content=brand-sitelinks\u0026c1=brand-sitelinks\u0026c2=us\u0026t202kw=whole+bean+coffee+delivery", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 12, "region_name": "Illinois", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 4, "aff_campaign_name": "Project Tool Pro Annual / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 845, "city_name": "Bad Bruckenau", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 2.4, "click_filtered": 0, "click_id": 1913, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1792620117, "country_code": "DE", "country_id": 5, "country_name": "Germany", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.70", "ip_id": 1848, "isp_id": 0, "isp_name": null, "keyword": "project management software", "keyword_id": 13, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=556134205\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=pro-q4\u0026utm_content=brand-exact\u0026c1=brand-exact\u0026c2=de\u0026t202kw=project+management+software", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 61, "region_name": "Bavaria", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 4, "browser_name": "Edge", "city_id": 193, "city_name": "Norcross", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 257, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792619882, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.2", "ip_id": 256, "isp_id": 0, "isp_name": null, "keyword": "coffee subscription", "keyword_id": 16, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=153609338\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=coffee-q4\u0026utm_content=brand-sitelinks\u0026c1=brand-sitelinks\u0026c2=us\u0026t202kw=coffee+subscription", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 13, "region_name": "Georgia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 27, "city_name": "Mechanicsville", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1871, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792619661, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.51.100.31", "ip_id": 1809, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=316509108\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=bakery-q4\u0026utm_content=friday-bake-list\u0026c1=friday-bake-list\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 24, "region_name": "Maryland", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 7, "browser_name": "Firefox", "city_id": 266, "city_name": "London", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.8, "click_filtered": 0, "click_id": 2765, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792619605, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.94", "ip_id": 2634, "isp_id": 0, "isp_name": null, "keyword": "free project planner", "keyword_id": 19, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=987532671\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=trial-q4\u0026utm_content=brand-exact\u0026c1=brand-exact\u0026c2=ca\u0026t202kw=free+project+planner", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 2, "region_name": "Ontario", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 626, "city_name": "Mt. Pleasant", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 1210, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792619559, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.51.100.162", "ip_id": 1178, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=975957852\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=weekend-pastry-box\u0026c1=cake-preorder\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 93, "region_name": "South Carolina", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 848, "city_name": "Rosharon", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 2838, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792619486, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.158", "ip_id": 2698, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=223444901\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=spring-q4\u0026utm_content=spring-drop-email\u0026c1=spring-drop-email\u0026c2=us", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 11, "region_name": "Texas", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 7, "aff_campaign_name": "Holiday Gift Cards / AU", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 11, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.48, "click_filtered": 0, "click_id": 734, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1792619481, "country_code": "AU", "country_id": 3, "country_name": "Australia", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "203.0.113.215", "ip_id": 723, "isp_id": 0, "isp_name": null, "keyword": "gift cards australia", "keyword_id": 2, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=977472043\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=gift-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=au\u0026t202kw=gift+cards+australia", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 10, "region_name": "Unknown region", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 615, "city_name": "Groveland", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 1, "click_id": 2004, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792619472, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.130", "ip_id": 1146, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=185316404\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=spring-q4\u0026utm_content=spring-drop-email\u0026c1=ugc-review\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 4, "ppc_account_name": "Social Ads - Retargeting", "ppc_network_name": "Social", "referer": null, "region_id": 17, "region_name": "Massachusetts", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 22, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 1381, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792619193, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "203.0.113.73", "ip_id": 1343, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=185316404\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=cart-reminder\u0026c1=cart-reminder\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 4, "ppc_account_name": "Social Ads - Retargeting", "ppc_network_name": "Social", "referer": null, "region_id": 19, "region_name": "Unknown region", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 7, "aff_campaign_name": "Holiday Gift Cards / AU", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 234, "city_name": "Perth", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.48, "click_filtered": 0, "click_id": 331, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1792619064, "country_code": "AU", "country_id": 3, "country_name": "Australia", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.75", "ip_id": 329, "isp_id": 0, "isp_name": null, "keyword": "last minute gift", "keyword_id": 4, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=977472043\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=gift-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=au\u0026t202kw=last+minute+gift", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 26, "region_name": "Western Australia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 17, "city_name": "Oakland", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 1398, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792618954, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "203.0.113.88", "ip_id": 1358, "isp_id": 0, "isp_name": null, "keyword": "linen shirt men", "keyword_id": 18, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=719630684\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=spring-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=us\u0026t202kw=linen+shirt+men", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 15, "region_name": "California", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 105, "city_name": "Philadelphia", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.55, "click_filtered": 0, "click_id": 945, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792618789, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "192.0.2.165", "ip_id": 927, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=615053373\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep212\u0026c1=host-read-ep212\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 6, "ppc_account_name": "Podcast Sponsorship", "ppc_network_name": "Owned Media", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 41, "city_name": "Baltimore", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 853, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792618783, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.75", "ip_id": 837, "isp_id": 0, "isp_name": null, "keyword": "wrap dress", "keyword_id": 10, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=static-model\u0026c1=static-model\u0026c2=us\u0026t202kw=wrap+dress", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 24, "region_name": "Maryland", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 60, "city_name": "Boston", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 2378, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792618775, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "203.0.113.249", "ip_id": 2281, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=316509108\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=bakery-q4\u0026utm_content=friday-bake-list\u0026c1=friday-bake-list\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 17, "region_name": "Massachusetts", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 206, "city_name": "Woodbridge", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 1906, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792618622, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.63", "ip_id": 1841, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=185316404\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=spring-q4\u0026utm_content=spring-drop-email\u0026c1=cart-reminder\u0026c2=us", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 4, "ppc_account_name": "Social Ads - Retargeting", "ppc_network_name": "Social", "referer": null, "region_id": 21, "region_name": "Virginia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 3, "browser_name": "Safari", "city_id": 39, "city_name": "West Palm Beach", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.55, "click_filtered": 0, "click_id": 1212, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792618257, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.164", "ip_id": 1180, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=615053373\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep212\u0026c1=host-read-ep212\u0026c2=us", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 6, "ppc_account_name": "Podcast Sponsorship", "ppc_network_name": "Owned Media", "referer": null, "region_id": 8, "region_name": "Florida", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 4, "browser_name": "Edge", "city_id": 155, "city_name": "Punta Gorda", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 698, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792618159, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "203.0.113.181", "ip_id": 689, "isp_id": 0, "isp_name": null, "keyword": "wrap dress midi", "keyword_id": 7, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=719630684\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=spring-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=us\u0026t202kw=wrap+dress+midi", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 8, "region_name": "Florida", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 166, "city_name": "Miami", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 2574, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792618029, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "192.0.2.182", "ip_id": 2468, "isp_id": 0, "isp_name": null, "keyword": "whole bean coffee delivery", "keyword_id": 12, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=153609338\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=coffee-q4\u0026utm_content=brand-sitelinks\u0026c1=brand-sitelinks\u0026c2=us\u0026t202kw=whole+bean+coffee+delivery", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 8, "region_name": "Florida", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 4, "aff_campaign_name": "Project Tool Pro Annual / US", "browser_id": 3, "browser_name": "Safari", "city_id": 479, "city_name": "Sanger", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.2, "click_filtered": 0, "click_id": 832, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1792617955, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.55", "ip_id": 817, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=696546218\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=pro-q4\u0026utm_content=host-read-ep87\u0026c1=host-read-ep87\u0026c2=us", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 6, "ppc_account_name": "Podcast Sponsorship", "ppc_network_name": "Owned Media", "referer": null, "region_id": 15, "region_name": "California", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 6, "browser_name": "Samsung Internet", "city_id": 278, "city_name": "Portland", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 1521, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792617861, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "203.0.113.207", "ip_id": 1477, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=185316404\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=ugc-review\u0026c1=cart-reminder\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 4, "ppc_account_name": "Social Ads - Retargeting", "ppc_network_name": "Social", "referer": null, "region_id": 30, "region_name": "Oregon", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 12, "city_name": "Houston", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 2307, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792617735, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "203.0.113.182", "ip_id": 2214, "isp_id": 0, "isp_name": null, "keyword": "linen shirt men", "keyword_id": 18, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=719630684\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=spring-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=us\u0026t202kw=linen+shirt+men", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 11, "region_name": "Texas", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 112, "city_name": "Reading", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 268, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792617422, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.51.100.13", "ip_id": 267, "isp_id": 0, "isp_name": null, "keyword": "spring collection", "keyword_id": 6, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=719630684\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=spring-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=us\u0026t202kw=spring+collection", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 205, "city_name": "Stockton", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 2253, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792617401, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "203.0.113.133", "ip_id": 2165, "isp_id": 0, "isp_name": null, "keyword": "wrap dress midi", "keyword_id": 7, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=719630684\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=spring-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=us\u0026t202kw=wrap+dress+midi", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 15, "region_name": "California", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 52, "city_name": "Bloomington", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 56, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792617330, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "192.0.2.56", "ip_id": 56, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=975957852\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=cake-preorder\u0026c1=cake-preorder\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 12, "region_name": "Illinois", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 4, "aff_campaign_name": "Project Tool Pro Annual / US", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 148, "city_name": "Fairfield", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.2, "click_filtered": 0, "click_id": 320, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1792617264, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.51.100.64", "ip_id": 318, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=696546218\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=pro-q4\u0026utm_content=host-read-ep87\u0026c1=host-read-ep87\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 6, "ppc_account_name": "Podcast Sponsorship", "ppc_network_name": "Owned Media", "referer": null, "region_id": 1, "region_name": "Pennsylvania", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 7, "aff_campaign_name": "Holiday Gift Cards / AU", "browser_id": 3, "browser_name": "Safari", "city_id": 11, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.31, "click_filtered": 1, "click_id": 2641, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1792616939, "country_code": "AU", "country_id": 3, "country_name": "Australia", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.228", "ip_id": 228, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=164272625\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=gift-q4\u0026utm_content=gift-guide-carousel\u0026c1=gift-guide-carousel\u0026c2=au", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 4, "ppc_account_name": "Social Ads - Retargeting", "ppc_network_name": "Social", "referer": null, "region_id": 10, "region_name": "Unknown region", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 4, "aff_campaign_name": "Project Tool Pro Annual / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 55, "city_name": "Toronto", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 2.4, "click_filtered": 0, "click_id": 1786, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1792616767, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.203", "ip_id": 1727, "isp_id": 0, "isp_name": null, "keyword": "project management software", "keyword_id": 13, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=556134205\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=pro-q4\u0026utm_content=brand-exact\u0026c1=brand-exact\u0026c2=ca\u0026t202kw=project+management+software", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 2, "region_name": "Ontario", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 7, "aff_campaign_name": "Holiday Gift Cards / AU", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 521, "city_name": "Jane Brook", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.48, "click_filtered": 0, "click_id": 924, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1792616533, "country_code": "AU", "country_id": 3, "country_name": "Australia", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "192.0.2.145", "ip_id": 907, "isp_id": 0, "isp_name": null, "keyword": "digital gift card", "keyword_id": 20, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=977472043\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=gift-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=au\u0026t202kw=digital+gift+card", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 26, "region_name": "Western Australia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 6, "browser_name": "Samsung Internet", "city_id": 401, "city_name": "Terryville", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 649, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792616393, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "203.0.113.133", "ip_id": 641, "isp_id": 0, "isp_name": null, "keyword": "wrap dress", "keyword_id": 10, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=video-15s\u0026c1=video-15s\u0026c2=us\u0026t202kw=wrap+dress", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 34, "region_name": "Connecticut", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 6, "aff_campaign_name": "Bakery Pre-orders / Local", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 437, "city_name": "East Brunswick", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 1164, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1792616222, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.118", "ip_id": 1134, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=975957852\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=cake-preorder\u0026c1=weekend-pastry-box\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 23, "region_name": "New Jersey", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 3, "browser_name": "Safari", "city_id": 861, "city_name": "Colne", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 1986, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792616177, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.140", "ip_id": 1918, "isp_id": 0, "isp_name": null, "keyword": "standing desk uk", "keyword_id": 1, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=standing+desk+uk", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 78, "region_name": "Lancashire", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 7, "browser_name": "Firefox", "city_id": 70, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 296, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1792616113, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.40", "ip_id": 294, "isp_id": 0, "isp_name": null, "keyword": "height adjustable desk", "keyword_id": 5, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=521835365\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=height+adjustable+desk", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 35, "region_name": "Unknown region", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 367, "city_name": "Naples", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 789, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792615797, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "192.0.2.16", "ip_id": 778, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=223444901\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=spring-q4\u0026utm_content=spring-drop-email\u0026c1=spring-drop-email\u0026c2=us", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 8, "region_name": "Florida", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 3, "browser_name": "Safari", "city_id": 22, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1228, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792615514, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.179", "ip_id": 1195, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=223444901\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=spring-q4\u0026utm_content=spring-drop-email\u0026c1=spring-drop-email\u0026c2=us", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 5, "ppc_account_name": "Newsletter", "ppc_network_name": "Owned Media", "referer": null, "region_id": 19, "region_name": "Unknown region", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 7, "aff_campaign_name": "Holiday Gift Cards / AU", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 11, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.31, "click_filtered": 0, "click_id": 2303, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1792614812, "country_code": "AU", "country_id": 3, "country_name": "Australia", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "203.0.113.178", "ip_id": 2210, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=164272625\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=gift-q4\u0026utm_content=gift-guide-carousel\u0026c1=gift-guide-carousel\u0026c2=au", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 4, "ppc_account_name": "Social Ads - Retargeting", "ppc_network_name": "Social", "referer": null, "region_id": 10, "region_name": "Unknown region", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 4, "aff_campaign_name": "Project Tool Pro Annual / US", "browser_id": 3, "browser_name": "Safari", "city_id": 339, "city_name": "Manchester", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 2.4, "click_filtered": 0, "click_id": 1493, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1792614558, "country_code": "GB", "country_id": 4, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "203.0.113.179", "ip_id": 1449, "isp_id": 0, "isp_name": null, "keyword": "project management software", "keyword_id": 13, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=556134205\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=pro-q4\u0026utm_content=brand-exact\u0026c1=competitor-alt\u0026c2=gb\u0026t202kw=project+management+software", "platform_id": 3, "platform_name": "Mac OS X", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 91, "region_name": "Manchester", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 5, "browser_name": "Chrome Mobile", "city_id": 169, "city_name": "Lake Worth", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 1973, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792614507, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.51.100.130", "ip_id": 1908, "isp_id": 0, "isp_name": null, "keyword": "spring outfits", "keyword_id": 3, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=177036074\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=carousel-lookbook\u0026c1=video-15s\u0026c2=us\u0026t202kw=spring+outfits", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 8, "region_name": "Florida", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 100, "city_name": "Montrose", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.55, "click_filtered": 0, "click_id": 122, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792614413, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "192.0.2.122", "ip_id": 122, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=615053373\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep212\u0026c1=host-read-ep218\u0026c2=us", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 6, "ppc_account_name": "Podcast Sponsorship", "ppc_network_name": "Owned Media", "referer": null, "region_id": 40, "region_name": "Minnesota", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 5, "aff_campaign_name": "Free Trial to Paid / CA", "browser_id": 2, "browser_name": "Chrome", "city_id": 607, "city_name": "Amesbury", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.8, "click_filtered": 0, "click_id": 1154, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1792613849, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.109", "ip_id": 1125, "isp_id": 0, "isp_name": null, "keyword": "project tool free trial", "keyword_id": 17, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=987532671\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=trial-q4\u0026utm_content=brand-exact\u0026c1=brand-exact\u0026c2=us\u0026t202kw=project+tool+free+trial", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 17, "region_name": "Massachusetts", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 172, "city_name": "Windsor", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.55, "click_filtered": 0, "click_id": 1274, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1792613626, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.51.100.225", "ip_id": 1241, "isp_id": 0, "isp_name": null, "keyword": null, "keyword_id": 0, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=615053373\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep212\u0026c1=host-read-ep212\u0026c2=us", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 6, "ppc_account_name": "Podcast Sponsorship", "ppc_network_name": "Owned Media", "referer": null, "region_id": 15, "region_name": "California", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null }, { "aff_campaign_id": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 324, "city_name": "Cambridge", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 497, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1792612823, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.51.100.239", "ip_id": 493, "isp_id": 0, "isp_name": null, "keyword": "wrap dress midi", "keyword_id": 7, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=719630684\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=spring-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=us\u0026t202kw=wrap+dress+midi", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 17, "region_name": "Massachusetts", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null } ], "pagination": { "limit": 50, "offset": 0, "total": 2900 } }
03Build your command
Pick values and the command line writes itself, quoted and ready to paste.
p202 click listSet flags below; the command updates as you type.
04Flags
29 flags, plus the global flags every command takes.
| Flag | What it does |
|---|---|
| --aff-campaign-idstring | Filter by INTERNAL campaign id (from campaign list), not the public id in tracking URLs |
| --aff-network-idstring | Filter by affiliate network ID |
| --allbool | Fetch all rows across pages |
| --browser-idstring | Filter by browser ID (the id of a --breakdown browser row) |
| --click-botstring | Filter: 0=human, 1=bot: 0, 101 |
| --click-leadstring | Filter: 0=clicks only, 1=conversions only: 0, 101 |
| --country-idstring | Filter by country ID |
| --device-typestring | Filter by device type ID: 1 Desktop, 2 Mobile, 3 Tablet, 4 Bot (the ids of --breakdown device_type rows) |
| --followbool | Keep printing new clicks as they arrive (the Spy page) |
| --intervalduration · default 5s | With --follow: how often to poll (at least 1s) |
| --ipstring | Only clicks from this one IP address, IPv4 or IPv6 |
| --isp-idstring | Filter by ISP/carrier ID (the id of a --breakdown isp row) |
| --keywordstring | Only clicks whose keyword contains this text (case-insensitive) |
| --landing-page-idstring | Filter by landing page ID |
| --limit, -lstring | Max results |
| --method-of-promotionstring | Only direct-link clicks or only landing-page clicks: directlink, landingpagedirectlinklandingpage |
| --offset, -ostring | Pagination offset |
| --pagestring | Page number (maps to offset) |
| --period, -pstring | Period: today, yesterday, last7, last14, last30, last90, thismonth, lastmonth, thisyear, lastyear, alltimetodayyesterdaylast7last14last30last90thismonthlastmonththisyearlastyearalltime |
| --platform-idstring | Filter by platform (OS) ID (the id of a --breakdown platform row) |
| --ppc-account-idstring | Filter by PPC account ID |
| --ppc-network-idstring | Filter by PPC network ID, or none for the clicks with no traffic source |
| --refererstring | Only clicks whose referring URL contains this text (case-insensitive) |
| --region-idstring | Filter by region ID (the id of a --breakdown region row) |
| --showstring | Which clicks count (default all): all, real, filtered, filtered_bot, leads; real = not filtered, filtered_bot = filtered as bots, leads = convertedallrealfilteredfiltered_botleads |
| --stop-afterduration · default 0s | With --follow: stop after this long, e.g. 10m (0 follows until interrupted) |
| --text-ad-idstring | Filter by text ad ID |
| --time-fromstring | Start: unix seconds, a date (2026-10-01, from its first second in the account's timezone) or a time with its offset (2026-10-01T09:30:00Z) |
| --time-tostring | End, inclusive: unix seconds, a date (2026-10-01, through its last second in the account's timezone) or a time with its offset |
05How it works
Lists clicks newest first, with what the Visitors page shows for each: campaign,
traffic source, keyword, IP, location, device, referrer and landing URLs. It takes
the Visitors page's filters, as p202 report does: --keyword and --referer
(contains), --ip, --device-type, --show real|filtered|filtered_bot|leads, location,
browser and platform ids, and --period.
--follow is the Spy page: it prints the newest --limit clicks (default 10), then each new click as it arrives, polling every --interval, until interrupted or --stop-after elapses. Under --json or --ndjson it writes one JSON object per click per line.
p202 click list --aff-campaign-id 12 --time-from 2026-10-01 --all --csv p202 click list --keyword shoes --show real --period last7 p202 click list --follow --ndjson --stop-after 10m
06For agents
Running this from an agent
- Read the same facts as JSON:
p202 commands click list --json. - With
AI_AGENT,CLAUDECODEor another agent variable set, output is compact JSON and errors arrive on stderr as a JSON envelope with ahint. - Exit codes: 0 ok, 1 bad input, 2 auth, 3 network, 4 server error, 5 partial failure, 6 no Pro licence on the install.
{
"path": "p202 click list",
"use": "list",
"short": "List tracked clicks with optional filters by campaign, time range, or bot status",
"long": "Lists clicks newest first, with what the Visitors page shows for each: campaign,\ntraffic source, keyword, IP, location, device, referrer and landing URLs. It takes\nthe Visitors page's filters, as `p202 report` does: --keyword and --referer\n(contains), --ip, --device-type, --show real|filtered|filtered_bot|leads, location,\nbrowser and platform ids, and --period.\n\n--follow is the Spy page: it prints the newest --limit clicks (default 10), then\neach new click as it arrives, polling every --interval, until interrupted or\n--stop-after elapses. Under --json or --ndjson it writes one JSON object per\nclick per line.\n\n p202 click list --aff-campaign-id 12 --time-from 2026-10-01 --all --csv\n p202 click list --keyword shoes --show real --period last7\n p202 click list --follow --ndjson --stop-after 10m",
"runnable": true,
"tasks": [
{
"run": "p202 click list --follow",
"ui_pages": [
"Spy"
],
"phrases": [
"realtime traffic",
"realtime clicks",
"live traffic",
"live clicks",
"watch clicks",
"watch traffic",
"tail clicks",
"stream clicks",
"monitor traffic",
"clicks as they arrive",
"clicks as they come in",
"incoming clicks"
]
},
{
"run": "p202 click list",
"ui_pages": [
"Visitors"
],
"phrases": [
"visitor log",
"recent clicks",
"click history",
"individual clicks"
]
}
],
"flags": [
{
"name": "aff-campaign-id",
"type": "string",
"default": "",
"usage": "Filter by INTERNAL campaign id (from `campaign list`), not the public id in tracking URLs",
"required": false
},
{
"name": "aff-network-id",
"type": "string",
"default": "",
"usage": "Filter by affiliate network ID",
"required": false
},
{
"name": "all",
"type": "bool",
"default": "false",
"usage": "Fetch all rows across pages",
"required": false
},
{
"name": "browser-id",
"type": "string",
"default": "",
"usage": "Filter by browser ID (the id of a `--breakdown browser` row)",
"required": false
},
{
"name": "click-bot",
"type": "string",
"default": "",
"usage": "Filter: 0=human, 1=bot: 0, 1",
"allowed_values": [
"0",
"1"
],
"required": false
},
{
"name": "click-lead",
"type": "string",
"default": "",
"usage": "Filter: 0=clicks only, 1=conversions only: 0, 1",
"allowed_values": [
"0",
"1"
],
"required": false
},
{
"name": "country-id",
"type": "string",
"default": "",
"usage": "Filter by country ID",
"required": false
},
{
"name": "device-type",
"type": "string",
"default": "",
"usage": "Filter by device type ID: 1 Desktop, 2 Mobile, 3 Tablet, 4 Bot (the ids of `--breakdown device_type` rows)",
"required": false
},
{
"name": "follow",
"type": "bool",
"default": "false",
"usage": "Keep printing new clicks as they arrive (the Spy page)",
"required": false
},
{
"name": "interval",
"type": "duration",
"default": "5s",
"usage": "With --follow: how often to poll (at least 1s)",
"required": false
},
{
"name": "ip",
"type": "string",
"default": "",
"usage": "Only clicks from this one IP address, IPv4 or IPv6",
"required": false
},
{
"name": "isp-id",
"type": "string",
"default": "",
"usage": "Filter by ISP/carrier ID (the id of a `--breakdown isp` row)",
"required": false
},
{
"name": "keyword",
"type": "string",
"default": "",
"usage": "Only clicks whose keyword contains this text (case-insensitive)",
"required": false
},
{
"name": "landing-page-id",
"type": "string",
"default": "",
"usage": "Filter by landing page ID",
"required": false
},
{
"name": "limit",
"shorthand": "l",
"type": "string",
"default": "",
"usage": "Max results",
"required": false
},
{
"name": "method-of-promotion",
"type": "string",
"default": "",
"usage": "Only direct-link clicks or only landing-page clicks: directlink, landingpage",
"allowed_values": [
"directlink",
"landingpage"
],
"required": false
},
{
"name": "offset",
"shorthand": "o",
"type": "string",
"default": "",
"usage": "Pagination offset",
"required": false
},
{
"name": "page",
"type": "string",
"default": "",
"usage": "Page number (maps to offset)",
"required": false
},
{
"name": "period",
"shorthand": "p",
"type": "string",
"default": "",
"usage": "Period: today, yesterday, last7, last14, last30, last90, thismonth, lastmonth, thisyear, lastyear, alltime",
"allowed_values": [
"today",
"yesterday",
"last7",
"last14",
"last30",
"last90",
"thismonth",
"lastmonth",
"thisyear",
"lastyear",
"alltime"
],
"required": false
},
{
"name": "platform-id",
"type": "string",
"default": "",
"usage": "Filter by platform (OS) ID (the id of a `--breakdown platform` row)",
"required": false
},
{
"name": "ppc-account-id",
"type": "string",
"default": "",
"usage": "Filter by PPC account ID",
"required": false
},
{
"name": "ppc-network-id",
"type": "string",
"default": "",
"usage": "Filter by PPC network ID, or none for the clicks with no traffic source",
"required": false
},
{
"name": "referer",
"type": "string",
"default": "",
"usage": "Only clicks whose referring URL contains this text (case-insensitive)",
"required": false
},
{
"name": "region-id",
"type": "string",
"default": "",
"usage": "Filter by region ID (the id of a `--breakdown region` row)",
"required": false
},
{
"name": "show",
"type": "string",
"default": "",
"usage": "Which clicks count (default all): all, real, filtered, filtered_bot, leads; real = not filtered, filtered_bot = filtered as bots, leads = converted",
"allowed_values": [
"all",
"real",
"filtered",
"filtered_bot",
"leads"
],
"required": false
},
{
"name": "stop-after",
"type": "duration",
"default": "0s",
"usage": "With --follow: stop after this long, e.g. 10m (0 follows until interrupted)",
"required": false
},
{
"name": "text-ad-id",
"type": "string",
"default": "",
"usage": "Filter by text ad ID",
"required": false
},
{
"name": "time-from",
"type": "string",
"default": "",
"usage": "Start: unix seconds, a date (2026-10-01, from its first second in the account's timezone) or a time with its offset (2026-10-01T09:30:00Z)",
"required": false
},
{
"name": "time-to",
"type": "string",
"default": "",
"usage": "End, inclusive: unix seconds, a date (2026-10-01, through its last second in the account's timezone) or a time with its offset",
"required": false
}
]
}