Feeds

The data feeds provide access to a number of online data sources. You can download data from these feeds directly into Omniscope.

Google Spreadsheets

Google Docs is a free, online, document storage service provided by Google. Users can create and edit documents and collaberate in real time with other users.

The Google Spreadsheets feed allows you to import either a spreadsheet from the Google Docs repository. You must have an internet connection to use this service.

Options

The Login section allows you to specify your authentication information for retrieving the spreadsheet. You can choose to retrieve a spreadsheet from a private account or a public account. A private account requires an Email address and a password. A public account merely requires you to enter the spreadsheet link or key. Public spreadsheets are available to all users.

Once you have entered the login details click the Login button. If the login was successfuly the spreadsheets and worksheets available in the selected account will be downloaded.

The Worksheet section allows you to select the spreadsheet and worksheet that you want to download. These options will only be available after successfully logging into a private or public account.

The table data section allows you to select how the selected worksheet should be imported into Omniscope. These options are the same as the options available when importing an Excel spreadsheet.

Email

The Email feed alllows you to import email data from a POP3 or IMAP email account.

Options

Server information

Mail server. The mail server drop-down allows you to select the email server that you want to download data from. This drop-down contains the configuration details for some common online mail servers including Google, Yahoo and AOL. When you select one of these servers the account type, incoming mail server URL, incoming mail server port and SSL encryption options are pre-populated. If your mail server does not appear in this list then you should select the Custom option. This allows you to enter these values manually. You can usually find out the connection details for your mail server by speaking to your system administrator.
Account type. The account type drop-down allows you to select the type of mail server. POP and IMAP are the two most common internet standard protocols for email retrieval.
Incoming server URL. Enter the URL of the internet mail server.
Incoming mail server port.
Use SSL encrpyion. Select this option if the mail server uses Secure Sockets Layer (SSL) encrption.

Login details

Email address. Enter the email address or username that you use to login to the mail server.
Password. Enter the password that you use to login to the mail server.

Download

Max messages. Enter the maximum number of messages that you want to download. The most recent messages will be downloaded first.
Download content. Select this option if you want to download the contents of each message. The message contents includes the message and the attachment information.
Download attachments. Select this option if you want to download the attachments associated with each message. If you select this option you must also select a local directory to download the attachments to.
Attachments folder. Allows you to specify the folder that you want to download attachments to.
Overwrite existing files. Select this option if you want to overwrite attachments if the file already exists in the selected attachment folder. If you leave this option unchecked each attachment will be given a unique name.

Website map

A website map is a network of interconnecting pages within a specified website. A connection between two pages exists if the first page contains a link to the second page. You can use a website map to visualise the structure of a website.

A website map can prove useful in many different scenarios:

You can use the website map functionality to get a quick understanding of your site structure. For example, you can quickly determine which pages haven't been modified in the last few months or determine the number of 'clicks' a user has to use to reach a particular page.
You can download and save a website map and use it as an 'Offline browser'for a particular website; allowing you to view the content for eachpage even when you're not connected to the internet.
By selecting the 'Include Google Analytics data' option you can import Google Analytics information for each page inside the website map. This can be used to provide additional data such as the number of clicks on each page and the bounce rate.
Omniscope automatically extracts the top keywords in each page. You can use this to get an understanding of the themes in a particular page without having to read the content or you can filter the data by a particular set of keywords, allowing you to retrieve pages of interest.

Options

Map configuration

URL(s). Enter one or more URL's to use as a starting point for the website map.
Link depth (same host). This determines the maximum depth ofthe website map, i.e. the maximum number of pages out from a starting URL. Generating a website map for a very large site can take a longtime. You can use this setting in combination with the 'Max pages' setting to reduce the number of pages processed and speed up the overall map generation time.
Max pages.
Include external pages. Most web sites include links to pages on other sites. If selected, this option includes pages from other sites referenced by links.
Enforce tree structure. If selected, Omniscope will ensure the resultant map reflects a proper tree structure. If selected, and during the map generation process Omniscope encounters a page that has already been processed, it is not added to the list of links. The diagram below shows the difference between anenforced and a non-enforced website map.
Exclusions.

