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.

  • Ad Group Performance Report: AccountDescriptiveName, Date, Campaign, Campaign Id, Ad Group, Ad Group Id, AD Group Status, Avg Position, Clicks, Avg CPC, Cost, Cost/Conv. (1-per-click), Ad Distribution, Impressions, Conversions, (1-per-click), Device, ClickType
  • Ad Group (Report) Daily Report: AccountDescriptiveName, Date, Campaign, Campaign Id, Ad Group, Ad Group Id, AD Group Status, Avg Position, Clicks, Avg CPC, Cost, Cost/Conv. (1-per-click), Ad Distribution, Impressions, Conversions, (1-per-click), Device, ClickType
  • Ad Group (Report) Monthly Report: AccountDescriptiveName, Month, Campaign, Campaign Id, Campaign Status, Ad Group, Ad Group Id, AD Group Status, Avg Position, Clicks, Avg CPC, CTR, Avg CPM, Cost, Cost/Conv. (1-per-click), Ad Distribution, Impressions, Conversions, (1-per-click), Device, ClickType
  • Search Query Performance, Daily Report: AccountDescriptiveName, Date, Search Query, Search Query Match Type, Avg Position, Clicks, Cost, Impressions, Conversions (1-per-click)
  • Search Query Performance, Monthly Report: AccountDescriptiveName, Month, Search Query, Search Query Match Type, Avg Position, Clicks, Cost, Impressions, Conversions (1-per-click)
  • Keyword, Daily Report: AccountDescriptiveName, Date , Campaign, Campaign Id, Campaign Status, Ad Group, Ad Group Id, Ad Group Status, Keyword, Avg Position, Clicks, Cost, Impressions, Conversions (1-per-click), Est. First Page Bid
  • Keyword, Monthly Report: AccountDescriptiveName, Month , Campaign, Campaign Id, Campaign Status, Ad Group, Ad Group Id, Ad Group Status, Keyword, Avg Position, Clicks, Cost, Impressions, Conversions (1-per-click), Est. First Page Bid
  • Geo Performance Report: AccountDescriptiveName, Campaign, Campaign Id, Country Criteria Id, City, Metro, Region, Campaign Status, Ad Group, Ad Group Id, Ad Group Status, Clicks, Cost, Impressions

Adding and Customizing Tables and Fields in Google Analytics and AdWords

You can customize both the tables and the fields that you imported from Google Analytics and AdWords. Using the procedure below, you can also import fields from tables that are not automatically imported by Sisense.

To customize the imported data:

  1. Find the appropriate dimension from the Google API: Google Analytics API / Google AdWords API.
    Note:
    Use the dimension name and not the XML attribute.
    dim name
  2. Open the GAnalytics.Fields and GAnalytics.Tables xml files for Google Analytics, or the AdWords.Fields and AdWords.Tables xml files for Google AdWords. These files can usually be found in the following location after the first successful build through the Google Analytics of Google Adwords connector:
  • %ProgramData%\Sisense\PrismServer\LocalRepository2.0\Resources\Google\Analytics
  • %ProgramData%\Sisense\PrismServer\LocalRepository2.0\Resources\Google\Adwords

Note: If you are unable to locate the files in the above directories, look under %AppData% \Roaming\Sisense\Prism\LocalRepository2.0\Resources\Google\Analytics/AdWords, or search for the XML files in your root directory.

  1. To add a new field from a different table, open the “GAnalytics.Tables.xml” file or “AdWords.Tables.xml” file, and add a new table element that includes the new field.
    Note: Do not add the field to an existing table element.
    In the following example, AccountTimeZoneId is a field from a table that is not imported by default.
<table name="Time Zone Table Example" report_type="Query" aggregation_type="Monthly">
 <fields>
 <field id="AccountTimeZoneId"></field>
 </fields>
 </table>
</tables>
  1. Add the same field to the relevant GAnalytics.Fields or AdWords.Fields xml file, as follows:
<field id="AccountTimeZoneId" name="AccountTimeZoneId" type="System.String" size="100" class=""></field>

Once you save these changes and connect to Google Analytics, you will see the AccountTimeZoneId field in the ‘Time Zone Table’ example.

Notes

  • At least one new table must be added to the Tables.xml file before field changes are made to any standard tables.

tab ele

  • When the type attribute is long, the build may fail. If this happens, change the type from long to a different type, for example string.

Adding Custom Dimensions and Values to Google Analytics Tables

To import custom dimensions and values, they must be first defined in the ‘Fields’ XML, and later included in the relevant reports in the ‘Tables’ XML.

Open the fields XML from: %ProgramData%\Sisense\PrismServer\LocalRepository2.0\Resources\Google\Analytics

Custom Dimension:

<field id=”ga:dimension1” name=”FIELD_NAME” response_value=”ga:dimension1”

Custom Metric:

<field id=”ga:customVarValue1” name=”VALUE_NAME” response_value=”ga:customVarValue1”

The serial number of the dimension/value must be the same as defined in Google Analytics. The rest of the custom field attributes must be defined according to type; you can use a similar field for reference.

After adding the field, save the XML and add the field to the relevant report in the tables XML.

For more troubleshooting, see our forum post.