p202 report daypart

Get stats grouped by hour of day (0-23) to find best-performing hours

Web UIOverview › Day Parting
All commands

p202 CLI reference

Back to the docs

01Jobs it does

Each one is a real command line. Copy it, or open it in the builder below to change it.

dayparting

Also: time of day

p202 report daypart
Web UIOverview › Day Parting

02What 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 report daypart --period last30 --sort roi
$ p202 report daypart --period last30 --sort roi
Clicks  Clickthroughs  Conversions  Conv %   Revenue  Cost    Profit   ROI %      EPC      CPA      Avg CPC  hour_of_day
------  -------------  -----------  -------  -------  ------  -------  ---------  -------  -------  -------  -----------
24      24             0            0        0        13.53   -13.53   -100       0        0        0.5637   0
44      44             0            0        0        32.89   -32.89   -100       0        0        0.7475   1
87      87             0            0        0        59.40   -59.40   -100       0        0        0.6828   19
34      34             0            0        0        23.97   -23.97   -100       0        0        0.705    20
18      18             0            0        0        14.49   -14.49   -100       0        0        0.805    22
22      22             0            0        0        13.53   -13.53   -100       0        0        0.615    23
147     147            4            2.7211   286      97.42   188.58   193.5742   1.9456   24.355   0.6627   10
155     155            6            3.871    392      108.58  283.42   261.0241   2.529    18.0967  0.7005   12
112     112            2            1.7857   300      82.12   217.88   265.319    2.6786   41.06    0.7332   3
18      18             2            11.1111  63       15.39   47.61    309.3567   3.50     7.695    0.855    21
178     178            7            3.9326   592      120.64  471.36   390.7162   3.3258   17.2343  0.6778   17
219     219            8            3.653    822      153.13  668.87   436.7988   3.7534   19.1412  0.6992   16
156     156            7            4.4872   623      105.15  517.85   492.4869   3.9936   15.0214  0.674    8
223     223            9            4.0359   954      158.02  795.98   503.721    4.278    17.5578  0.7086   15
171     171            6            3.5088   904      124.87  779.13   623.9529   5.2865   20.8117  0.7302   6
162     162            8            4.9383   1023     113.78  909.22   799.1035   6.3148   14.2225  0.7023   9
145     145            7            4.8276   1118     118.38  999.62   844.4163   7.7103   16.9114  0.8164   4
133     133            6            4.5113   925      92.28   832.72   902.384    6.9549   15.38    0.6938   11
167     167            8            4.7904   1343     120.27  1222.73  1016.6542  8.0419   15.0337  0.7202   13
164     164            9            5.4878   1346     118.65  1227.35  1034.429   8.2073   13.1833  0.7235   7
195     195            10           5.1282   1738     131.52  1606.48  1221.472   8.9128   13.152   0.6745   14
136     136            11           8.0882   1125     79.71   1045.29  1311.3662  8.2721   7.2464   0.5861   5
124     124            6            4.8387   1380     93.20   1286.80  1380.6867  11.129   15.5333  0.7516   18
67      67             5            7.4627   903      42.06   860.94   2046.933   13.4776  8.412    0.6278   2
Real output · p202 1.9.77 · demo dataexit 0

Profit by hour of day

  1. 00h
  4. 20h
  7. 10h
  10. 21h
  13. 08h
  16. 09h
  19. 13h
  21. $1,606.48
  22. 05h
  24. 02h

Drawn from the JSON output above; hover a column for its value. The highest is labeled.

p202 report daypart
$ p202 report daypart
Clicks  Clickthroughs  Conversions  Conv %   Revenue  Cost    Profit   ROI %      EPC      CPA      Avg CPC  hour_of_day
------  -------------  -----------  -------  -------  ------  -------  ---------  -------  -------  -------  -----------
24      24             0            0        0        13.53   -13.53   -100       0        0        0.5637   0
44      44             0            0        0        32.89   -32.89   -100       0        0        0.7475   1
67      67             5            7.4627   903      42.06   860.94   2046.933   13.4776  8.412    0.6278   2
112     112            2            1.7857   300      82.12   217.88   265.319    2.6786   41.06    0.7332   3
145     145            7            4.8276   1118     118.38  999.62   844.4163   7.7103   16.9114  0.8164   4
136     136            11           8.0882   1125     79.71   1045.29  1311.3662  8.2721   7.2464   0.5861   5
171     171            6            3.5088   904      124.87  779.13   623.9529   5.2865   20.8117  0.7302   6
164     164            9            5.4878   1346     118.65  1227.35  1034.429   8.2073   13.1833  0.7235   7
156     156            7            4.4872   623      105.15  517.85   492.4869   3.9936   15.0214  0.674    8
162     162            8            4.9383   1023     113.78  909.22   799.1035   6.3148   14.2225  0.7023   9
147     147            4            2.7211   286      97.42   188.58   193.5742   1.9456   24.355   0.6627   10
133     133            6            4.5113   925      92.28   832.72   902.384    6.9549   15.38    0.6938   11
155     155            6            3.871    392      108.58  283.42   261.0241   2.529    18.0967  0.7005   12
167     167            8            4.7904   1343     120.27  1222.73  1016.6542  8.0419   15.0337  0.7202   13
195     195            10           5.1282   1738     131.52  1606.48  1221.472   8.9128   13.152   0.6745   14
223     223            9            4.0359   954      158.02  795.98   503.721    4.278    17.5578  0.7086   15
219     219            8            3.653    822      153.13  668.87   436.7988   3.7534   19.1412  0.6992   16
178     178            7            3.9326   592      120.64  471.36   390.7162   3.3258   17.2343  0.6778   17
124     124            6            4.8387   1380     93.20   1286.80  1380.6867  11.129   15.5333  0.7516   18
87      87             0            0        0        59.40   -59.40   -100       0        0        0.6828   19
34      34             0            0        0        23.97   -23.97   -100       0        0        0.705    20
18      18             2            11.1111  63       15.39   47.61    309.3567   3.50     7.695    0.855    21
18      18             0            0        0        14.49   -14.49   -100       0        0        0.805    22
22      22             0            0        0        13.53   -13.53   -100       0        0        0.615    23
Real output · p202 1.9.77 · demo dataexit 0