Page aliases

Use alias file list.
Alias URL list file path.

Google analytics

Import Google Analytics data. If selected Omniscope will attempt to retrieve Google Analytics information for any of the pages encountered that belong to one of the sites associated with a Google Analytics account to which you have access. If you select this option then youwill have to enter a Google Analytics username and password.

Custom feed

Web feeds, such as RSS and Atom, are used to provide users with news and other content over the internet.

The Custom feed allows you to import data from an RSS feed.

Options

Feed URL. Enter the URL of the web feed you want to import.

Facebook

Facebook is a social networking service launched in 2004. As of January 2011 Facebook had more than 600 million active users.

The Omniscope Facebook feed allows you to download Facebook user, group, event, page, wall post and insight data associated with your Facebook account.

Options

Click on the "Connect" button to allow Omniscope to establish your Facebook connection details. The connection is established through your web browser. If you are already logged into Facebook then your current connection is used. In order to connect to a different account you must log out through your browser before clicking the "Connect" button.

After connecting to Facebook you need to select what data you want to download in the "Report" dropdown. Omniscope currently provides six different reports: Users, Groups, Events, Pages, Wall posts, Insights. Each of these report types is outlined below.

Users report

The "Users" report allows you to download the details of all of the users associated with your account. At the moment this includes data on the logged in user and the friends associated with that user.

Each row of data represents a single Facebook user. For each user, Omniscope provides information including the user's name, activities, interests, music TV and profile photographs.

Groups report

The "Groups" report allows you to retrieve the details of all of the Facebook groups associated with your account.

Each row of the data represents a single Facebook group. Omniscope provides information including the group name, type, website and recent news.

Events report

The "Events" report allows you to retrieve the details of all the Facebook events associated with your account.

Each row of the data represents a single Facebook event. Omniscope provides information including the event name, type, start and end time.

Pages /applications report

The "Pages/applications" report allows you to download the details of all the Facebook pages and Facebook applications associated with your account.

Each row of the data represents a Facebook page or a Facebook application. Omniscope provides data including the fan count, website and company information.

Wall posts report

The "Wall posts" report allows you to download the wall posts for selected users, groups, events and pages. If you select more than one entity the wall posts will be appended into a single table. You can determine the entity name and type (user, group event or page) by referring to the "Entity name" and "Entity type" columns.

Each row of the data represents a single wall posting. Omniscope provides data such as the posting user, number of impressions, like count, comment count and message. The "

Select the "Download comments" checkbox if you want to download the comments (where available) for the postings.

Insights

Facebook insights provide Facebook page owners and application developers access to metrics about their content. You can use this data to analyse growth, demographics, consumption and creation of content.

The "Insights" report allows you to download Facebook insights data.

Pages/applications. Select the page or application that you want to download insights data for.
Metrics. Select the metrics that you want to download. Metrics are downloaded into 11 categories.
Date period. Select the breakdown of your data. If you select the "Day" date period your data will be split by day, with each row representing data for a specific date. If you select the "Month" date period your data will be split by month.
Date range. Select the start and end date you want to download insights for. This should be used in combination with the "Date period" option.
Report structure. Select the "Pivot data" option to show the data for each metric in a separate column. Select the "Raw data" option to download the information in it's raw format.

SalesForce

Salesforce [1] is an application that runs in the Force.com [2] online cloud-computing hosted platform, one of the largest and fastest-growing general-purpose SaaS platforms. Salesforce is widely used for CRM (Customer Relationship Management, composed of the 'Sales Cloud' and service/case management, aso know as the 'Service Cloud'). Almost any application can be written on the Force.com platform. If you have a Salesforce account, it is possible to access your Reports and Data Objects/Tables stored in Salesforce using either the Omniscope direct connector (File > Open online source > Salesforce) or the free web connector [3] your Administrator can install into your Salesforce account from the online AppExchange [4].

