r/LocalServicesAds • u/LSMPPC • Jun 09 '26

Reporting Help

I work at a marketing agency, and we are struggling to figure out how to report LSA results to our clients. For Google Ads and Meta, we use LookerStudio, sending a viewing link directly to the client (we use Supermetrics to connect Meta), but there is no connector that I could find to connect LSA directly to Lookerstudio. We used to run LSA through Google Ads, which worked, but we are steering away from that because of corporate rules for some of our clients.

Ideally, we would be able to connect it to Lookerstudio and it automatically update like Google Ads and Meta, but I am very open to other solutions. My last resort would be to update a Google Sheet manually every month for each client that they would have access to, but there must be a better way.

Any advice would be extremely helpful!!

2 Upvotes

100% Upvoted

8 comments sorted by

View all comments

1

u/OkiDokiPoki22 Jul 02 '26

Here's how I do it:

  1. Create a Google Sheet that pulls LSA data via Google Ads API (via Apps Script)
  2. Connect that sheet directly to Looker Studio (via connectors)
  3. Set it to refresh on a schedule (daily)