@Kornexl opened this Issue on April 9th 2015

I would like to merge the data from two sites into one of these
(id 5 and id 15 to 15)

@daandres commented on May 1st 2015

I support this request.
My scenario is:
I have a Wordpress site and use wp-piwik. It sneds data automatically to piwik site with id 1.
After migrating my site to use only ssl, wp-piwik detects this as a new site (id=2).
I have seen that this behaviour is fixed in wp-piwik, but too late for me.

Therefore I want to merge the sites with id 1 and 2 in one single side with only one id.

Thanks

@Creat1veM1nd commented on June 22nd 2015

I do support this request also.

@lioman commented on July 19th 2015

This would be useful. I accidently created a new website in Piwik and now the data of half a year is in the wrong website.

A simple SQL script to merge the data together would be usefull too.

@Breighton commented on September 22nd 2015

I also support this request. We went from a "beta" site to a "production" site but our marketing folks need data that goes back through the "beta" site's data, and the merging of the two sites would do exactly that for us.

@Undergrounder commented on September 22nd 2015

I am extending the SiteMigration plugin to allow doing this. I hope to get this feature this week done.

@benji1000 commented on September 26th 2015

Oh, that would be very useful!

I just ran into the situation where I moved my websites from one server to another, initiated the tracking on the new server, and made the mistake to migrate the data from the old server afterwards.

Although the two configurations were quite identical (same domains, same ID), migrating data of one of the two websites with the SiteMigration plugin created a third website on the new server, instead of merging with the corresponding ID.

Thank you Undergrounder!

@monty241 commented on February 11th 2016

Great change! SiteMigration plugin is quite slow with large websites and creates a new idsite for every date-from/date-to range being uploaded. This would allow multiple uploads to run in parallel.

@davidak commented on July 16th 2016

@Undergrounder is that now supported? How would i do it?

@Undergrounder commented on July 17th 2016

No, sorry.

My old company switched to Google analytics and the implementation was't yet complete.

@christianhennen commented on July 25th 2017

Are there any updates on this? We at @ZIMK would greatly appreciate such a feature.

@saschafoerster commented on June 6th 2018

Just have the same problem, that the plugin wp-piwik created a new ID. So another +1 for this year!

@krrishh-org commented on July 31st 2018

+1

@D37R4C7 commented on September 18th 2018

+1

@b3n4kh commented on March 8th 2019

@Kornexl could you elaborate on why this feature is unwanted?

@Creat1veM1nd commented on March 8th 2019

Would like to know the reason for closing also. Thanks.

@mattab commented on March 18th 2019 Member

Sorry it was closed by mistake. Let's re-open.

Btw we have released a new slightly related plugin which lets you migrate one website from one instance to another: http://plugins.matomo.org/Migration
But it doesn't work for "merging" two websites together. Maybe it can be useful in some cases.

@prathers commented on December 1st 2019

This issue has become more important since the launch of the Google Analytics Importer plugin. If you choose to import older data from Google after you already has the same website enabled in Matomo, you end up with two set of data.

@MaghSamana commented on March 3rd 2020

Once you set up and use Google Analytics Importer Plugin, you end up with two sites. The one you have set up with Matomo (its tracker includes the website ID), and the other that's created from Google Analytics continued import (different website ID).

In case you continue to get analytics from both Google and Matomo, merging them would have to deal with the issue of double records - same visitors tracking from both. It needs some scripting for this. In addition some metrics differ, so how would these be handled?

Adding the past data from GA to Matomo's website seems a better option if you want to have a single website for tracking, and want to fill in the past gaps (e.g. if you've been using GA for years and switched to Matomo at some point). I think the migration plugin, mentioned earlier may be useful here.

@mattab commented on March 4th 2020 Member
@simardcasanova commented on March 31st 2020

+1 for merging two IDs together

@xavez commented on April 10th 2020

Just wanted to weigh in here that I also have the same problem.

@davidak commented on April 24th 2020

@xavez @simardcasanova please only add :+1: to the initial issue! This way the maintainers can easily see that the issue affects many people. Writing a comment with "+1" don't add any useful information and everyone in this thread get's an e-mail about it. That wastes peoples time and it will take longer until issues get fixed.

@UttaraRC commented on October 12th 2020

I would like to merge the data from two sites into one of these
(id 5 and id 15 to 15)

I have same issue. My both websites on same installation of matomo.
can anyone having solution for this

@jwest75674 commented on December 23rd 2020

Can anyone comment as to if there is a manual method for copying historical data from one site to another? I am not averse to copying the historical and deleting the then redundant site if there is a way?

@tsteur commented on December 23rd 2020 Member

@jwest75674 sorry I'm not aware of any manual way so far.

@simardcasanova commented on January 12th 2021

@xavez @simardcasanova please only add :+1: to the initial issue! This way the maintainers can easily see that the issue affects many people. Writing a comment with "+1" don't add any useful information and everyone in this thread get's an e-mail about it. That wastes peoples time and it will take longer until issues get fixed.

I'm sorry @davidak but I couldn't find any mention anywhere about not doing this. You cannot expect people to comply with rules that are never specified.

So speaking about "useful information", I would then suggest to update the README to explain more clearly how people are expected to +1 feature requests 🙂

@alderson59 commented on January 14th 2021

As @jwest75674 mentioned for a manual method for copying, I second this with perhaps a simpler suggestion for implementation while we iron out the many kinks of undertaking such an effort.

What if we try just overwriting overlapping data for the same dates first, since there could be some users (myself included) who only ran the two datasets in parallel for a short time. One simple way would be to set a cut-off date. Of course a huge CAVEAT in red text's gotta be shown before confirming the merging and losing partial data :P

This way, we can alpha test the feature before fully implementing it by handling overlaps, goals and custom dimensions. Also saves us time and effort from figuring out all the technical details while having something functional in the meantime.

@UttaraRC commented on January 14th 2021

Hii,
There is one method but for that you have to take manual efforts, that
efforts can be successful if you have hosted matomo on your server, we
need access of mysql of matomo.

Create your new website, which will give you your siteId, if you want to
merge site A to site B(newly created site) write update queries on site for
your near about all mysql tables

Update table set siteId=siteId of B where siteId =site id of A

On Wed, 23 Dec, 2020, 10:32 PM Joshua West, <notifications@github.com>
wrote:

Can anyone comment as to if there is a manual method for copying
historical data from one site to another? I am not averse to copying the
historical and deleting the then redundant site if there is a way?


You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/matomo-org/matomo/issues/7650#issuecomment-750389461,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AHBSDOJTTEGHL7M7V6MTDXTSWIPCXANCNFSM4A7UDJ5Q
.

Powered by GitHub Issue Mirror