Salesforce web connector: the free Omniscope Connector for Salesforce [3] web service can be installed in your Salesforce account(s) from the AppExchange listing page [3] by your Administrator, unless you have a Group Edition. Instructions for installing in Group Editions are here. The web connector installation will add a new tab from which you can download reports and un-joined data objects using pre-configured templates to deliver files that will open in the free Viewer. An activated version of Omniscope is required to modify and save customised templates, which can then be uploaded to your account, adding new download and viewing options for different classes of users within your organisation. More on using the online Web Connector for Salesforce [5].

Salesforce direct connector: Omniscope Professional and Enterprise 2.5 (and later) enable to access your Salesforce reports and data objects directly. More on using the Direct Connector for Salesforce [6]to access, modify, edit and synchronise changes with your Salesforce-hosted data.

More detail and a solutions roadmap for making the most of the combination of Salesforce and Omniscope is here [7].

Google Analytics

Google Analytics is a web analytics toolkit that allows users to access insights into website traffic and marketing effectiveness. For more information please visit the Google Analytics website [8].

The Omniscope Google Analytics feed allows you to download Google Analytics data.

Options

Authentication

Enter your Google Analytics username and password. This is the same username/password that you use to login to your online Google Analytics account. Once you have entered this data click the "Connect" button to connect to the Google Analytics server.

Report configuration

The "Report configuration" section allows you to select and configure the analytics data that you want to download.

Account. Select the account you want to access.
Profile. The profile you want to use. Normally a website profile corresponds to a domain and you will have one profile per domain.
Report. Select the report you want to download. Omniscope provides nine pre-defined reports. Each report is defined by a set of dimensions and metrics. which are shown below the report drop-down. If you want to define your own dimensions and metrics select the "Custom" report option.
Dimensions. Dimensions are used to determine the rows of the data in your Google Analytics report. They can be thought of as the data categories. The more dimensions you select, the more rows of data are likely to be produced. If you select a pre-defined report the Dimensions for that report are shown. If you select the "Custom" report option you can choose which dimensions you want to use. You must select at least one dimension. An example of a dimension is "Browser". Selecting this dimension on its own will produce a report containing a row for each web Browser.
Metric. A metric is a value for a combination of dimensions. Unlike the dimension selection, the metric selection doesn't effect the number of rows in the data. An example of a metric is "Visitor count". If you select the "Browser" dimension and the "Visitor count" metric the resultant report will provide you with a breakdown of the total visitor count to your website by Browser name.
Date range. Select the date range of the data you want to download.
Max records. It is very easy when selecting a series of dimensions to request a report that contains thousands of records. This can take a very long time to execute. The "Max records" option allows you to specify the maximum number of rows a report can produce before the execution is aborted. If you don't want to specify a maximum number of records leave this option blank.

Microsoft Atlas

Microsoft Atlas for advertisers and agencies allows users to manage digital marteting campaigns accross display banners, rich media, search, video and websites. For more information please visit the Atlas website [9].

The Omniscope Atlas connector allows you to download Atlas advertiser data.

Options

Connection

Enter your username, password and developers token and click the "Connect" button. If you don't have a developers token you need to contact your Microsoft Atlas representative.

After connecting to the Atlas server you can configure the Atlas data you want to download. The configuration options are designed to mimic the options available in the online Atlas interface.

DoubleClick

DoubleClick for Advertisers (DFA) is an ad management and ad serving toolkit that manages digital advertising programs. For more information about DoubleClick please visit their website [10].

The Omniscope DoubleClick feed allows you to download advertisment data from the DoubleClick server.

Options

The DoubleClick interface has been designed to mirror the options provided in DoubleClick ReportCentral.

Connection

The connection section lets you specify the username and password to connect to the DoubleClick server.

Unfortunately the username/password that you use to login to the DoubleClick website will not work. Instead you need to create a new username and password to allow you to access the DoubleClick API. If you can't do this yourself you need to speak to your Google/DoubleClick TAM (Technical Account Manager). This policy has been enforced by Google.

After entering your authentication details click on the "Connect" button to login to the DoubleClick server.

Query

After successfully connecting to the DoubleClick server you need to specify and configure the DoubleClick report you want to download. You can select the type of report in the "Query" dropdown. Omniscope currently provides 11 different reports. All of these reports are available in ReportCentral.

