A simple tool that takes CSV reports from Google Adsense, Google Admob, and Google Analytics and outputs them in JSON / Pandas.DataFrame format.
Project description
google-csv-helper
A simple tool for parsing google csv files.
Installation
% pip install google-csv-helper
Usage
% tree csv
csv
├── admob
│ └── hk
│ ├── End-2023-05-31-day-admob-report.csv
│ ├── End-2023-05-31-month-admob-report.csv
│ ├── End-2023-05-31-week-admob-report.csv
│ ├── latest-day.csv
│ ├── latest-month.csv
│ └── latest-week.csv
└── adsense
├── cn
│ ├── End-2023-05-31-day-AdSenseReport.csv
│ ├── End-2023-05-31-month-AdSenseReport.csv
│ ├── End-2023-05-31-week-AdSenseReport.csv
│ ├── latest-day.csv
│ ├── latest-month.csv
│ └── latest-week.csv
└── hk
├── End-2023-05-31-day-report.csv
├── End-2023-05-31-month-report.csv
├── End-2023-05-31-week-report.csv
├── latest-day.csv
├── latest-month.csv
└── latest-week.csv
6 directories, 18 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)
% 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 | | |
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 |
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
google-csv-helper-1.0.4.tar.gz
(11.7 kB
view hashes)
Built Distribution
Close
Hashes for google_csv_helper-1.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7d35014fcb5d1be1e214da509ad649e857a10d261ea10bb785c0bc82e5983fe |
|
MD5 | 667cc291f8db2fc7a456fa45154f7047 |
|
BLAKE2b-256 | 6159e8a652eaa9b0bf0f512213d0c60c0fef61db75ca1b8d2fbc3589d21f8b4e |