ZohoAnalytics: Pivot Campaigns vs Contacts
A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts.
Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search223 entries / matching Zoho
Clear filters
A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts.
A quick article on some code added to a button in ZohoBooks off the invoice module to initiate your Stripe terminal to take a payment.
Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM.
A quick follow-on article to my previous article on Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo.
Another one of these articles talking about getting all the active product listings from eBay for a specific client.
A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge.
An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well.
A really quick article on how to hide these using CSS... at least until Zoho have this as a setting using the GUI.
An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products.
Working principle
My work sits within a wider delivery team at Ascent Business Solutions, recognised as a leading Zoho Premium Solutions Partner in the United Kingdom. Clients are supported by a team rather than an individual, covering everything from small technical fixes through to full Zoho CRM migrations and complex implementations. The team I manage focuses on API integrations between Zoho and platforms such as Xero, Shopify, WooCommerce and eBay, solving problems that are often undocumented or previously unsuccessful. Outcomes are measured in practical terms, including improved efficiency, scalable systems and clear returns, from helping new ventures grow into six-figure monthly operations to delivering rapid gains through streamlined payments and automated, data-driven processes.
Recently Added
Zoho Books: Change a Purchase Order's Delivery Address over API Zoho CRM: Presenting ABM for Zoho CRM: Expand and retain your customers with precision Zoho CRM: Announcing the new SKILL.md for Zoho CRM and the updated OAS repository! Zoho CRM: Allow Only Administrators To Change Task Owners Zoho Billing: Workflow does not exist!Protected notes
Log in for protected notes and any private client projects assigned to your account.