Single Advertiser. Provides information about one advertiser at a time. Once you choose an advertiser, you can then see a wide range of customisable data about that advertisers campaigns and ads.
Network. Provides detailed data on a DFA account (network), aggregating information across all of the account's advertisers and campaigns. Network reports are especially useful if you want to compare performance data across multiple advertisers and campaigns.
Geography. Used to provide information about ads that use geographic targeting. You can see data about countries, telephone area codes, and states and regions to which your geo-targeted ads were delivered. Ads that are targeted to other geographical entities, such as ZIP codes, are also included in the report, but information about those geographic criteria is not. Ads that are not geo-targeted are not included in the report.
Placement tag status. These hourly reports let you know whether DART ad tags that have been Placed on the web are receiving impressions and clicks. They're especially useful at the beginning of a new campaign, or after you've made changes. You can also compare performance over the last 24 hours with performance over the last 30 days, which can help you to detect unexpected behavior such as a sudden drop in impressions or an unexpected change in the type of DART ad tags that's generating your clicks and impressions.
Planned media. Planned Media reports are designed to serve two purposes: To show you information about future bookings and to compare past bookings with actual performance. Planned Media reports show data for the past 16 months.
Custom spotlight variables. If you've set up custom spotlight variables, you can use custom spotlight variables reports to show data about them. Custom spotlight variables reports show data for the past 16 months.
Placement frequency. Shows, for each placement, how many impressions were delivered at each frequency, as well as how many of these impressions resulted in clicks. Frequency is the number of times a user saw an ad on a given placement.
Search. Provides information about your DoubleClick Search campaigns.
Advertiser reach by month. Shows the number of unique users who have seen each advertiser's ads each month. You can use these reports to compare the reach of multiple advertisers, getting a sense of how many customers are seeing each advertiser's campaigns.
Campaign reach. Shows the number of unique users who have seen each campaign. You can use these reports to compare the reach of multiple campaigns.
Site reach summary by month. Shows, for a given campaign, the number of unique users per month for each targetted site. You can use these reports to compare the reach of a campaign across multiple sites.

After selecting a query the relevent options for that query are displayed. These options are split into four sections: "Scope", "Filter criteria", "Main criteria" and "Spotlight information". The structure of these options should be near identical to the equivalent options in the ReportCentral interface.

Brandwatch

Brandwatch offers a range of tools and services to monitor social media data. For more information please see the Brandwatch website [11].

The Omniscope Brandwatch feed allows you to download data from the Brandwatch server into Omniscope. In order to use the feed you must have an active Brandwatch account.

Options

Username/Password. Enter the authentication information for your Brandwatch account. This is the same username/password that you use to login to the online tool. Once you have entered this information click the Connect button to connect to the Brandwatch server.
Brand selection. Select which brand(s) you want to retrieve data for. You can only select these brands after connecting to the Brandwatch server. Brands are organised alphabetically. Click on the Show industries checkbox to show organise the top level industries. Click on the Show unsubscribed checkbox to show all the brands that brandwatch collects data for, including the brands you are not currently subscribed to.
Report. Allows you to choose what data you want to retrieve. Omniscope currently provides five different reports to choose from. The Mentions report allows you to search for mentions of one or more brands. The Daily mention report provides a daily count and breakdown of mentions by site type, credibility and sentiment. The Top 20 domains report shows the top 20 sites that are discussing the selected brands, ranked by the number of mentions. The Trends report shows how topics have behaved over time. The Industry overview report provides a breakdown for all brands accross the associated industry.
Date range. Allows you to select the date range of the report.
Site credibility. Allows you to retrieve data from sites deemed to be of a particular credibility.
Site type. Allows you to retrieve data from a certain type of website, for example news or forum.
Sentiment. Allows you to retrieve data based on the sentiment of the content, for example positive or negative.
Language. Only applicable when the brands you have selected contain more than one languages. Allows you to only show results in a specific subset of languages. By default all languages are selected.
Country. Allows you to filter the brand pages by geographical locations.