rjmetrics

Acquisition Source Grabber

  • Popularity Score 144 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

  • Magento Connect Bronze Industry Partner
Captures visitor source information from the Google Analytics cookie and stores it to the Magento database.
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.
In order to get this extension, you must have active Magento Go Store. Click here to create Go store.

Magento Connect 2.0

Magento Connect 2.0

FREE
Previous Next
Overview

Acquisition Source Grabber

Perform in-dept analysis on your referral sources and see which channels bring in the most valuable users. This tool captures visitor source information from the Google Analytics cookie and stores it to your Magento database.

Once you install the Acquisition Source Grabber, a set of new data fields will be available in your Magento database. Each of your new users will then have corresponding acquisition source data, and each new order will have corresponding referral source data. Essentially, you will be able to segment users and orders by GA referral sources (please also see this article on GA source data terminologies).

Order Referral Source Data

An order's referral source data corresponds to the web location that a user visited prior to a specific purchase. For example, the same user may have found your product via Google Search this time and an Advertisement the next time, so this value is specific to the purchase and may differ for a single user over time.

Orders have their corresponding referral data stored in the following data table and columns:

  • `sales_flat_order`.`rjm_utm_source`
  • `sales_flat_order`.`rjm_utm_medium`
  • `sales_flat_order`.`rjm_utm_term`
  • `sales_flat_order`.`rjm_utm_content`
  • `sales_flat_order`.`rjm_utm_campaign`

User Acquisition Source Data

A user's acquisition source data corresponds to the web location from which the user visited your site the first time.

Users will have their corresponding acquisition source data stored in the `customer_entity_varchar`.`value` table and column. Since the `customer_entity_varchar` table is an EAV type table, a specific `customer_entity_varchar`.`attribute_id` is needed to identify a specific utm field.

You can find the exact `attribute_id` values in the `eav_attribute` table by running the following query, which returns the exact `attribute_id` and corresponding user acquisition utm field:

SELECT `attribute_id`, `attribute_code` FROM `eav_attribute` WHERE `attribute_code` like 'rjm_utm%'

Here are the five user acquisition utm fields (`attribute_code`) that you will find:

  • `rjm_utm_source`
  • `rjm_utm_medium`
  • `rjm_utm_term`
  • `rjm_utm_content`
  • `rjm_utm_campaign`

For example, you may find that the `attribute_id` for `rjm_utm_source` may be a number such as 997. If that is the case, then you can query a user's corresponding acquisition utm_source with the following query which returns a user's utm_source and entity_id values:

SELECT cev.`value`, ce.`entity_id` FROM `customer_entity` ce JOIN `customer_entity_varchar` cev ON ce.`entity_id`=cev.`entity_id` WHERE `attribute_id`=997 LIMIT 100

Release Notes

RJMetrics_Campaigns

2013-08-05 19:30:42
  • Version number: 1.0.0.2
  • Stability: Stable
  • Compatibility: 1.5, 1.6, 1.6.1, 1.6.2.0, 1.7, 1.10, 1.11, 1.11.1, 1.12, 1.13
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

Fixes issue with acquisition source not updating.

RJMetrics_Campaigns

2013-05-16 19:50:41
  • Version number: 1.0.0.1
  • Stability: Stable
  • Compatibility: 1.5, 1.6, 1.6.1, 1.6.2.0, 1.7, 1.10, 1.11, 1.11.1, 1.12, 1.13
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

Supports the SOAP but not the REST API in this version. REST to be supported in a coming release.

RJMetrics_Campaigns

2013-05-08 14:31:42
  • Version number: 1.0.0.0
  • Stability: Stable
  • Compatibility: 1.5, 1.6, 1.6.1, 1.6.2.0, 1.7
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

Supports the SOAP but not the REST API in this version. REST to be supported in a coming release.
Reviews

About the Developer

This extension was developed by and is supported by rjmetrics

Q&A
(1 Question : 0 Answers)

Product Q&A

Ask your questions. Share your answers.

 
 
« Back
 
 
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_27237483
Customer avatar
I have Install Your Extension but can you please tell me that how can i test this extension working or not
by
vivek9716
-
3 months, 1 week ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
1 of 1
1 of 1
Get Help

Support for This Extension

The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Magento Platform Support

If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.