New Features
1. Dynamic Date Range in Database Data Sources : With the new @startDate and @endDate parameters, you can now directly use the date range you've set in your Looker Studio report in your SQL queries (MySQL, MariaDB, PostgreSQL, or Cloud FireStore). This not only makes your queries customizable but also speeds up data loading. Check out how to use this feature from these articles:
2. Dynamic Bearer Token in API Bridge: Tired of your access token getting expired in API Bridge? Our new feature will automatically refreshes the token for you based on your specified refresh token endpoint. Learn more about this option here.
New Metrics, Dimensions and Report Types
| Connector | Dimensions | Metrics |
|---|---|---|
| TikTok Ads | DMA ID, DMA name | Profile visits rate, Landing page views, Focused views (6sec), Focused views (15sec) |
| LinkedIn Ads | Creative Post URL | |
| Amazon Ads | Ad ID, Advertised ASIN, Advertised product title, Advertised SKU, Keyword, Keyword ID, Keyword status, Keyword type, Keyword bid, Targeting Expression, Target ID, Targeting type, Brands creative type | CVR (conversion rate), ACOS, 1 day ACOS, 7 days ACOS, 14 days ACOS, 30 days ACOS, 14 days ACOS (view-attributed), 1 day ROAS, 7 days ROAS, 14 days ROAS, 30 days ROAS, 14 days ROAS (view-attributed), 1 day CVR, 7 day CVR, 14 day CVR, 30 day CVR, 14 days CVR (view-attributed) |
| Google My Business | View source, View medium, Action type | |
| Google Trends | Trend Type (For Related queries, Related Topics) | Rising percentage (For Related queries, Related Topics) |
| LinkedIn Pages | Post media URL |
New Connectors
New Connectors
New Features
Timezone Selection: Easily handle time zone variations with the ability to choose the right one for your queries. Set a default timezone for your team or customize it for specific queries, ensuring accurate date calculations. Learn more about it in here.
New Metrics, Dimensions and Report Types
| Connector | Dimensions | Metrics |
|---|---|---|
| HubSpot | Link to contact, Contact owner ID, Contact owner name, Original source, Original source drill-down 1, Original source drill-down 2, First page seen, First referring site, First touch converting campaign, Last page seen, Last referring site, Last touch converting campaign, Date of first session, Time of first session, Date of last session, Time of last session, First conversion date, First conversion datetime, Recent conversion date, Recent conversion datetime, IP city, IP country, IP country code, Deal collaborator, Deal name, Deal description, Currency, Owner assigned date, Owner assigned datetime, Hubspot team, Deal type, Pipeline, Hubspot create date, Hubspot create datetime, Last activity date, Last activity datetime, Last contacted date, Last contacted datetime, Next activity date, Next activity datetime, Closed lost reason, Closed won reason, Original source type, Original source data 1, Original source data 2, Email address quarantined, First marketing email send date, First marketing email send datetime, First marketing email open date, First marketing email open datetime, and 48 more... | Event completions, Event Revenue, Page views, Avg page views, Deal probability, Closed deal amount |
| Instagram Insights | Profile engaged users | |
| Facebook Insights | Page views, Page views (logout), Page views (logged in), Page views (logged in) (unique), Page total actions | |
| LinkedIn Pages | Engagement rate, Lifetime engagement rate |
New Connectors
New Features
1. Ability to select Reporting timezone in Klaviyo - You can now specify the timezone you want to use when querying and displaying data from Klaviyo. Stay tuned for this feature to be extended to other supported data sources.
Â
2. Increased Page Speed Insights URL limit to 50Â - Now you can include 50 URLs in Page speed Insight's Realtime Method.
New Metrics, Dimensions and Report Types
| Connector | Dimensions | Metrics |
|---|---|---|
| LinkedIn Ads | Serving location | eCPC, eCPV, Total conversion value, Conversion rate, Return on ad spend |
| TikTok Ads | Region | Gross Impressions, Total Engagement, Engagement Rate, Clicks on music disc, Duet Clicks, Stitch Clicks, Sound Usage Clicks, Anchor Clicks, Anchor Click rate, Clicks on hashtag challenge, Instant Experience Avg View Time, Instant Experience Avg View %, Cost per Complete Payment (Onsite), Complete Payment Rate (Onsite), Value per Complete Payment (Onsite), Total Complete Payment Value (Onsite), LIVE Views, LIVE Unique Views, Effective LIVE Views, LIVE Product Clicks |
| Apple App Store | Product type, Product type description | Initial downloads, Re downloads, Updates, In app purchases, Paid app installs |
| Facebook Ads | Link to promoted post | Cost per New Messaging Conversation within 7 days |
| Facebook Page Insights | Country, Age, Gender | Post video views paid, Post video views paid unique, Post video avg time, Post video views organic unique, Post comments, Post shares, New conversations (unique), Blocked conversations count (unique), Reported conversations count (unique), Post video ad break impressions, Post video ad break earnings, Post video ad break CPM, Total video ad break CPM, Total video ad break impressions, Total video ad break earnings |
| Google Ads | Country | Value / conv. (by conv. time), All conv. (by conv. time), All conv. value (by conv. time), Value / all conv. (by conv. time) |
| Shopify | Product category, Product category full name, Product URL, Product URL (Decoded), SEO title, SEO description, Product published date, Product published datetime, Product comparison price, Customer tags, Transaction ID, Transaction kind, Payment method, Transaction created date, Transaction created datetime, Transaction processed date, Transaction processed datetime, Accelerated checkout, Credit card | Tips, Ordered quantity, Returned quantity, Net quantity, Gross payments, Refunded payments, Net payments, Transactions |
| Klaviyo | Tag name, Tag ID | Email bounce rate |
| Amazon seller | Marketplace name, Marketplace host name, Marketplace country code | |
| Google Analytics 4 | Session manual ad content, User default channel grouping, Default channel grouping | |
| Pinterest Ads | Amount spent (USD), Amount spent (EUR), Amount spent (GBP) | |
| Instagram Insights | New followers count, Profile growth, Profile followers count, Profile unfollowers count |
New report types in Google Search Console
Â
New Report types in Amazon Seller
Deprecated Reports in Amazon Seller
New Integrations 
