Skip to content

Instantly share code, notes, and snippets.

@alexstrat

alexstrat/ads_report.csv

Last active February 24, 2016 16:17
Show Gist options
  • Save alexstrat/8bed46aad5102ffa3ed5 to your computer and use it in GitHub Desktop.
Save alexstrat/8bed46aad5102ffa3ed5 to your computer and use it in GitHub Desktop.
Download ZIP
Work4 analyst test datasets
Raw
ads_report.csv
date campaign_name ad_name targeting_type bid_type impressions reach clicks applicants amount_spend_dollars
2/1/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1722 1333 14 1 8.44
2/1/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1693 1584 7 1 6.45
2/1/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1542 1414 16 1 9.66
2/1/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1607 1517 13 1 10.37
2/1/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1982 1964 18 0 10.69
2/1/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1917 1650 10 1 9.17
2/1/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1959 1651 12 1 8.48
2/1/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1702 1568 7 1 5.57
2/1/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1672 1431 8 0 6.65
2/1/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 140 100 1 0 1.48
2/2/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1633 1354 13 0 8.03
2/2/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1602 1199 8 0 7.5
2/2/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1841 1374 17 0 10.06
2/2/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1622 1151 13 0 10.4
2/2/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1887 1802 12 1 7.54
2/2/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1925 1476 9 0 7.97
2/2/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1963 1910 11 0 7.73
2/2/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1703 1493 7 0 5.54
2/2/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1684 1507 9 1 7.42
2/2/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 161 122 2 0 3.02
2/3/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1904 1681 15 0 9.8
2/3/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1538 1457 6 0 5.38
2/3/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1726 1546 17 0 10.43
2/3/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1611 1526 10 1 8.07
2/3/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1769 1467 14 0 9.06
2/3/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1963 1594 8 0 7.19
2/3/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 2053 1944 12 0 8.77
2/3/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1706 1390 6 1 4.81
2/3/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1389 1109 6 0 4.84
2/3/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 159 124 0 0 0.00
2/4/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 2017 1851 19 0 10.37
2/4/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1695 1221 7 0 6.27
2/4/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1365 1249 13 1 7.93
2/4/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1531 1174 12 0 9.6
2/4/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 2404 2261 17 0 10.19
2/4/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1931 1504 11 1 9.81
2/4/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 2021 1662 11 0 7.34
2/4/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1769 1546 7 0 5.70
2/4/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1682 1543 9 0 7.36
2/4/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 117 103 0 0 0.00
2/5/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1749 1224 13 1 8.37
2/5/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1702 1433 6 1 5.4
2/5/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1426 1195 15 0 10.01
2/5/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1485 1271 12 1 9.6
2/5/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 2108 1663 15 0 9.10
2/5/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1945 1624 9 1 8.62
2/5/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 2049 1888 12 1 8.46
2/5/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1652 1619 8 0 6.64
2/5/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1847 1819 8 0 6.76
2/5/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 139 131 1 0 1.50
2/6/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1730 1599 13 0 7.07
2/6/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1704 1371 7 0 6.52
2/6/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1603 1373 15 1 8.78
2/6/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1433 1140 11 0 8.88
2/6/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1990 1618 14 0 8.45
2/6/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 2051 1481 8 1 7.54
2/6/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1976 1836 11 0 7.27
2/6/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1702 1664 7 0 5.17
2/6/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1681 1444 9 1 7.45
2/6/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 123 102 0 0 0.00
2/7/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1733 1476 13 0 8.11
2/7/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1561 1151 7 0 6.75
2/7/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1549 1232 14 1 8.8
2/7/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1611 1313 10 0 8.35
2/7/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1985 1547 12 1 7.06
2/7/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 2241 1701 12 0 10.88
2/7/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1961 1585 12 1 8.19
2/7/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1573 1247 6 0 4.75
2/7/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1673 1468 8 0 6.29
2/7/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 102 99 0 1 0.00
2/8/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1584 1573 14 0 9.43
2/8/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1693 1628 8 0 7.11
2/8/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1771 1429 15 0 9.96
2/8/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1845 1734 16 1 10.46
2/8/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1983 1933 15 1 8.64
2/8/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1923 1823 9 0 8.42
2/8/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1939 1551 11 0 8.65
2/8/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1601 1503 6 0 4.70
2/8/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1798 1637 9 0 8.45
2/8/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 99 95 0 0 0.00
2/9/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1722 1698 12 0 7.12
2/9/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1486 1180 6 0 5.87
2/9/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1354 1198 13 1 7.76
2/9/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1484 1330 12 0 10.04
2/9/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 2353 2293 18 0 11.03
2/9/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 2125 1951 10 0 9.20
2/9/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1701 1687 10 1 7.23
2/9/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1931 1887 8 0 6.40
2/9/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1696 1498 8 0 6.64
2/9/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 76 65 0 0 0.00
2/10/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1727 1267 13 1 8.03
2/10/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1433 1069 6 1 5.32
2/10/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1498 1486 12 1 6.73
2/10/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1706 1695 14 0 10.49
2/10/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 2154 2009 19 0 11.56
2/10/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1924 1747 9 1 9.01
2/10/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 2052 1545 12 1 8.48
2/10/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1866 1625 9 0 6.82
2/10/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 2028 1916 11 1 9.15
2/10/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 87 79 0 0 0.00
2/11/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1752 1291 14 0 8.4
2/11/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1861 1841 8 0 7.26
2/11/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1382 1135 14 0 9.01
2/11/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1331 1297 10 0 8.1
2/11/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1902 1335 15 0 9.16
2/11/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 2192 1920 10 0 8.72
2/11/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1611 1512 9 0 6.95
2/11/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1573 1234 7 1 6.23
2/11/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1872 1448 10 1 7.39
2/11/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 97 95 1 0 1.59
2/12/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1660 1417 11 1 7.15
2/12/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1693 1212 7 1 6.71
2/12/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1544 1500 14 1 8.41
2/12/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1858 1794 17 0 10.41
2/12/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 2310 2098 18 0 10.80
2/12/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1929 1357 9 1 8.62
2/12/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1728 1322 10 0 7.03
2/12/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1625 1256 8 0 7.12
2/12/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1471 1229 7 0 5.21
2/12/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 74 52 0 0 0.00
2/13/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1581 1556 12 0 7.06
2/13/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1436 1208 6 0 5.28
2/13/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1548 1342 15 1 8.63
2/13/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1624 1217 12 0 9.56
2/13/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 2008 1820 19 1 12.14
2/13/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1596 1356 6 0 5.44
2/13/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1972 1723 11 1 8.31
2/13/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1882 1704 8 1 6.43
2/13/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1839 1753 10 0 8.93
2/13/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 43 42 0 0 0.00
2/14/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1703 1218 13 0 8.07
2/14/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 2053 1965 7 0 6.11
2/14/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1283 987 14 0 9.19
2/14/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1760 1592 16 1 10.53
2/14/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1982 1790 15 0 9.05
2/14/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1912 1387 11 0 9.77
2/14/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1610 1271 9 1 6.93
2/14/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1636 1613 8 0 6.17
2/14/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1684 1185 9 1 7.84
2/14/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 17 13 0 0 0.00
2/15/2016 Campaign 1 Interests - CPC [job_id=63100481] Interests CPC 1542 1352 12 0 6.87
2/15/2016 Campaign 1 Interests - oCPM [job_id=63100481] Interests oCPM 1718 1313 8 0 7.44
2/15/2016 Campaign 1 Work Position - CPC [job_id=67563580] Work Position CPC 1568 1169 17 0 10.39
2/15/2016 Campaign 1 Interests - oCPM [job_id=67563580] Interests oCPM 1615 1366 13 0 9.86
2/15/2016 Campaign 1 Interests - CPC [job_id=68755574] Interests CPC 1984 1860 15 0 9.38
2/15/2016 Campaign 1 Interests - oCPM [job_id=68755574] Interests oCPM 1926 1694 11 0 9.79
2/15/2016 Campaign 1 Work Position - oCPM [job_id=68755574] Work Position oCPM 1678 1525 9 0 6.66
2/15/2016 Campaign 1 Interests - CPC [job_id=74131568] Interests CPC 1990 1553 8 0 6.20
2/15/2016 Campaign 1 Interests - oCPM [job_id=74131568] Interests oCPM 1680 1676 8 0 7.21
2/15/2016 Campaign 1 Interests - CPM [job_id=74131568] Interests CPM 22 16 0 0 0.00
Raw
jobs.csv
job_id client_name job_title industry
63100481 SuperTech Software Engineers Tech
67563580 SuperTech Data Analysts Tech
68755574 BestVendors Sales Representatives Retail
74131568 FinanceNinja Contrôleur de gestion junior Finance
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment