ÃÛ¶¹ÊÓƵ

Export information for accounts with high sharing score export-account-info-high-score

Account IQ allows you to export account sharing details for top 1000 subscriber accounts based on their sharing probabilities. You can export the account sharing information for the current segment and specified time interval on the Shared Accounts Reports page.

Follow the steps to export the account sharing information of subscriber accounts for a specific segment.

  1. Log in with your credentials.

  2. Navigate to the Shared Accounts tab under Reports section.

  3. Select the required segment and time interval from segment and time interval panel. Learn how to select a segment and time interval.

    If required, refer to the instructions for creating a segment or editing a segment.

  4. Select Export top 1000 accounts located in the upper-right corner of the segment and time interval panel.

    Export top 1000 accounts

    Select Export top 1000 accounts option

The file will automatically download to your local machine as a .csv.

This file contains the data for top 1000 accounts based on the sharing probabilities of the subscriber accounts in the current segment in a decreasing order.

The following is an example of the exported .csv file.

exported data in .csv file

Exported data in .csv file

Columns in the exported report columns-in-export

Week/Month

The selected week or month within the Granularity and Time Interval option in the segment selector.

MVPD

If you are a programmer, the column shows the distributor with whom the account is subscribed.

NOTE
The MVPD column is only available for TV Everywhere versions.

Subscriber ID

The unique identifier for the specific account.

Minimum # Devices

The minimum number of devices from which users are actively streaming content.

NOTE
The actual number of devices streaming content is greater than the minimum number of devices specified for a particular account.

Minimum # Persons

The minimum number of individuals actively streamed content using those devices.

NOTE
The actual number of individuals streaming content is greater than the minimum number of persons assigned to a particular account.

# IPs

The number of IP addresses from which content is streamed.

# Locations

The number of locations (based on zip code) from which content is streamed.

# Cities

The number of cities where the streaming activity has taken place.

# States

The number of states where the streaming activity has taken place.

# Clusters

The number of distinct clusters where streaming has taken place.

Geographic span (miles)

The maximum distance between the streaming locations associated with the account.

# AuthN OK

The number of logins users make during the specified period using that account.

NOTE
Some D2C services may not see # AuthN OK data as it might not be included in their company’s data.

# AuthZ OK

The number of times an MVPD has authorized a stream or granted access to content for that account.

NOTE
# AuthZ OK is not available for D2C services.
NOTE
For TV Everywhere, # AuthZ OK is correlated with the number of # Play Requests. It will always be less than # Play Requests because ÃÛ¶¹ÊÓƵ typically caches the authorizations from MVPDs for approximately 24 hours.

# Play Requests

The actual number of streams occurred during a specified time period.

NOTE
The # Play Requests column isn’t available in TV Everywhere MVPD version.

# Channels

The overall number of channels that the account has watched over a specified period.

NOTE
For D2C services # Channels is equivalent to number of # Video categories.
NOTE
For TV Everywhere, they include the channels that may not belong to the logged-in programmer. This number for the account includes your channel and other channels accessed during the specified period.

Usage Pattern

The values within these columns serve as identifiers corresponding to one of the 14 patterns we use to categorize all user accounts.

ID
Usage Patterns
1
Regular user
2
Traveler or commuter
3
Large family
4
Close family and friends
5 and 8
Social group sharing
6
Large group of friends
7
Concurrent streaming
9
Community sharing
10 and 11
Uncertain behavior
12
Small family
13
Second home
14
Abnormal usage

Usage pattern identifiers in exported .csv mapping with usage patterns

Sharing Probability

The likelihood that a specific account is sharing its credentials.

NOTE
The average of the sharing probability of all the accounts in the selected segment is used to compute the sharing level of the average sharing score.
recommendation-more-help
c7f53f4e-296f-4575-aec1-be021e87e81f