03Build your command

Pick values and the command line writes itself, quoted and ready to paste.

p202 report daypart

Set flags below; the command updates as you type.

04Flags

22 flags, plus the global flags every command takes.

FlagWhat it does
--aff-campaign-idstringFilter by INTERNAL campaign id (from campaign list), not the public id in tracking URLs
--aff-network-idstringFilter by affiliate network ID
--browser-idstringFilter by browser ID (the id of a --breakdown browser row)
--country-idstringFilter by country ID
--device-typestringFilter by device type ID: 1 Desktop, 2 Mobile, 3 Tablet, 4 Bot (the ids of --breakdown device_type rows)
--ipstringOnly clicks from this one IP address, IPv4 or IPv6
--isp-idstringFilter by ISP/carrier ID (the id of a --breakdown isp row)
--keywordstringOnly clicks whose keyword contains this text (case-insensitive)
--landing-page-idstringFilter by landing page ID
--method-of-promotionstringOnly direct-link clicks or only landing-page clicks: directlink, landingpage
directlinklandingpage
--period, -pstringPeriod: today, yesterday, last7, last14, last30, last90, thismonth, lastmonth, thisyear, lastyear, alltime
todayyesterdaylast7last14last30last90thismonthlastmonththisyearlastyearalltime
--platform-idstringFilter by platform (OS) ID (the id of a --breakdown platform row)
--ppc-account-idstringFilter by PPC account ID
--ppc-network-idstringFilter by PPC network ID, or none for the clicks with no traffic source
--refererstringOnly clicks whose referring URL contains this text (case-insensitive)
--region-idstringFilter by region ID (the id of a --breakdown region row)
--showstringWhich clicks count (default all): all, real, filtered, filtered_bot, leads; real = not filtered, filtered_bot = filtered as bots, leads = converted
allrealfilteredfiltered_botleads
--sort, -sstringSort by: hour_of_day, total_clicks, total_click_throughs, total_leads, total_income, total_cost, total_net, epc, avg_cpc, conv_rate, roi, cpa (aliases: clicks=total_clicks, conversions=total_leads, cost=total_cost, income=total_income, leads=total_leads, net=total_net, profit=total_net, revenue=total_income)
hour_of_daytotal_clickstotal_click_throughstotal_leadstotal_incometotal_costtotal_netepcavg_cpcconv_rateroicpaclicks → total_clicksconversions → total_leadscost → total_costincome → total_incomeleads → total_leadsnet → total_netprofit → total_netrevenue → total_income
--sort-dirstringSort direction (also --sort-dir): ASC, DESC
ASCDESC
--text-ad-idstringFilter by text ad ID
--time-fromstringStart: 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-tostringEnd, inclusive: unix seconds, a date (2026-10-01, through its last second in the account's timezone) or a time with its offset

05For agents

Running this from an agent

  • Read the same facts as JSON: p202 commands report daypart --json.
  • With AI_AGENT, CLAUDECODE or another agent variable set, output is compact JSON and errors arrive on stderr as a JSON envelope with a hint.
  • Exit codes: 0 ok, 1 bad input, 2 auth, 3 network, 4 server error, 5 partial failure.
p202 commands report daypart --json
{
  "path": "p202 report daypart",
  "use": "daypart",
  "short": "Get stats grouped by hour of day (0-23) to find best-performing hours",
  "runnable": true,
  "tasks": [
    {
      "run": "p202 report daypart",
      "ui_pages": [
        "Overview › Day Parting"
      ],
      "phrases": [
        "dayparting",
        "time of day"
      ]
    }
  ],
  "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": "browser-id",
      "type": "string",
      "default": "",
      "usage": "Filter by browser ID (the id of a `--breakdown browser` row)",
      "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": "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": "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": "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": "sort",
      "shorthand": "s",
      "type": "string",
      "default": "",
      "usage": "Sort by: hour_of_day, total_clicks, total_click_throughs, total_leads, total_income, total_cost, total_net, epc, avg_cpc, conv_rate, roi, cpa (aliases: clicks=total_clicks, conversions=total_leads, cost=total_cost, income=total_income, leads=total_leads, net=total_net, profit=total_net, revenue=total_income)",
      "allowed_values": [
        "hour_of_day",
        "total_clicks",
        "total_click_throughs",
        "total_leads",
        "total_income",
        "total_cost",
        "total_net",
        "epc",
        "avg_cpc",
        "conv_rate",
        "roi",
        "cpa"
      ],
      "value_aliases": {
        "clicks": "total_clicks",
        "conversions": "total_leads",
        "cost": "total_cost",
        "income": "total_income",
        "leads": "total_leads",
        "net": "total_net",
        "profit": "total_net",
        "revenue": "total_income"
      },
      "required": false
    },
    {
      "name": "sort-dir",
      "type": "string",
      "default": "",
      "usage": "Sort direction (also --sort-dir): ASC, DESC",
      "allowed_values": [
        "ASC",
        "DESC"
      ],
      "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
    }
  ]
}