p202 report timeseries

Get stats over time — daily/hourly buckets of clicks, conversions, revenue, etc.

Web UIOverview › Breakdown Analysis
All commands

01Jobs it does

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

performance over time

Also: daily stats, trend

p202 report timeseries
Web UIOverview › Breakdown Analysis

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 timeseries --period last30
$ p202 report timeseries --period last30
Clicks  Clickthroughs  Conversions  Conv %  Revenue  Cost    Profit   ROI %      EPC      CPA      Avg CPC  period
------  -------------  -----------  ------  -------  ------  -------  ---------  -------  -------  -------  ----------
62      62             2            3.2258  187      45.65   141.35   309.6386   3.0161   22.825   0.7363   2026-09-09
68      68             6            8.8235  904      44.44   859.56   1934.2034  13.2941  7.4067   0.6535   2026-09-10
76      76             4            5.2632  411      49.62   361.38   728.295    5.4079   12.405   0.6529   2026-09-11
87      87             4            4.5977  257      57.40   199.60   347.7352   2.954    14.35    0.6598   2026-09-12
77      77             5            6.4935  286      55.29   230.71   417.2726   3.7143   11.058   0.7181   2026-09-13
60      60             4            6.6667  560      42.03   517.97   1232.3816  9.3333   10.5075  0.7005   2026-09-14
76      76             5            6.5789  600      53.52   546.48   1021.0762  7.8947   10.704   0.7042   2026-09-15
73      73             1            1.3699  164      58.23   105.77   181.6418   2.2466   58.23    0.7977   2026-09-16
81      81             1            1.2346  34       51.62   -17.62   -34.1341   0.4198   51.62    0.6373   2026-09-17
100     100            9            9       1295     75.66   1219.34  1611.6045  12.95    8.4067   0.7566   2026-09-18
90      90             1            1.1111  29       63.89   -34.89   -54.6095   0.3222   63.89    0.7099   2026-09-19
94      94             6            6.383   395      63.36   331.64   523.4217   4.2021   10.56    0.674    2026-09-20
74      74             0            0       0        61.72   -61.72   -100       0        0        0.8341   2026-09-21
83      83             4            4.8193  449      60.77   388.23   638.8514   5.4096   15.1925  0.7322   2026-09-22
91      91             4            4.3956  924      70.83   853.17   1204.532   10.1538  17.7075  0.7784   2026-09-23
107     107            3            2.8037  647      76.45   570.55   746.3048   6.0467   25.4833  0.7145   2026-09-24
80      80             5            6.25    224      43.56   180.44   414.2332   2.80     8.712    0.5445   2026-09-25
97      97             4            4.1237  1132     59.20   1072.80  1812.1622  11.6701  14.80    0.6103   2026-09-26
102     102            1            0.9804  588      72.86   515.14   707.0272   5.7647   72.86    0.7143   2026-09-27
101     101            5            4.9505  934      64.16   869.84   1355.7357  9.2475   12.832   0.6352   2026-09-28
88      88             6            6.8182  793      54.76   738.24   1348.1373  9.0114   9.1267   0.6223   2026-09-29
86      86             6            6.9767  1214     66.95   1147.05  1713.2935  14.1163  11.1583  0.7785   2026-09-30
102     102            1            0.9804  29       68.70   -39.70   -57.7875   0.2843   68.70    0.6735   2026-10-01
108     108            3            2.7778  97       64.54   32.46    50.2944    0.8981   21.5133  0.5976   2026-10-02
121     121            5            4.1322  471      84.83   386.17   455.2281   3.8926   16.966   0.7011   2026-10-03
139     139            5            3.5971  171      98.30   72.70    73.9573    1.2302   19.66    0.7072   2026-10-04
122     122            7            5.7377  1158     83.48   1074.52  1287.1586  9.4918   11.9257  0.6843   2026-10-05
124     124            4            3.2258  484      92.08   391.92   425.6299   3.9032   23.02    0.7426   2026-10-06
125     125            3            2.40    839      98.31   740.69   753.4228   6.712    32.77    0.7865   2026-10-07
161     161            5            3.1056  181      122.55  58.45    47.6948    1.1242   24.51    0.7612   2026-10-08
46      46             2            4.3478  380      28.22   351.78   1246.5627  8.2609   14.11    0.6135   2026-10-09
Real output · p202 1.9.77 · demo dataexit 0

Profit by period

  1. 09-09
  2. 09-12
  3. 09-15
  4. $1,219.3409-18
  5. 09-21
  6. 09-24
  7. 09-27
  8. 09-30
  9. 10-03
  10. 10-06
  11. 10-09

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

