Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Anyone using Google Analytics Dashboard Reports
Steve Froggatt
Member
May 14, 2014 - 12:06 pm
Member Since: May 2, 2014
Forum Posts: 514
sp_UserOfflineSmall Offline

Tried installling this and i think its terminal, anyone using this successfully and can point me in the direction of what to do

exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘littlebl_mage1.mage_googleanalytics’ doesn’t exist’ in /home/littlebl/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /home/littlebl/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /home/littlebl/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/littlebl/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3 /home/littlebl/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #4 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘DESCRIBE `mage_…’, Array) #5 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘DESCRIBE `mage_…’, Array) #6 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(156): Varien_Db_Adapter_Pdo_Mysql->query(‘DESCRIBE `mage_…’) #7 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1596): Zend_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’, NULL) #8 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Abstract.php(206): Varien_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’) #9 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(586): Mage_Core_Model_Resource_Abstract->_prepareDataForTable(Object(Cinasstore_Googleanalytics_Model_Googleanalytics), ‘mage_googleanal…’) #10 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(449): Mage_Core_Model_Resource_Db_Abstract->_prepareDataForSave(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #11 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #12 /home/littlebl/public_html/app/code/local/Cinasstore/Googleanalytics/Model/Observer.php(10): Mage_Core_Model_Abstract->save() #13 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1338): Cinasstore_Googleanalytics_Model_Observer->saveGoogleanalyticsConfig(Object(Varien_Event_Observer)) #14 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Cinasstore_Googleanalytics_Model_Observer), ‘saveGoogleanaly…’, Object(Varien_Event_Observer)) #15 /home/littlebl/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent(‘admin_system_co…’, Array) #16 /home/littlebl/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(179): Mage::dispatchEvent(‘admin_system_co…’, Array) #17 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_System_ConfigController->saveAction() #18 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘save’) #19 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #20 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #21 /home/littlebl/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #22 /home/littlebl/public_html/index.php(87): Mage::run(”, ‘store’) #23 {main} Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘littlebl_mage1.mage_googleanalytics’ doesn’t exist’ in /home/littlebl/public_html/lib/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /home/littlebl/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/littlebl/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/littlebl/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘DESCRIBE `mage_…’, Array) #4 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘DESCRIBE `mage_…’, Array) #5 /home/littlebl/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(156): Varien_Db_Adapter_Pdo_Mysql->query(‘DESCRIBE `mage_…’) #6 /home/littlebl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(1596): Zend_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’, NULL) #7 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Abstract.php(206): Varien_Db_Adapter_Pdo_Mysql->describeTable(‘mage_googleanal…’) #8 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(586): Mage_Core_Model_Resource_Abstract->_prepareDataForTable(Object(Cinasstore_Googleanalytics_Model_Googleanalytics), ‘mage_googleanal…’) #9 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(449): Mage_Core_Model_Resource_Db_Abstract->_prepareDataForSave(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #10 /home/littlebl/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Cinasstore_Googleanalytics_Model_Googleanalytics)) #11 /home/littlebl/public_html/app/code/local/Cinasstore/Googleanalytics/Model/Observer.php(10): Mage_Core_Model_Abstract->save() #12 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1338): Cinasstore_Googleanalytics_Model_Observer->saveGoogleanalyticsConfig(Object(Varien_Event_Observer)) #13 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Cinasstore_Googleanalytics_Model_Observer), ‘saveGoogleanaly…’, Object(Varien_Event_Observer)) #14 /home/littlebl/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent(‘admin_system_co…’, Array) #15 /home/littlebl/public_html/app/code/core/Mage/Adminhtml/controllers/System/ConfigController.php(179): Mage::dispatchEvent(‘admin_system_co…’, Array) #16 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_System_ConfigController->saveAction() #17 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘save’) #18 /home/littlebl/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #19 /home/littlebl/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #20 /home/littlebl/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #21 /home/littlebl/public_html/index.php(87): Mage::run(”, ‘store’) #22 {main}

Dom Rand
Member
May 14, 2014 - 12:32 pm
Member Since: April 2, 2014
Forum Posts: 219
sp_UserOfflineSmall Offline

Can I ask why you want google analytics in dashboard, why not simply login into google anayltics?

And which one are you using?

"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln

Dom Rand
Member
May 14, 2014 - 12:37 pm
Member Since: April 2, 2014
Forum Posts: 219
sp_UserOfflineSmall Offline

reading the 1st line if I am correct it is basically saying you have no database table for it.

Have a look in your php admin for the table labled

littlebl_mage1.mage_googleanalytics

"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln

Steve Froggatt
Member
May 14, 2014 - 12:42 pm
Member Since: May 2, 2014
Forum Posts: 514
sp_UserOfflineSmall Offline

Regarding the DB, I saw that but I thought the extension would set everything up, as there are no extensions.

I find GA pretty difficult to navigate/read and thought this extension would simplyfy it a tad

Maybe I have to work out how to uninstall or i will be left with a load of dross in the admin panel

Dom Rand
Member
May 14, 2014 - 12:48 pm
Member Since: April 2, 2014
Forum Posts: 219
sp_UserOfflineSmall Offline

Steve Froggatt said

Regarding the DB, I saw that but I thought the extension would set everything up, as there are no extensions.

I find GA pretty difficult to navigate/read and thought this extension would simplyfy it a tad

Maybe I have to work out how to uninstall or i will be left with a load of dross in the admin panel

Which extension is it?

I can always try and see if I can get it to install on mine….

Steve

It depends on what you want from GA to achieve for you, if its just a simple case of visitors per day and a few more stats then it should be easy.

If you are going down the route of serious tracking. For example tracking your individual links in each transactional email you send out to see what works and what doesnt. Tracking your shares across social media. Changing your landing pages for promos to see which ones make purchases. Adwords campaigns etc etc then I suggest you login to analytics.

"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln

Steve Froggatt
Member
May 14, 2014 - 1:03 pm
Member Since: May 2, 2014
Forum Posts: 514
sp_UserOfflineSmall Offline

Hi Dom
Its this one http://www.magentocommerce.com…..ics-3.html

For now simple stats are more than adequate, I wont be getting full on with GA for a while yet

Steve

Dom Rand
Member
May 14, 2014 - 1:13 pm
Member Since: April 2, 2014
Forum Posts: 219
sp_UserOfflineSmall Offline

Steve Froggatt said

Hi Dom
Its this one http://www.magentocommerce.com…..ics-3.html

For now simple stats are more than adequate, I wont be getting full on with GA for a while yet

Steve

It installed for me, just doesnt show much……..

"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln

Steve Froggatt
Member
May 14, 2014 - 1:31 pm
Member Since: May 2, 2014
Forum Posts: 514
sp_UserOfflineSmall Offline

Did you enter anything in Analytic Account Email ID

I can only see 3 configuration options
Google Analytic Profile ID
[STORE VIEW]
Analytic Account Email ID
[STORE VIEW]
Analytic Account Password

Dom Rand
Member
May 14, 2014 - 3:20 pm
Member Since: April 2, 2014
Forum Posts: 219
sp_UserOfflineSmall Offline

where are those options?

Nothing showing up for me that i can find…

"Dont believe everything you read on the internet just because there is a picture with a quote next to it" Abraham Lincoln

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
21 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5222

Posts: 27488

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606