> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bigdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Company news coverage

If you want to analyse upfront how much news coverage your universe of companies receives under your current data packages, reviewing the volume of documents available over the last **month**, **6 months**, and **12 months** helps you decide whether those packages are the right fit for your portfolio, and informs how you design queries in the Search Service to extract the most relevant insights.

You can review your current data packages, and explore others that you can unlock, in the [Bigdata Store](https://platform.bigdata.com/store).

The script below leverages the [Volume endpoint](/api-reference/search/search-volume), which returns the unique number of documents and unique number of chunks matching a query over a given period. It sets an Entity filter and issues one call per company for the defined window.

## Coverage analysis

<Steps>
  <Step title="Resolve companies">
    The script takes as input the file of RavenPack IDs produced by the [Resolve companies](/api-rest/best-practices/resolve_companies) script, so make sure you have resolved your universe before running it.
  </Step>

  <Step title="Run the script">
    Clone the public repository and follow the instructions in its `README.md` to run the script.

    <Card title="How-to scripts: company news coverage" icon="github" href="https://github.com/Bigdata-com/bigdata-docs-resources/tree/main/how_to_guides/api_company_volume_coverage">
      Ready-to-run scripts that measure news coverage across your universe of companies over the last month, 6 months, and 12 months.
    </Card>
  </Step>

  <Step title="Import as Excel">
    The output file is in CSV format, and you can import it into an Excel by opening a new document, clicking on Data, and selecting "From Text/CSV".

    <img src="https://mintcdn.com/ravenpackinternational/9t4nxMLz4HFDcoQF/images/api-rest/best-practices/how-to-import-csv-in-excel.png?fit=max&auto=format&n=9t4nxMLz4HFDcoQF&q=85&s=822bb31a42552a95cadd9e01e432802f" alt="How to import CSV in Excel" style={{ width: "500px" }} width="740" height="266" data-path="images/api-rest/best-practices/how-to-import-csv-in-excel.png" />

    This is an example that only shows the columns of distinct documents in the last month, 6 months and 12 months.

    <img src="https://mintcdn.com/ravenpackinternational/9t4nxMLz4HFDcoQF/images/api-rest/best-practices/company_news_coverage.png?fit=max&auto=format&n=9t4nxMLz4HFDcoQF&q=85&s=ddfaced937af61d4803f7908d8fa6599" alt="Company news coverage example" style={{ width: "900px" }} width="1193" height="264" data-path="images/api-rest/best-practices/company_news_coverage.png" />
  </Step>
</Steps>