If you want to create a custom table to Google Adwords you will need to create an XML text to define you table/s.

 

How to: 

1. Find the XML file Adwords.Tables.xml defined in:
    C:\Documents and Settings\[USER]\Application Data\SiSense\Prism\LocalRepository2.0\Resources\Google\Adwords\
2. If this file/folder does not exist it can  be created on the first use of this provider in ElastiCube project manager
3. Edit the file and add a new table with your custom fields.
4. The Add XML should look like this:

   <table name="Placement/Keyword, Daily Report" report_type="Keyword" aggregation_type="Daily" accumulate_by="Date">
       <fields>
         <field id="ClientEmail"></field>
         <field id="Date"></field>
         <field id="Campaign"></field>
         <field id="CampaignId"></field>
         <field id="CampaignStatus"></field>
         <field id="AdGroup"></field>
         <field id="AdGroupId"></field>
         <field id="AdGroupStatus"></field>
         <field id="Keyword"></field>
         <field id="KeywordStatus"></field>
         <field id="AveragePosition"></field>
         <field id="Clicks"></field>
         <field id="Cost"></field>
         <field id="Impressions"></field>
         <field id="Conversions"></field>
         <field id="Transactions"></field>
       </fields>
     </table>

5. Tables xml elements:

   name: Must be unique and descriptive

   report_type:

   aggregation_type: used for the accumulate function

   field id: The field name defined in google (can also be found in C:\Documents and Settings\[User]\Application Data\SiSense\Prism\LocalRepository2.0\Resources\Google\Adwords\Adwords.Fields.xml)

See Also