Ways to access your data
To access your
For some of the tables, you need to enter the client ID. To find this ID, log into the relevant
Loading data from tables
After you authenticate the connector with your account credentials, you can use the following tables to select and load data:
|Customers||Shows the customers and information about customers that are accessible with the authenticated
|ManagedCustomers||Shows the details for managed customer accounts. You need to enter a Client ID.|
Build an ad hoc report with
To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*). The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.
With the AdHocReportFromAWQL table, you can use
SELECT Date, Clicks FROM CAMPAIGN_PERFORMANCE_REPORT DURING 2010101,20130101
To learn more about
Working with the Google API quota limits
You can refer to the Google Developer documentation to learn more about the requirements and restriction imposed by the
You may receive a report timeout message
Possible cause Possible cause
The report download request is too large. Loading too large data sets may cause the request to time out.
Proposed action Proposed action
Reduce the size of the report download request. There is no explicit data size limit but we recommend to try a smaller date range or to use predicates to break up the report into smaller requests.
You are trying to run a report for multiple campaigns but you get timeout errors. Instead of running one report, filter on a subset of campaign IDs and run multiple reports.