Use by publication year

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Example 1: YOP interval = 1Y
2	Title	Print ISSN	Online ISSN	Year of publicaton	Access type	Metric type	Reporting period total	Jan-2020	Feb-2020	Mar-2020	Apr-2020	May-2020	Jun-2020
3	List all titles from agreement line, even if no COUNTER data present; if title is part of a package, list it separately.	Print ISSN from agreement line	Online ISSN from agreement line	Year of publication from COUNTER report	Access type from COUNTER report	Metric type from COUNTER report; include both total and unique item requests	1. Begin with COUNTER data from usage provider associated with the agreement. 2. Filter COUNTER data to only titles matching agreement lines. 3. Filter COUNTER data to only publication years matching coverage dates of agreement lines 4. Sum COUNTER data by total item requests occuring in the reporting period	Include COUNTER data for each month that appears in the reporting period
4	Totals - Total item requests						3,045	903	565	468	206	372	531
5	Totals - Unique item requests						2,710	712	508	375	150	558	407
6	Journal A	1111-22222	1111-1223	2020	Controlled	Total_Item_Requests	1,823	494	287	402	112	260	269
7	Journal A	1111-22222	1111-1223	2020	Controlled	Unique_Item_Requests	1,221	408	279	66	94	112	262
8	Journal A	1111-22222	1111-1223	2019	Controlled	Total_Item_Requests	1,489	304	229	309	57	446	145
9	Journal A	1111-22222	1111-1223	2019	Controlled	Unique_Item_Requests	1,706	340	71	397	490	274	134
10	Journal A	1111-22222	1111-1223	2018	Controlled	Total_Item_Requests	1,633	74	451	293	348	383	83
11	Journal A	1111-22222	1111-1223	2018	Controlled	Unique_Item_Requests	2,173	242	414	289	486	332	409
12	Journal A	1111-22222	1111-1223	2020	Gold_OA	Total_Item_Requests	2,296	449	498	405	424	37	483
13	Journal A	1111-22222	1111-1223	2020	Gold_OA	Unique_Item_Requests	1,339	193	292	62	136	428	227
14	Journal A	1111-22222	1111-1223	2019	Gold_OA	Total_Item_Requests	1,353	220	75	204	347	79	430
15	Journal A	1111-22222	1111-1223	2019	Gold_OA	Unique_Item_Requests	1,180	354	194	114	28	21	469
16	Journal A	1111-22222	1111-1223	2018	Gold_OA	Total_Item_Requests	1,375	93	84	92	226	400	480
17	Journal A	1111-22222	1111-1223	2018	Gold_OA	Unique_Item_Requests	1,936	267	450	440	387	202	190
18	Journal B	1111-22211	1111-1213	2020	Controlled	Total_Item_Requests	1,964	239	427	446	156	358	339
19	Journal B	1111-22211	1111-1213	2020	Controlled	Unique_Item_Requests	1,191	365	93	135	35	129	434
20	Journal B	1111-22211	1111-1213	2019	Controlled	Total_Item_Requests	1,401	45	314	459	355	2	226
21	Journal B	1111-22211	1111-1213	2019	Controlled	Unique_Item_Requests	1,419	381	375	109	246	143	165
22	Journal B	1111-22211	1111-1213	2018	Controlled	Total_Item_Requests	1,112	426	426	21	71	59	108
23	Journal B	1111-22211	1111-1213	2018	Controlled	Unique_Item_Requests	1,684	406	142	177	109	481	371
24	Journal B	1111-22211	1111-1213	2020	Gold_OA	Total_Item_Requests	2,268	410	441	327	116	476	497
25	Journal B	1111-22211	1111-1213	2020	Gold_OA	Unique_Item_Requests	446	51	128	2	11	139	116
26	Journal B	1111-22211	1111-1213	2019	Gold_OA	Total_Item_Requests	1,611	446	247	64	405	44	405
27	Journal B	1111-22211	1111-1213	2019	Gold_OA	Unique_Item_Requests	1,837	100	421	306	135	449	425
28	Journal B	1111-22211	1111-1213	2018	Gold_OA	Total_Item_Requests	1,207	213	42	137	166	229	419
29	Journal B	1111-22211	1111-1213	2018	Gold_OA	Unique_Item_Requests	1,367	35	63	289	222	309	449
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100