Can I change my google account after initially using a different google account during code redemption? 2. Or alternative to 1, can I use the code in two different google accounts?
Q: Hi there,
just purchased KPIbees and I am trying to connect Analytics 4 of one of my websites to a sheet.
Unfortunately nothing happens. It just keeps on loading without the data getting connected to the sheet. What can I do here? What could be the issue here?
I'm not very familiar with those products. What is definitely a plus for KPIBees is that you get the data in a spreadsheet, so you can have all the flexibility in any kind of report that you want to build.
Any spreadsheet can be connected to Google Data Studio, so once KPIBees brings the data to the spreadsheet, you can connect this to GDS.
One use case of that might be that you can connect an external API using the JSON connector and get SEO data in the spreadsheet for analysis purposes. In the future, we will add direct SEO connectors. However, they will still be external apis.
I'm not saying just saying it. We simply are a Supermetrics alternative. :)
https://prnt.sc/200vshr - Sure, the pricing model is a little different, but we offer hourly refreshing for all plans. Also, we don't have a limit on how many connectors or accounts you add.
There are some general plans regarding Google Data Studio, but it's further down the line.
I would really prefer to be limited in connectivity than in data. I know that if I need a connector, I'll buy it. But at any time I'm left with the option of getting data. They should take a better look at the pricing model.
Q: It asks a lot of permissions for google during registration, is this normal?
Unfortunately, in order to show the KPIBees sidebar on the right side of the spreadsheet, these permissions are needed. All add-ons in this category have the same set of permissions required.
This being said, we are GDPR compliant and fully respect your privacy.
Q: Hi, you say you are the number 1 alternative to Supermetrics, however I downloaded the extension to test it ...
out connected to Facebook Ads and couldn't see any way to export conversion data for campaigns broken down by date (no date dimension), which kind of renders it as useless, unless I am missing something?
Other things...
- I couldn't find a way to connect to multiple Facebook Ad accounts at the same time. Is that not possible?
- When selecting a date range I was unable to choose 'last x days' or 'last x months' and instead had to choose one of your presets. Having more flexibility for the user to choose how many months or days of data they want is very important.
I wasn't aware of the time increment option, however having played around with that it doesn't appear to work and even if it were working the date / month that it is breaking the data down by is not shown in the row so I have no idea what date or month the data is for.
If I want a Facebook report for the last 6 months broken down by date and campaign so I can see the date and campaign in each row is that possible and if so how?
Also choosing last X months or last X days and being able to choose X ourselves (rather than your predefined options) doesn't appear to be possible at least for the Facebook Ads integration.
Time increment is used to have the results for the whole period, or have results for smaller time slices. You can also add the date by including fields like: "Date Start" and "Date Stop" Can I get more details on the doesn't work thing? The entity Ads Insights will get you ads insight for the entire account/ all campaigns. You will need to select Custom Time Range. By default, this will fetch the Time increment for the whole period. Please make sure to include "Date start" too. For your last point, we don't have it yet. We will add it in the next months. This is related to the previous question and we will also add last 6 months.
Thank you for question!
Q: Hi,
Sorry for the complete layman's question :)
I am looking for a tool that will allow me to collect ...
quantitative data from selected websites on an ongoing basis and place it in the appropriate Excel cells. I'm thinking for example of the so-called indexes popular on the web: Human Development Index (HDI) http://hdr.undp.org/en/content/human-development-index-hdi; Democracy Index https://www.eiu.com/n/campaigns/democracy-index-2020/; Human Freedom Index https://www.cato.org/human-freedom-index/2020 and many others. Would this be possible with KPIBees? Best
Great, thank you! I'm buying it and will learn and check, following your advice :) All the best
Q: Hello!
Quick question before I make a decision. On your integrations page, you list Google Search as new. What are the functions of this Google Search integration?
For reference: https://share.getcloudapp.com/12uPRv5l
The purpose of the Google Search connector is to enable you to query a search term and bring the results to a spreadsheet. The query results themselves may be different than what you search in the browser because it does not have the geo and historical context.
A single pull from GA with Year's worth of days and a dozen metrics OR per metric pulled? I ask because I'm thinking the max plan may not be enough, unless I'm missing this.
For example when I pull GMB it has about ten data points per location. Is this considered ten queries or one? If one, is it also one if pulled for all locations in a single request (they're grouped in GMB)?
A query is a refresh of data. I suggest going over this article to see how query credits work: https://help-center.kpibees.com/en/articles/5574538-what-are-query-credits
Additionally, I also recommend using KPIBees a little. Then you can go to Add-ons / KPIBees / Premium / Query Logs. Here you will see how your queries use the credits.
Q: Is it possible to filter a query before executing it?
For example, it is possible to pull goal completions by channel to start, or would I need to pull all goal completions in my query, and then filter the data once I have it on my end. Thanks!
I'm afraid I'm not sure what data source you refer to - we have 21 connectors :)
I suggest that you give it a try, there's a lot of options. And in the end, you are in a spreadsheet, so you can filter and tweak the data once it's there.
Is it possible somehow, to get this tool to scrape Facebook topics containing specific words? So everytime a person creates a new question in a group or on a profile, this tool can grap this question and put it into a Spreadsheet.
Look here: https://prnt.sc/1zgp3ex
On this screenshot, you can see that I have been searching for "tyveri bil". I have chosen to only show topics, and only new topics. And in the center of the screen, I have a overview of the lastest new topics containing "tyveri bil" on Facebook profiles and groups. I want this overview to automatically come into a Spreadsheet and with a direct link to the topic, so it is easy for me to find it.
I'm sorry, but at the moment this doesn't seem possible. It would be difficult to connect the webscraper to a logged in FB session and besides this there is a risk of facebook detecting it as spam.
Perhaps in the future we will launch other connectors that can get this particular information from facebook.
If I get the product to collect information about like views on videos from Youtube, and I want it to update the views each month and tell me how many % it has raised or fallen, is such a %-information possible to insert into the Google Sheet document, where the software is calculating the difference from month to month automatically?
You can execute a query every month to get the metrics for the last last. After this, you are in a spreadsheet, so you can very easily add a formula in the nearest column to calculate the value that you seek.
I haven't heard of it before, but you can connect exactly in the same manner as mentioned here: https://readme.directual.com/api-integrations/other-integrations/coupler.io
I recommend using either the XML or JSON connectors for this one. From what I saw namecheap has an API that you can use https://www.namecheap.com/support/api/intro/
namecheap.domains.getList Returns a list of domains for the particular user
Example Request https://api.namecheap.com/xml.response?ApiUser=apiexample&ApiKey=56b4c87ef4fd49cb96d915c0db68194&UserName=apiexample&Command=namecheap.domains.getList&ClientIp=192.168.1.109 get your api and then replace it here
If it says somewhere to whitelist an IP, this is our IP 94.130.18.249.
No, 1 account means that you can install KPIBees on one google account and use it on unlimited spreadsheets. You can connect any number of data sources, no limitation on this part.
Q: Are you maybe coming back to AppSumo launching your Excel Add-in?
Share KPIBees
Q: 1.
Can I change my google account after initially using a different google account during code redemption?
2. Or alternative to 1, can I use the code in two different google accounts?
Andrei_KPIBees
May 14, 2024A: Hi,
Yes, we understand if there is a need to change your account in the future, but this can't substitute a 2 account usage, of course.
I'm afraid you will not be able to use 1 code for 2 accounts - sorry.
Thank you!
Share KPIBees
Verified purchaser
So you are saying yes to #1 and no to #2, correct?
Correct. :)
Q: Are you planning on integrating tools like Semrush or Ahrefs in the future?
I don't see any mention of that in your roadmap?
Andrei_KPIBees
May 14, 2024A: Hi,
Yes, we were in discussion with SEMRush for an app, but it will take a little longer until they can support an add-on like ours.
Thank you!
Share KPIBees
Q: Hi there, just purchased KPIbees and I am trying to connect Analytics 4 of one of my websites to a sheet.
Unfortunately nothing happens. It just keeps on loading without the data getting connected to the sheet.
What can I do here? What could be the issue here?
Thanks in advance,#
Andrei_KPIBees
May 14, 2024A: Hi!
We don't support GA4 just yet. It's on the roadmap and we will add it soon!
Thank you for the patience!
Share KPIBees
Q: Hi, with XPATH fields, can I use with Instagram and schedule refresh every day ?
Thank you
Andrei_KPIBees
May 14, 2024A: Hi,
At the moment you can use JSON connector to connect to Instagram. We do have plans to build a direct connector for Instagram though.
Thank you!
Share KPIBees
Q: Hello, I want to make marketing reports to present to various clients, what are you different from oviond, Gyana, Reportei and heybooster?
all still active in appsumo. Also do you connect with google data studio?
Andrei_KPIBees
May 14, 2024A: Hi!
I'm not very familiar with those products. What is definitely a plus for KPIBees is that you get the data in a spreadsheet, so you can have all the flexibility in any kind of report that you want to build.
Any spreadsheet can be connected to Google Data Studio, so once KPIBees brings the data to the spreadsheet, you can connect this to GDS.
Thank you!
Share KPIBees
Q: Can this be used for SEO research?
Andrei_KPIBees
May 14, 2024A: Hi,
One use case of that might be that you can connect an external API using the JSON connector and get SEO data in the spreadsheet for analysis purposes. In the future, we will add direct SEO connectors. However, they will still be external apis.
Thank you!
Share KPIBees
Q: You say it's an alternative to supermetrics.
But supermetrics doesn't work with credits per month. Which seems to me a flaw. Do you plan to integrate for data studio?
Andrei_KPIBees
May 14, 2024A: Hi!
I'm not saying just saying it. We simply are a Supermetrics alternative. :)
https://prnt.sc/200vshr - Sure, the pricing model is a little different, but we offer hourly refreshing for all plans. Also, we don't have a limit on how many connectors or accounts you add.
There are some general plans regarding Google Data Studio, but it's further down the line.
Thanks for the question!
Share KPIBees
I would really prefer to be limited in connectivity than in data. I know that if I need a connector, I'll buy it. But at any time I'm left with the option of getting data. They should take a better look at the pricing model.
Q: It asks a lot of permissions for google during registration, is this normal?
I was a little hesitant.
Andrei_KPIBees
May 14, 2024A: Hi!
Yes, it's totally understandable.
Unfortunately, in order to show the KPIBees sidebar on the right side of the spreadsheet, these permissions are needed. All add-ons in this category have the same set of permissions required.
This being said, we are GDPR compliant and fully respect your privacy.
Thank you!
Share KPIBees
Q: Hi, you say you are the number 1 alternative to Supermetrics, however I downloaded the extension to test it ...
out connected to Facebook Ads and couldn't see any way to export conversion data for campaigns broken down by date (no date dimension), which kind of renders it as useless, unless I am missing something?
Other things...
- I couldn't find a way to connect to multiple Facebook Ad accounts at the same time. Is that not possible?
- When selecting a date range I was unable to choose 'last x days' or 'last x months' and instead had to choose one of your presets. Having more flexibility for the user to choose how many months or days of data they want is very important.
- There were no filter options available.
- There were no sort options available.
Andrei_KPIBees
May 14, 2024A: Hi Jamie,
If you go to Single Campaign Insights you can select a date range (or last X days), and you can break it down by month (in the Time increments field).
We have in our roadmap to add support for multiple FB accounts.
There is the breakdown field which has several options. Could this be what you are looking for?
Thank you
Share KPIBees
Hi Andrei,
I wasn't aware of the time increment option, however having played around with that it doesn't appear to work and even if it were working the date / month that it is breaking the data down by is not shown in the row so I have no idea what date or month the data is for.
If I want a Facebook report for the last 6 months broken down by date and campaign so I can see the date and campaign in each row is that possible and if so how?
Also choosing last X months or last X days and being able to choose X ourselves (rather than your predefined options) doesn't appear to be possible at least for the Facebook Ads integration.
Thanks.
Hi!
Sorry for the delayed reply!
Time increment is used to have the results for the whole period, or have results for smaller time slices. You can also add the date by including fields like: "Date Start" and "Date Stop" Can I get more details on the doesn't work thing?
The entity Ads Insights will get you ads insight for the entire account/ all campaigns. You will need to select Custom Time Range. By default, this will fetch the Time increment for the whole period. Please make sure to include "Date start" too.
For your last point, we don't have it yet. We will add it in the next months. This is related to the previous question and we will also add last 6 months.
Thank you for question!
Q: Hi, Sorry for the complete layman's question :) I am looking for a tool that will allow me to collect ...
quantitative data from selected websites on an ongoing basis and place it in the appropriate Excel cells. I'm thinking for example of the so-called indexes popular on the web: Human Development Index (HDI) http://hdr.undp.org/en/content/human-development-index-hdi; Democracy Index https://www.eiu.com/n/campaigns/democracy-index-2020/; Human Freedom Index https://www.cato.org/human-freedom-index/2020 and many others.
Would this be possible with KPIBees?
Best
Andrei_KPIBees
May 14, 2024A: Hi!
Here is what I was able to get for https://www.eiu.com/n/campaigns/democracy-index-2020/
--->
https://prnt.sc/1zl219i
I recommend having a look at the web scraper video tutorial that's listed in the app for more options.
Best of luck :)
Share KPIBees
Great, thank you!
I'm buying it and will learn and check, following your advice :)
All the best
Q: Hello!
Quick question before I make a decision. On your integrations page, you list Google Search as new. What are the functions of this Google Search integration?
For reference: https://share.getcloudapp.com/12uPRv5l
Andrei_KPIBees
May 14, 2024A: Hi,
The purpose of the Google Search connector is to enable you to query a search term and bring the results to a spreadsheet. The query results themselves may be different than what you search in the browser because it does not have the geo and historical context.
Thank you!
Share KPIBees
Verified purchaser
Awesome! How many SERP results does it pull? I’m looking for the top 100?
Hi,
It pulls up to 100 which is also the limitation of the google search API.
Thanks!
Q: Does it costs extra to add multiple users to an account?
If so, how does that work? Thanks!
Andrei_KPIBees
May 14, 2024A: Hi!
If you want to use KPIBees on more than a single google account, you can see multiple code stacking options https://prnt.sc/1zsn13p
Thank you!
Share KPIBees
Q: Hi there - just checking, is there any limit to the type of sql query you can run?
Can you use joins and views for example?
Andrei_KPIBees
May 14, 2024A: Hi,
You can run any type of SELECT statements, this includes view and joins. :)
Thank you!
Share KPIBees
Q: What is a query considered?
A single pull from GA with Year's worth of days and a dozen metrics OR per metric pulled? I ask because I'm thinking the max plan may not be enough, unless I'm missing this.
For example when I pull GMB it has about ten data points per location. Is this considered ten queries or one? If one, is it also one if pulled for all locations in a single request (they're grouped in GMB)?
Thanks!
Andrei_KPIBees
May 14, 2024A: Hi!
A query is a refresh of data. I suggest going over this article to see how query credits work: https://help-center.kpibees.com/en/articles/5574538-what-are-query-credits
Additionally, I also recommend using KPIBees a little. Then you can go to Add-ons / KPIBees / Premium / Query Logs. Here you will see how your queries use the credits.
Thanks
Share KPIBees
Q: Is it possible to filter a query before executing it?
For example, it is possible to pull goal completions by channel to start, or would I need to pull all goal completions in my query, and then filter the data once I have it on my end.
Thanks!
Andrei_KPIBees
May 14, 2024A: Hi David!
I'm afraid I'm not sure what data source you refer to - we have 21 connectors :)
I suggest that you give it a try, there's a lot of options. And in the end, you are in a spreadsheet, so you can filter and tweak the data once it's there.
Thank you!
Share KPIBees
Q: Hello!
Is it possible somehow, to get this tool to scrape Facebook topics containing specific words? So everytime a person creates a new question in a group or on a profile, this tool can grap this question and put it into a Spreadsheet.
Look here: https://prnt.sc/1zgp3ex
On this screenshot, you can see that I have been searching for "tyveri bil". I have chosen to only show topics, and only new topics. And in the center of the screen, I have a overview of the lastest new topics containing "tyveri bil" on Facebook profiles and groups.
I want this overview to automatically come into a Spreadsheet and with a direct link to the topic, so it is easy for me to find it.
Would that be possible?
Andrei_KPIBees
May 14, 2024A: Hi,
I'm sorry, but at the moment this doesn't seem possible. It would be difficult to connect the webscraper to a logged in FB session and besides this there is a risk of facebook detecting it as spam.
Perhaps in the future we will launch other connectors that can get this particular information from facebook.
Thank you for the question!
Share KPIBees
All right. :-)
If I get the product to collect information about like views on videos from Youtube, and I want it to update the views each month and tell me how many % it has raised or fallen, is such a %-information possible to insert into the Google Sheet document, where the software is calculating the difference from month to month automatically?
Hope it makes sence..
Hi,
You can execute a query every month to get the metrics for the last last. After this, you are in a spreadsheet, so you can very easily add a formula in the nearest column to calculate the value that you seek.
Thank you!
"You can execute a query every month to get the metrics for the last last"
--> Sorry, I meant to say:
You can execute a query every month to get the metrics for the last month.
Q: hi does the kpibees integrates to any no code platform tool such as Directual etc?
Andrei_KPIBees
May 14, 2024A: Hi,
I haven't heard of it before, but you can connect exactly in the same manner as mentioned here: https://readme.directual.com/api-integrations/other-integrations/coupler.io
Thank you!
Share KPIBees
Q: Hello Andrel, Can I use this to pull domain name lists directly from domain name registrars like Godaddy and ...
Namecheap and others to google sheets? Thank you.
Andrei_KPIBees
May 14, 2024A: Hi!
I recommend using either the XML or JSON connectors for this one. From what I saw namecheap has an API that you can use https://www.namecheap.com/support/api/intro/
namecheap.domains.getList
Returns a list of domains for the particular user
Example Request
https://api.namecheap.com/xml.response?ApiUser=apiexample&ApiKey=56b4c87ef4fd49cb96d915c0db68194&UserName=apiexample&Command=namecheap.domains.getList&ClientIp=192.168.1.109
get your api and then replace it here
If it says somewhere to whitelist an IP, this is our IP 94.130.18.249.
I assume it will be similar for godaddy :)
Best of luck to you
Share KPIBees
Q: Hi.
What does "1 account" mean in this case? Is that the ability to just connect to one platform or something else?
Andrei_KPIBees
May 14, 2024A: Hi!
No, 1 account means that you can install KPIBees on one google account and use it on unlimited spreadsheets. You can connect any number of data sources, no limitation on this part.
Thank you!
Share KPIBees