A simple tool for parsing google csv files.
% pip install google-csv-helper
% tree csv
csv
├── admob
│ └── hk
│ └── latest-day.csv
└── adsense
├── cn
│ └── latest-day.csv
└── hk
└── latest-day.csv
6 directories, 3 files
% file csv/admob/hk/latest-day.csv
csv/admob/hk/latest-day.csv: Unicode text, UTF-16, little-endian text
% iconv -f UTF-16 -t UTF-8 csv/admob/hk/latest-day.csv | head -n1
日期 預估收益 (USD) 觀察到的有效千次曝光出價 (USD) 請求 媒合率 (%) (%) 比對成功的請求 顯示率 (%) (%) 曝光 點閱率 (%) (%) 點擊次數 出價要求 參與競價的出價 (%) 參與競價的出價 勝出出價 (%) 勝出出價次數
% file csv/adsense/hk/latest-day.csv
csv/adsense/hk/latest-day.csv: CSV text
% head -n1 csv/adsense/hk/latest-day.csv
日期,預估收益 (USD),瀏覽量,網頁千次曝光收益 (USD),曝光次數,曝光千次曝光收益 (USD),Active View 可視率,點擊,點閱率,單次點擊出價 (USD)
% head -n1 csv/adsense/cn/latest-day.csv
日期,估算收入 (USD),网页浏览量,网页 RPM (USD),展示次数,每千次展示收入 (USD),Active View 可见率,点击次数,点击率,CPC (USD)
Use Google AdSense/Admob api to get the report content and convert it into csv format
% google-csv-helper --google-token-file .google-account01 --google-show-report-list
% google-csv-helper --google-token-file .google-account02 --google-show-report-list
% google-csv-helper --google-token-file .google-account01 --google-adsense-latest-csv > csv/account1/adsense/latest-day.csv
% google-csv-helper --google-token-file .google-account02 --google-admob-latest-csv > csv/account2/admob/latest-day.csv
% google-csv-helper --google-token-file .google-account02 --google-adsense-latest-csv > csv/account2/adsense/latest-day.csv
% tree csv
csv
├── account01
│ └── adsense
│ └── latest-day.csv
└── account02
├── adsense
│ └── latest-day.csv
└── admob
└── latest-day.csv
6 directories, 3 files
Create Dashboard reports from csv files
% google-csv-helper --output markdown csv
## Current:
### Date Range: 2023-06-01 ~ 2023-06-04
#### compare: 2023-05-01 ~ 2023-05-31
| Item | Cumulative Revenue | Average Daily Revenue | Average CPC | Min Daily Revenue | Max Daily Revenue
| -- | --: | --: | --: | --: | --:
| Admob Global | 1,234.56 | 123.45 (-12.34%) | 0.001 (-1.23%) | 234.56 [06/02 Fri] | 456.78 [06/01 Thu]
| Adsense Global | 1,234.56 | 123.45 (-12.34%) | 0.1234 (-2.34%) | 123.45 [06/02 Fri] | 345.67 [06/01 Thu]
| Adsense China | 1,234.56 | 123.45 (-12.34%) | 0.2345 (2.34%) | 123.45 [06/02 Fri] | 345.67 `[06/01 Thu]
| Total | 1,234.56 | 456.78 | | |
% google-csv-helper --output markdown --output-chart-columns 'Estimated earnings (USD)' csv
Date Range: 2023-06-01 ~ 2023-06-04
compare: 2023-05-01 ~ 2023-05-31
Item |
Cumulative Revenue |
Average Daily Revenue |
Average CPC |
Min Daily Revenue |
Max Daily Revenue |
Admob Global |
1,234.56 |
123.45 (-12.34%) |
0.001 (-1.23%) |
234.56 [06/02 Fri] |
456.78 [06/01 Thu] |
Adsense Global |
1,234.56 |
123.45 (-12.34%) |
0.1234 (-2.34%) |
123.45 [06/02 Fri] |
345.67 [06/01 Thu] |
Adsense China |
1,234.56 |
123.45 (-12.34%) |
0.2345 (2.34%) |
123.45 [06/02 Fri] |
345.67 `[06/01 Thu] |
Total |
1,234.56 |
456.78 |
|
|
|
Sum of (Admob Global, Adsense Global, Adsense China) - Cumulative Average of 'Estimated earnings (USD)' Chart:
867.61 ┤
846.52 ┤ ╭──
825.44 ┼╮ ╭╯
804.36 ┤│ ╭─╯
783.27 ┤│ ╭╯
762.19 ┤│ ╭─╯
741.11 ┤│ ╭╮ ╭╮ ╭╯
720.02 ┤│╭╯╰─╯╰╮ │
698.94 ┤╰╯ ╰─╮ │
677.86 ┤ ╰╮ ╭╯
656.77 ┤ ╰───╮ │
635.69 ┤ ╰───╯
% google-csv-helper --output-chart-columns 'Estimated earnings (USD)' --output-chart-detailed-columns csv
Date Range: 2023-06-01 ~ 2023-06-04
compare: 2023-05-01 ~ 2023-05-31
Item |
Cumulative Revenue |
Average Daily Revenue |
Average CPC |
Min Daily Revenue |
Max Daily Revenue |
Admob Global |
1,234.56 |
123.45 (-12.34%) |
0.001 (-1.23%) |
234.56 [06/02 Fri] |
456.78 [06/01 Thu] |
Adsense Global |
1,234.56 |
123.45 (-12.34%) |
0.1234 (-2.34%) |
123.45 [06/02 Fri] |
345.67 [06/01 Thu] |
Adsense China |
1,234.56 |
123.45 (-12.34%) |
0.2345 (2.34%) |
123.45 [06/02 Fri] |
345.67 `[06/01 Thu] |
Total |
1,234.56 |
456.78 |
|
|
|
Sum of (Admob Global, Adsense Global, Adsense China) - Cumulative Average of 'Estimated earnings (USD)' Chart:
867.61 ┤
846.52 ┤ ╭──
825.44 ┼╮ ╭╯
804.36 ┤│ ╭─╯
783.27 ┤│ ╭╯
762.19 ┤│ ╭─╯
741.11 ┤│ ╭╮ ╭╮ ╭╯
720.02 ┤│╭╯╰─╯╰╮ │
698.94 ┤╰╯ ╰─╮ │
677.86 ┤ ╰╮ ╭╯
656.77 ┤ ╰───╮ │
635.69 ┤ ╰───╯
Admob Global - Cumulative Average of 'Estimated earnings (USD)' Chart:
297.11 ┼╮
294.28 ┤│ ╭╮
291.46 ┤│ ╭╯╰─╮
288.64 ┤│ │ ╰╮
285.81 ┤│ │ ╰╮╭╮
282.99 ┤│ │ ╰╯╰╮
280.17 ┤│ │ ╰╮
277.35 ┤│ ╭╯ ╰╮
274.52 ┤│ │ ╰╮ ╭─╮
271.70 ┤╰╮ │ ╰─╯ ╰─╮ ╭──
268.88 ┤ ╰──╯ ╰──╯
266.06 ┤
Adsense Global - Cumulative Average of 'Estimated earnings (USD)' Chart:
495.71 ┤
473.65 ┤ ╭──
451.59 ┤ ╭╯
429.53 ┼╮ ╭╯
407.46 ┤│ ╭─╯
385.40 ┤│ ╭╯
363.34 ┤│╭─╮ ╭╯
341.28 ┤╰╯ ╰╮ ╭╯
319.22 ┤ ╰──╮ │
297.16 ┤ ╰╮ ╭╯
275.10 ┤ ╰─╮ ╭╯
253.04 ┤ ╰──────╯
Adsense China - Cumulative Average of 'Estimated earnings (USD)' Chart:
211.76 ┤
209.91 ┤ ╭──╮
208.06 ┤ │ ╰╮
206.20 ┤ │ ╰╮ ╭─╮
204.35 ┤ │ ╰─╯ ╰╮ ╭──╮
202.50 ┤ ╭╯ ╰──╯ ╰─╮
200.65 ┼╮ ╭╯ ╰────╮
198.80 ┤│ │ ╰
196.95 ┤│ │
195.10 ┤│ ╭╯
193.25 ┤│ │
191.40 ┤╰─╯