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 -------- ---------- ---------------------------- ------------------------ -------------- ----------- ---------- ------------ 618 1791539076 Coffee Subscription / US Search Ads - Brand United States Mobile 0 32 2547 1791538857 Bakery Pre-orders / Local Social Ads - Prospecting United States Tablet 0 24 1204 1791538750 Spring Collection / US Newsletter United States Desktop 0 86 1101 1791538698 Project Tool Pro Annual / US Newsletter United Kingdom Desktop 1 348 108 1791538325 Coffee Subscription / US Social Ads - Retargeting United States Mobile 0 32 1608 1791537999 Coffee Subscription / US Search Ads - Brand United States Tablet 0 32 737 1791537954 Coffee Subscription / US Social Ads - Retargeting United States Mobile 0 32 2110 1791537546 Bakery Pre-orders / Local Social Ads - Prospecting United States Mobile 0 24 Total: 946 | Limit: 8 | Offset: 0 Warning: Showing 8 of 946 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": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 387, "city_name": "Colorado Springs", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 618, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791539076, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.2.103", "ip_id": 611, "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=605286342\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": 6, "region_name": "Colorado", "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": 647, "city_name": "Boulder", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 2547, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1791538857, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.9.155", "ip_id": 2441, "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=885956463\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": 6, "region_name": "Colorado", "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": 13, "city_name": "Houston", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1204, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791538750, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.4.156", "ip_id": 1172, "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=721048108\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": 12, "region_name": "Texas", "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": 584, "city_name": "Ely", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1101, "click_id_public": 0, "click_in": 1, "click_lead": 1, "click_out": 1, "click_payout": 348, "click_time": 1791538698, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.4.59", "ip_id": 1075, "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=280241962\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=pro-q4\u0026utm_content=product-update-oct\u0026c1=product-update-oct\u0026c2=gb", "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": 129, "region_name": "Cambridgeshire", "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": 89, "city_name": "Hillsborough", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 108, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791538325, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.0.108", "ip_id": 108, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=cart-reminder\u0026c1=ugc-review\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": 41, "region_name": "New Hampshire", "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": 1608, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537999, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.6.37", "ip_id": 1561, "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=605286342\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": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 6, "browser_name": "Samsung Internet", "city_id": 438, "city_name": "Candia", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 737, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537954, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.2.218", "ip_id": 726, "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=244906148\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": 41, "region_name": "New Hampshire", "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": 893, "city_name": "Manassas", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 2110, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1791537546, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.8.3", "ip_id": 2035, "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=885956463\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=weekend-pastry-box\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": 21, "region_name": "Virginia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null } ], "pagination": { "limit": 8, "offset": 0, "total": 946 } }
$ 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 -------------------------- --------------- ---------------------------- ---------- ---------------- ------- ---------------- --------- --------- -------------- --------- -------------- -------- --------------- -------- ---------- --------- ------------ ---------- ------------ ---------- -------------- --------- ---------------- ----------- ------------ ----- ------ -------- ---------- ------- --------------- --------------------- ------------------------------------------ ----------- ------------- -------------- ------------------------ ---------------- ------- --------- -------------- ---------- ------- ---------------- ---------- ------------ whole bean coffee delivery 2 Coffee Subscription / US 1 Mobile Safari 387 Colorado Springs 0 0 0 0.38 0 618 0 1 0 1 32 1791539076 US 2 United States 1 iPhone Mobile 198.18.2.103 611 0 12 0 https://track.example.com/tracking202/redirec… 1 iOS 1 Search Ads - Brand Search 6 Colorado 0 6 Bakery Pre-orders / Local 1 Mobile Safari 647 Boulder 0 0 0 0.18 0 2547 0 1 0 1 24 1791538857 US 2 United States 2 iPad Tablet 198.18.9.155 2441 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 6 Colorado 0 1 Spring Collection / US 2 Chrome 13 Houston 0 0 0 0 0 1204 0 1 0 1 86 1791538750 US 2 United States 3 Desktop Desktop 198.18.4.156 1172 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 5 Newsletter Owned Media 12 Texas 0 4 Project Tool Pro Annual / US 3 Safari 584 Ely 0 0 0 0 0 1101 0 1 1 1 348 1791538698 GB 3 United Kingdom 3 Desktop Desktop 198.18.4.59 1075 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 5 Newsletter Owned Media 129 Cambridgeshire 0 2 Coffee Subscription / US 6 Samsung Internet 89 Hillsborough 0 0 0 0.29 0 108 0 1 0 1 32 1791538325 US 2 United States 5 Samsung SM-S921B Mobile 198.18.0.108 108 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 41 New Hampshire 0 whole bean coffee delivery 2 Coffee Subscription / US 1 Mobile Safari 166 Miami 0 0 0 0.38 0 1608 0 1 0 1 32 1791537999 US 2 United States 2 iPad Tablet 198.18.6.37 1561 0 12 0 https://track.example.com/tracking202/redirec… 1 iOS 1 Search Ads - Brand Search 8 Florida 0 2 Coffee Subscription / US 6 Samsung Internet 438 Candia 0 0 0 0.29 0 737 0 1 0 1 32 1791537954 US 2 United States 5 Samsung SM-S921B Mobile 198.18.2.218 726 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 41 New Hampshire 0 6 Bakery Pre-orders / Local 1 Mobile Safari 893 Manassas 0 0 0 0.18 0 2110 0 1 0 1 24 1791537546 US 2 United States 1 iPhone Mobile 198.18.8.3 2035 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 21 Virginia 0 2 Coffee Subscription / US 2 Chrome 201 Cape May 0 0 0 0.29 0 271 0 1 0 1 32 1791537506 US 2 United States 3 Desktop Desktop 198.18.1.15 269 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 4 Social Ads - Retargeting Social 23 New Jersey 0 wrap dress 1 Spring Collection / US 5 Chrome Mobile 294 Pulaski 0 0 0 0.42 0 447 0 1 0 1 86 1791537500 US 2 United States 4 Pixel 8 Mobile 198.18.1.189 443 0 10 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 21 Virginia 0 Total: 946 | Limit: 10 | Offset: 0 Warning: Showing 10 of 946 results. Use --all to fetch all.
$ p202 click list --limit 10 --period last7 --json { "data": [ { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 387, "city_name": "Colorado Springs", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 618, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791539076, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.2.103", "ip_id": 611, "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=605286342\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": 6, "region_name": "Colorado", "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": 647, "city_name": "Boulder", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 2547, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1791538857, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.9.155", "ip_id": 2441, "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=885956463\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": 6, "region_name": "Colorado", "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": 13, "city_name": "Houston", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1204, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791538750, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.4.156", "ip_id": 1172, "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=721048108\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": 12, "region_name": "Texas", "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": 584, "city_name": "Ely", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1101, "click_id_public": 0, "click_in": 1, "click_lead": 1, "click_out": 1, "click_payout": 348, "click_time": 1791538698, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.4.59", "ip_id": 1075, "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=280241962\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=pro-q4\u0026utm_content=product-update-oct\u0026c1=product-update-oct\u0026c2=gb", "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": 129, "region_name": "Cambridgeshire", "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": 89, "city_name": "Hillsborough", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 108, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791538325, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.0.108", "ip_id": 108, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=cart-reminder\u0026c1=ugc-review\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": 41, "region_name": "New Hampshire", "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": 1608, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537999, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.6.37", "ip_id": 1561, "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=605286342\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": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 6, "browser_name": "Samsung Internet", "city_id": 438, "city_name": "Candia", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 737, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537954, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.2.218", "ip_id": 726, "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=244906148\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": 41, "region_name": "New Hampshire", "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": 893, "city_name": "Manassas", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 2110, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1791537546, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.8.3", "ip_id": 2035, "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=885956463\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=weekend-pastry-box\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": 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": 2, "browser_name": "Chrome", "city_id": 201, "city_name": "Cape May", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 271, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537506, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.1.15", "ip_id": 269, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=ugc-review\u0026c1=ugc-review\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": 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": 5, "browser_name": "Chrome Mobile", "city_id": 294, "city_name": "Pulaski", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 447, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791537500, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.18.1.189", "ip_id": 443, "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=216455507\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": 21, "region_name": "Virginia", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null } ], "pagination": { "limit": 10, "offset": 0, "total": 946 } }
$ 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 -------------------------- --------------- ---------------------------- ---------- ---------------- ------- ---------------- --------- --------- -------------- --------- -------------- -------- --------------- -------- ---------- --------- ------------ ---------- ------------ ---------- -------------- --------- ---------------- ----------- ------------- ----- ------ -------- ---------- ------- --------------- --------------------- ------------------------------------------ ----------- ------------- -------------- ------------------------ ---------------- ------- --------- ------------------------- ---------- ------- ---------------- ---------- ------------ whole bean coffee delivery 2 Coffee Subscription / US 1 Mobile Safari 387 Colorado Springs 0 0 0 0.38 0 618 0 1 0 1 32 1791539076 US 2 United States 1 iPhone Mobile 198.18.2.103 611 0 12 0 https://track.example.com/tracking202/redirec… 1 iOS 1 Search Ads - Brand Search 6 Colorado 0 6 Bakery Pre-orders / Local 1 Mobile Safari 647 Boulder 0 0 0 0.18 0 2547 0 1 0 1 24 1791538857 US 2 United States 2 iPad Tablet 198.18.9.155 2441 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 6 Colorado 0 1 Spring Collection / US 2 Chrome 13 Houston 0 0 0 0 0 1204 0 1 0 1 86 1791538750 US 2 United States 3 Desktop Desktop 198.18.4.156 1172 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 5 Newsletter Owned Media 12 Texas 0 4 Project Tool Pro Annual / US 3 Safari 584 Ely 0 0 0 0 0 1101 0 1 1 1 348 1791538698 GB 3 United Kingdom 3 Desktop Desktop 198.18.4.59 1075 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 5 Newsletter Owned Media 129 Cambridgeshire 0 2 Coffee Subscription / US 6 Samsung Internet 89 Hillsborough 0 0 0 0.29 0 108 0 1 0 1 32 1791538325 US 2 United States 5 Samsung SM-S921B Mobile 198.18.0.108 108 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 41 New Hampshire 0 whole bean coffee delivery 2 Coffee Subscription / US 1 Mobile Safari 166 Miami 0 0 0 0.38 0 1608 0 1 0 1 32 1791537999 US 2 United States 2 iPad Tablet 198.18.6.37 1561 0 12 0 https://track.example.com/tracking202/redirec… 1 iOS 1 Search Ads - Brand Search 8 Florida 0 2 Coffee Subscription / US 6 Samsung Internet 438 Candia 0 0 0 0.29 0 737 0 1 0 1 32 1791537954 US 2 United States 5 Samsung SM-S921B Mobile 198.18.2.218 726 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 41 New Hampshire 0 6 Bakery Pre-orders / Local 1 Mobile Safari 893 Manassas 0 0 0 0.18 0 2110 0 1 0 1 24 1791537546 US 2 United States 1 iPhone Mobile 198.18.8.3 2035 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 21 Virginia 0 2 Coffee Subscription / US 2 Chrome 201 Cape May 0 0 0 0.29 0 271 0 1 0 1 32 1791537506 US 2 United States 3 Desktop Desktop 198.18.1.15 269 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 4 Social Ads - Retargeting Social 23 New Jersey 0 wrap dress 1 Spring Collection / US 5 Chrome Mobile 294 Pulaski 0 0 0 0.42 0 447 0 1 0 1 86 1791537500 US 2 United States 4 Pixel 8 Mobile 198.18.1.189 443 0 10 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 21 Virginia 0 digital gift card 7 Holiday Gift Cards / AU 3 Safari 11 Unknown city 0 0 0 0.48 0 1937 0 1 0 1 50 1791537332 AU 4 Australia 3 Desktop Desktop 198.18.7.94 1872 0 20 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 2 Search Ads - Shopping Search 10 Unknown region 0 2 Coffee Subscription / US 6 Samsung Internet 320 North Port 0 0 0 0.29 0 2786 0 1 0 1 32 1791536820 US 2 United States 5 Samsung SM-S921B Mobile 198.18.10.112 2652 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 8 Florida 0 2 Coffee Subscription / US 1 Mobile Safari 632 Panama City 0 0 0 0.38 0 1222 0 1 1 1 32 1791536774 US 2 United States 1 iPhone Mobile 198.18.4.174 1190 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 1 Search Ads - Brand Search 8 Florida 0 gantt chart tool 4 Project Tool Pro Annual / US 3 Safari 205 Stockton 0 0 0 2.40 0 2034 0 1 0 1 348 1791536687 US 2 United States 3 Desktop Desktop 198.18.7.186 1964 0 11 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 1 Search Ads - Brand Search 16 California 0 electric sit stand desk 3 Standing Desk Launch / UK 7 Firefox 458 Luton 0 0 0 1.10 0 1379 0 1 0 1 480 1791536408 GB 3 United Kingdom 3 Desktop Desktop 198.18.5.71 1341 0 14 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 2 Search Ads - Shopping Search 108 Luton 0 wrap dress 1 Spring Collection / US 1 Mobile Safari 242 Vancouver 0 0 0 0.42 0 1403 0 1 0 1 86 1791536169 US 2 United States 1 iPhone Mobile 198.18.5.93 1363 0 10 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 20 Washington 0 whole bean coffee delivery 2 Coffee Subscription / US 5 Chrome Mobile 38 West Palm Beach 0 0 0 0.38 0 2391 0 1 0 1 32 1791535990 US 2 United States 4 Pixel 8 Mobile 198.18.9.8 2294 0 12 0 https://track.example.com/tracking202/redirec… 4 Android 1 Search Ads - Brand Search 8 Florida 0 digital gift card 7 Holiday Gift Cards / AU 5 Chrome Mobile 11 Unknown city 0 0 0 0.48 0 1933 0 1 0 1 50 1791535837 AU 4 Australia 4 Pixel 8 Mobile 198.18.7.90 1868 0 20 0 https://track.example.com/tracking202/redirec… 4 Android 2 Search Ads - Shopping Search 10 Unknown region 0 linen shirt 1 Spring Collection / US 6 Samsung Internet 730 Mantua 0 0 0 0.42 0 1524 0 1 0 1 86 1791535076 US 2 United States 5 Samsung SM-S921B Mobile 198.18.5.210 1480 0 15 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 23 New Jersey 0 2 Coffee Subscription / US 1 Mobile Safari 23 Unknown city 0 0 0 0.29 0 2327 0 1 0 1 32 1791534950 US 2 United States 1 iPhone Mobile 198.18.8.201 2233 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 4 Social Ads - Retargeting Social 19 Unknown region 0 spring collection 1 Spring Collection / US 1 Mobile Safari 112 Reading 0 0 0 0.65 0 266 0 1 0 1 86 1791534637 US 2 United States 2 iPad Tablet 198.18.1.11 265 0 6 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 2 Pennsylvania 0 3 Standing Desk Launch / UK 1 Mobile Safari 675 Milton Keynes 0 0 0 0.85 0 2279 0 1 0 1 480 1791534616 GB 3 United Kingdom 1 iPhone Mobile 198.18.8.156 2188 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 142 Milton Keynes 0 1 Spring Collection / US 3 Safari 51 Cypress 0 0 0 0 0 55 0 1 0 1 86 1791534545 US 2 United States 3 Desktop Desktop 198.18.0.55 55 0 0 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 5 Newsletter Owned Media 12 Texas 0 height adjustable desk 3 Standing Desk Launch / UK 1 Mobile Safari 223 Evesham 0 0 0 1.10 0 311 0 1 0 1 480 1791534479 GB 3 United Kingdom 1 iPhone Mobile 198.18.1.55 309 0 4 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 72 Worcestershire 0 project tool free trial 5 Free Trial to Paid / CA 3 Safari 56 Toronto 0 0 0 1.80 0 2666 0 1 0 1 29 1791534154 CA 1 Canada 3 Desktop Desktop 198.18.10.5 2545 0 17 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 1 Search Ads - Brand Search 1 Ontario 0 gantt chart tool 4 Project Tool Pro Annual / US 3 Safari 98 Unknown city 0 0 0 2.40 0 1814 0 1 0 1 348 1791533982 DE 5 Germany 3 Desktop Desktop 198.18.6.230 1754 0 11 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 1 Search Ads - Brand Search 44 Unknown region 0 gift cards australia 7 Holiday Gift Cards / AU 3 Safari 353 Vale Park 0 0 0 0.48 0 919 0 1 0 1 50 1791533748 AU 4 Australia 3 Desktop Desktop 198.18.3.140 902 0 3 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 2 Search Ads - Shopping Search 7 South Australia 0 fresh roasted coffee 2 Coffee Subscription / US 5 Chrome Mobile 397 Lansing 0 0 0 0.38 0 639 0 1 0 1 32 1791533608 US 2 United States 4 Pixel 8 Mobile 198.18.2.123 631 0 8 0 https://track.example.com/tracking202/redirec… 4 Android 1 Search Ads - Brand Search 53 Michigan 0 linen shirt men 1 Spring Collection / US 1 Mobile Safari 35 Chicago 0 0 0 0.65 0 2019 0 1 0 1 86 1791533392 US 2 United States 1 iPhone Mobile 198.18.7.171 1949 0 18 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 11 Illinois 0 5 Free Trial to Paid / CA 2 Chrome 217 St. John's 0 0 0 0.95 0 299 0 1 0 1 29 1791533328 CA 1 Canada 3 Desktop Desktop 198.18.1.43 297 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 3 Social Ads - Prospecting Social 70 Newfoundland and Labrador 0 linen shirt men 1 Spring Collection / US 2 Chrome 43 Naperville 0 0 0 0.65 0 789 0 1 0 1 86 1791533012 US 2 United States 3 Desktop Desktop 198.18.3.16 778 0 18 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 11 Illinois 0 wrap dress 1 Spring Collection / US 1 Mobile Safari 640 Woodstock 0 0 0 0.42 0 1241 0 1 0 1 86 1791532729 CA 1 Canada 1 iPhone Mobile 198.18.4.193 1209 0 10 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 1 Ontario 0 2 Coffee Subscription / US 1 Mobile Safari 616 Groveland 0 0 0 0.29 1 2004 0 1 0 1 32 1791531722 US 2 United States 1 iPhone Mobile 198.18.4.130 1146 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 4 Social Ads - Retargeting Social 18 Massachusetts 0 wrap dress 1 Spring Collection / US 1 Mobile Safari 38 West Palm Beach 0 0 0 0.42 0 125 0 1 0 1 86 1791531628 US 2 United States 1 iPhone Mobile 198.18.0.125 125 0 10 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 8 Florida 0 3 Standing Desk Launch / UK 1 Mobile Safari 625 Sheffield 0 0 0 0.85 0 1286 0 1 0 1 480 1791530841 GB 3 United Kingdom 2 iPad Tablet 198.18.4.237 1253 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 136 Sheffield 0 electric sit stand desk 3 Standing Desk Launch / UK 2 Chrome 503 Northwich 0 0 0 1.10 0 876 0 1 0 1 480 1791529339 GB 3 United Kingdom 3 Desktop Desktop 198.18.3.98 860 0 14 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 116 Cheshire 0 3 Standing Desk Launch / UK 5 Chrome Mobile 70 Unknown city 0 0 0 1.10 0 521 0 1 0 1 480 1791527868 GB 3 United Kingdom 4 Pixel 8 Mobile 198.18.2.7 515 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 2 Search Ads - Shopping Search 35 Unknown region 0 2 Coffee Subscription / US 5 Chrome Mobile 105 Philadelphia 0 0 0 0.38 0 133 0 1 0 1 32 1791525280 US 2 United States 4 Pixel 8 Mobile 198.18.0.133 133 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 1 Search Ads - Brand Search 2 Pennsylvania 0 2 Coffee Subscription / US 1 Mobile Safari 191 Citrus Heights 0 0 0 0.55 0 255 0 1 0 1 32 1791524815 US 2 United States 2 iPad Tablet 198.18.0.254 254 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 6 Podcast Sponsorship Owned Media 16 California 0 2 Coffee Subscription / US 1 Mobile Safari 34 Jacksonville 0 0 0 0.55 0 1693 0 1 0 1 32 1791524627 US 2 United States 1 iPhone Mobile 198.18.6.116 1640 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 6 Podcast Sponsorship Owned Media 8 Florida 0 2 Coffee Subscription / US 1 Mobile Safari 509 Eugene 0 0 0 0.29 0 1339 0 1 0 1 32 1791524300 US 2 United States 1 iPhone Mobile 198.18.5.33 1303 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 4 Social Ads - Retargeting Social 31 Oregon 0 spring collection 1 Spring Collection / US 1 Mobile Safari 28 Loganville 0 0 0 0.65 0 29 0 1 0 1 86 1791524080 US 2 United States 1 iPhone Mobile 198.18.0.29 29 0 6 0 https://track.example.com/tracking202/redirec… 1 iOS 2 Search Ads - Shopping Search 13 Georgia 0 standing desk uk 3 Standing Desk Launch / UK 2 Chrome 93 Hampstead 0 0 0 1.10 0 112 0 1 0 1 480 1791523192 GB 3 United Kingdom 3 Desktop Desktop 198.18.0.112 112 0 1 0 https://track.example.com/tracking202/redirec… 3 Mac OS X 2 Search Ads - Shopping Search 43 Camden 0 2 Coffee Subscription / US 6 Samsung Internet 23 Unknown city 0 0 0 0.29 0 883 0 1 0 1 32 1791521742 US 2 United States 5 Samsung SM-S921B Mobile 198.18.3.105 867 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 19 Unknown region 0 3 Standing Desk Launch / UK 1 Mobile Safari 800 Peterhead 0 0 0 0.85 0 1749 0 1 0 1 480 1791520974 GB 3 United Kingdom 1 iPhone Mobile 198.18.6.169 1693 0 0 0 https://track.example.com/tracking202/redirec… 1 iOS 3 Social Ads - Prospecting Social 150 Aberdeenshire 0 wrap dress 1 Spring Collection / US 6 Samsung Internet 486 Olathe 0 0 0 0.42 0 844 0 1 0 1 86 1791520924 US 2 United States 5 Samsung SM-S921B Mobile 198.18.3.66 828 0 10 0 https://track.example.com/tracking202/redirec… 4 Android 3 Social Ads - Prospecting Social 113 Kansas 0 2 Coffee Subscription / US 2 Chrome 526 Dracut 0 0 0 0.29 0 941 0 1 0 1 32 1791517134 US 2 United States 3 Desktop Desktop 198.18.3.161 923 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 4 Social Ads - Retargeting Social 18 Massachusetts 0 2 Coffee Subscription / US 6 Samsung Internet 23 Unknown city 0 0 0 0.29 0 1455 0 1 0 1 32 1791515276 US 2 United States 5 Samsung SM-S921B Mobile 198.18.5.142 1412 0 0 0 https://track.example.com/tracking202/redirec… 4 Android 4 Social Ads - Retargeting Social 19 Unknown region 0 spring collection 1 Spring Collection / US 2 Chrome 286 Atlanta 0 0 0 0.65 0 1767 0 1 0 1 86 1791514892 US 2 United States 3 Desktop Desktop 198.18.6.186 1710 0 6 0 https://track.example.com/tracking202/redirec… 2 Windows 2 Search Ads - Shopping Search 13 Georgia 0 2 Coffee Subscription / US 2 Chrome 227 Minneapolis 0 0 0 0.29 0 2350 0 1 0 1 32 1791514086 US 2 United States 3 Desktop Desktop 198.18.8.223 2255 0 0 0 https://track.example.com/tracking202/redirec… 2 Windows 4 Social Ads - Retargeting Social 39 Minnesota 0 Total: 2901 | Limit: 50 | Offset: 0 Warning: Showing 50 of 2901 results. Use --all to fetch all.
$ p202 click list --json { "data": [ { "aff_campaign_id": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 387, "city_name": "Colorado Springs", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 618, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791539076, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.2.103", "ip_id": 611, "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=605286342\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": 6, "region_name": "Colorado", "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": 647, "city_name": "Boulder", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 2547, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1791538857, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.9.155", "ip_id": 2441, "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=885956463\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": 6, "region_name": "Colorado", "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": 13, "city_name": "Houston", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1204, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791538750, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.4.156", "ip_id": 1172, "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=721048108\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": 12, "region_name": "Texas", "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": 584, "city_name": "Ely", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 1101, "click_id_public": 0, "click_in": 1, "click_lead": 1, "click_out": 1, "click_payout": 348, "click_time": 1791538698, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.4.59", "ip_id": 1075, "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=280241962\u0026t202kw=\u0026utm_source=newsletter\u0026utm_medium=email\u0026utm_campaign=pro-q4\u0026utm_content=product-update-oct\u0026c1=product-update-oct\u0026c2=gb", "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": 129, "region_name": "Cambridgeshire", "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": 89, "city_name": "Hillsborough", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 108, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791538325, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.0.108", "ip_id": 108, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=cart-reminder\u0026c1=ugc-review\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": 41, "region_name": "New Hampshire", "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": 1608, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537999, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.6.37", "ip_id": 1561, "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=605286342\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": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 6, "browser_name": "Samsung Internet", "city_id": 438, "city_name": "Candia", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 737, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537954, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.2.218", "ip_id": 726, "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=244906148\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": 41, "region_name": "New Hampshire", "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": 893, "city_name": "Manassas", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.18, "click_filtered": 0, "click_id": 2110, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 24, "click_time": 1791537546, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.8.3", "ip_id": 2035, "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=885956463\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=bakery-q4\u0026utm_content=weekend-pastry-box\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": 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": 2, "browser_name": "Chrome", "city_id": 201, "city_name": "Cape May", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 271, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791537506, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.1.15", "ip_id": 269, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=ugc-review\u0026c1=ugc-review\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": 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": 5, "browser_name": "Chrome Mobile", "city_id": 294, "city_name": "Pulaski", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 447, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791537500, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.18.1.189", "ip_id": 443, "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=216455507\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": 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": 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.48, "click_filtered": 0, "click_id": 1937, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1791537332, "country_code": "AU", "country_id": 4, "country_name": "Australia", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.7.94", "ip_id": 1872, "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=256735301\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": 3, "platform_name": "Mac OS X", "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": 6, "browser_name": "Samsung Internet", "city_id": 320, "city_name": "North Port", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 2786, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791536820, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.10.112", "ip_id": 2652, "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=244906148\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": 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": 632, "city_name": "Panama City", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 1222, "click_id_public": 0, "click_in": 1, "click_lead": 1, "click_out": 1, "click_payout": 32, "click_time": 1791536774, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.4.174", "ip_id": 1190, "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=605286342\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep218\u0026c1=brand-sitelinks\u0026c2=us", "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": 205, "city_name": "Stockton", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 2.4, "click_filtered": 0, "click_id": 2034, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1791536687, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.7.186", "ip_id": 1964, "isp_id": 0, "isp_name": null, "keyword": "gantt chart tool", "keyword_id": 11, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=850037020\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=pro-q4\u0026utm_content=competitor-alt\u0026c1=competitor-alt\u0026c2=us\u0026t202kw=gantt+chart+tool", "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": 16, "region_name": "California", "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": 458, "city_name": "Luton", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 1379, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791536408, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.5.71", "ip_id": 1341, "isp_id": 0, "isp_name": null, "keyword": "electric sit stand desk", "keyword_id": 14, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=267619878\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=electric+sit+stand+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": 108, "region_name": "Luton", "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": 242, "city_name": "Vancouver", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 1403, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791536169, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.5.93", "ip_id": 1363, "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=216455507\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=video-15s\u0026c1=carousel-lookbook\u0026c2=us\u0026t202kw=wrap+dress", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 20, "region_name": "Washington", "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": 38, "city_name": "West Palm Beach", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 2391, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791535990, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.18.9.8", "ip_id": 2294, "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=605286342\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": 4, "platform_name": "Android", "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": 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.48, "click_filtered": 0, "click_id": 1933, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1791535837, "country_code": "AU", "country_id": 4, "country_name": "Australia", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.18.7.90", "ip_id": 1868, "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=256735301\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": 4, "platform_name": "Android", "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": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 6, "browser_name": "Samsung Internet", "city_id": 730, "city_name": "Mantua", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 1524, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791535076, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.5.210", "ip_id": 1480, "isp_id": 0, "isp_name": null, "keyword": "linen shirt", "keyword_id": 15, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=216455507\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=static-model\u0026c1=carousel-lookbook\u0026c2=us\u0026t202kw=linen+shirt", "platform_id": 4, "platform_name": "Android", "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": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 23, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 2327, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791534950, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.8.201", "ip_id": 2233, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=cart-reminder\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": 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": 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": 266, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791534637, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.1.11", "ip_id": 265, "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=950355925\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": 2, "region_name": "Pennsylvania", "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": 1, "browser_name": "Mobile Safari", "city_id": 675, "city_name": "Milton Keynes", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.85, "click_filtered": 0, "click_id": 2279, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791534616, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.8.156", "ip_id": 2188, "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=388878295\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=desk-q4\u0026utm_content=static-office\u0026c1=video-assembly\u0026c2=gb", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 142, "region_name": "Milton Keynes", "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": 51, "city_name": "Cypress", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0, "click_filtered": 0, "click_id": 55, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791534545, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.0.55", "ip_id": 55, "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=721048108\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": 12, "region_name": "Texas", "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": 1, "browser_name": "Mobile Safari", "city_id": 223, "city_name": "Evesham", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 311, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791534479, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.1.55", "ip_id": 309, "isp_id": 0, "isp_name": null, "keyword": "height adjustable desk", "keyword_id": 4, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=267619878\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": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 72, "region_name": "Worcestershire", "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": 3, "browser_name": "Safari", "city_id": 56, "city_name": "Toronto", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.8, "click_filtered": 0, "click_id": 2666, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1791534154, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.10.5", "ip_id": 2545, "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=883090088\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=trial-q4\u0026utm_content=brand-exact\u0026c1=brand-exact\u0026c2=ca\u0026t202kw=project+tool+free+trial", "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": 1, "region_name": "Ontario", "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": 98, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 2.4, "click_filtered": 0, "click_id": 1814, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 348, "click_time": 1791533982, "country_code": "DE", "country_id": 5, "country_name": "Germany", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.6.230", "ip_id": 1754, "isp_id": 0, "isp_name": null, "keyword": "gantt chart tool", "keyword_id": 11, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=850037020\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=pro-q4\u0026utm_content=competitor-alt\u0026c1=competitor-alt\u0026c2=de\u0026t202kw=gantt+chart+tool", "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": 44, "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": 3, "browser_name": "Safari", "city_id": 353, "city_name": "Vale Park", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.48, "click_filtered": 0, "click_id": 919, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 50, "click_time": 1791533748, "country_code": "AU", "country_id": 4, "country_name": "Australia", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.3.140", "ip_id": 902, "isp_id": 0, "isp_name": null, "keyword": "gift cards australia", "keyword_id": 3, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=256735301\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": 3, "platform_name": "Mac OS X", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 7, "region_name": "South Australia", "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": 397, "city_name": "Lansing", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.38, "click_filtered": 0, "click_id": 639, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791533608, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.18.2.123", "ip_id": 631, "isp_id": 0, "isp_name": null, "keyword": "fresh roasted coffee", "keyword_id": 8, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=605286342\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=coffee-q4\u0026utm_content=brand-sitelinks\u0026c1=brand-sitelinks\u0026c2=us\u0026t202kw=fresh+roasted+coffee", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 53, "region_name": "Michigan", "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": 35, "city_name": "Chicago", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 2019, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791533392, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.7.171", "ip_id": 1949, "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=950355925\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": 1, "platform_name": "iOS", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 11, "region_name": "Illinois", "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": 217, "city_name": "St. John's", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.95, "click_filtered": 0, "click_id": 299, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 29, "click_time": 1791533328, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.1.43", "ip_id": 297, "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=121145792\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=trial-q4\u0026utm_content=video-demo-30s\u0026c1=video-demo-30s\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": 70, "region_name": "Newfoundland and Labrador", "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": 43, "city_name": "Naperville", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 789, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791533012, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.3.16", "ip_id": 778, "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=950355925\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": "Illinois", "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": 640, "city_name": "Woodstock", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 1241, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791532729, "country_code": "CA", "country_id": 1, "country_name": "Canada", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.4.193", "ip_id": 1209, "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=216455507\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=video-15s\u0026c1=carousel-lookbook\u0026c2=ca\u0026t202kw=wrap+dress", "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": "Ontario", "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": 616, "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": 1791531722, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.4.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=244906148\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": 18, "region_name": "Massachusetts", "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": 38, "city_name": "West Palm Beach", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 125, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791531628, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.0.125", "ip_id": 125, "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=216455507\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": 1, "platform_name": "iOS", "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": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 625, "city_name": "Sheffield", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.85, "click_filtered": 0, "click_id": 1286, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791530841, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.4.237", "ip_id": 1253, "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=388878295\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=desk-q4\u0026utm_content=static-office\u0026c1=video-assembly\u0026c2=gb", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 136, "region_name": "Sheffield", "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": 2, "browser_name": "Chrome", "city_id": 503, "city_name": "Northwich", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 876, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791529339, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.3.98", "ip_id": 860, "isp_id": 0, "isp_name": null, "keyword": "electric sit stand desk", "keyword_id": 14, "landing": null, "landing_page_id": 0, "landing_page_nickname": null, "outbound": "https://track.example.com/tracking202/redirect/dl.php?t202id=267619878\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=shopping-feed\u0026c1=shopping-feed\u0026c2=gb\u0026t202kw=electric+sit+stand+desk", "platform_id": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "ppc_network_name": "Search", "referer": null, "region_id": 116, "region_name": "Cheshire", "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": 5, "browser_name": "Chrome Mobile", "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": 521, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791527868, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.18.2.7", "ip_id": 515, "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=267619878\u0026t202kw=\u0026utm_source=search\u0026utm_medium=shopping\u0026utm_campaign=desk-q4\u0026utm_content=static-office\u0026c1=shopping-feed\u0026c2=gb", "platform_id": 4, "platform_name": "Android", "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": 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.38, "click_filtered": 0, "click_id": 133, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791525280, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 4, "device_name": "Pixel 8", "device_type": "Mobile", "ip_address": "198.18.0.133", "ip_id": 133, "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=605286342\u0026t202kw=\u0026utm_source=search\u0026utm_medium=cpc\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep212\u0026c1=brand-sitelinks\u0026c2=us", "platform_id": 4, "platform_name": "Android", "ppc_account_id": 1, "ppc_account_name": "Search Ads - Brand", "ppc_network_name": "Search", "referer": null, "region_id": 2, "region_name": "Pennsylvania", "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": 191, "city_name": "Citrus Heights", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.55, "click_filtered": 0, "click_id": 255, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791524815, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 2, "device_name": "iPad", "device_type": "Tablet", "ip_address": "198.18.0.254", "ip_id": 254, "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=623059210\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep218\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": 16, "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": 1, "browser_name": "Mobile Safari", "city_id": 34, "city_name": "Jacksonville", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.55, "click_filtered": 0, "click_id": 1693, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791524627, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.6.116", "ip_id": 1640, "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=623059210\u0026t202kw=\u0026utm_source=podcast\u0026utm_medium=audio\u0026utm_campaign=coffee-q4\u0026utm_content=host-read-ep212\u0026c1=host-read-ep212\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": 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": 509, "city_name": "Eugene", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 1339, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791524300, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.5.33", "ip_id": 1303, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=ugc-review\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": 31, "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": 1, "browser_name": "Mobile Safari", "city_id": 28, "city_name": "Loganville", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 29, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791524080, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.0.29", "ip_id": 29, "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=950355925\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": 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": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 2, "browser_name": "Chrome", "city_id": 93, "city_name": "Hampstead", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 1.1, "click_filtered": 0, "click_id": 112, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791523192, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.0.112", "ip_id": 112, "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=267619878\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": 43, "region_name": "Camden", "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": 23, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 883, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791521742, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.3.105", "ip_id": 867, "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=244906148\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": 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": 3, "aff_campaign_name": "Standing Desk Launch / UK", "browser_id": 1, "browser_name": "Mobile Safari", "city_id": 800, "city_name": "Peterhead", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.85, "click_filtered": 0, "click_id": 1749, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 480, "click_time": 1791520974, "country_code": "GB", "country_id": 3, "country_name": "United Kingdom", "device_id": 1, "device_name": "iPhone", "device_type": "Mobile", "ip_address": "198.18.6.169", "ip_id": 1693, "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=388878295\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=desk-q4\u0026utm_content=video-assembly\u0026c1=static-office\u0026c2=gb", "platform_id": 1, "platform_name": "iOS", "ppc_account_id": 3, "ppc_account_name": "Social Ads - Prospecting", "ppc_network_name": "Social", "referer": null, "region_id": 150, "region_name": "Aberdeenshire", "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": 486, "city_name": "Olathe", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.42, "click_filtered": 0, "click_id": 844, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791520924, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.3.66", "ip_id": 828, "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=216455507\u0026t202kw=\u0026utm_source=social\u0026utm_medium=paid_social\u0026utm_campaign=spring-q4\u0026utm_content=video-15s\u0026c1=carousel-lookbook\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": 113, "region_name": "Kansas", "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": 526, "city_name": "Dracut", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 941, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791517134, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.3.161", "ip_id": 923, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=ugc-review\u0026c1=ugc-review\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": 18, "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": 6, "browser_name": "Samsung Internet", "city_id": 23, "city_name": "Unknown city", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 1455, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791515276, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 5, "device_name": "Samsung SM-S921B", "device_type": "Mobile", "ip_address": "198.18.5.142", "ip_id": 1412, "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=244906148\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": 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": 1, "aff_campaign_name": "Spring Collection / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 286, "city_name": "Atlanta", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.65, "click_filtered": 0, "click_id": 1767, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 86, "click_time": 1791514892, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.6.186", "ip_id": 1710, "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=950355925\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": 2, "platform_name": "Windows", "ppc_account_id": 2, "ppc_account_name": "Search Ads - Shopping", "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": 2, "aff_campaign_name": "Coffee Subscription / US", "browser_id": 2, "browser_name": "Chrome", "city_id": 227, "city_name": "Minneapolis", "click_alp": 0, "click_bot": 0, "click_cloaking": 0, "click_cpc": 0.29, "click_filtered": 0, "click_id": 2350, "click_id_public": 0, "click_in": 1, "click_lead": 0, "click_out": 1, "click_payout": 32, "click_time": 1791514086, "country_code": "US", "country_id": 2, "country_name": "United States", "device_id": 3, "device_name": "Desktop", "device_type": "Desktop", "ip_address": "198.18.8.223", "ip_id": 2255, "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=244906148\u0026t202kw=\u0026utm_source=social\u0026utm_medium=retargeting\u0026utm_campaign=coffee-q4\u0026utm_content=cart-reminder\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": 39, "region_name": "Minnesota", "rotator_id": null, "rule_id": null, "rule_redirect_id": null, "text_ad_id": 0, "text_ad_name": null } ], "pagination": { "limit": 50, "offset": 0, "total": 2901 } }
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.
{
"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
}
]
}