Hi Christian,
Thanks for that. I've used the following for types, would you agree
with my choices?
Cheers,
Derek.
public struct ColumnDefinition
{
public string Name;
public string Description;
public string XmlName;
public Type Type;
public ColumnDefinition(string name, string xmlName, string
description, Type type)
{
Name = name;
Description = description;
XmlName = xmlName;
Type = type;
}
}
/// <summary>Keyword (attribute)</summary>
public static ColumnDefinition Keyword =
new ColumnDefinition("Keyword",
"keyword / site / kwSite",
"Keyword (attribute)",
typeof(string));
/// <summary>Keyword Id (attribute)</summary>
public static ColumnDefinition KeywordId =
new ColumnDefinition("KeywordId",
"keywordid",
"Keyword Id (attribute)",
typeof(long));
/// <summary>Ad Group (attribute)</summary>
public static ColumnDefinition AdGroup =
new ColumnDefinition("AdGroup",
"adgroup",
"Ad Group (attribute)",
typeof(string));
/// <summary>Ad Group Id (attribute)</summary>
public static ColumnDefinition AdGroupId =
new ColumnDefinition("AdGroupId",
"adgroupid",
"Ad Group Id (attribute)",
typeof(string));
/// <summary>Ad Group Status (attribute)</summary>
public static ColumnDefinition AdGroupStatus =
new ColumnDefinition("AdGroupStatus",
"agStatus",
"Ad Group Status (attribute)",
typeof(string));
/// <summary>Ad Distribution (attribute)</summary>
public static ColumnDefinition AdWordsType =
new ColumnDefinition("AdWordsType",
"adwordsType",
"Ad Distribution (attribute)",
typeof(string));
/// <summary>Avg Value (measure)</summary>
public static ColumnDefinition AverageConversionValue =
new ColumnDefinition("AverageConversionValue",
"avgConvValue",
"Avg Value (measure)",
typeof(float));
/// <summary>Avg Position (measure)</summary>
public static ColumnDefinition AveragePosition =
new ColumnDefinition("AveragePosition",
"pos",
"Avg Position (measure)",
typeof(float));
/// <summary>Lowest Position Preference (attribute)</summary>
public static ColumnDefinition BottomPosition =
new ColumnDefinition("BottomPosition",
"bottomPosition",
"Lowest Position Preference
(attribute)",
typeof(uint));
/// <summary>Avg CPC (measure)</summary>
public static ColumnDefinition CPC =
new ColumnDefinition("CPC",
"cpc",
"Avg CPC (measure)",
typeof(float));
/// <summary>Avg CPM (measure)</summary>
public static ColumnDefinition CPM =
new ColumnDefinition("CPM",
"cpm",
"Avg CPM (measure)",
typeof(float));
/// <summary>CTR (measure)</summary>
public static ColumnDefinition CTR =
new ColumnDefinition("CTR",
"ctr",
"CTR (measure)",
typeof(float));
/// <summary>Campaign (attribute)</summary>
public static ColumnDefinition Campaign =
new ColumnDefinition("Campaign",
"campaign",
"Campaign (attribute)",
typeof(string));
/// <summary>Campaign Id (attribute)</summary>
public static ColumnDefinition CampaignId =
new ColumnDefinition("CampaignId",
"campaignid",
"Campaign Id (attribute)",
typeof(long));
/// <summary>Campaign Status (attribute)</summary>
public static ColumnDefinition CampaignStatus =
new ColumnDefinition("CampaignStatus",
"campStatus",
"Campaign Status (attribute)",
typeof(string));
/// <summary>Clicks (measure)</summary>
public static ColumnDefinition Clicks =
new ColumnDefinition("Clicks",
"clicks",
"Clicks (measure)",
typeof(uint));
/// <summary>Conversion Cost (measure)</summary>
public static ColumnDefinition ConversionCost =
new ColumnDefinition("ConversionCost",
"convCost",
"Conversion Cost (measure)",
typeof(float));
/// <summary>Conversion Rate (measure)</summary>
public static ColumnDefinition ConversionRate =
new ColumnDefinition("ConversionRate",
"convRate",
"Conversion Rate (measure)",
typeof(float));
/// <summary>Conversions (measure)</summary>
public static ColumnDefinition Conversions =
new ColumnDefinition("Conversions",
"conv",
"Conversions (measure)",
typeof(uint));
/// <summary>Cost (measure)</summary>
public static ColumnDefinition Cost =
new ColumnDefinition("Cost",
"cost",
"Cost (measure)",
typeof(float));
/// <summary>Cost/conversion (measure)</summary>
public static ColumnDefinition CostPerConverstion =
new ColumnDefinition("CostPerConverstion",
"costPerConv",
"Cost/conversion (measure)",
typeof(float));
/// <summary>Cost/transaction (measure)</summary>
public static ColumnDefinition CostPerTransaction =
new ColumnDefinition("CostPerTransaction",
"cpt",
"Cost/transaction (measure)",
typeof(float));
/// <summary>Account (attribute)</summary>
public static ColumnDefinition CustomerName =
new ColumnDefinition("CustomerName",
"acctname",
"Account (attribute)",
typeof(string));
/// <summary>Time Zone (attribute)</summary>
public static ColumnDefinition CustomerTimeZone =
new ColumnDefinition("CustomerTimeZone",
"timezone",
"Time Zone (attribute)",
typeof(string));
/// <summary>Daily Budget (attribute)</summary>
public static ColumnDefinition DailyBudget =
new ColumnDefinition("DailyBudget",
"budget",
"Daily Budget (attribute)",
typeof(float));
/// <summary>Other Count (measure)</summary>
public static ColumnDefinition DefaultCount =
new ColumnDefinition("DefaultCount",
"defaultConv",
"Other Count (measure)",
typeof(float));
/// <summary>Other Value (measure)</summary>
public static ColumnDefinition DefaultValue =
new ColumnDefinition("DefaultValue",
"defaultConvValue",
"Other Value (measure)",
typeof(float));
/// <summary>Customer Id (attribute)</summary>
public static ColumnDefinition ExternalCustomerId =
new ColumnDefinition("ExternalCustomerId",
"customerid",
"Customer Id (attribute)",
typeof(long));
/// <summary>Impressions (measure)</summary>
public static ColumnDefinition Impressions =
new ColumnDefinition("Impressions",
"imps",
"Impressions (measure)",
typeof(uint));
/// <summary>Keyword Destination URL (attribute)</summary>
public static ColumnDefinition KeywordDestUrlDisplay =
new ColumnDefinition("KeywordDestUrlDisplay",
"kwDestUrl",
"Keyword Destination URL
(attribute)",
typeof(string));
/// <summary>Keyword Min CPC (attribute)</summary>
public static ColumnDefinition KeywordMinCPC =
new ColumnDefinition("KeywordMinCPC",
"keywordMinCpc",
"Keyword Min CPC (attribute)",
typeof(float));
/// <summary>Keyword Status (attribute)</summary>
public static ColumnDefinition KeywordStatus =
new ColumnDefinition("KeywordStatus",
"kwStatus / siteStatus /
siteKwStatus",
"Keyword Status (attribute)",
typeof(string));
/// <summary>Keyword Type (attribute)</summary>
public static ColumnDefinition KeywordTypeDisplay =
new ColumnDefinition("KeywordTypeDisplay",
"kwType / siteType / kwSiteType",
"Keyword Type (attribute)",
typeof(string));
/// <summary>Leads Count (measure)</summary>
public static ColumnDefinition LeadCount =
new ColumnDefinition("LeadCount",
"leads",
"Leads Count (measure)",
typeof(uint));
/// <summary>Leads Value (measure)</summary>
public static ColumnDefinition LeadValue =
new ColumnDefinition("LeadValue",
"leadValue",
"Leads Value (measure)",
typeof(float));
/// <summary>Content Bid (attribute)</summary>
public static ColumnDefinition MaxContentCPC =
new ColumnDefinition("MaxContentCPC",
"maxContentCpc",
"Content Bid (attribute)",
typeof(float));
/// <summary>Current Maximum CPC (attribute)</summary>
public static ColumnDefinition MaximumCPC =
new ColumnDefinition("MaximumCPC",
"maxCpc",
"Current Maximum CPC (attribute)",
typeof(float));
/// <summary>Current Maximum CPM (attribute)</summary>
public static ColumnDefinition MaximumCPM =
new ColumnDefinition("MaximumCPM",
"maxCpm",
"Current Maximum CPM (attribute)",
typeof(float));
/// <summary>Page View Count (measure)</summary>
public static ColumnDefinition PageViewCount =
new ColumnDefinition("PageViewCount",
"pageviews",
"Page View Count (measure)",
typeof(uint));
/// <summary>Page View Value (measure)</summary>
public static ColumnDefinition PageViewValue =
new ColumnDefinition("PageViewValue",
"pageviewValue",
"Page View Value (measure)",
typeof(float));
/// <summary>Current Preferred CPC (attribute)</summary>
public static ColumnDefinition PreferredCPC =
new ColumnDefinition("PreferredCPC",
"preferredCpc",
"Current Preferred CPC (attribute)",
typeof(float));
/// <summary>Current Preferred CPM (attribute)</summary>
public static ColumnDefinition PreferredCPM =
new ColumnDefinition("PreferredCPM",
"preferredCpm",
"Current Preferred CPM (attribute)",
typeof(float));
/// <summary>Sales Count (measure)</summary>
public static ColumnDefinition SalesCount =
new ColumnDefinition("SalesCount",
"purchases",
"Sales Count (measure)",
typeof(uint));
/// <summary>Sales Value (measure)</summary>
public static ColumnDefinition SalesValue =
new ColumnDefinition("SalesValue",
"purchaseValue",
"Sales Value (measure)",
typeof(float));
/// <summary>Sign-up Count (measure)</summary>
public static ColumnDefinition SignupCount =
new ColumnDefinition("SignupCount",
"signups",
"Sign-up Count (measure)",
typeof(uint));
/// <summary>Sign-up Value (measure)</summary>
public static ColumnDefinition SignupValue =
new ColumnDefinition("SignupValue",
"signupValue",
"Sign-up Value (measure)",
typeof(float));
/// <summary>Highest Position Preference (attribute)</summary>
public static ColumnDefinition TopPosition =
new ColumnDefinition("TopPosition",
"topPosition",
"Highest Position Preference
(attribute)",
typeof(uint));
/// <summary>Total Value (measure)</summary>
public static ColumnDefinition TotalConversionValue =
new ColumnDefinition("TotalConversionValue",
"convValue",
"Total Value (measure)",
typeof(float));
/// <summary>Transactions (measure)</summary>
public static ColumnDefinition Transactions =
new ColumnDefinition("Transactions",
"transactions",
"Transactions (measure)",
typeof(uint));
/// <summary>Value/click (measure)</summary>
public static ColumnDefinition ValuePerClick =
new ColumnDefinition("ValuePerClick",
"convVpc",
"Value/click (measure)",
typeof(float));
/// <summary>Value/cost (measure)</summary>
public static ColumnDefinition ValuePerCost =
new ColumnDefinition("ValuePerCost",
"valueCostRatio",
"Value/cost (measure)",
typeof(float));
}
On Oct 6, 1:57 pm, Christian Krahn <[EMAIL PROTECTED]> wrote:
> Hi Derek,
>
> all definitions are found
> here:http://code.google.com/apis/adwords/docs/developer/adwords_api_report...
>
> Just follow the link to the right report and there is a list of all
> the fields you have to provide and the fields you get in return.
>
> Unfortunately there is no list of field types. Just remember that id's
> should be large integer fields (BIGINT 20 at least). Personally i use
> varchar fields mostly, sometimes unsigned integer fields for values
> like clicks and impressions.
>
> Regards,
> Christian
>
> On 6 Okt., 14:43, DerekX <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hi All,
>
> > I'm looking for a proper column definition of the fields in the
> > reports available through the ReportService.
>
> > Name, Type, nullable, etc.
>
> > Can anyone point me in the right direction?
>
> > Cheers,
> > Derek.- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
-~----------~----~----~----~------~----~------~--~---
