When connecting your data to a pre-built data source, you may encounter drop-down lists that don’t show everything from the service you are connecting to. It could be a list of account names, a list of projects, or web properties - it varies from data source to data source. This typically happens because the account you are connecting to is very active and you have lots of different projects on the go, and the drop-down list cannot display everything.
This article will give you some tips on what to do if this happens when creating a pre-built data source from the Service Connectors page.
How do I get to my data when the drop-down list doesn't have the option I'm looking for?
When you are creating a new data source, some services allow you to select from drop-down menu lists. If you don't see the option you want in the list, you can modify the query directly to get the exact data you need. To do this, you will need to find your unique ID number for the service you are connecting to in Klipfolio. To find your ID number, refer to the relevant data source article for that service. Once you have your ID number, you are ready to edit your query.
To edit your query:
- If you haven't already, find your data source on the Service Connectors page.
- Select a pre-built data source from the left section of the Choose a pre-built or custom connection page.
- Authenticate your account.
- You are now on the Configure your data source page in Klipfolio. If you see drop-down menus and they are not displaying the information that you are looking for, complete the selections anyway.
- Click Switch to Custom Settings.
Note: The drop-down menus include a list of names (word/phrase). However, in the API query itself, it is actually a numeric value - an ID number associated with the account.
For more details, search for the appropriate data source article here in the Klipfolio Knowledge Base. Look for instructions on how to modify the query to bring back the data you need.
Example: Missing options while adding a Google Analytics data source
Let's say, when adding a Google Analytics data source on the Basic Settings page (see steps on how to get there below), you know that your Analytics Account is correct, but there are missing options in the drop-down lists. Follow the steps below to get the exact data that you need.
First, you need to find your Profile ID.
To find your Profile ID:
- Open a new window and log into your Google Analytics account.
- Select the Web Property (website) from which you want to get data.
- Navigate up to the address bar and take a look at the URL.
- Copy the Profile ID from the URL in the address bar, which can be found right after the letter ‘p’:
https://www.google.com/analytics/web/#report/visitors-overview/a666666w88888888p<YourProfileID>.
To get data from the correct website that you track in Google Analytics:
- Navigate to the Service Connectors page in Klipfolio and select Google Analytics from the list.
- Select a pre-built data source from the left section of the Choose a pre-built or custom connection page.
- Authenticate your account.
Note: Make sure you are connecting to the Google Analytics account that includes the website that you want to track. - On the Basic Settings page, complete all the selections, even if you don't see what you are looking for.
- Click Switch to Custom Settings.
- You have the option to complete the data request in Simple Mode or Advanced Mode. Either way, you will need the Profile ID of your chosen Google Analytics web property (see steps above on where to find your Profile ID).
- If you are in Advanced mode, paste the Profile ID into the query after
ids=ga:<YourProfileID> - If you are in Simple mode, paste the Profile ID in the Profile ID text box and configure the rest of the settings.
- Click Get data.
Your data source should now return information from the correct Google Analytics account, Web Property and Analytics Profile.