Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Expired Reports

Reports will expire 10 days after creation. To view older reports, the report must be refreshed. You can refresh a report by clicking on the circling arrows button on your report list.

...

Data Storage for Reports and Exports

...

  • Duplicated Count= 6 (as there were six visits)

  • Unique Count= 4 (as these visits were only from 4 different people)

Visit #

Client Name

Visit Date

1

Bob Jones

January 4

2

Mary Smith

January 4

3

Bob Jones

January 6

4

Amy Green

January 6

5

Linda Simpson

January 9

6

Bob Jones

January 10

...


Example 2- Unique and Duplicated Counts with Changing Demographic Information

...

Their second visit is on January 2. At the time of this visit, Client 1 is thirteen years old and Client 2 is fifteen years old.


Visits

Client

Age

January 1

Client 1

12

Client 2

15

January 2

Client 1

13

Client 2

15


A report is run from January 1 to January 3 and these are the only two visits recorded during the reporting period. The following would be the Unique and Duplicated counts for Age Group for the table above:






Unique

0-12         0

For the Unique count each individual is only counted once, regardless of the number of times they visited during the report period.

Client 1 was 13 at the time of their second visit, so they are only counted in the 13-15 grouping, because Unique counts take demographic data from the most recent visit.

13-15       2

Total        2


Duplicated

0-12         1

For the Duplicated count each individual is counted each time they visited.


Because each visit is counted, Client 1's first visit is included in the 0-12 grouping and their second visit is included in the 13-15 grouping. Both of Client 2's visits are included in the 13-15 grouping.

13-15       3

Total        4

Image Removed

...

Aggregated/Not Aggregated- Network Reports

Network reports are for organizations with multiple agencies (such as food banks). Please note: The use of the “Aggregate Across” features mentioned in this section are only relevant for networks and do not apply to single (standalone) agencies.

Aggregated/Not Aggregated One Row Per Organization/One Row Total Definition

You can further define how you want the data de-duplicated, by selecting or not selecting “Aggregate report data across the selected agencies” ("Aggregate Across" for short).Aggregated“One Row Per Organization” or “One Row Total”.

One Row Total: This displays all Unique report sections as one unique count by de-duplicating across the organizations selected. This option is selected by clicking “Aggregate report data across the selected agencies” “One row total” in the "For the followingOrganizations" section of the report setup. 

  • Aggregate Across OrganizationsOne Row Total by Organization by Name: This will produce a single network count for all organizations selected.

  • Aggregate Across County/City/Organization Tag: This will produce a single network count for the organizations that fall under all counties/cities/tags selected

    • This de-duplicates across all organizations within all counties/cities/tags selected.

Not Aggregated: One Row Per Organization: This displays all Unique report sections  as as a count for each agency  by de-duplicating within duplicating within each agency selected.

  • Not Aggregated Across OrganizationsOne Row Per Organization by Name: This will produce one row for each organization.

  • Not Aggregated Across One Row Per Organization by County/City/Organization Tag: This will produce one row for each county/city/tag selected.

    • This de-duplicates across the organizations within each individual city/county/tag selected.

NOTE: "Not AggregatedOne Row Per Organization" reports will not show a "total" row or graphs for the Unique report sections as they are not a true Unique total (the data is not de-duplicated across the agencies, so clients are counted at each agency they visit).

Client Name

Agency Visited

Visit Date

Bob Jones

Agency A

January 4

Mary Smith

Agency C

January 4

Bob Jones

Agency B

January 6

Amy Green

Agency B

January 6

Linda Simpson

Agency A

January 9

Bob Jones

Agency A

January 10


A report is run from January 1 to January 10 with "Aggregate Across" selected:


Unique Count

Explanation

Network 

4

We are only counting Bob Jones ONCE across all of the agencies he’s visited.

...


...

A report is run from January 1 to January 10 without "Aggregate Across" selected:

Organization

Unique Count

Explanation

Agency A

2

Bob Jones visited Agency A twice along with one other person (Linda Simpson) so the unique count for Agency A is 2.

Agency B

2

Bob Jones visited Agency B once along with one other person (Amy Green) so the unique count for Agency B is 2.

Agency C

1

Only Mary Smith visited Agency C, so the unique count for Agency C is one.

Total*

5

If you were to add up the unique counts in this example it would show the total as 5, because in this example Bob Jones is counted under both Agency A’s unique count and Agency B’s Unique Count.

*The total row here is to illustrate how this works. The actual reports in Link2Feed do not show a total for Unique counts when "Aggregate Across" is not selected.

...


Reports and Aggregate Options

The following reports contain the option to have "Aggregate AcrossOne Row Total" because they may need to be viewed as unique counts by agency OR one unique count across the network:

...

The following reports automatically "Aggregate Across calculate with "One Row Total" because they can only be presented as one unique count across the network:

...

The following reports do not "Aggregate Across have the option for "One Row Total" because they must be presented as unique counts by agency:

  • Monitoring Report

  • Pantry Report

  • School Pantry Report

  • Visits to Other Agencies Report

  • Social Services Outcomes Report (US Only)

The following reports do not "Aggregate Across have the option for "One Row Total" because they do not deal with standard "Visit" data.:

  • Generic Bulk Program Report (uses a mix of bulk data and known generic program data) 

  • Survey: Answer Frequencies Report (uses survey data)

  • Survey: Non-Response Report deals (uses survey data)

  • Assessment Reports (uses assessment data)

...

Regional reports are for organizations with multiple networks (such as a state/provincial or national organization). Please note: The use of the “Aggregate Across” “One Row Per Organization” and “One Row Total” features at the regional level are only relevant for organizations setup as regional and do not apply to networks or single (standalone) agencies.

