Follow the steps below to compile consumption data on a custom list of up to 500 musical entities.

Need more help? Check our Report Builder FAQs.

Back to Report Builder 

Back to User Guide  

---

Build a Trend Report 

From the CONNECT sidebar menu, select Report Builder > Trend to open the Report Builder.

Some fields will appear blank; others will be pre-filled with default options.

Blank Report Builder: Trend

1. ---

   Name your report

Enter a title for your report on the Report Name line. If you’ve created reports before, you may see a pop-up of previous report titles to start with or adapt. 

Title your report something descriptive, like “Taylor Swift Song Sales Last Week - US National.” An ideal report title is short and to the point, but detailed enough to differentiate from your other reports (Report Builder > Management). 

2. ---

   Set time frame and location

Below the title line, you can customize Time Frame, Location and Markets (if applicable). Use these fields or the top menu bar to make selections.

Market selection menu

Within the U.S. and Canada, select National (default, nationwide view) or United States/Canada Market. Choosing the Market option enables selection from the list of top markets.

Checking Select All will give a market aggregate, but excludes some data from national providers (i.e. data that is reported nationwide but not at the market level). 

A Trend Report can break out market-level data for up to 5 markets at a time.

Market breakouts: Select up to 5 at once

You may select as many U.S. or Canada markets as you like, but a Trend Report export can only break out 5 or fewer markets at a time. 

Adding more than 5 markets will sum your selected markets into a combined figure in your export grid. 

 

​

3. ---

   Include Activities 

To the right of Markets, click the Include Activities field to choose activities and breakouts. Your selections will add columns to your Trend Report. This field is mandatory. You must set at least one activity.

Activity selection menu

Hit Click to add to open the Activity Options menu.

Check or uncheck the boxes for Streams, Song Sales, Product Sales and Airplay to include or exclude those activities. Click > to set breakout views (if desired).

Additional Criteria

Click ADD + to open the full Data Controls menu.

Scroll to Release Type and Format to filter by product format and category.

You can also filter by Compilation Type(s) to include or exclude compilations (applies to Release Groups). 

You can also use this menu to adjust any of your existing selections. Be sure to APPLY CHANGES when you’re done. 

            Go to: Data Controls: All Activity Types, breakouts and filters

4. ---

   Add items
   

Once you’re satisfied with your date, location and activity parameters, click ADD ITEMS to start compiling a list of entities for your Trend Report. Use the search bar to find artists, songs or releases by name. Start typing and suggested results will appear. Check the box next to any result you want to include in your report. 

Filter your search by entity type by selecting Artist, Release Group or Song from the fields below the search bar.

Scroll to see all results

Search results initially display up to 60 items. Scroll to the end of the list to populate more entities. Keep scrolling to load more results for your query, ordered by popularity/consumption totals.  

Select up to 500

Check the box next to the Name field to include all results. A Trend Report can include up to 500 entities. If your search returns more than 500 results, the Select All option will only check the first 500 on the list. 

5. ---

   Finalize selection 

To the right of the RESULTS tab, the SELECTED tab displays a count of items you’ve chosen to include so far. Click this tab to view and edit your selections.

Edit Trend Report selections

Use the trash can icon at left to remove an item from the list.

Click SAVE SELECTION at bottom right to return to the main Report Builder page, which now displays your selected list and all your report parameters. 

From here, you can search within your selections, check or uncheck items and delete entries if needed. If you’re still under 500 total, click ADD ITEMS again to reopen the search pop-up. 

​

 

​

6. ---

   Format your report 

When you’re ready, click CONTINUE at bottom right. The Report Format Options pop-up allows you to format your report based on time view and breakout options.

Use the Time View dropdown to select view options for your selected date range. If desired, check the ATD and YTD boxes to include those aggregates. Choose Total or Breakout for the other categories to see either combined or segmented data. 

Time View options

Depending on your selected timespan, the menu offers a choice between Daily/Weekly, Weekly/Quarterly or Quarterly/Yearly.

1-60 days / 1-8 weeks	Daily (default) or Weekly
60-112 days / 9-17 weeks	Weekly only
18-68 weeks / 1-2 years	Weekly (default) or Quarterly
69-105 weeks / 1-2 years	Weekly, Quarterly (default) or Yearly
106+ weeks / 2+ years	Quarterly (default) or Yearly

ATD/YTD numbers in Trend exports

ATD and YTD totals for some items in Trend Report exports may appear lower than ATD/YTD figures on Dashboards. 

This is because Trend Reports exclude items, breakouts and days/weeks with no activity. If there's no consumption for an entity or breakout within your time frame, the associated row(s) won't appear in your export. This can omit ATD/YTD values for those breakouts and lower ATD/YTD totals for some items in your export.

In the future, Trend Report exports will include complete ATD/YTD data for all items. For now, use Dashboards to verify total ATD/YTD values for items in your report. 

​

 

7. ---

   Submit your report 
   

When you’re ready, click BUILD REPORT at bottom right. From here, you can build another report using the same parameters as a starting point, build a new report from scratch or see your in-progress report on the Management page. 

When your report is complete, you’ll also be able to see details, export it or create a schedule using the Management tool. 

---

More to know

Build a Ranking Report

User Guide FAQs: Help with CONNECT features, tools and settings

How to CONNECT: All tutorials, walkthroughs and video demos

Read next: Client Support: Find answers and get the help you need