p202 report daypart

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

Web UIOverview › Day Parting
All commands

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
------  -------------  -----------  -------  -------  ------  -------  ---------  -------  -------  -------  -----------
17      17             0            0        0        14.17   -14.17   -100       0        0        0.8335   0
12      12             0            0        0        12.36   -12.36   -100       0        0        1.03     21
121     121            2            1.6529   79       95.17   -16.17   -16.9906   0.6529   47.585   0.7865   4
96      96             4            4.1667   126      53.20   72.80    136.8421   1.3125   13.30    0.5542   3
22      22             1            4.5455   32       13.12   18.88    143.9024   1.4545   13.12    0.5964   23
83      83             1            1.2048   132      52.12   79.88    153.2617   1.5904   52.12    0.628    19
28      28             2            7.1429   61       18      43       238.8889   2.1786   9        0.6429   1
150     150            3            2        366      105.45  260.55   247.0839   2.44     35.15    0.703    11
157     157            7            4.4586   431      117.03  313.97   268.2816   2.7452   16.7186  0.7454   12
166     166            3            1.8072   450      110.11  339.89   308.6822   2.7108   36.7033  0.6633   13
133     133            5            3.7594   427      95.26   331.74   348.2469   3.2105   19.052   0.7162   5
204     204            11           5.3922   769      148.48  620.52   417.9149   3.7696   13.4982  0.7278   14
164     164            3            1.8293   634      114.19  519.81   455.215    3.8659   38.0633  0.6963   9
55      55             4            7.2727   268      43.87   224.13   510.8958   4.8727   10.9675  0.7976   20
138     138            5            3.6232   714      100.57  613.43   609.9533   5.1739   20.114   0.7288   10
268     268            12           4.4776   1567     191.78  1375.22  717.0821   5.847    15.9817  0.7156   15
52      52             2            3.8462   287      30.87   256.13   829.7052   5.5192   15.435   0.5937   2
244     244            10           4.0984   1641     176.30  1464.70  830.7998   6.7254   17.63    0.7225   16
141     141            6            4.2553   1192     105.44  1086.56  1030.5008  8.4539   17.5733  0.7478   7
201     201            9            4.4776   1402     123.92  1278.08  1031.3751  6.9751   13.7689  0.6165   17
139     139            9            6.4748   1226     97.28   1128.72  1160.2796  8.8201   10.8089  0.6999   18
158     158            9            5.6962   1633     113.93  1519.07  1333.3363  10.3354  12.6589  0.7211   8
134     134            9            6.7164   1535     92.59   1442.41  1557.8464  11.4552  10.2878  0.691    6
17      17             3            17.6471  377      7.66    369.34   4821.671   22.1765  2.5533   0.4506   22
Real output · p202 1.9.78 · demo dataexit 0

Profit by hour of day

  1. 00h
  2. 03h
  3. 01h
  4. 13h
  5. 09h
  6. 15h
  7. 07h
  8. $1,519.0708h
  9. 22h

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
------  -------------  -----------  -------  -------  ------  -------  ---------  -------  -------  -------  -----------
17      17             0            0        0        14.17   -14.17   -100       0        0        0.8335   0
28      28             2            7.1429   61       18      43       238.8889   2.1786   9        0.6429   1
52      52             2            3.8462   287      30.87   256.13   829.7052   5.5192   15.435   0.5937   2
96      96             4            4.1667   126      53.20   72.80    136.8421   1.3125   13.30    0.5542   3
121     121            2            1.6529   79       95.17   -16.17   -16.9906   0.6529   47.585   0.7865   4
133     133            5            3.7594   427      95.26   331.74   348.2469   3.2105   19.052   0.7162   5
134     134            9            6.7164   1535     92.59   1442.41  1557.8464  11.4552  10.2878  0.691    6
141     141            6            4.2553   1192     105.44  1086.56  1030.5008  8.4539   17.5733  0.7478   7
158     158            9            5.6962   1633     113.93  1519.07  1333.3363  10.3354  12.6589  0.7211   8
164     164            3            1.8293   634      114.19  519.81   455.215    3.8659   38.0633  0.6963   9
138     138            5            3.6232   714      100.57  613.43   609.9533   5.1739   20.114   0.7288   10
150     150            3            2        366      105.45  260.55   247.0839   2.44     35.15    0.703    11
157     157            7            4.4586   431      117.03  313.97   268.2816   2.7452   16.7186  0.7454   12
166     166            3            1.8072   450      110.11  339.89   308.6822   2.7108   36.7033  0.6633   13
204     204            11           5.3922   769      148.48  620.52   417.9149   3.7696   13.4982  0.7278   14
268     268            12           4.4776   1567     191.78  1375.22  717.0821   5.847    15.9817  0.7156   15
244     244            10           4.0984   1641     176.30  1464.70  830.7998   6.7254   17.63    0.7225   16
201     201            9            4.4776   1402     123.92  1278.08  1031.3751  6.9751   13.7689  0.6165   17
139     139            9            6.4748   1226     97.28   1128.72  1160.2796  8.8201   10.8089  0.6999   18
83      83             1            1.2048   132      52.12   79.88    153.2617   1.5904   52.12    0.628    19
55      55             4            7.2727   268      43.87   224.13   510.8958   4.8727   10.9675  0.7976   20
12      12             0            0        0        12.36   -12.36   -100       0        0        1.03     21
17      17             3            17.6471  377      7.66    369.34   4821.671   22.1765  2.5533   0.4506   22
22      22             1            4.5455   32       13.12   18.88    143.9024   1.4545   13.12    0.5964   23
Real output · p202 1.9.78 · 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, 6 no Pro licence on the install.
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
    }
  ]
}