p202 report timeseries --period last7 --interval day
$ p202 report timeseries --period last7 --interval day
Clicks  Clickthroughs  Conversions  Conv %  Revenue  Cost    Profit   ROI %      EPC     CPA      Avg CPC  period
------  -------------  -----------  ------  -------  ------  -------  ---------  ------  -------  -------  ----------
108     108            3            2.7778  97       64.54   32.46    50.2944    0.8981  21.5133  0.5976   2026-10-02
121     121            5            4.1322  471      84.83   386.17   455.2281   3.8926  16.966   0.7011   2026-10-03
139     139            5            3.5971  171      98.30   72.70    73.9573    1.2302  19.66    0.7072   2026-10-04
122     122            7            5.7377  1158     83.48   1074.52  1287.1586  9.4918  11.9257  0.6843   2026-10-05
124     124            4            3.2258  484      92.08   391.92   425.6299   3.9032  23.02    0.7426   2026-10-06
125     125            3            2.40    839      98.31   740.69   753.4228   6.712   32.77    0.7865   2026-10-07
161     161            5            3.1056  181      122.55  58.45    47.6948    1.1242  24.51    0.7612   2026-10-08
46      46             2            4.3478  380      28.22   351.78   1246.5627  8.2609  14.11    0.6135   2026-10-09
Real output · p202 1.9.77 · demo dataexit 0
p202 report timeseries
$ p202 report timeseries
Clicks  Clickthroughs  Conversions  Conv %  Revenue  Cost    Profit   ROI %      EPC      CPA      Avg CPC  period
------  -------------  -----------  ------  -------  ------  -------  ---------  -------  -------  -------  ----------
62      62             2            3.2258  187      45.65   141.35   309.6386   3.0161   22.825   0.7363   2026-09-09
68      68             6            8.8235  904      44.44   859.56   1934.2034  13.2941  7.4067   0.6535   2026-09-10
76      76             4            5.2632  411      49.62   361.38   728.295    5.4079   12.405   0.6529   2026-09-11
87      87             4            4.5977  257      57.40   199.60   347.7352   2.954    14.35    0.6598   2026-09-12
77      77             5            6.4935  286      55.29   230.71   417.2726   3.7143   11.058   0.7181   2026-09-13
60      60             4            6.6667  560      42.03   517.97   1232.3816  9.3333   10.5075  0.7005   2026-09-14
76      76             5            6.5789  600      53.52   546.48   1021.0762  7.8947   10.704   0.7042   2026-09-15
73      73             1            1.3699  164      58.23   105.77   181.6418   2.2466   58.23    0.7977   2026-09-16
81      81             1            1.2346  34       51.62   -17.62   -34.1341   0.4198   51.62    0.6373   2026-09-17
100     100            9            9       1295     75.66   1219.34  1611.6045  12.95    8.4067   0.7566   2026-09-18
90      90             1            1.1111  29       63.89   -34.89   -54.6095   0.3222   63.89    0.7099   2026-09-19
94      94             6            6.383   395      63.36   331.64   523.4217   4.2021   10.56    0.674    2026-09-20
74      74             0            0       0        61.72   -61.72   -100       0        0        0.8341   2026-09-21
83      83             4            4.8193  449      60.77   388.23   638.8514   5.4096   15.1925  0.7322   2026-09-22
91      91             4            4.3956  924      70.83   853.17   1204.532   10.1538  17.7075  0.7784   2026-09-23
107     107            3            2.8037  647      76.45   570.55   746.3048   6.0467   25.4833  0.7145   2026-09-24
80      80             5            6.25    224      43.56   180.44   414.2332   2.80     8.712    0.5445   2026-09-25
97      97             4            4.1237  1132     59.20   1072.80  1812.1622  11.6701  14.80    0.6103   2026-09-26
102     102            1            0.9804  588      72.86   515.14   707.0272   5.7647   72.86    0.7143   2026-09-27
101     101            5            4.9505  934      64.16   869.84   1355.7357  9.2475   12.832   0.6352   2026-09-28
88      88             6            6.8182  793      54.76   738.24   1348.1373  9.0114   9.1267   0.6223   2026-09-29
86      86             6            6.9767  1214     66.95   1147.05  1713.2935  14.1163  11.1583  0.7785   2026-09-30
102     102            1            0.9804  29       68.70   -39.70   -57.7875   0.2843   68.70    0.6735   2026-10-01
108     108            3            2.7778  97       64.54   32.46    50.2944    0.8981   21.5133  0.5976   2026-10-02
121     121            5            4.1322  471      84.83   386.17   455.2281   3.8926   16.966   0.7011   2026-10-03
139     139            5            3.5971  171      98.30   72.70    73.9573    1.2302   19.66    0.7072   2026-10-04
122     122            7            5.7377  1158     83.48   1074.52  1287.1586  9.4918   11.9257  0.6843   2026-10-05
124     124            4            3.2258  484      92.08   391.92   425.6299   3.9032   23.02    0.7426   2026-10-06
125     125            3            2.40    839      98.31   740.69   753.4228   6.712    32.77    0.7865   2026-10-07
161     161            5            3.1056  181      122.55  58.45    47.6948    1.1242   24.51    0.7612   2026-10-08
46      46             2            4.3478  380      28.22   351.78   1246.5627  8.2609   14.11    0.6135   2026-10-09
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 timeseries

Set flags below; the command updates as you type.

04Flags

21 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)
--interval, -istringInterval: hour, day, week, month
--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
--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 timeseries --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 timeseries --json
{
  "path": "p202 report timeseries",
  "use": "timeseries",
  "short": "Get stats over time — daily/hourly buckets of clicks, conversions, revenue, etc.",
  "runnable": true,
  "tasks": [
    {
      "run": "p202 report timeseries",
      "ui_pages": [
        "Overview › Breakdown Analysis"
      ],
      "phrases": [
        "performance over time",
        "daily stats",
        "trend"
      ]
    }
  ],
  "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": "interval",
      "shorthand": "i",
      "type": "string",
      "default": "",
      "usage": "Interval: hour, day, week, month",
      "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": "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
    }
  ]
}