New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Let users import Google Analytics data in Matomo #6095
Comments
Will importing history from GA cause duplication in Piwik? e.g. For a site which has been using GA for a year, but only 3 months in Piwik, we might want to import the previous 9 months to get 1 year of history. |
What's the overall status of this? It seems that there's no activity at all in both issues. Do you have this in your short term roadmap? |
There is no update and while it is currently in the |
This feature would be great! |
This is great feature! |
We are really looking forward to this feature in our company. We cannot ask our clients to use our central Piwik installation until this has been released, since they have been relying on Google Analytics for too long and wish to keep their historical data. |
+1 |
3 similar comments
+1 |
+1 |
+1 |
What about importing raw google analytics data? I have a copy of every hit saved, can these be imported into piwik? |
+1 |
6 similar comments
+1 |
+1 |
+1 |
+1 |
+1 |
+1 |
@mattab cool, thanks! I wish I could help, will just watch for an update for now. |
Really interested in this. |
@mattab I can look at getting some of my guys involved in this later in February there is no problem. We are in the process of developing additional implantation with our CMS engine and Matamo. We did this previously with the Google api. So when we are finished this could dig much deeper into this. |
that's really exciting news @alexgogan ! |
@alexgogan be good to keep us up to date and let us know if we can be of any help. We're keen on investigating this as well. Also in general: It's obviously not the same but may be sometimes better than nothing to use Log Analytics to import old data if the logs still exist. |
I've done some research into the feasibility of importing log data from Google Analytics into Matomo. I've come up with two possible solutions, one which probably isn't workable, and another whose feasibility won't become apparent until a PoC is built. Both solutions allow the visitor log to function w/ the imported data. If we just import reports, this won't be the case. First, here are the limitations with Google Analytics API:
Here is the solution that probably isn't workable, but would be easier to understand:
Pros
Cons
The other solution uses the reporting API to make multiple requests that are combined into a result we can use:
Explanation for combining reports to get a report for every dimension: Ideally, we want to get the number of hits for every dimension value (eg, browser name, action time, referrer name, etc.). Since there's a limit of 7 dimensions, we can't do this. Instead we have to find some way to combine queries for less dimensions. To illustrate how we do this, let's limit the number of dimensions and dimension values. We'll say there are 3 dimensions total (DA, DB, DC), 1 dimension value for each (A, B, C), and GA only allows selecting 2 dimensions. So w/ these limitations, we have to find out what the report for dimensions = [DA, DB, DC] when we can only query two at a time. We'll do this by first querying every possible combination of two dimensions:
(where The thing to understand here is that the hits for dimensions = [DA, DB] is the cardinality of the subset of all actions where DA = A & DB = B. We want to find the hits for dimensions = [DA, DB, DC], which is the cardinality of the subset of all actions where DA = A, DB = B & DC = C. This is the intersection of sets (DA + DB), (DA + DC), (DB + DC), which means we can calculate N(A, B, C) by getting the minimum value of the cardinality of all these sets, ie: The idea is to use this property and apply to all the dimensions we're interested in and all their queried values. This will give us essentially the properties for every action. Pros
Cons
EDIT: One way to get user IDs/client IDs would be to issue requests like those that are made in the UI. I'm not sure how well that would work, and I'm guessing the page size will be smaller so it would take more requests. Also I am not sure if there are any limits to doing that, since that's outside of the API. |
I would say raw data may not be as important? Of course be great to have it for segmentation, but maybe not needed eg if there's a problem with the 50K req/day limit? |
@diosmosis thanks for the report. Sounds like importing RAW data is tricky and not easily do-able at this time. So we probably want to import Aggregated reports only. And forget about RAW data. -> As a next step, would be interesting to understand what it would take to build a Google Analytics Report data importer? |
@mattab We would map matomo dimensions to GA dimensions, query for report data, then map GA values to Matomo values (ie, dimensions). It's pretty straightforward (though value mapping might be difficult). We could also allow users to supply segments to make available (we can add segments to the report fetching API method). |
In V1 we would just want to keep it simple and import "All visits" segment (ie. not import any segment and segment data from GA) |
Status update:
Next things todo:
|
Hi Everyone! good news, we are almost done with the Google Analytics to Matomo Importer implementation. We'll start the beta release in a few days. Get ready for testing to import your Google Analytics data in Matomo 😎 |
OMG THIS IS THE BEST NEWS!!!! thank you so much!
…On Sun, Aug 11, 2019, 4:59 PM Matthieu Aubry ***@***.***> wrote:
Hi Everyone! good news, we are almost done with the Google Analytics to
Matomo Importer implementation. We'll start the beta release in a few days.
Get ready for testing to import your Google Analytics data in Matomo 😎
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#6095?email_source=notifications&email_token=AD4OCBKRIZBKZSCMIGK2GRLQECKUHA5CNFSM4ATUFKS2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4BKUOY#issuecomment-520268347>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AD4OCBN5BWIBBGDCGZM7IXLQECKUHANCNFSM4ATUFKSQ>
.
|
@mattab . Thanks for this great work, Please I have migrated from 3.11 to 3.12 but I don't see the google analytics import section. |
Hi @kimoudev the plugin hasn't been released yet, there are still a couple import accuracy bugs to work through before it's ready for a public beta. Should be soon though. |
Hi @diosmosis . Ok, Thank you so much. |
Hi Everyone, The Google Analytics Importer for Matomo is now released and available to all! 🎉
We're looking forward to hearing how it goes for you to import your GA data into Matomo. |
To use the Google Analytics Importer, you first need to upgrade to the latest Matomo 3.12.0 beta version. This can be done in 3 clicks, see instructions here |
Hello
Thanks thanks a lot. You have made a big collaboration that makes
internet more free and less controlled by Google, the Big Brother nowadays.
Thanks again
…On 22/8/19 12:00, Matthieu Aubry wrote:
Hi Everyone,
The Google Analytics Importer for Matomo is now released and
available to all! 🎉
* Get the plugin from:
https://plugins.matomo.org/GoogleAnalyticsImporter (see also: How
do I install a plugin in Matomo?
<https://matomo.org/faq/plugins/faq_21/>)
* Read the user guide at:
https://matomo.org/docs/google-analytics-importer/
* Report your feedback here in this issue, or if you find a bug
please create a new issue in the plugin's issue tracker at:
https://github.com/matomo-org/plugin-GoogleAnalyticsImporter/issues
We're looking forward to hearing how it goes for you to import your GA
data into Matomo.
Kuddos @diosmosis <https://github.com/diosmosis> for building this tool 💪
We're happy to help you migrate your GA data into Matomo and stay in
control! 🚀
Thanks to everyone who will help test this tool and report their feedback.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
<#6095?email_source=notifications&email_token=AAOBSY3YDZAALGHETVOW5WLQFZPSHA5CNFSM4ATUFKS2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD44R4EY#issuecomment-523836947>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AAOBSY2LWVHIMA6BBTMN4ADQFZPSHANCNFSM4ATUFKSQ>.
|
Hope you enjoy the Google Analytics importer tool. You can post your feedback in the issue tracker: https://github.com/matomo-org/plugin-GoogleAnalyticsImporter/issues Will close it now as we consider it done. Exciting! 🎉 |
The goal of this ticket is to create an easy to use tool that will let anyone import in Piwik their Google Analytics data.
Features expected in this tool
Tasks
Google Analytics Importer
This issue requires #6094 (Create an API to let users import historical report data in Piwik)
The text was updated successfully, but these errors were encountered: