Description | Features | Technologies | How to setup it? | FAQ
This solution was made to proper detect access comming from all ads platforms and make my own analysis, in alternative of google analytics. This tool is meant to be used with shopify-store-omni-pixel.
It is very useful analytics tool because, since IOS 14 came in, facebook ads conversions aren't beign really reliable, not to mention that as the data is stored in a google spreadsheet, you can manipulate the data as you wish, and create the reports you want.
The pixel collects the data as the customer advances in the store funnel, as it follows:
| Step | Collected data |
|---|---|
| first_access | date, time, token, clarity_id, ip_address, ip_location, device, state, city, country, month, day, week_day, hour, initial_page, maximum_step, initial_date, initial_time, referrer, url, path, utm_source, utm_medium, utm_campaign, utm_content, utm_term, utm_id, utm_ad, utm_placement, utm_prodid, utm_affiliation, utm_coupon, |
| checkout | shopify_token, product, price |
| address | name, email, cpf, phone |
| payment | cep, shipping_method |
| payment | payment_method |
These are the most important features, but remember that with the data you'll be collecting you can generate new statistics, reports and so on directly on google spreadsheets. As an example, I made an chart to look from which device comes the most access.
- Track user information across all shopify store funnel and saves it in a google spreadsheet table;
- Can track inumerous stores into the same spreadsheet, just need to duplicate the original store sheet and rename it, and also update the snippet code in the others stores to proper send data to the corresponding sheet;
- Detect the maximum step the customer have been in, so you can check how effective you store is in coversions;
- Detect from what utm related tags the user have come from (utm_campaign, utm_source, utm_medium, and others), so you can check which campaigns performed better;
- Detect the customer clarity id, so you can check the screen recording by searching for this id in microsoft clarity.
This project uses the following technologies:
| Scope | Technologies |
|---|---|
| main | Google apps script |
| secondary | Google sheets |
| dev tools | EditorConfig | Git |
Copy this spreadsheet into your personal Google account.
On the copied spreadsheet tab, click in "Extensions" and after in "Apps scripts". When the google spreadsheet source code open in a new tab, click on "Publish" and after in "New publish". On project type, select "Web app", and click on "deploy".
Make sure to save the web app link, as we'll use it latter.
Rename the sheet into a more meaningful name related to your store.
Take notes to: (a) the name of the store sheet, (b) the id of the spreadsheet, which can be found after the url https://docs.google.com/spreadsheets/d/ and finaly (c) the web app url generated link.
Update the shopify-store-omni-pixel snippet code at google tag manager to include the information you've got in the previus step, as it follows:
...,
google_sheets: {
store_sheet_name: "a",
spreadsheet_id: "b",
api_url: "c"
},
...What do I do with the code in this repository?
Nothing. That's it. The code in this repository already is embeded in the google spreadsheet you should copy to your google account.
How to edit the columns order in the store sheet?
To do that, you'll have to edit the order both in the google spreadsheet sheet and in the API source code variables function.
How to pause the tacking in lvt analytics?
To do that, you'll have to edit the snippet code at shopify-store-omni-pixel and turn the setting: pixel_events.lvt to false.
Made with ♥ by Lucas Vieira.
Get it touch: github | linkedin | lucasvtiradentes@gmail.com