Use Data Studio to convert reports into multiple currencies

Expanding to international markets provides opportunities and challenges for e-commerce companies. One challenge is to report the return on advertising and revenue in each country and overall. Adding more currencies to the mix complicates the effort. Google Analytics can combine multiple currencies into one. Google explains in one Analytics Help Post how to include the … Read more Use Data Studio to convert reports into multiple currencies

Delete personal data from Google Analytics

Google Analytics prohibiting collection of personally identifiable information. If detected, Google may delete PII from your reports. Therefore, Google Analytics users should be proactive in detecting and removing PII if needed. I explain how to do it in this post. The best way to remove PII is not to send it to Analytics to begin … Read more Delete personal data from Google Analytics

7 Ways Big Data Will Affect Ecommerce 2020

The rise of e-commerce has generated an avalanche of data, most of which is unused. In 2020 and beyond, merchants will increasingly use the data to improve their businesses while protecting consumers' privacy. As e-commerce grows, so does data stored and used. However, only a fraction of this data is used. But this is likely … Read more 7 Ways Big Data Will Affect Ecommerce 2020

Using COUNTIF, COUNTIFS in Google Sheets to sort, analyze data

Whether you're researching keywords, examining lead sources, or analyzing customer attributes from a CRM export, Google Sheets COUNTIF and COUNTIFS formulas can help. These two spreadsheet formulas only count a cell (from a range of cells) if specific criteria are met. Recently, a multi-channel reseller wanted to analyze five years worth of lead and conversion … Read more Using COUNTIF, COUNTIFS in Google Sheets to sort, analyze data