For anyone else who may have the same problem:
When you clone your site to a new domain (for staging an improvement), JetPack assigns a new blog_id thereby breaking association with JetPack’s previous stats. So, your staging site cannot be used to replace the new site without losing stats and subscribers.
However, you can change your blog_id to match the original site and restore stats:
(1) The blog_id is in the wp_options table’s ‘stats_options’ record:
SELECT * FROM wp_options WHERE option_name=’stats_options’;
- Your ‘blog_id’ is listed in PHP object serialized format. e.g. blog_id = 0123456789 is represented as:
s:7:”blog_id”;i:0123456789;
- Change that blog_id to your original blog_id (keeping PHP serialization format).
- Then you must disconnect from JetPack and then reconnect JetPack (setup) and then reconnect your WP.com account.
At that point, the stats and subscribers were restored for me.
(2) You can also download your subscriber email list in csv format, if you are logged into the correct WP.com account:
https://dashboard.wordpress.com/wp-admin/admin.php?page=stats&blog=BLOG_ID_HERE&blog_subscribers=csv&type=email
There’s also a “type=wpcom” list for your WP.com followers, but it is not useful without WP.com properly linking them to their users.
Jetpack support used to be responsive, but I have not received a reply in more than a week. I posted both in this forum and using their magic link which emails them at [email protected] and assigns a support ticket #:
https://jetpack.com/contact-support/?rel=support&hpi=1
Hi @consultkevin
Thank you for posting and providing what you did to solve the issue. We appreciate your patience while we work through a backlog of tickets due to a number of factors. Paid users do receive priority as well.
Is everything as it should be for you now, or did you still need help?
