Connecting to your data
You need to authenticate the connector with the
After you authenticate the connector with your account credentials, use the tables to fetch your data. Some tables are preconfigured to access a specific set of data while others let you create custom queries.
Do the following:
- Select a table from the Tables column.
Enter table parameters, if required.
Required parameters are marked with a *.
Click Data preview to see a sample of your data and to select the table fields that you want to load.
The table below outlines some of the use cases for some of the tables that are available.
|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 Customer ID.|
Build an ad hoc report with
Loading data into your Qlik Sense app
Once you have finished selecting data, you can load your data into your Qlik Sense app. How you proceed will depend on whether you load data with Add data or the Data load editor.
To load data using Add data, click Add data. This will open the data in the Associations view of the data manager. In the associations view, you can continue to add data sources, transform the data, and associate the tables in Data manager.
Data profiling is enabled by default when you click Add data. Data profiling does the following:
- Recommends data associations.
- Auto-qualifies common fields between tables. This adds a unique prefix based on table name.
- Maps date and time fields to autoCalendar.
Tables are not associated on common field names automatically. You can associate tables in the Associations view.
If you want to load the data directly into your app, click and then disable data profiling.
When you add data with data profiling disabled, all existing data from data sources will be reloaded when you add the data. Tables will be associated on common field names automatically. Date and time fields will not be created.
Data load editor
To load data with the Data load editor, click Insert script once you are finished selecting the data. A load script is inserted into the script editor of the Data load editor. You can continue to edit the script in the script editor or you can click Load data to run the data load script.
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
The report download request is too large. Loading too large data sets may cause the request to time out.
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.