Introduction

Sisense provides a connector to easily access data from both Google Analytics and AdWords. By default certain tables and fields are imported from these sources. A detailed description of these standard tables and fields can be found below.
In addition, you can add customized tables and additional fields. For more details, read the section below on customization.

Standard Tables from Google Analytics

Below is a list of ready-made reports you can easily access using the Sisense Google Analytics provider.
  • Goals, Daily Report: Site,date,source,medium,goalCompletionsAll,goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value, goal2Value, goal3Value, goal4Value
  • Goals, Monthly Report: Site, year, month, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals, Weekly Report: Site, year, week, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Keyword, Daily Report: Site, date, campaign, keyword, hostname, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Keyword, Daily Report: Site, year, month, campaign, keyword, hostname, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Keyword, Daily Report: Site, year, month, campaign, keyword, hostname, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Keyword, Weekly Report: Site, year, week, campaign, keyword, hostname, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Geography, Daily Report: Site, date, continent, subcontinent, region, country, city, campaign, keyword, hostname, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Geography, Monthly Report: Site, date, continent, subcontinent, region, country, city, campaign, keyword, hostname, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Geography, Weekly Report: Site, date, continent, subcontinent, region, country, city, campaign, keyword, hostname, source, medium, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value
  • Goals By Content, Daily Report: Site, date, pagePath, pageTitle, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value, goal2Value, goal3Value, goal4Value
  • Goals By Content, Monthly Report: Site, year, month, pagePath, pageTitle, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value, goal2Value, goal3Value, goal4Value
  • Goals By Content, Weekly Report: Site, year, week, pagePath, pageTitle, goalCompletionsAll, goal1Completions, goal2Completions, goal3Completions, goal4Completions, goalValueAll, goal1Value, goal2Value, goal3Value, goal4Value
  • Traffic, Daily Report: Site, date, bounces, entrances, exits, newVisits, pageviews, timeOnPage, timeOnSite, visitors, visits
  • Traffic, Monthly Report: Site, year, month, bounces, entrances, exits, newVisits, pageviews, timeOnPage, timeOnSite, visitors, visits
  • Traffic, Weekly Report: Site, year, week, bounces, entrances, exits, newVisits, pageviews, timeOnPage, timeOnSite, visitors, visits
  • Traffic By Geography, Daily Report: Site, date, continent, subcontinent, region, country, city, bounces, entrances, exits, newVisits, pageviews, timeOnPage, timeOnSite, visits
  • Traffic By Geography, Monthly Report: Site, year, month, continent, subcontinent, region, country, city, bounces, entrances, exits, newVisits, pageviews, timeOnPage, timeOnSite, visits
  • Traffic By Geography, Weekly Report: Site, year, week, continent, subcontinent, region, country, city, bounces, entrances, exits, newVisits, pageviews, timeOnPage, timeOnSite, visits
  • Traffic By Keyword, Daily Report: Site, year, date, pagePath, pageTitle, source, medium, bounces, entrances, exits, newVisits, pageviews, timeOnPage, visits
  • Traffic By Keyword, Monthly Report: Site, year, month, pagePath, pageTitle, source, medium, bounces, entrances, exits, newVisits, pageviews, timeOnPage, visits
  • Traffic By Keyword, Weekly Report: Site, year, week, pagePath, pageTitle, source, medium, bounces, entrances, exits, newVisits, pageviews, timeOnPage, visits
  • Traffic By Content, Daily Report: Site, date, pagePath, pageTitle , source , medium, bounces , entrances, exits , newVisits , pageviews, timeOnPage, visits
  • Traffic By Content, Monthly Report: Site, year, month, pagePath, pageTitle , source , medium, bounces , entrances, exits , newVisits , pageviews, timeOnPage, visits
  • Traffic By Content, Weekly Report: Site, year, week, pagePath, pageTitle , source , medium, bounces , entrances, exits , newVisits , pageviews, timeOnPage, visits
  • Traffic By Navigation, Daily Report: Site, date, pagePath, landingPagePath, exitPagePath, secondPagePath , medium, uniquePageviews, bounces, entrances, exits, newVisits, pageviews, timeOnPage
  • Traffic By Navigation, Monthly Report: Site, year, Month, pagePath, landingPagePath, exitPagePath, secondPagePath , medium, uniquePageviews, bounces, entrances, exits, newVisits, pageviews, timeOnPage
  • Traffic By Content, Navigation Report: Site, year, week, pagePath, landingPagePath, exitPagePath, secondPagePath, medium, uniquePageviews, bounces, entrances, exits, newVisits, pageviews, timeOnPage

 Standard Tables from Google AdWords