At the regional level, users see all of their networks listed, with the option to expand the list and select specific agencies within each network.

In these reports, "Aggregate Across" “One Row Total” is de-duplicating across agencies within networks (not between different networks). The results from the aggregated de-duplicated count for a network run at the regional level will be the same as the aggregated count de-duplicated if it were run at the network level.

Regional reports can be selected to aggregate de-duplicate across a) particular organizations within a network or b) all organizations within a network. 

AggregatedOne Row Total: This displays all Unique report sections as one unique count per network by de-duplicating across the organizations selected for each network. This option is included by clicking “Aggregate report data across the selected agencies” One Row Per Organizationin the "For the followingOrganizations" section of the report setup. 

  • Aggregate Across OrganizationsOne Row Total by Name: This will produce a single network count labeled with the name of each network.

  • Aggregate Across One Row Total by County/City/Organization Tag: This will produce a single network count for each network that has agencies that fall under that county/city/tag.

    Image RemovedImage Added

Not Aggregated: This displays data as a count for each agency organization selected. For report sections that say (Unique) it will de-duplicate the count within each agency selected.

  • Not Aggregated Across OrganizationsOne Row Per Organization by Name: This will show one row for each organization selected.

  • Not Aggregated Across One Row Per Organization by County/City/Organization Tag: This will show one row for each county/city/tag and include non-aggregated data for all organizations with that county/city/tag. 

NOTE: "Not AggregatedOne Row Per Organization" reports will not show a "total" row or graphs for the Unique report sections as they are not a true Unique total (the data is not de-duplicated across the agencies, so clients are counted at each agency they visit).

...

Anonymous Visits will be included in reports by selecting "Include Anonymous Visits" in the "For the followingAdditional Options" section of the report setup. 

Anonymous with"Aggregate Across"One Row Total”: Anonymous visits will show as a final column labeled as "Anonymous". This will include anonymous visits recorded at any organization selected for the report.

Anonymous without "Aggregate Across with "One Row Per Organization": Anonymous visits from each agency will show as a final column labeled as "Anonymous".

...

 It will take the first food bank visit recorded on the Services page of the client's profile.

  • If no, then pulls from first food bank visit

  • If you'd like it to check the first food bank visit date on the Personal page, add another agency in your network. It doesn't have to have any programs attached to it, but when using it in your reports, the system will recognize it as the "Multi-Agency Network" below.

Multi-Agency Network

 It will check the first food bank visit date on the Personal page of the client's profile.

Comparing Report Sections Across Reports 

  • Statistics Report and Interactive Household Report

    • The Statistics and Interactive Household Report sections will match for Unique counts if the statistics report has"

  • Aggregate Across
    • One Row Total" selected, because the Interactive Report is set to automatically

  • "Aggregate Across
    • generate with the logic of "One Row Total".

    • There are NO duplicated or non-aggregated sections of the Interactive Household Report.

  • Statistics Report and Pantry Report

    • The Statistics and Pantry Report sections will match for Unique and Duplicate counts if the Statistics Report is set as "

  • Not Aggregated Across
    • One Row Per Agency", because the Pantry Report will report on information per pantry and does not

  • "Aggregate Across
    • allow for "One Row Total".

    • This will only match if the Statistics Report is run for pantry programs only.

  • Statistics Report and Time Series Report

    • The Statistics and Time Series Report sections will match for Unique and Duplicated counts if the Statistics Report has "

  • Aggregate Across
    • One Row Total" selected, because the Time Series Report is set to automatically

  • "Aggregate Across
    • generate with the logic of "One Row Total".

  • CSFP Case Load Report (US Only) 

    • The "Number of Individuals Served (Unique)" from the Statistics Report (with only “CSFP” selected under “For the following program types”) will match the "Served" section from the CSFP Case Load Report if the Statistics Report has "

  • Aggregate Across
    • One Row Total" selected, because the CSFP Case Load Report is set to

  • automatically "Aggregate Across
    • automatically generate with the logic of "One Row Total".

  • CSFP Ethnicity Report- Duplicated (US Only)

    • The "Number of Individuals Served (Duplicated)" from the Statistics Report (with only “CSFP” selected under “For the following program types”) will match the "Total" section from the CSFP Ethnicity Report (Duplicated) if the Statistics Report has "

  • Aggregate Across
    • One Row Total" selected, because the CSFP Ethnicity Report (Duplicated) is set to automatically

  • "Aggregate Across
    • generate with the logic of "One Row Total".

  • CSFP Ethnicity Report- Unique (US Only)

    • The "Number of Individuals Served (Unique)" from the Statistics Report (with only “CSFP” selected under “For the following program types”) will match the "Total" section from the CSFP Ethnicity Report (Unique) if the Statistics Report has "

  • Aggregate Across
    • One Row Total" selected, because the CSFP Ethnicity Report (Unique) is set to automatically

  • "Aggregate Across
    • generate with the logic of "One Row Total".

  • School Pantry Report

    • The Statistics and Pantry Report sections will match for Unique and Duplicate counts if the statistics report is set as "

  • Not Aggregated Across
    • One Row Per Agency", because the School Pantry Report

  • does not "Aggregate Across
    • automatically generate with the logic of "One Row Per Agency".

NOTE: If it appears two reports "don't match" be sure that they have been set with the same parameters (same date ranges, program types, etc.). 

...

  • When comparing counts with export data, keep in mind that:

    • The unique Unique count only counts clients once, so the total number of rows will not match the unique number of households or individuals served.

  • The unique count will use demographic data from the most recent visit and demographic variables may change during the time period selected.

  • Individuals may have lived in multiple households during the reporting period.

...