Below is a list of ready-made reports you can easily access using the Sisense Google AdWords provider.
  • Goals, Daily Report: ClientEmail, Date, CampaignName, CampaignId, CampaignStatus, AdGroupName, AdGroupId, AdGroupStatus, KeywordText, AveragePosition, Clicks, Cost, Impressions, Conversions
  • Placement/Keyword, Daily Report: ClientEmail, Month, CampaignName, CampaignId, CampaignStatus, AdGroupName, AdGroupId, AdGroupStatus, KeywordText, AveragePosition, Clicks, Cost, Impressions, Conversions
  • Ad Performance, Daily Report: ClientEmail, Date, CreativeId, CampaignName, CampaignId, AdGroupName, AdGroupId, AdGroupStatus, KeywordText, VisibleUrl, QualityScore, AveragePosition, TopPosition, BottomPosition, Clicks, Cost, Impressions, Conversions
  • Ad Performance, Monthly Report: ClientEmail, Month, CreativeId, CampaignName, CampaignId, AdGroupName, AdGroupId, AdGroupStatus, KeywordText, VisibleUrl, QualityScore, AveragePosition, TopPosition, BottomPosition, Clicks, Cost, Impressions, Conversions
  • Geographic Report: ClientEmail, Month, CreativeId, CampaignName, CampaignId, AdGroupName, AdGroupId, AdGroupStatus, Country, City, Region, Region, Metro, Clicks, Cost, Impressions, Conversions
  • Search Queries, Daily Report: ClientEmail, Date, Query , MatchType, AveragePosition, Clicks, Cost, Impressions, Conversions
  • Search Queries, Monthly Report: ClientEmail, Date, Query , MatchType, AveragePosition, Clicks, Cost, Impressions, Conversions

Customizing the Tables and Data from Google Analytics and AdWords

You can customize both the tables and the fields that you imported from Google Analytics and AdWords.
Follow the steps below.
1 – Find the appropriate dimension from the Google API: Google Analytics API / Google AdWords API
2 – Once you locate and understand the fields that need to be added,  open the GAnalytics.Fieldsand GAnalytics.Tables xml files for Google Analytics, or the AdWords.Fields and AdWords.Tablesxml files for Google AdWords. These files can usually be found in the following location:
  • %AppData% \Sisense\Prism\LocalRepository2.0\Resources\Google\Analytics
  • %AppData% \Sisense\Prism\LocalRepository2.0\Resources\Google\AdWords
3 – If you want to customize an existing field, or create a new field, open the “GAnalytics.Tables.xml” file or “AdWords.Tables.xml” file, and add a new table element that includes the new field.In the example below you first add the page load element (ga:pageLoadTime) from the Analytics API into the GAnalytics.Fields xml file.
<!-- M1. Speed -->
  <field id="ga:pageLoadTime" name="pageLoadTime" response_value="ga:pageLoadTime" type="System.Int32" size="" category="M1. Speed" class="measure"></field><i;i++)>
Once added the page load field can be included in a new table in the GAnalytics.Tables.xml by simply adding the new page load dimension along with other existing / new dimensions to  a new table
<field id=”ga:pageLoadTime”></field>
<table name="Page Load Sample Table" accumulate_by="ga:date">
    <fields>
      <field id="Site"></field>
      <field id="ga:pageLoadTime"></field>
      <field id="ga:date"></field>
      <field id="ga:bounces"></field>
      <field id="ga:entrances"></field>
      <field id="ga:exits"></field>
      <field id="ga:newVisits"></field>
      <field id="ga:pageviews"></field>
      <field id="ga:timeOnPage"></field>
      <field id="ga:timeOnSite"></field>
      <field id="ga:visitors"></field>
      <field id="ga:visits"></field>
    </fields>
  </table><i;i++)>
Once you save these changes and connect to Google Analytics, you will see the pageLoadTime in the ‘Page Load Sample Table’.
Note: At least one new table must be added to the Tables.xml file before field changes are made to any standard tables.